Test of Normal Distribution
Sample Results as an Excel Table:
| Test of Normal Distribution | |||||
| Tests for continuous variables | |||||
| Kolmogorov-Smirnov | Shapiro-Wilk | ||||
| N | D | P | W | P | |
| Income | 72 | 0.083848245 | 0.692056008 | 0.95906408 | 0.01956914 |
| Horsepower | 72 | 0.215061772 | 0.002561715 | 0.820434662 | 6.34984E-08 |
| Chi-square test for discrete variables | |||||
| Classes | Chi-square | Degrees of Freedom | P | ||
| Income | 11 | 9.287383783 | 8 | 0.318635757 | |
| Horsepower | 12 | 164.5591969 | 9 | 8.37418E-31 | |
Note: create the "cumulative frequencies" chart to get a graphical comparison between the variable's distribution and a normal distribution.