Become a stats superstar by using Excel to reveal the powerful secrets of statistics Microsoft Excel offers numerous possibilities for statistical analysis―and you don’t have to be a math wizard to unlock them. In Statistical Analysis with Excel For Dummies, fully updated for the 2021 version of Excel, you’ll hit the ground running with straightforward techniques and practical guidance to unlock the power of statistics in Excel. Bypass unnecessary jargon and skip right to mastering formulas, functions, charts, probabilities, distributions, and correlations. Written for professionals and students without a background in statistics or math, you’ll learn to create, interpret, and translate statistics―and have fun doing it! In this book you’ll find out how For anyone who’s ever wanted to unleash the full potential of statistical analysis in Excel―and impress your colleagues or classmates along the way― Statistical Analysis with Excel For Dummies walks you through the foundational concepts of analyzing statistics and the step-by-step methods you use to apply them.
One of the challenges in rating a book on technical subjects is balancing the utility with the readability. I am biased towards the Dummies series because of their proven ability to find that elusive balance. This book is a bit of a platypus - not quite a stats book, and not quite an Excel book. It struggles to be good at either one. There is a lot of valuable information in the book on the Excel functions - but the discussion of the statistical theory gets in the way. Unfortunately there isn't enough of a statistical bent to really bridge the gap. It's understandable given that book might be double the size. However, it leaves this one wanting in both categories. I've got it on my desk and will be using it for some referencing. However, the alternative book for "... People That Think They Hate Statistics for Excel" is a better, but much more expensive, choice.
Clear and succinct with lots of examples, many functions of statistical analysis in excel I knew of and a few that I didn't. But the bonus comes from the work arounds presented in the book to cover the statistic methods that excel doesn't cover in its formulas.
Great application to many fields of study. If you looking for and easy to understand intro to statistical applications, try 'Statistical Analysis for Dummies'.