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:
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.
Copyright © 2000-2019 StatsDirect Limited, all rights reserved. Download a free trial here.