Statistical Analysis with Excel For Dummies. Joseph Schmuller

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