FreeStatisticalTools.com
Nonparametric tests

Wilcoxon Signed-Rank Test Calculator

Compare two related measurements without assuming normal differences. Small samples without ties get an exact p-value.

Free · No sign-upReplaces SPSS · PrismWorks with your data
Updated · By Bibin Xavier

Data 24 × 5

Paste from Excel, or drop a CSV, TSV or Excel file here.
Example data 24 rows, 5 variables. Data stays in this browser tab.
Patienttext · 24 levelsWeek_0numericWeek_4numericWeek_8numericWeek_12numeric
P01108.58.47.9
P027.76.35.37.1
P03976.77.7
P046.75.74.83.3
P058.76.77.56.2
P066.84.93.55
P078.27.34.86.4
P087.865.94.8

Variables and options

Results update automatically when you change an option.

Results

24 rows · example data
Table 1

Ranks

Week_4 − Week_0nSum of ranks
Positive differences11.0
Negative differences23299.0
Ties (excluded)0

Note. Medians: Week_4 = 5.85, Week_0 = 7.00.

Table 2

Test statistics

WzpEffect size rMedian difference
1.0-4.24< .001.866-1.60

Note. Normal approximation with tie and continuity corrections.

Interpretation

Week_4 was significantly lower than Week_0 (r = .866, a strong effect).

A Wilcoxon signed-rank test showed a significant difference, W = 1.0, z = -4.24, p < .001, r = .866.

How to cite this tool

Using these results in a thesis, journal article, report or class assignment? Please cite this free tool so others can find it. It keeps the site free.

APA 7

Xavier, B. (2026). Wilcoxon Signed-Rank Test Calculator [Web application]. FreeStatisticalTools.com. https://freestatisticaltools.com/wilcoxon-signed-rank-test-calculator/

BibTeX

@software{xavier_wilcoxonsignedranktest_2026,
  author = {Xavier, Bibin},
  title = {Wilcoxon Signed-Rank Test Calculator},
  publisher = {FreeStatisticalTools.com},
  year = {2026},
  url = {https://freestatisticaltools.com/wilcoxon-signed-rank-test-calculator/},
  note = {Web application}
}

Suggested sentence for your methods section: “The analysis was carried out with the free Wilcoxon Signed-Rank Test Calculator tool on FreeStatisticalTools.com (Xavier, 2026).”

What is the Wilcoxon signed-rank test?

The Wilcoxon signed-rank test compares two related measurements without assuming that the differences are normally distributed. It ranks the absolute differences and compares positive and negative ranks.

When to use the Wilcoxon signed-rank test

Use it for pre-post or matched data when differences are skewed or the outcome is ordinal.

Assumptions

  • Paired observations.
  • Differences roughly symmetric around the median.

How to use this tool

  1. Enter your data. Paste columns from Excel, Google Sheets or SPSS with variable names in the first row, or upload a CSV or Excel file. The example data shows the expected layout.
  2. Choose the variables. Select the measurement 1 and measurement 2.
  3. Read the results. Results update automatically. Read the plain-English interpretation, then use Copy table to paste APA-style tables into Word and Copy for the results sentence.

How to report the Wilcoxon signed-rank test in APA style

“Pain decreased from week 0 (Mdn = 7.1) to week 4 (Mdn = 6.0), W = 12, z = −3.94, p < .001, r = .80.”

Frequently asked questions

When do I use the Wilcoxon signed-rank test?

For before-and-after or matched-pair data where the differences are skewed or the outcome is ordinal.

How are zero differences handled?

Pairs with no difference are dropped, as in SPSS and R, and the number dropped is reported.

Does the calculator give exact p-values?

Yes, for up to 30 non-zero pairs without ties. Larger samples or tied data use the normal approximation with tie and continuity corrections.

Related tools

Browse all categories