Part 2: Describing Data
by Joseph Schmuller
Statistical Analysis with Excel For Dummies, 4th Edition
- Cover
- 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: 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
- Chapter 16: It’s About Time
- Chapter 17: Non-Parametric 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
Part 2
Describing Data
IN THIS PART …
Summarize and describe data
Work with Excel graphics
Determine central tendency and variability
Work with standard scores
Understand and visualize normal distributions
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.