Statistical Analysis: Microsoft Excel 2013

Statistical Analysis: Microsoft Excel 2013

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 real-world 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 crystal-clear instructions, insider insights, and complete step-by-step projects—all complemented by extensive web-based 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 Add-in
  • 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″]

3 comments

  1. 3 of 3 people found the following review helpful
    4.0 out of 5 stars
    A Practical Use of Statistics for people without a lot (or any) statistical background, May 29, 2014
    By 
    Broken

    This is a pretty good book. As I am still working my way through it I can’t speak for the later chapters more than my skimming them to see what they contained.
    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 re-read 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

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

  2. 1 of 1 people found the following review helpful
    4.0 out of 5 stars
    Very thorough, May 30, 2014
    By 
    steven oden “steven” (decatur, GA) –

    This review is from: Statistical Analysis: Microsoft Excel 2013 (Paperback)
    As an advanced user of Excel I did not find this book as helpful as some others may find it. However, I highly recommend this book for newer/intermediate users of excel & statistical analysis. This book gives very thorough and step by step instructions from the very simple statistical analysis (Mean, median, etc…) to the more advanced types of analysis (Multiple regression, CoVar, etc…). If you are a beginner to statistical analysis in excel or an intermediate user you will find this book helpful with designing meaningful workbooks. You will also have an easy to read reference with step by step instructions on how to set up the statistical analysis you wish to perform.

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

  3. 4.0 out of 5 stars
    Detailed and Practical Statistics for Beginner and Intermediate Users, September 14, 2014
    This review is from: Statistical Analysis: Microsoft Excel 2013 (Paperback)
    One thing to note about this book before you consider your purchase is that it assumes you are a complete beginner and know basically nothing about statistics, however, you do need at least a basic knowledge of how to use Excel. In addition, it is not an Excel reference guide. For that you’ll need to look elsewhere or at the Excel manual. With that said, Statistical Analysis: Microsoft Excel 2013 is an excellent guide to statistics and Excel forumlas. The books starts with a brief introduction and then a first chapter about variables and values in Excel.

    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, Chi-Square 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

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

Leave a Reply to steven oden "steven" Cancel reply

Your email address will not be published. Required fields are marked *