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.
Related reference