Statistical Analysis with Excel For Dummies, 4th Edition

  • 6h 20m
  • Joseph Schmuller
  • John Wiley & Sons (US)
  • 2016
  • Learn all of Excel's statistical tools
  • Test your hypotheses and draw conclusions
  • Use Excel to give meaning to your data
  • Use Excel to interpret stats

Statistical analysis with Excel is incredibly useful—and this book shows you that it can be easy, too! You'll discover how to use Excel's perfectly designed tools to analyze and understand data, predict trends, make decisions, and more. Tackle the technical aspects of Excel and start using them to interpret your data!


  • Covers Excel 2016 for Windows® & Mac® users
  • Check out new Excel stuff
  • Make sense of worksheets
  • Create shortcuts
  • Tool around with analysis
  • Use Quick Statistics
  • Graph your data
  • Work with probability
  • Handle random variables

About the Author

Joseph Schmuller, PhD, is a Research Scholar at the University of North Florida. He is a former member of the American Statistical Association and has taught statistics at the undergraduate, honors undergraduate, and graduate levels.

In this Book

  • Introduction
  • Evaluating Data in the Real World
  • Understanding Excel's Statistical Capabilities
  • Show and Tell—Graphing Data
  • Finding Your Center
  • Deviating from the Average
  • Meeting Standards and Standings
  • Summarizing it All
  • What's Normal?
  • The Confidence Game—Estimation
  • One-Sample Hypothesis Testing
  • Two-Sample Hypothesis Testing
  • Testing More than Two Samples
  • Slightly More Complicated Testing
  • Regression—Linear and Multiple
  • Correlation—The Rise and Fall of Relationships
  • It's about Time
  • Non-Parametric Statistics
  • Introducing Probability
  • More on Probability
  • A Career in Modeling
  • Ten Statistical and Graphical Tips and Traps
  • Ten Things (Twelve, Actually) That Just Didn't Fit in Any other Chapter