You are here

The Sage website, including book and journal ordering services, may be unavailable due to system maintenance between Saturday 13th and Sunday 14th December. If you need assistance please contact us. Thank you for your patience and we apologise for the inconvenience.

Statistics for People Who (Think They) Hate Statistics
Share
Share

Statistics for People Who (Think They) Hate Statistics
Using Microsoft Excel

Sixth Edition


February 2026 | 496 pages | SAGE Publications, Inc
This Sixth Edition of Salkind and Frey'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. This edition notably offers Excel 2025 for use in statistical analysis, including updated graphics and coverage of how to use functions and formulas.  With improved navigation and a new 4-color format, the book is now offered in the Sage Vantage learning platform with critical thinking tools, practice opportunities, and assessment.  A new section on using AI chatbots for statistics will engage readers. Tried and true features such as the "Path to Wisdom and Knowledge" flowcharts help students learn to select the appropriate statistical test in each of the core chapters. With Excel incorporated throughout, the authors guide students through basic and advanced statistical procedures, from correlation and graph creation to analysis of variance, regression, non-parametric tests, and more
 
Preface
 
Acknowledgments
 
About the Authors
 
Part I: Yippee! I’m in Statistics
 
Chapter 1: Statistics or Sadistics? It’s Up to You
Why Statistics?

 
Descriptive Statistics and Averages

 
Computing the Mean

 
Computing the Median

 
Computing the Mode

 
What Am I Doing in a Statistics Class?

 
Ten Ways to Use This Book (and Learn Statistics at the Same Time!)

 
About the Book’s Features

 
Summary

 
List of Key Terms

 
Activities

 
Review Questions

 
Critical Thinking Questions

 
 
Chapter 2: What Do Your Data Look Like? Summarizing and Picturing Distributions
How Much Information Is in Your Variable?

 
How Much Information Is in Your Variable?

 
All You Need to Know About Using the Amazing Data Analysis Tools

 
All You Need to Know About Using the Amazing Data Analysis Tools

 
Shaping Things Up

 
Using the Amazing Data Analysis Tools to Create a Histogram

 
List of Key Terms

 
Activities

 
Review Questions

 
Critical Thinking Questions

 
 
Chapter 3: Computing Correlation Coefficients: Ice Cream and Crime
How’s Your Relationship?

 
Computing a Pearson Correlation Coefficient

 
What’s It All Mean?

 
Ice Cream Causes Crime (Association vs. Causation)

 
And Now . . . Using Excel’s CORREL Function

 
Creating a Scatterplot

 
Other Cool Correlations

 
Parting Ways: A Bit About Partial Correlations

 
Summary

 
List of Key Terms

 
Activities

 
Review Questions

 
Critical Thinking Questions

 
 
Chapter 4: Reliability and Validity: Tell the Truth, Precisely the Truth
Reliability: Getting It Right the First Time

 
Different Types of Reliability

 
Test–Retest Reliability: Time and Time Again

 
Internal Consistency Reliability: To One’s Own Self Be True

 
Interrater Reliability: Agreeing Not to Disagree

 
How Big Is Big? Interpreting Reliability Coefficients

 
Validity: What’s the Meaning of Life!?

 
Validity and Reliability: Really Close Cousins

 
Summary

 
List of Key Terms

 
Activities

 
Review Questions

 
Critical Thinking Questions

 
 
Part II: Taking Chances for Fun and Profit
 
Chapter 5: The Normal Curve: It’s Shaped Like a Bell and It’s Everywhere!
Distributions and Probabilities

 
Area Codes: Areas Under the Normal Curve

 
The Amazing Super-Informative z Score

 
Using Excel to Compute z Scores

 
Fat and Skinny Frequency Distributions

 
Summary

 
List of Key Terms

 
Activities

 
Review Questions

 
Critical Thinking Questions

 
 
Chapter 6: Hypotheticals and You: Making Guesses
Samples and Populations

 
The Null Hypothesis

 
The Research Hypothesis

 
A Closer Look at Our Two Favorite Hypotheses

 
What Makes a Good Research Hypothesis?

 
Summary

 
List of Key Terms

 
Activities

 
Review Questions

 
Critical Thinking Questions

 
 
Chapter 7: Significance: Not Everything That Can Be Counted Counts
The Concept of Significance

 
If Only We Were Perfect

 
Type I or Type II: Errors in Inferential Statistics

 
Significance Versus Meaningfulness

 
An Introduction to Inferential Statistics

 
An Introduction to Tests of Significance

 
Be Even More Confident

 
Summary

 
List of Key Terms

 
Activities

 
Review Questions

 
Critical Thinking Questions

 
 
Part III: Significantly Different: Using Inferential Statistics
 
Chapter 8: Single Samples: One Group All Alone
Introduction to the Single-Sample z Test

 
Computing the z Test Statistic

 
Using Excel to Perform a z Test t Test

 
Special Effects: Do They Matter?

 
Summary

 
List of Key Terms

 
Activities

 
Review Questions

 
Critical Thinking Questions

 
 
Chapter 9: t(ea) for Two: Comparing Two Means
The Classic Group Comparison: Independent t Test

 
The Classic Group Comparison: Independent t Test

 
Using Excel to Perform an Independent t Test

 
One Group Compared to Itself: Paired-Samples t Test

 
Using Excel to Perform a Paired-Samples t Test

 
Summary

 
List of Key Terms

 
Activities

 
Review Questions

 
Critical Thinking Questions

 
 
Chapter 10: More Than Two Groups? Analysis of Variance to the Rescue
Different Flavors of Analysis of Variance

 
Computing the F Test Statistic

 
Using Excel for One-Way Analysis of Variance

 
The Effect Size for One-Way ANOVA

 
Summary

 
List of Key Terms

 
Activities

 
Review Questions

 
Critical Thinking Questions

 
 
Chapter 11: Two (or More) ANOVAs in One: Factorial Analysis of Variance
Factorial Analysis of Variance

 
A New Flavor of ANOVA

 
The Main Event: Main Effects in Factorial ANOVA

 
Even More Interesting: Interaction Effects

 
Using Excel to Conduct a Factorial Analysis of Variance

 
Computing the Effect Size for Factorial ANOVA

 
Summary

 
List of Key Terms

 
Activities

 
Review Questions

 
Critical Thinking Questions

 
 
Chapter 12: Correlation Coefficients and Regression: Can You Relate?
Remember the Correlation Coefficient?

 
Computing the Test Statistic

 
Linear Regression

 
Drawing the World’s Best Line (for Your Data)

 
How Good Is Your Prediction?

 
Using Excel to Compute the Regression Line

 
Multiple Regression: The More Predictors the Better? Maybe

 
Summary

 
List of Key Terms

 
Activities

 
Review Questions

 
Critical Thinking Questions

 
 
Part IV: More Statistics! More Tools! More Fun!
 
Chapter 13: Chi-Square and Some Other Nonparametric Tests: What to Do When You’re Not Normal
Introduction to Nonparametric Statistics

 
Introduction to the Goodness-of-Fit (One-Sample) Chi-Square

 
Computing the Goodness-of-Fit Chi-Square Test Statistic

 
Introduction to the Chi-Square Test of Independence

 
Using Excel to Perform Chi-Square Tests

 
Other Nonparametric Tests You Should Know About

 
Summary

 
List of Key Terms

 
Activities

 
Review Questions

 
Critical Thinking Questions

 
 
Chapter 14: Some Other (Important) Statistical Stuff You Should Know About
Sophisticated Group Comparisons

 
Sophisticated Group Comparisons

 
It’s Not About What Data Are Mine, It’s About What Data Are Mined

 
Using Chatbots for Statistical Analyses

 
Summary

 
List of Key Terms

 
 
Appendices: Information Never Ends!
 
Appendix A: Excel-erate Your Learning
 
Appendix B: Tables
 
Appendix C: Data Sets
 
Appendix D: Answers to Practice Questions
 
Appendix E: Math: Just the Basics
 
Appendix F: The 10 Commandments of Data Collection
 
Appendix G: The Reward: The Brownie Recipe

For instructors

EC Rep

International Associates Auditing & Certification Limited
The Black Church, St Mary's Place,
Dublin 7, D07 P4AX Ireland
Sage's GPSR statement