Step-By-Step Normality and Nonparametric Testing in Excel - The Complete Guide

by Mark Harmon

● This is a complete yet simple instruction manual that explains the most widely-used Normality and Nonparametric tests and how to perform them all in Excel, Step-By-Step . ● This manual will make you an expert at knowing exactly how and when to use and set up in Excel many widely-used types of Normality and Nonparametric tests, such as the Kolmogorov-Smirnov Test, the Anderson-Darling Test, the Chi-Square GOF Test, the Normal Probability Plot, the Mann Whitney U Test for both large and small samples, the Kruskall Wallis Test, the Wilcoxon Rank Sum Test (only a brief discussion about this test since it is the same test as the Mann-Whitney U Test), the Spearman Correlation Coefficient Test, the Sign Test, and the Wilcoxon Signed Rank Test for both large and small samples. ● This manual is loaded with completed examples and screenshots in Excel of all the above of Normality and Nonparametric tests performed. ● The instructions are clear and easy-to-follow but at the graduate level. If you are currently taking a difficult graduate-level statistics course that covers Nonparametric or Normality tests, you will find this manual to be an outstanding course supplement that will explain them MUCH MORE CLEARLY than your textbook does.
● Normality and Nonparametric tests are important statistical tests in business, but are not widely understood. Normality and Nonparametric testing should be performed in place of most well-known statistics tests when it is not known that samples are being taken from a normally distributed population. This is more often the case than not, yet not many people have a working knowledge of nonparametric testing. You will.

● The Kolmogorov-Smirnov Test
● The Anderson-Darling Test
● The Chi-Square Goodness-of-Fit Test
● The Normal Probability Plot
● The Mann-Whitney U Test
● The Kruskal-Wallis Test
● The Wilcoxon Rank Sum Test For Both Small Samples and For Large Samples (2 Completely Different Procedures)
● The Spearman Correlation Coefficient Test
● The Nonparametric Sign Test
● The Wilcoxon Signed-Rank Test For Both Small Samples and For Large Samples (2 Completely Different Procedures)
● The Chi-Square Independence Test
This manual will make you an expert at understanding the above Normality and Nonparametric tests and how to set them up in Excel.

Covers the most widely-used Normality and Nonparametric Tests. Each test is used in very different circumstances, set up differently, and uses totally different formulas. Very few other statistics books clarify the differences between the many types of Normality and Nonparametric tests anywhere near the degree that this manual does.

You'll notice that these tests are not that complicated.
You just need to see how they are performed.

302 pages, Kindle Edition

First published April 25, 2013