One Sample Wilcoxon with SigmaXL

What is the One Sample Wilcoxon Test?

The one sample Wilcoxon test is a hypothesis test to compare the median of one population with a specified value.

[unordered_list style=”star”]

• Null Hypothesis (H₀): η = η₀
• Alternative Hypothesis (H_a): η ≠ η₀

[/unordered_list]

It is an alternative test of one sample t-test when the distribution of the data is non-normal. It is more powerful than one sample sign test but it assumes the distribution of the data is symmetric.

One Sample Wilcoxon Test Assumptions

[unordered_list style=”star”]

• The sample data drawn from the population of interest are unbiased and representative.
• The data are continuous or ordinal when the spacing between adjacent values is not constant.
• The distribution of the data is symmetric about a median.
• The one sample Wilcoxon test is robust for the non-normally distributed population.

[/unordered_list]

The assumptions are similar to other non-parametric tests, again the difference about the symmetry of the distribution.

How the One Sample Wilcoxon Test Works

Step 1: Create the following columns one by one:

[unordered_list style=”star”]

• Column 1: All the raw observations (X)
• Column 2: The differences between each observation value and the hypothesized median (X – η₀)
• Column 3: The signs (+ or –) of column 2
• Column 4: The absolute value of column 2
• Column 5: The ranks of each item in column 4 in ascending order
• Column 6: The product of column 3 and column 5

[/unordered_list]

Step 2: Calculate the test statistic W_calc , which is the sum of all the non-negative values in column 6.

Step 3: Make a decision on whether to reject the null hypothesis. Use the table of critical values for the Wilcoxon test to get the W_crit with predetermined alpha level and number of observations.

If the W_calc is smaller than the W_crit, we fail to reject the null hypothesis and claim that there is no significant difference between the population median and the hypothesized median. To calculate the W statistic, sum all of the non-negative values in column 6. To assess the hypothesis, the W statistic is compared against the critical W value.

Use SigmaXL to Run a One Sample Wilcoxon Test

Case study: We are interested in comparing the overall satisfaction of customer type 1 against a specified benchmark satisfaction (3.5) using a nonparametric (i.e. distribution-free) hypothesis test: one sample Wilcoxon test.
Data File: “One Sample Wilcoxon” tab in “Sample Data.xlsx”

[unordered_list style=”star”]

• Null Hypothesis(H₀): η₁ = 3.5
• Alternative Hypothesis(H_a): η₁ ≠ 3.5

[/unordered_list]

Steps to run a one sample Wilcoxon test in SigmaXL:

1. Select the entire range of data (both “Customer Type” and “Overall Satisfaction”
2. Click SigmaXL -> Statistical Tools -> Nonparametric Tests -> 1 Sample Wilcoxon
3. A new window named “1 Sample Wilcoxon” pops up with the selected range appearing in the box under “Please select your data”
   
4. Click “Next>>”
5. A new window also named “1 Sample Wilcoxon” appears
6. Select “Overall Satisfaction” as the “Numeric Data Variables (Y)”
   Select “Customer Type” as the “Group Category (X)”
   Enter “3.5” in the box next to “H0: Median=“
   
7. Click “OK”
8. The one sample Wilcoxon test results appear in the newly generated tab “1 Sample Wilcoxon (1)”
   

Model summary: The p-value of the one sample Wilcoxon test is 0.557, higher than the alpha level (0.05), and we fail to reject the null hypothesis. There is not any statistically significant difference between the overall satisfaction of customer type 1 and the benchmark satisfaction level.