One Sample Wilcoxon Test with SigmaXl

What is the One Sample Wilcoxon Test with SigmaXL?

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

  • Null Hypothesis (H0): η = η0
  • Alternative Hypothesis (Ha): ηη0

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

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

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:

  • Column 1: All the raw observations (X)
  • Column 2: The differences between each observation value and the hypothesized median (X – η0)
  • 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

Step 2: Calculate the test statistic Wcalc , 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 Wcrit with predetermined alpha level and number of observations.

If the Wcalc is smaller than the Wcrit, 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.

Run a One Sample Wilcoxon Test with SigmaXL

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”

  • Null Hypothesis(H0): η1 = 3.5
  • Alternative Hypothesis(Ha): η1 ≠ 3.5

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)”
    One Sample Wilcoxon Test with SigmaXl

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.

Join Our Community

Instant access to hundreds of "How to" articles, Tools, Templates, Roadmaps, Data-Files.. Everything Lean Six Sigma! Come on in! Welcome to our community of Lean Six Sigma certified professionals.


My Interest in This Content is More Closely Related to*
This field is for validation purposes and should be left unchanged.

About Lean Sigma Corporation

Lean Sigma Corporation is a trusted leader in Lean Six Sigma training and certification, boasting a rich history of providing high-quality educational resources. With a mission to honor and maintain the traditional Lean Six Sigma curriculum and certification standards, Lean Sigma Corporation has empowered thousands of professionals and organizations worldwide with over 5,300 certifications, solidifying its position and reputation as a go-to source for excellence through Lean Six Sigma methodologies.