In general, you can use Excel's SQRT() and LOG() functions to normalize a negatively skewed distribution, and an exponentiation operator, for example,, =A2<sup>2 to square the value in A2, to help normalize a positively skewed distribution.

As I was writing this, I got this secondary question:

Does SQRT() and LOG() bring positive numbers closer to zero, and exponents make negative numbers closer to zero? Is that why this works?

Also, why do some statistical analyses require a normal distribution? Why can't they work with a skewed distribution?

Also, are they saying that they use SQRT() and LOG() at the same time, or one or the other? Thanks.

Rob