Читать книгу Statistical Analysis with Excel For Dummies - Joseph Schmuller - Страница 3

1  Cover

2  Title Page

3  Copyright

4  Introduction About This Book What’s New in This Edition What’s New in Excel (Microsoft 365) Foolish Assumptions Icons Used in This Book Where to Go from Here Beyond This Book

5  Part 1: Getting Started with Statistical Analysis with Excel: A Marriage Made in Heaven Chapter 1: Evaluating Data in the Real World The Statistical (and Related) Notions You Just Have to Know Inferential Statistics: Testing Hypotheses Some Excel Fundamentals Chapter 2: Understanding Excel's Statistical Capabilities Getting Started Setting Up for Statistics Creating Your Own Array Formulas Accessing Commonly Used Functions The New Analyze Data Tool Data from Pictures!

6  Part 2: Describing Data Chapter 3: Show-and-Tell: Graphing Data Why Use Graphs? Examining Some Fundamentals Gauging Excel's Graphics (Chartics?) Capabilities Becoming a Columnist Stacking the Columns Slicing the Pie Drawing the Line Adding a Spark Passing the Bar The Plot Thickens Finding Another Use for the Scatter Chart Chapter 4: Finding Your Center Means: The Lore of Averages Medians: Caught in the Middle Statistics à la Mode Chapter 5: Deviating from the Average Measuring Variation Back to the Roots: Standard Deviation Related Functions Chapter 6: Meeting Standards and Standings Catching Some Z’s Where Do You Stand? Chapter 7: Summarizing It All Counting Out The Long and Short of It Getting Esoteric Tuning In the Frequency Can You Give Me a Description? Be Quick About It! Instant Statistics Chapter 8: What's Normal? Hitting the Curve A Distinguished Member of the Family Graphing a Standard Normal Distribution

7  Part 3: Drawing Conclusions from Data Chapter 9: The Confidence Game: Estimation Understanding Sampling Distributions An EXTREMELY Important Idea: The Central Limit Theorem The Limits of Confidence Fit to a t Chapter 10: One-Sample Hypothesis Testing Hypotheses, Tests, and Errors Hypothesis Tests and Sampling Distributions Catching Some Z's Again t for One Visualizing a t-Distribution Testing a Variance Visualizing a Chi-Square Distribution Chapter 11: Two-Sample Hypothesis Testing Hypotheses Built for Two Sampling Distributions Revisited t for Two A Matched Set: Hypothesis Testing for Paired Samples Testing Two Variances Visualizing the F-Distribution Chapter 12: Testing More Than Two Samples Testing More than Two Another Kind of Hypothesis, Another Kind of Test ANOVA on the iPad ANOVA on the iPad: Another Way Repeated Measures ANOVA on the iPad Chapter 13: Slightly More Complicated Testing Cracking the Combinations Cracking the Combinations Again Two Kinds of Variables — at Once Using Excel with a Mixed Design Graphing the Results After the ANOVA Two-Factor ANOVA on the iPad Chapter 14: Regression: Linear and Multiple The Plot of Scatter Graphing a line Regression: What a Line! Worksheet Functions for Regression Data Analysis Tool: Regression Juggling Many Relationships at Once: Multiple Regression Excel Tools for Multiple Regression Regression Analysis on the iPad Chapter 15: Correlation: The Rise and Fall of Relationships Scatterplots Again Understanding Correlation Correlation and Regression Testing Hypotheses about Correlation Worksheet Functions for Correlation Data Analysis Tool: Correlation Data Analysis Tool: Covariance Using Excel to Test Hypotheses about Correlation Correlation Analysis on the iPad Chapter 16: It’s About Time A Series and Its Components A Moving Experience How to Be a Smoothie, Exponentially One-Click Forecasting Working with Time Series on the iPad Chapter 17: Nonparametric Statistics Independent Samples Matched Samples Correlation: Spearman’s r_S A Heads-Up

8  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 Discovering Beta Poisson Working with Gamma Exponential Chapter 20: Using Probability: Modeling and Simulation Modeling a Distribution A Simulating Discussion Chapter 21: Estimating Probability: Logistic Regression Working Your Way Through Logistic Regression Mining with XLMiner

9  Part 5: The Part of Tens Chapter 22: Ten (12, Actually) 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 a Quantitative Variable Is Just Plain Wrong Whenever Appropriate, Include Variability in Your Graph Be Careful When Relating Statistics Textbook Concepts to Excel It’s Always a Good Idea to Use Named Ranges in Excel Statistical Analysis with Excel on the iPad Is Pretty Good! Chapter 23: Ten Topics (Thirteen, Actually) That Just Don't Fit Elsewhere Graphing the Standard Error of the Mean Probabilities and Distributions Drawing Samples Testing Independence: The True Use of CHISQ.TEST Logarithmica Esoterica Sorting Data

10  Part 6: Appendices Appendix A: When Your Data Live Elsewhere Appendix B: Tips for Teachers (and Learners) Augmenting Analyses Is a Good Thing Simulating Data Is Also a Good Thing When All You Have Is a Graph Appendix C: More on Excel Graphics 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 Filled Maps Appendix D: The Analysis of Covariance Covariance: A Closer Look Why You Analyze Covariance How You Analyze Covariance ANCOVA in Excel And One More Thing

11  Index

12  About the Author

13  Connect with Dummies

14  End User License Agreement