To use this function, choose .
Provides the expected values of the ordered data under normality. These scores can be used to produce normal probability plots and various tests.
NSCORES(number)
For number, specify the column number.
To determine if the expected values of a column of data (C1) are from a normal distribution, enter the expression NSCORE(C1) and store the results in C2.
C1 | C2 |
---|---|
0.1 | −1.54664 |
0.2 | −0.65542 |
1.1 | −0.12258 |
1.5 | 0.12258 |
3.8 | 0.37546 |
5.4 | 0.65542 |
6.9 | 1.54664 |
6.6 | 1.00049 |
0.2 | −0.65542 |
0.2 | −0.65542 |