Statistical Analysis: Microsoft Excel 2013

Statistical Analysis: Microsoft Excel 2013

Use Excel 2013’s statistical instruments to rework your facts into knowledge

Conrad Carlberg indicates the right way to use Excel 2013 to accomplish center statistical projects each company specialist, pupil, and researcher may still grasp. utilizing real-world examples, Carlberg is helping you decide the fitting method for every challenge and get the main out of Excel’s statistical gains, together with lately brought consistency features. alongside the best way, he clarifies complicated statistical terminology and is helping you stay away from universal mistakes.

You’ll methods to use correlation and regression, learn variance and covariance, and attempt statistical hypotheses utilizing the conventional, binomial, t, and F distributions. that can assist you make exact inferences in line with samples from a inhabitants, this version provides extra chapters on inferential facts, protecting an important issues starting from experimental layout to the statistical strength of F tests.


Becoming a professional with Excel information hasn't ever been more uncomplicated! You’ll locate crystal-clear directions, insider insights, and whole step by step projects—all complemented via broad web-based resources.

  • Master Excel’s most precious descriptive and inferential statistical tools
  • Tell the reality with statistics—and realize while others don’t
  • Accurately summarize units of values
  • Infer a population’s features from a sample’s frequency distribution
  • Explore correlation and regression to benefit how variables circulation in tandem
  • Use Excel consistency features akin to STDEV.S() and STDEV.P()
  • Test ameliorations among ability utilizing z assessments, t checks, and Excel’s facts research Add-in
  • Use ANOVA to check changes among greater than means
  • Explore statistical strength by way of manipulating suggest adjustments, average error, directionality, and alpha
  • Take benefit of urged PivotTables, fast research, and different Excel 2013 shortcuts

Show sample text content

Download sample