Statistical Analysis with Excel® For Dummies®, 3rd Edition -- Contents at a Glance -- Table of Contents -- Introduction -- About This Book -- What You Can Safely Skip -- Foolish Assumptions -- How This Book Is Organized -- Icons Used in This Book -- Where to Go from Here -- Part I: Getting Started with Statistical Analysis with Excel -- Chapter 1: Evaluating Data in the Real World -- The Statistical (And Related) Notions You Just Have to Know -- Inferential Statistics: Testing Hypotheses -- What's New in Excel 2013? -- What's Old in Excel 2013? -- Knowing the Fundamentals -- What's New in This Edition? -- Chapter 2: Understanding Excel's Statistical Capabilities -- Getting Started -- Setting Up for Statistics -- Accessing Commonly Used Functions -- For Mac Users -- Part II:Describing Data -- Chapter 3: Show and Tell: Graphing Data -- Why Use Graphs? -- Some Fundamentals -- Excel's Graphics (Chartics?) Capabilities -- Becoming a Columnist -- Slicing the Pie -- Drawing the Line -- Adding a Spark -- Passing the Bar -- The Plot Thickens -- Finding Another Use for the Scatter Chart -- Power View! -- For Mac Users -- 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 Zs -- Where Do You Stand? -- For Mac Users -- 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 -- For Mac Users -- Chapter 8: What's Normal? -- Hitting the Curve -- A Distinguished Member of the Family -- Part III: Drawing Conclusions from Data -- Chapter 9: The Confidence Game: Estimation.

Understanding Sampling Distribution -- 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 -- Catching Some Z's Again -- t for One -- Testing a Variance -- 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 -- For Mac Users -- Chapter 12: Testing More Than Two Samples -- Testing More Than Two -- Another Kind of Hypothesis, Another Kind of Test -- For Mac Users -- Chapter 13: Slightly More Complicated Testing -- Cracking the Combinations -- Cracking the Combinations Again -- For Mac Users -- Chapter 14: Regression: Linear and Multiple -- The Plot of Scatter -- Graphing Lines -- Regression: What a Line! -- Worksheet Functions for Regression -- Data Analysis Tool: Regression -- Juggling Many Relationships at Once: Multiple Regression -- Excel Tools for Multiple Regression -- For Mac Users -- 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 -- Testing Hypotheses About Correlation -- For Mac Users -- Part IV: Probability -- Chapter 16: 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 17: More on Probability.

Discovering Beta -- Poisson -- Working with Gamma -- Exponential -- Chapter 18: A Career in Modeling -- Modeling a Distribution -- A Simulating Discussion -- For Mac Users -- Part V: The Part of Tens -- Chapter 19: Ten 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 Though It's a Quantitative Variable Is Just Wrong -- Whenever Appropriate, Include Variability in Your Graph -- Be Careful When Relating Statistics Textbook Concepts to Excel -- Chapter 20: Ten Things (Thirteen, Actually) That Just Didn't Fit in Any Other Chapter -- Forecasting Techniques -- Graphing the Standard Error of the Mean -- Probabilities and Distributions -- Drawing Samples -- Testing Independence: The True Use of CHISQ. TEST -- Logarithmica Esoterica -- Sorting Data -- For Mac Users -- Appendix A: When Your Worksheet Is a Database -- Introducing Excel Databases -- Counting and Retrieving -- Arithmetic -- Statistics -- Pivot Tables -- Appendix B: The Analysis of Covariance -- Covariance: A Closer Look -- Why You Analyze Covariance -- How You Analyze Covariance -- ANCOVA in Excel -- And One More Thing -- Index.