Statistical Analysis: Microsoft Excel 2013
Use Excel 2013’s statistical tools to transform your data into knowledge
Conrad Carlberg shows how to use Excel 2013 to perform core statistical tasks every business professional, student, and researcher should master. Using realworld examples, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features, including recently introduced consistency functions. Along the way, he clarifies confusing statistical terminology and helps you avoid common mistakes.
You’ll learn how to use correlation and regression, analyze variance and covariance, and test statistical hypotheses using the normal, binomial, t, and F distributions. To help you make accurate inferences based on samples from a population, this edition adds two more chapters on inferential statistics, covering crucial topics ranging from experimental design to the statistical power of F tests.
Becoming an expert with Excel statistics has never been easier! You’ll find crystalclear instructions, insider insights, and complete stepbystep projects—all complemented by extensive webbased resources.
 Master Excel’s most useful descriptive and inferential statistical tools
 Tell the truth with statistics—and recognize when others don’t
 Accurately summarize sets of values
 Infer a population’s characteristics from a sample’s frequency distribution
 Explore correlation and regression to learn how variables move in tandem
 Use Excel consistency functions such as STDEV.S() and STDEV.P()
 Test differences between two means using z tests, t tests, and Excel’s Data Analysis Addin
 Use ANOVA to test differences between more than two means
 Explore statistical power by manipulating mean differences, standard errors, directionality, and alpha
 Take advantage of Recommended PivotTables, Quick Analysis, and other Excel 2013 shortcuts
List Price: $ 39.99
Price: [wpramaprice asin=”0789753111″]
[wpramareviews asin=”0789753111″]
A Practical Use of Statistics for people without a lot (or any) statistical background,
I will try to detail out what this book is and how it handles itself (which is in essence why I characterize it as a “good” book).
Firstly, this is not a reference book.
There is an index that seems quite detailed so if you want to reference something you can. However what I mean by it not being a reference book is that you cannot ask yourself, “How do I do such and such in Excel?” and then go look up the answer within a minute. So that is sort of a negative, but really, in the end it is not because the book is much more than that.
This book goes into great detail to explain statistics.
Simply reading the introduction really breaks you in to where the author is coming from and how he approaches the book.
He assumes you know NOTHING about statistics.
Think of him like a teacher, but one you are sitting down and having coffee with. He simply explains to you statistics in steps, and allows you to absorb it. Sometimes you absorb faster than others, sometimes he needs to repeat himself (basically meaning you go back and reread the last page to make sure you understand). Each explanation comes with an example that is simple and made up (because it is an illustrative example) but seems plausible and lets you understand how and why this could be used.
Remember that scene from Peggy Sue Got Married? She sits in her math class and tells the teacher she doesn’t need Algebra in real life. A classic, funny moment, but this book isn’t that. It shows you how the Statistics are used, and why they are important. There are probably many analysis’ that you won’t need, but you can at least still see how many other people would need and use them frequently.
Then about the Excel part.
The book handles this more easily than the statistics part. Basically because there are not many changes in Excel from any particular version, and if there are the author details out what they are (which is pretty great in my mind because I have used Excel for 15+ years and can’t break down all the various nuances in the versions).This is also a good quality because it really doesn’t matter which version of Excel you have.
I would say that while the book details steps very well for the Excel process and procedures, you really need to have at least basic knowledge of Excel in order to use this book. But I also think that is a good presumption, as if you didn’t know basic use of Excel (how to set up spreadsheets, input formulas, etc…) then you wouldn’t be looking at a book on Statistical Analysis in the first place.
So what can you expect out of this book?
Like I previously alluded to, this is more a Statistics book than Excel book. I would say that you can expect to glean “practical use of statistics” where you just happen to use Excel to do so (because in this day and age nobody would be using pads of paper). In fact I put the whole practical part in quotes because I think that would be a good type of title. It isn’t theoretical, and while it could be considered textbook statistics, the fact that the book shows how to use statistical concepts in real world analysis.
That is really the golden nugget here, because statistics is a thought process. It isn’t about an equation to plug into and get an answer. It is how to think about organizing and reading your data to see what it tells you.
Similarly, Excel is a very powerful program, but unless you as a user can think of how to work in the program to find a solution to what you are looking for, then you will never unlock the true power of how Excel can work. The book doesn’t go into this as much as I would like, but it covers more than enough statistics to make up for it.
So take a look at the preview available here. It is indeed a good sample of what the book is.
It will give you a great understanding at how the book is written, how it approaches explaining things, and the level of detail you can expect. You can also look through the contents listing to see all the various Statistical concepts and expressions that will be covered.
0
Was this review helpful to you?

Very thorough,
0
Was this review helpful to you?

Detailed and Practical Statistics for Beginner and Intermediate Users,
The book then naturally progresses to information about calculating the mean, median and mode, as well as measuring variability and standard deviation. You’ll learn about correlation, pivot tables, ChiSquare functions, normal distribution, testing means, some of the limitations and solutions of using Excel’s functions and tools, plus more. In addition, some more advanced chapters are included that cover ANOVA, multiple regression, ANCOVA, and analysis of covariance.
The book is nicely designed with a font and layout that is easy on the eyes, and includes plenty of Excel screenshots along with many graph figures that are explained in detail. If you’re looking to explore statistics with Microsoft Excel, then you’ll find Statistical Analysis: Microsoft Excel 2013 to be an excellent read. — Find more reviews at NewTechReview.com.
0
Was this review helpful to you?
