Statistical analysis with Excel for dummies
(eBook)

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 CapabilitiesGetting 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 AverageMeasuring 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 DistributionAn 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 TestingCracking 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.