the Statistics Add-In for Microsoft® Excel

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.