Statistical Analysis with Excel For Dummies. Joseph Schmuller
Читать онлайн книгу.
href="#ulink_ec588966-77b9-511c-b346-308d7ee00265">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