Statistical Analysis with Excel For Dummies [Paperback]

Joseph Schmuller Ph.D. (Author)

Book Description

Publication Date: June 2, 2009 | ISBN-10: 0470454067 | ISBN-13: 978-0470454060 | Edition: 2

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

Editorial Reviews

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

--This text refers to an out of print or unavailable edition of this title.

About the Author

Joseph Schmuller, PhD, is a technical architect at Blue Cross-Blue Shield of Florida. A former member of the American Statistical Association, he has taught statistics at the undergraduate, honors undergraduate, and graduate levels, and has been honored with an award for excellence in teaching.

Product Details

• Paperback: 504 pages
• Publisher: For Dummies; 2 edition (June 2, 2009)
• Language: English
• ISBN-10: 0470454067
• ISBN-13: 978-0470454060
• Product Dimensions: 9.3 x 7.4 x 1.1 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 4.6 out of 5 stars  See all reviews (16 customer reviews)
• Amazon Best Sellers Rank: #16,826 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

52 of 52 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 review is from: Statistical Analysis with Excel For Dummies (Paperback)

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.

41 of 46 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)   

This review is from: Statistical Analysis with Excel For Dummies (Paperback)

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.

36 of 40 people found the following review helpful:

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

By 

RaCat - See all my reviews

Amazon Verified Purchase

This review is from: Statistical Analysis with Excel For Dummies (Paperback)

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!!