Question

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

Answer 1

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.