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 Wilcoxon Rank-Sum Test, to be used for 2 independent samples.
The proposed Excel solution is based on a user-friendly Excel macro program called Wilcoxon.xlsm (for Windows), or WilcoxonMac.xlsm (for Mac), which requires no installation at all. It is provided in the form of a stand-alone Excel workbook into which the macro program is embeded. See a sample of screenshots below for a flavor of this practical approach.
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 Wilcoxon WilcoxonMac.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.
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:
|Purchase "The Wilcoxon Rank Tests with Excel" for Windows, for only $9.95||Purchase "The Wilcoxon Rank Tests with Excel" for Mac, for only $9.95|
|You may want to explore additional Excel Solutions to Other Nonparametric Tests (Kruskal-Wallis, Friedman, etc...)|