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 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
