Statistical Analysis with Excel For Dummies

Bol

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 to: Understand, describe, and summarize any kind of data, from sports stats to sales figures Confidently draw conclusions from your analyses, make accurate predictions, and calculate correlations Model the probabilities of future outcomes based on past data Perform statistical analysis on any platform: Windows, Mac, or iPad Access additional resources and practice templates through Dummies.com 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.

Bol Partner

A clear and easy-to-understand guide on using Excel to create and interpret statistics * Shows readers how to use Excel for statistical analysis--even if they haven't taken a statistics class or if they're math-challenged--and helps them confidently use Excel to crunch the numbers and interpret the statistics of everyday life, from business and sports stats to gambling odds and medical correlations * Covers formulas and functions, charts and PivotTables, samples and normal distributions, and probabilities and related distributions * Demystifies statistical terms such as median vs. mean, margin of error, standard deviation, permutations, and correlations Joseph Schmuller, PhD (Jacksonville, FL), is a technical architect at Blue Cross-Blue Shield of Florida. He is the author of several books and numerous articles on advanced technology.