# Nonparametric Testing in Excel - The Excel Statistical Master

Mark Harmon, Feb 18, 2011 - Education
69 pages of complete step-by-step instructions showing how to perform nearly every major type of nonparametric test and how to do them all in Excel. This e-manual will make you an expert on knowing exactly how and when to use and set up in Excel all types of nonparametric tests, such as the Mann Whitney U Test, the Kruskall Wallis Test, the Wilcoxon Rank Sum Test for both large and small samples, the Spearman Correlation Coefficient Test, the Sign Test, and the Wilcoxon Signed Rank Test for both large and small samples. This e-manual is loaded with completed examples and screenshots in Excel of all the above of nonparametric tests being 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 e-manual to be an outstanding course supplement that will explain nonparametric tests much more clearly than your textbook does. If you are a business manager, you will really appreciate how easily and clearly this e-manual will show you how you can perform nonparametric tests in Excel to solve difficult statistical problems on your job. Nonparametric tests are the most important of all statistical tests in business, but are not widely understood. Nonparametric testing must nearly always 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. This e-manual will make you an Excel Statistical Master of nonparametric testing.

### What people are saying -Write a review

We haven't found any reviews in the usual places.

### Contents

 Nonparametric Tests When To Use Them 6 The MannWhitney U Test Done in Excel 7 The KruskalWallis Test Done in Excel 12 The Wilcoxon Rank Sum Test 18 Wilcoxon Rank Sum Test for Small Samples in Excel 20 Wilcoxon Rank Sum Test For Large Samples in Excel 26 The Spearman Correlation Coefficient Test Done in Excel 33 The Sign Test Nonparametric Done in Excel 39
 Wilcoxon SignedRank Test in Excel for Small Samples 44 Wilcoxon SignedRank Test in Excel For Large Samples 50 Statistical Mistakes You Dont Want To Make 61 Correctable Reasons Why Your Data Is Not Normally Distributed 67 Meet Mark the Author 70 Back Cover 71 Copyright