Book description
Take the mystery out of statistical terms and put Excel to work!
If you need to create and interpret statistics in business or classroom settings, this easy-to-use guide is just what you need. It shows you how to use Excel's powerful tools for statistical analysis, even if you've never taken a course in statistics. Learn the meaning of terms like mean and median, margin of error, standard deviation, and permutations, and discover how to interpret the statistics of everyday life. You'll learn to use Excel formulas, charts, PivotTables, and other tools to make sense of everything from sports stats to medical correlations.
Statistics have a reputation for being challenging and math-intensive; this friendly guide makes statistical analysis with Excel easy to understand
Explains how to use Excel to crunch numbers and interpret the statistics of everyday life: sales figures, gambling odds, sports stats, a grading curve, and much more
Covers formulas and functions, charts and PivotTables, samples and normal distributions, probabilities and related distributions, trends, and correlations
Clarifies statistical terms such as median vs. mean, margin of error, standard deviation, correlations, and permutations
Statistical Analysis with Excel For Dummies, 3rd Edition helps you make sense of statistics and use Excel's statistical analysis tools in your daily life.
Table of contents
- Cover
- Title Page
- Table of Contents
- Introduction
- Part I: Getting Started with Statistical Analysis with Excel
- Part II: Describing Data
-
Part III: Drawing Conclusions from Data
- Chapter 9: The Confidence Game: Estimation
- Chapter 10: One-Sample Hypothesis Testing
- Chapter 11: Two-Sample Hypothesis Testing
- Chapter 12: Testing More Than Two Samples
- Chapter 13: Slightly More Complicated Testing
- Chapter 14: Regression: Linear and Multiple
- Chapter 15: Correlation: The Rise and Fall of Relationships
- Part IV: Probability
- Part V: The Part of Tens
- Cheat Sheet
Product information
- Title: Statistical Analysis with Excel For Dummies, 3rd Edition
- Author(s):
- Release date: April 2013
- Publisher(s): For Dummies
- ISBN: 9781118464311
You might also like
book
Statistical Analysis with Excel For Dummies, 5th Edition
Become a stats superstar by using Excel to reveal the powerful secrets of statistics Microsoft Excel …
book
Excel Data Analysis For Dummies, 2nd Edition
Harness the power of Excel to discover what your numbers are hiding Excel Data Analysis For …
book
Excel Data Analysis For Dummies, 4th Edition
Take Excel to the next level Excel is the world’s leading spreadsheet application. It’s a key …
book
Statistical Analysis: Microsoft Excel 2016
USE EXCEL’S STATISTICAL TOOLS TO TRANSFORM YOUR DATA INTO KNOWLEDGE Nationally recognized Excel expert Conrad Carlberg …