This Fifth Edition of Neil J. Salkind’s Statistics for People Who (Think They) Hate Statistics: Using Microsoft Excel, presents an often intimidating and difficult subject in a way that is clear, informative, and personable. Opening with an introduction to Excel, including coverage of how to use functions and formulas, this edition shows students how to install the Excel Data Analysis Tools option to access a host of useful analytical techniques. New to the Fifth Edition is new co-author Bruce Frey who has added a new feature on statisticians throughout history (with a focus on the contributions of women and people of color). He has updated the "Real-World Stats” feature, and added more on effect sizes, updated the discussions on hypotheses, measurement concepts like validity and reliability, and has more closely tied analytical choices to the level of measurement of variables.
PART I: YIPPEE! I’M IN STATISTICS!
Chapter 1: Statistics or Sadistics? It’s Up to You
Chapter 2: Getting Started in Excel
PART II: SIGMA FREUD AND DESCRIPTIVE STATISTICS
Chapter 3: Computing and Understanding Averages: Means to an End
Chapter 4: Understanding Variability: Vive la Différence
Chapter 5: Creating Graphs: A Picture Really Is Worth a Thousand Words
Chapter 6: Computing Correlation Coefficients: Ice Cream and Crime
Chapter 7: Understanding Reliability and Validity: Just the Truth
PART III: TAKING CHANCES FOR FUN AND PROFIT
Chapter 8: Hypotheticals and You: Testing Your Questions
Chapter 9: Probability and Why It Counts: Fun With a Bell-Shaped Curve
PART IV: SIGNIFICANTLY DIFFERENT: USING INFERENTIAL STATISTICS
Chapter 10: Significantly Significant: What It Means for You and Me
Chapter 11: The One-Sample Z-Test: Only the Lonely
Chapter 12: t(ea) for Two: Tests Between the Means of Different Groups
Chapter 13: t(ea) for Two (Again): Tests Between the Means of Related Groups
Chapter 14: Analysis of Variance: Two Groups Too Many?
Chapter 15: Factorial Analysis of Variance: Two Too Many Factors
Chapter 16: Testing Relationships Using the Correlation Coefficient: Cousins or Just Good Friends?
Chapter 17: Using Linear Regression: Predicting the Future
PART V: MORE STATISTICS! MORE TOOLS! MORE FUN!
Chapter 18: Chi-Square and Some Other Nonparametric Tests: What to Do When You’re Not Normal
Chapter 19: Some Other (Important) Statistical Procedures You Should Know About
Chapter 20: Data Mining: A Introduction to Getting the Most Out of Your BIG Data