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
Double-click on the drag handle at the bottom right of the active cell to copy
the formula down the entire column.