Author Description

Complete step-by-step instructions showing how to perform nearly every major type of nonparametric test and how to do each one of them in Excel. This 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 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. Nothing but simple explanations all taught in small-bite-size lessons. The emphasis is on problem solving, not on useless, complicated, hard-to-apply theory that fills many statistics course. 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 nonparametric tests much more clearly than your textbook does. Every lesson uses Excel. You'll be glad to know that you'll never have to look up anything on statistical charts ever again. The easy-to-follow frameworks in this manual can be cleanly and swiftly duplicated in the real world and on statistics exams by hand (without Excel) right away. If you are a business manager, you will really appreciate how easily and clearly this manual will show you how you can perform nonparametric tests in Excel to solve difficult statistical problems on your job. You already know Excel so no new software is necessary. You don't need SPSS, SAS, SyStat, or Minitab (all of those are expensive, require lots of user training, and expect the user to be an expert statistician right from the start. Not Excel nor this book. This manual achieves two goals: teaching graduate-level nonparametric