Hypothesis Testing in Excel - The Excel Statistical Master

by Mark Harmon

Complete step-by-step instructions showing how to perform every type of hypothesis test and how to do each in Excel. This manual will make you an expert on knowing exactly how and when to use all types of hypothesis tests (hypothesis tests of mean vs. proportion, one-tailed vs. two-tailed tests, one-sample vs. two-sample tests, and unpaired data vs. paired data tests) and how to set them all up in Excel. This manual is loaded with completed problems and screenshots in Excel of all major variations of hypothesis tests. All hypothesis tests regardless of type can be solved in four steps. This manual walks you through that four-step process during each of the many solved problems. 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 hypothesis tests, you will find this manual to be an outstanding course supplement that will explain hypothesis testing 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 hypothesis 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 hypothesis testing statistical frameworks in an easy-to-understand, real-world, practical way and then showing how to implement all of it in Excel. Hypothesis tests are the most widely-used statistical tests in business. This manual will make you an Excel Statistical Master of hypothesis testing.

142 pages, Paperback

First published April 10, 2011