Statistical Analysis with Excel For Dummies. Joseph Schmuller
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 rS 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