Nonparametric Testing in Excel - The Excel Statistical Master

Front Cover
Mark Harmon, Feb 18, 2011 - Education
0 Reviews
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

Other editions - View all

Common terms and phrases

Bibliographic information