Statistical Analysis with Excel For Dummies and over 2 million other books are available for Amazon Kindle . Learn more
£17.59
  • RRP: £21.99
  • You Save: £4.40 (20%)
FREE Delivery in the UK.
Only 4 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Quantity:1
Statistical Analysis with... has been added to your Basket
Trade in your item
Get a £1.56
Gift Card.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Statistical Analysis with Excel For Dummies Paperback – 9 Apr 2013


See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
£17.59
£8.72 £10.99
£17.59 FREE Delivery in the UK. Only 4 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.

Frequently Bought Together

Statistical Analysis with Excel For Dummies + Statistics For Dummies, 2E + Statistics II For Dummies
Price For All Three: £42.07

Buy the selected items together


Trade In this Item for up to £1.56
Trade in Statistical Analysis with Excel For Dummies for an Amazon Gift Card of up to £1.56, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Product details

  • Paperback: 528 pages
  • Publisher: John Wiley & Sons; 3rd Edition edition (9 April 2013)
  • Language: English
  • ISBN-10: 1118464311
  • ISBN-13: 978-1118464311
  • Product Dimensions: 18.8 x 2.5 x 23.6 cm
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Bestsellers Rank: 68,596 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

From the Back Cover

Learn to:

  • Understand common statistical terms
  • Interpret sales figures, gambling odds, sports stats, and more
  • Use Excel formulas, functions, charts, and PivotTables
  • Develop a grading curve or medical correlations

Forget the mumbo–jumbo!

Statistical analysis with Excel can be easy and useful, too

Stunned by statistics? Exhausted by Excel? Relax! This book makes it easy to learn statistical analysis and actually use it to interpret the statistics of everyday life. Take your Excel knowledge to a new level as you discover how to use Excel′s perfectly designed tools to analyze and understand data, predict trends, make decisions, and much more.

  • The scoop on stats learn about statistical concepts such as samples and populations, variables, and probability
  • New Excel stuff check out naming conventions, new functions, and other elements that are different in Excel 2013
  • Striking sparks discover the cool new "sparklines" feature that lets you quickly create small graphs to illustrate data trends
  • Means to an end understand means, medians, and modes and the worksheet functions associated with them
  • Reasonable estimation work with sampling distributions for estimation and understand the all–important Central Limit Theorem
  • It′s probable explore Excel′s rich set of built–in capabilities for understanding and applying probability
  • Send in the data see how to import data from databases, the web, or from text

Open the book and find:

  • A roundup of new Excel capabilities
  • Different types of hypothesis testing
  • Tools and instructions just for Mac users
  • What ANOVA means and why you must know
  • Statistical and graphical tips and traps
  • How Excel can pinch–hit as a database
  • What to do with random variables
  • Appendixes that delve into specific tools and tricks

About the Author

Joseph Schmuller, PhD, is a technical architect at Blue Cross–Blue Shield of Florida. An adjunct professor at the University of North Florida, he is a former member of the American Statistical Association and has taught statistics at the undergrad, honors undergrad, and graduate levels.


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

4.8 out of 5 stars
5 star
3
4 star
1
3 star
0
2 star
0
1 star
0
See all 4 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

2 of 2 people found the following review helpful By RJP the Book Boy TOP 500 REVIEWERVINE VOICE on 18 May 2013
Format: Paperback Verified Purchase
I have needed to do some very complex Excel reports.
I know my way around Excel but needed to really get into it's functions. This book does exactly what I wanted. It showed me how to implement detailed statistical analysis using Excel and generate the reports I needed. The book does assume some knowledge of basic statistics and Excel but apart from that it is great at explaining thinks. Along with 'Visual Basic in easy step' by Mike Mcgrath I have now completed a full integrated accounts monitoring system with reporting. Excel is so powerful but it takes books like this to really unlock its potential.
Overall 'Statistical Analysis with Excel' is a brilliant book in the Dummies series and I am very glad I bought it. I have learned so much and feel I can tackle any Excel based problem now. Highly recommended.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By ProgrammerWhizz on 25 Mar. 2014
Format: Paperback Verified Purchase
From Karl Pearson's correlation F distributions, to ANOVA variance testing, to probability, to multiple linear regression, to Normal and T distribution testing, to Chi Square testing and many more Excel functions, backed by theory and equations. This book has it all. I would really recommend this book for any seasoned statistician to those who are just learning statistics - this book has it all.

The best statistics book, bar Statistical Analysis by Conrad Calberg.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback Verified Purchase
Great book , for a clear and good explanantions on statistical Analysis.
Decent price and prompt delivery. I always use it now before I start any analysis , to recap on techniques . Puts matters into perspective , then start the analysis. Definitely a good book to have at home or in the office.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By B. Seworde on 24 Oct. 2014
Format: Paperback
Very useful and good value for money.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 47 reviews
58 of 58 people found the following review helpful
Excellent 17 Mar. 2005
By R Smith - Published on Amazon.com
Format: 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.
45 of 50 people found the following review helpful
Excellent Reference, Not For Beginners. 8 Feb. 2007
By RaCat - Published on Amazon.com
Format: Paperback Verified Purchase
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!!
43 of 50 people found the following review helpful
More Than a Simple Spread Sheet 4 Mar. 2005
By John Matlock - Published on Amazon.com
Format: 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.
12 of 12 people found the following review helpful
I hate statistics, but this book helped it make sense. 1 Sept. 2008
By J. Haggard - Published on Amazon.com
Format: Paperback Verified Purchase
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!
10 of 10 people found the following review helpful
A few good tricks but not user friendly.... 30 April 2012
By Ashley - Published on Amazon.com
Format: Paperback Verified Purchase
I ordered this book because I am trying to brush up on statistics for a course I need to take (or try to test out of). Since the last time I took stats, everything was pencil, paper and calculator, I thought it might be a good idea to brush up on some of the statistical functionality.

I will tell you that I am very familiar with excel. I use it almost every day at work. However, I did pick up a few tricks when using this book. Overall, it was pretty helpful. It covered major stats content and showed the functionality.

I did find it a bit hard to follow. I'm a visual person, so I liked following along on my computer with the book. Unfortunately, almost every example uses a different set of numbers, so I was constantly inputting numbers to try to replicate the example (which was time consuming). Sometimes you couldn't even see the data set. It would be great if they had a place where you could download the data sets to follow along.

There were also a couple of places where I noted some of the examples had incorrect calculations. The steps and instructions by the author were right, but the visuals actually included some mistakes.

For what it is, I thought it was a very helpful reference if you're already familiar with both basic stats and excel. Otherwise, this book may not be for you.
Were these reviews helpful? Let us know


Feedback