Normality Tests

The normality test tool provides for four tests of normality.

  1. Anderson Darling Test
  2. Cramér-von Mises Test
  3. Lilliefors (Kolmogorov-Smirnov) Test
  4. Shapiro-Francia Test
Figure 8-76Normality Test Dialog

The data range is specified via the Input Range: entry (see Figure 8-76). The given range or list of ranges can be grouped into separate data sets by columns, rows, or areas. The tool performs a separate test for each data set.

Figure 8-77Test Tab of the Normality Test Dialog

On the test tab one specifies which of the four tests to perform, the significance level for the test and whether to include a normal probability plot of the data (see Figure 8-77).

Figure 8-78Normality Test Example Data
Example 8-16Using the Normality Test Tool

Suppose you want to perform a Lilliefors (Kolmogorov-Smirnov) Test for Normality on the data given in Figure 8-78.

  1. Enter A1:A50 (or Sheet1!$A$1:$A$50) in the Input Range: entry by typing this directly into the entry or clicking in the entry field and then selecting the range on the sheet.
  2. Select the Labels option since the first row contains a label. (see Figure 8-79).
  3. On the test tab of the dialog (see Figure 8-80) select the Lilliefors (Kolmogorov-Smirnov) Test.
  4. Specify an appropriate significance level Alpha, say 0.05.
  5. Select the Create Normal Probability Plot option to include a normal probability plot in the output.
  6. Specify the output options as described above.
  7. Press the OK button.

The output of this normality test is shown in Figure 8-81. Note that the graph appears initially on top of the output data and needs to be moved to make the data visible.

Figure 8-79Completed Input Tab of the Normality Test Dialog
Figure 8-80Completed Test Tab of the Normality Test Dialog
Figure 8-81Normality Test Output