Choose the Example 1: Repeat Example 1 of Shapiro Wilk Original Test using the expanded test. The dialog box shown in Figure 5 now appears. Shapiro-Wilk Expanded Test, Enter Ctrl-m and select the Descriptive Statistics and Normality tool from the dialog box that appears. my example: n=25, w value calculated by excel is 0.953, while w value calculated by spss is 0.952, and also the p value is not equal, I used Linear Interpolation to calculate, and the p value calculated by linear interpolation is 0.367, but the p value in spss is 0.273. I do the shapiro-wilk test in excel and spss.

Shapiro-Wilk Test, Describes how to perform the original Shapiro-Wilk test for normality in Excel. Shapiro Wilk Normality Test Using SPSS Interpretation Based on Shapiro Wilk's output, the significance value (Sig) for the Samsung variable is 0.983, while the significance value (Sig) for the Lenovo variable is 0.136. The above table presents the results from two well-known tests of normality, namely the Kolmogorov-Smirnov Test and the Shapiro-Wilk Test.Ĭonducting a Shapiro-Wilk Normality Test in SPSS, How to test for normality in the SPSS statistics package (including Kolmogorov-Smirnov & Shapiro-Wilk).

If the Shapiro-Wilk Test of Normality Published with written permission from SPSS Statistics, IBM Corporation.

The Prob 0.05, then the data is normally distributed. Testing for Normality using SPSS Statistics when you have only one, The null hypothesis for this test is that the data are normally distributed.

Perform a Shapiro-Wilk Normality Test Shapiro-wilk test interpretation

Spss code for test of normality