In: Statistics and Probability
how i can perform normality test for dataset using
excel
2.49 |
3.39 |
7.41 |
2.88 |
0.76 |
1.32 |
7.05 |
1.37 |
6.17 |
5.12 |
1.34 |
0.5 |
4.35 |
1.67 |
1.63 |
4.88 |
15.19 |
0.67 |
4.14 |
2.16 |
1.14 |
2.66 |
4.67 |
1.54 |
5.06 |
3.4 |
1.39 |
1.11 |
6.92 |
36.99 |
We use Q-Q plot for checking the normality of the given data after rearranging them in ascending order.Which is described as follows:
Where,
Probability of i =(i-0.5)/n
Z-score of i has been calculated using command =NORM.S.INV().
Standardized value of x can be calculated using cell formula =(B2-AVERAGE($B$2:$B$31))/STDEV.S($B$2:$B$31).
The above graphs shows that data given is approximately normal.