http://www.amazon.com/gp/product/0470454067/ref=pd_lpo_k2_dp_sr_1?pf_rd_p=304485901&pf_rd_s=lpo-top-stripe-1&pf_rd_t=201&pf_rd_i=0764575945&pf_rd_m=ATVPDKIKX0DER&pf_rd_r=0FNS6NTTJYWWNZ4M7HYH

Statistical Analysis with Excel For Dummies (For Dummies (Computer/Tech))
By Joseph Schmuller Ph.D.

Publisher:   For Dummies
Number Of Pages:   504
Publication Date:   2009-06-02
ISBN-10 / ASIN:   0470454067
ISBN-13 / EAN:   9780470454060

Product Description:

You too can understand the statistics of life, even if you're math-challenged!
What do you need to calculate? Manufacturing output? A curve for test scores? Sports stats? You and Excel can do it, and this non-intimidating guide shows you how. It demystifies the different types of statistics, how Excel functions and formulas work, the meaning of means and medians, how to interpret your figures, and more — in plain English.

Getting there — learn how variables, samples, and probability are used to get the information you want
Excel tricks — find out what's built into the program to help you work with Excel formulas
Playing with worksheets — get acquainted with the worksheet functions for each step
Graphic displays — present your data as pie graphs, bar graphs, line graphs, or scatter plots
What's normal? — understand normal distribution and probability
Hyping hypotheses — learn to use hypothesis testing with means and variables
When regression is progress — discover when and how to use regression for forecasting
What are the odds — work with probability, random variables, and binomial distribution
Open the book and find:

Ten statistical and graphical tips and traps
The difference between descriptive and inferential statistics
Why graphs are good
How to measure variations
What standard scores are and why they're used
When to use two-sample hypothesis testing
How to use correlations
Different ways of working with probability


Summary: This book helped me survive "sadistics" and pass the class!
Rating: 4
I used this book along with the "dummies" book as tutorials to help me get enough of a grasp of sadistics (I mean, statistics) to earn a "C" in the class. It would NOT have been possible without the two book aids I bought. The pages were worn and curled by the time the 6-week course was over, but it was so nice to find what I couldn't understand from the professor and the classroom text, in this book.

Summary: Easy to follow - lots of examples
Rating: 5
I had statistics in college (15+ years ago) but don't remember much. I don't have any statistical software at work, but need to do some deeper analysis. I bought this book and am about 1/2 way through. It is very easy to understand and is loaded with examples. I never realized I could do so much with Excel. Although this book was written for Excel 2003, I'm using 2007 and can still follow along without any issues. I'd highly recommend this book for anyone needing to do some basic statistical analysis!

Summary: I hate statistics, but this book helped it make sense.
Rating: 4
I have been taking a statistics course and was terrible at the concepts being taught. Regression, Anova, single sample, etc. So I bought this book since I am a total dummy when it comes to Stats. The book really does a great job as long as you have windows and excel as you can imagine given the title of the book. :) I do recommend it to anyone struggling as it walks you through step by step of each type of problem and explains in clear english what exactly is going on. I found myself making notes, highlighting and referencing various formulas in it often. Thanks to this book I passed my stats class!


Summary: An excellent resource
Rating: 5
This is an excellent resource for those who need to do statistical analysis, but who don't want to (or can't afford) to hire it professionally done.
Excel has many sophisticated statistical analysis tools built in. The author explains how to access these capabilities, how to decide which of them to use, and how to use them correctly. In addition, there is a great deal of information on designing graphs to display the results of the analysis.
In addition, the author introduces each statistical function by explaining what the function does, how it does it, and why one might consider using it. The examples are brief, but that's because the book isn't intended to be a comprehensive introduction to statistics. (One excellent book for that is "Statistics for Dummies," by Deborah Rumsey.)
As is the case with most of the "for Dummies" books, this one divides the information into short, easily digestible bites. The writing style is somewhat breezy, but that never interferes with the utility of the book.
This is an excellent, short reference that is worth every penny. I'm very happy I bought it, and I'd do it again.

Summary: I liked it
Rating: 5
very helpful for someone who has little previous knowledge of the subject. I needed a simple lead in and this provided.