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
|