Book description
Learn all of Excel's statistical tools
Test your hypotheses and draw conclusions
Use Excel to give meaning to your data
Use Excel to interpret stats
Statistical analysis with Excel is incredibly useful—and this book shows you that it can be easy, too! You'll discover how to use Excel's perfectly designed tools to analyze and understand data, predict trends, make decisions, and more. Tackle the technical aspects of Excel and start using them to interpret your data!
Inside...
 Covers Excel 2016 for Windows® & Mac® users
 Check out new Excel stuff
 Make sense of worksheets
 Create shortcuts
 Tool around with analysis
 Use Quick Statistics
 Graph your data
 Work with probability
 Handle random variables
Table of contents

 Cover
 Introduction
 Part 1: Getting Started with Statistical Analysis with Excel: A Marriage Made in Heaven

Part 2: Describing Data

Chapter 3: Show and Tell: Graphing Data
 Why Use Graphs?
 Some Fundamentals
 Excel’s Graphics (Chartics?) Capabilities
 Becoming a Columnist
 Slicing the Pie
 Drawing the Line
 Adding a Spark
 Passing the Bar
 The Plot Thickens
 Finding Another Use for the Scatter Chart
 Tasting the Bubbly
 Taking Stock
 Scratching the Surface
 On the Radar
 Growing a Treemap and Bursting Some Sun
 Building a Histogram
 Ordering Columns: Pareto
 Of Boxes and Whiskers
 3D Maps
 Chapter 4: Finding Your Center
 Chapter 5: Deviating from the Average
 Chapter 6: Meeting Standards and Standings
 Chapter 7: Summarizing It All
 Chapter 8: What’s Normal?

Chapter 3: Show and Tell: Graphing Data

Part 3: Drawing Conclusions from Data
 Chapter 9: The Confidence Game: Estimation
 Chapter 10: OneSample Hypothesis Testing
 Chapter 11: TwoSample 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
 Chapter 16: It’s About Time
 Chapter 17: NonParametric Statistics

Part 4: Probability

Chapter 18: Introducing Probability
 What Is Probability?
 Compound Events
 Conditional Probability
 Large Sample Spaces
 Worksheet Functions
 Random Variables: Discrete and Continuous
 Probability Distributions and Density Functions
 The Binomial Distribution
 Worksheet Functions
 Hypothesis Testing with the Binomial Distribution
 The Hypergeometric Distribution
 Chapter 19: More on Probability
 Chapter 20: A Career in Modeling

Chapter 18: Introducing Probability

Part 5: The Part of Tens

Chapter 21: Ten Statistical and Graphical Tips and Traps
 Significant Doesn’t Always Mean Important
 Trying to Not Reject a Null Hypothesis Has a Number of Implications
 Regression Isn’t Always Linear
 Extrapolating Beyond a Sample Scatterplot Is a Bad Idea
 Examine the Variability Around a Regression Line
 A Sample Can Be Too Large
 Consumers: Know Your Axes
 Graphing a Categorical Variable as Though It’s a Quantitative Variable Is Just Wrong
 Whenever Appropriate, Include Variability in Your Graph
 Be Careful When Relating Statistics Textbook Concepts to Excel
 Chapter 22: Ten Things (Twelve, Actually) That Just Didn’t Fit in Any Other Chapter
 Appendix A: When Your Worksheet Is a Database
 Appendix B: The Analysis of Covariance

Chapter 21: Ten Statistical and Graphical Tips and Traps
 About the Author
 Advertisement Page
 Connect with Dummies
 End User License Agreement
Product information
 Title: Statistical Analysis with Excel For Dummies, 4th Edition
 Author(s):
 Release date: July 2016
 Publisher(s): For Dummies
 ISBN: 9781119271154
You might also like
book
Data Smart: Using Data Science to Transform Information into Insight
Data Science gets thrown around in the press like it's magic. Major retailers are predicting everything …
book
Statistics Essentials For Dummies
Statistics Essentials For Dummies (9781119590309) was previously published as Statistics Essentials For Dummies (9780470618394). While this …
book
Excel 2019 Bible
The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, …
book
40 Algorithms Every Programmer Should Know
Learn algorithms for solving classic computer science problems with this concise guide covering everything from fundamental …