Statistical Analysis with Excel For Dummies

by Joseph Schmuller

This book makes it easy to crunch numbers and interpret statistics with Excel, even for the math-challenged Using plain English and real-life examples, the author provides information that will help readers improve their performance on the job or in the classroom Covers formulas and functions, charts and PivotTables, samples and normal distributions, probabilities and related distributions, trends and correlations, as well as statistical terms like median vs. mean, margin of error, standard deviation, permutations, and correlations-all using Excel

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

408 pages, Paperback

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'.