Transforming variables

Transform a variable to normalize, shift, scale or otherwise change the shape of the distribution so that it meets the assumptions of a statistical test.

1. Activate the dataset worksheet.
2. In an empty column adjoining the dataset, enter the transformation function.

   For example =LOG(A1)

3. Double-click on the drag handle at the bottom right of the active cell to copy the formula down the entire column.