Standardization
Menu location: Data_Transforming and Deriving_Standardization
This function saves standardized values of workbook data you select into a new workbook column marked Std. (Method): Name, where Name is the column label of the original data and Method is one of the methods listed below.
Three different methods for standardization are provided:
- (x - mean) / standard deviation
- x / standard deviation
- x - mean
Example
Test workbook (Nonparametric worksheet: First Born).
Standardizing the following agressivity scores for a sample of firstborn twins using the first method above gives.
First Born ---> | Std ((x-mean)/SD): First Born |
86 | 0.7782 |
71 | -0.9095 |
77 | -0.2344 |
68 | -1.2470 |
91 | 1.3408 |
72 | -0.7970 |
77 | -0.2344 |
91 | 1.3408 |
70 | -1.0220 |
71 | -0.9095 |
88 | 1.0033 |
87 | 0.8907 |
See also: Z scores.