Statistical Analysis with Excel For Dummies [Paperback]

Joseph Schmuller (Author)

Book Description

ISBN-10: 0764575945 | ISBN-13: 978-0764575945 | Publication Date: March 4, 2005 | Edition: 1

• 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

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

About the Author

A veteran of over twenty years in Information Technology, Joseph Schmuller is a Technical Architect at Blue Cross-Blue Shield of Florida. He is the author of several books on computing, including the three editions of Teach Yourself UML in 24 Hours (SAMS), and he has written numerous articles on advanced technology. From 1991 through 1997, he was Editor-in-Chief of PC AI magazine.
He is a former member of the American Statistical Association, and he has taught statistics at the undergraduate and graduate levels. He holds a B.S. from Brooklyn College, an M.A. from the University of Missouri-Kansas City, and a Ph.D. from the University of Wisconsin. He and his family live in Jacksonville, Florida, where he is an Adjunct Professor at the University of North Florida.

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
• Average Customer Review: 4.6 out of 5 stars  See all reviews (16 customer reviews)
• Amazon Best Sellers Rank: #426,404 in Books (See Top 100 in Books)
  • #86 in Books > Computers & Technology > Microsoft > Applications > Excel

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