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