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.
- Activate the dataset worksheet.
-
In an empty column adjoining the dataset, enter the transformation
function.
For example =LOG(A1)
- Double-click on the drag handle at the bottom right of the active cell to copy the formula down the entire column.
Related reference