Standardise(column, mean, sd)

Top  Previous  Next

Standardises the data in column so that it has a new mean of mean and a new standard deviation of sd.  Each data point maintains its zscore (each score stays the same number of standard deviations from the mean).

 

Example:  Standardise(A,60,15)

 

Note:  If you type decimals using a comma (eg 3,2) you should enter this formula as Standardise(A; 60; 15)  - using the ; as a separator