Statistical Analysis with Excel For Dummies (Paperback)

by Joseph Schmuller (Author) "The field of statistics is all about decision-making - decision-making based on groups of numbers..." (more)
Key Phrases: absolute reference format, separate data array, analysis tool dialog box, Insert Function, Function Arguments, Drawing Conclusions (more...)

Editorial Reviews

Product Description

• 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

From the Back Cover
Create graphs, develop estimates, and apply probability

Get the scoop on all of Excel's statistical tools and what they can do for you

If "permutation" sounds like something you shouldn't say around your grandmother and you read "margin of error" as "margin of terror," take heart! This easy-to-follow guide explains statistics in plain English and shows you how to use Excel charts, functions, samples, and correlations to make sense of it all — even if you're numerically challenged!

Discover how to

• Understand means, medians, and standard deviations
• Use Excel to give meaning to sets of numbers
• Draw conclusions from data
• Test your hypotheses
• Apply statistical concepts to real-world situations

See all Editorial Reviews

Product Details

• Paperback: 408 pages
• Publisher: For Dummies; 1 edition (March 4, 2005)
• Language: English
• ISBN-10: 0764575945
• ISBN-13: 978-0764575945
• Product Dimensions: 9.1 x 7.3 x 1 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.6 out of 5 stars See all reviews (9 customer reviews)
• Amazon.com Sales Rank: #78,669 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

34 of 34 people found the following review helpful:

5.0 out of 5 stars Excellent, March 16, 2005

By	R Smith "R Smith" (chicago, il) - See all my reviews

This book is excellent for seasoned Excel users and people who were taught (but didn't learn) statistics in your average graduate school program. I have never seen statistical concepts so briefly and at the same time well explained. Actually applying the concepts adds another level of learning. I highly recommend this book.

31 of 35 people found the following review helpful:

5.0 out of 5 stars More Than a Simple Spread Sheet, March 4, 2005

By	John Matlock "Gunny" (Winnemucca, NV) - See all my reviews (REAL NAME)

Excel is of course first and foremost a spreadsheet. They were designed to allow you to play what if senarios. You can change this part of the budget to see what the effect is over there.

But beyond the spread sheet functionality Excel has numerous functions and capabilities to do all kinds of analysis capabilities.

This book is on using these functions to perform a whole range of statistical functions. Not only does this book cover the functions themselves, but gives the background and description of what this particular kind of function is doing. Both numerical analysis and charting functions are included and in detail.

Don't skip the part in this book called the Part of Tens. This section in the For Dummies books often has some interesting points, but here the summation of statistical limitations is just great.

22 of 25 people found the following review helpful:

4.0 out of 5 stars Excellent Reference, Not For Beginners., February 8, 2007

By	R. Snavely - See all my reviews (REAL NAME)

I bought this book to help me with the statistical analyses involved with my senior dissertation at my university. I am a psychology major and I could use all the help I could get understanding the Results Sections in the literature. This book explains all kinds of statistics, including the very helpful ANOVA and regression analysis amongst many other. However, it doesn't explain very well when or why you use these statistics. They don't provide many examples of research or problems that require such analyses. This book is great for a step by step tutorial using Excel and handwriting statistics problems, and reading your data.... but unless you have an idea of what you're looking for in the first place, don't bother. I am totally ignorant to statistical analyses and coming into this book, I didn't know when to use ANCOVA or even what precisely it was demonstrating in relation to the research I am conducting... and I still only have a vague idea... Hopefully this will all be explained in course. But, this is a valued reference for all Excel users, without a doubt!!