Some statistical tests require a normal distribution. If your data are not normally distributed, you can sometimes transform the data into a normal distribution. There are two of these transformations in SPC for Excel:
These two transformations are accessed by selecting either “Data Transformation” on the “Distributions” panel on the SPC for Excel ribbon.
Select the links above for information on how to do each transformation.