Statistical Analysis with Excel For Dummies

by Joseph Schmuller

There's nothing random about it—this is the book on statistical analysis with Excel

Stunned by statistics? Exhausted by Excel? Relax! Statistical Analysis with Excel For Dummies, 4th Edition shows you how to use the world's most popular spreadsheet program to crunch numbers and interpret statistics—even if you've never taken a statistics or advanced math course. In no time, you'll learn to use Excel to create and translate statistics in everyday life, understand common statistical terms, and improve your classroom or professional skills.

Statistics has a reputation for being a challenging, math-intensive pursuit—but it doesn't have to make your palms sweat. Using a minimum of equations and assuming no prior knowledge of statistics or Excel, this hands-on guide cuts through the jargon and shows you how to make sense of formulas and functions, charts and PivotTables, samples and normal distributions, probabilities and related distributions, trends and correlations, and much more.

Use Excel's tools to analyze and understand data Apply statistical analysis to predict trends and make decisions Interpret sales figures, gambling odds, and sports stats Develop a grading curve or medical correlations

Forget the mumbo jumbo! This guide shows you that statistical analysis with Excel can be easy, fun, and useful!

Genres: Reference, Nonfiction, Mathematics, Software, Computer Science, Textbooks, Technical

552 pages, Kindle Edition

First published March 4, 2005

Reviews

[Laurie Neighbors]

It's actually kind of a page-turner.

[Ed Barton · Rating 3 out of 5]

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.

[Stuart Bateman · Rating 5 out of 5]

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.

[Ben · Rating 4 out of 5]

A great book on statistical analysis.

I have been doing lots of this in Excel lately, and this was a great book to detail some important tips!

3.8/5

[Steven Thomas · Rating 5 out of 5]

As usual, having to rely on this series given that I’m 30 years out of mathematical practice.

[Tom Walsh]

My job as an HRIS analyst leads me to these kinds of books. The "for Dummies" series is clear and explains everything one needs to know.

[Elizabeth]

This is just a sad testiment to the fact that my work has hijacked my life!

[Shelton Hill · Rating 4 out of 5]

This book is very straight-forward, comprehensive and digestible.

It's a great refresher and an easy reference for what you're trying to do but forgot how...

[Shauntelle James · Rating 5 out of 5]

Great application to many fields of study. If you looking for and easy to understand intro to statistical applications, try 'Statistical Analysis for Dummies'.