One Sample Tests

8.5.1. 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

8.5.2. One Median

The One Median test tool provides two non-parametric tests that test the null hypothesis that the sample comes from a population with a given median:

  1. Sign Test
  2. Wilcoxon Signed Rank Test

Selecting the appropriate submenu item opens the dialog with the respective test preselected.

8.5.2.1. Sign Test

This section describes the one sample sign test to test the null hypothesis that the sample comes from a population with the given median. The tool to perform a sign test to test the null hypothesis that two paired samples come from populations with the same median is in section Section 8.6.2.1 ― Sign Test.

Figure 8-82One-Median Test Dialog

The Sign Test tool performs a one-sample sign test whether the sample comes from a population with a given median.

The sample data range is specified via the Input Range: entry (see Figure 8-82). 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.

On the Testtab of the dialog (see Figure 8-83) the predicted median as well as the significance level are specified.

Figure 8-83The Test Tab of the One-Median Test Dialog
Example 8-17Using the Sign Test Tool

Suppose you want to perform a Sign Test on the data given in Figure 8-82 to determine whether the sample comes from a population of mean 3.

  1. Enter A1:A19 (or Sheet1!$A$1:$A$19) 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-82).
  3. On the Test tab of the dialog (see Figure 8-83) select the Sign Test.
  4. Specify an appropriate significance level Alpha, say 0.05.
  5. Select thepecify the median of the null hypothesis (3) in the Predicted Median entry.
  6. Specify the output options as described above.
  7. Press the OK button.

The output of this sign test is shown in Figure 8-84.

Figure 8-84Output of a Sign Test

8.5.2.2. Wilcoxon Signed Rank Test

This section describes the one sample Wilcoxon signed rank test to test the null hypothesis that the sample comes from a population with the given median. The tool to perform a Wilcoxon signed rank test to test the null hypothesis that two paired samples come from populations with the same median is in section Section 8.6.2.2 ― Wilcoxon Signed Rank Test.

The Wilcoxon Signed Rank TTest tool performs a one-sample sign test whether the sample comes from a population with a given median.

The sample data range is specified via the Input Range: entry (see Figure 8-82). 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.

On the Testtab of the dialog (see Figure 8-83) the predicted median as well as the significance level are specified.

The p-values given by this tool are determined using a normal approximation. This approximation is only valid if the sample size is at least 12.

Example 8-18Using the Wilcoxon Signed Rank Test Tool

Suppose you want to perform a Wilcoxon Signed Rank Test on the data given in Figure 8-82 to determine whether the sample comes from a population of mean 3.

  1. Enter A1:A19 (or Sheet1!$A$1:$A$19) 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-82).
  3. On the Test tab of the dialog (see Figure 8-83) select the Wilcoxon Signed Rank Test.
  4. Specify an appropriate significance level Alpha, say 0.05.
  5. Select thepecify the median of the null hypothesis (3) in the Predicted Median entry.
  6. Specify the output options as described above.
  7. Press the OK button.

The output of this sign test is shown in Figure 8-85.

Figure 8-85Output of a Wilcoxon Signed Rank Test