Menu location: Data_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 |