How Do I Perform a Johnson Transformation in Excel Using SigmaXL?

1. Open the file Nonnormal Cycle Time2.xlsx. Select Sheet 1 Tab.
   
   
2. Click SigmaXL > Process Capability > Nonnormal > Capability Combination Report (Individuals Nonnormal). Ensure that the entire data table is selected. If not, check Use Entire Data Table. Click Next.
   
   
3. Select Cycle Time (Minutes), click Numeric Data Variable (Y) >>.  Under Transformation/Distribution Options, select Johnson Transformation. You must select an Upper Spec Limit.  In this example, we have entered a USL of 500.
   
   

   

4. Click OK. The resulting report is shown:
   
   





5. The AD Normality P-Value Transformed Data value of 0.5990 tells us the Johnson transformation to normality was successful.