Welcome to the website of the e-document "The Wilcoxon Nonparametric Tests with Excel in 3 Simple Steps." The purpose of this document is to show you a few simple steps for implementing three Wilcoxon rank tests with Excel. The proposed solution can be implemented with Excel for Windows as well as with Excel for Mac. These 3 tests are the following:

The One-Sample Wilcoxon Signed-Rank Test

The Two-sample Wilcoxon Signed-Rank Test, to be used for 2 dependent samples, and

The above documents provides a detailed description of the Excel solution I propose for implementing the 3 Wilcoxon nonparametric tests. A trial version of the macro program Wilcoxon.xlsm (for Windows) or WilcoxonWilcoxonMac.xlsm (for Mac) is included in the zip file, in addition to being attached to this PDF document, from which it can be retrieved (follow the instructions in the document). This is the easiest and most practical method for performing these popular nonparameteric tests without having to learn to use the major and expensive statistical software such as SAS, SPSS, Stata, R, and others.

If you are from a country that uses the comma as the decimal symbol, and/or the dot as the list separator, you need to take the following actions in order to run these Excel macros smoothly:

Just for the purpose of running the program, change the decimal symbol from comma (,) to dot (.), and the list separator from whatever it is to comma (,) ? This is accomplished as follows:

1) Go to CONTROL PANEL
2) Clock, Language, and Region
3) Region and Language
4) Additional settings ...
5) Then you can change the decimal symbol, and the list separator.

Do you have problems running the Windows version of this program?

If you are unable to run this macro, it is likely due to a security update recently released by Microsoft that was installed on your computer. Please check the link http://support.microsoft.com/kb/3025036/EN-US to see what Microsoft suggests to do to get the program running

Note that the macro programs Wilcoxon.xlsm, and WilcoxonMac_evaluation.xlsm are to be used for evaluation purposes only, and can handle a limited number of data points. You may purchase the full versions of these programs by using one of the following 2 options:

The START worksheet of the Wilcoxon.xlsm Excel Macro. Here is where you will select which one of the 3 Wilcoxon rank tests you want to use. The 3 options are the (i) One-sample signed-rank test, (ii) Two-sample signed-rank test, and (iii) Rank-sum test.

The Rank-Sum Test Dialog Form. As an example, below is the dialog form associated with the rank-sum test, for defining your input data, and specifying various options for test. Play with it and you will be surprised how intuitive and simple it is.

The Wilcoxon(Output) Worksheet. Here is an example of the results that the Wilcoxon.xlsm program will produce. Numerous statistics are generated for you to complete your analysis report with no additional effort. Wilcoxon.xlsm is the quickest way to perform a Wilcoxon test

About the Author (Kilem L. Gwet, Ph.D)

Contact Information

A statistical consultant, researcher and instructor. He has over 15 years of experience in various industries in the US and Canada. He possesses a doctorate degree in statistics from Carleton University - Canada -