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

*Statistics for People Who (Think They) Hate Statistics*, this adapted Excel 2016 version presents an often intimidating and difficult subject in a way that is clear, informative, and personable. Researchers and students uncomfortable with the analysis portion of their work will appreciate the book's unhurried pace and thorough, friendly presentation. Opening with an introduction to Excel 2016, including functions and formulas, this edition shows students how to install the Excel Data Analysis Tools option to access a host of useful analytical techniques and then walks them through various statistical procedures, beginning with correlations and graphical representation of data and ending with inferential techniques and analysis of variance.

New to the **Fourth Edition**:

- A new chapter 20 dealing with large data sets using Excel functions and pivot tables, and illustrating how certain databases and other categories of functions and formulas can help make the data in big data sets easier to work with and the results more understandable.
- New chapter-ending exercises are included and contain a variety of levels of application.
- Additional
*TechTalks*have been added to help students master Excel 2016. - A new, chapter-ending
*Real World Stats*feature shows readers how statistics is applied in the everyday world. - Basic maths instruction and practice exercises for those who need to brush up on their math skills are included in the appendix.

Why Statistics? |

A Five-Minute History of Statistics |

Statistics: What It Is (and Isn’t) |

Tooling Around With the Analysis ToolPak |

What Am I Doing in a Statistics Class? |

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

About Those Icons |

Key to Difficulty Icons |

Key to “How Much Excel” Icons |

Little Chapter 1a. All You Need to Know About Formulas and Functions |

What’s a Formula? |

What’s a Function? |

Little Chapter 1b. All You Need to Know About Using the Amazing Analysis ToolPak |

A Look at the Analysis ToolPak |

Don’t Have It? |

Little Chapter 1c. Mac Lovers Rejoice! StatPlus: The Mac Alternative to the Analysis ToolPak |

Little Chapter 1c. For Mac Lovers Who are Still using Version 2011: Rejoice!! And, for Mac Lovers Who are new to Version 2016, Rejoice More!!! |

Computing the Mean |

Computing a Weighted Mean |

Computing the Median |

Computing the Mode |

Using the Amazing Analysis ToolPak to Compute Descriptive Statistics |

When to Use What |

Why Understanding Variability Is Important |

Computing the Range |

Computing the Standard Deviation |

Computing the Variance |

And Now... Using Excel’s VAR.S Function |

The Standard Deviation Versus the Variance |

Using the Amazing Analysis ToolPak (Again!) |

Why Illustrate Data? |

Ten Ways to a Great Figure (Eat Less and Exercise More?) |

First Things First: Creating a Frequency Distribution |

The Plot Thickens: Creating a Histogram |

Fat and Skinny Frequency Distributions |

Excellent Charts |

Excellent Charts Part Deux: Making Charts Pretty |

Other Cool Charts |

What Are Correlations All About? |

Computing a Simple Correlation Coefficient |

More Excel—Bunches of Correlations à la Excel |

Using the Amazing Analysis ToolPak to Compute Correlations |

Understanding What the Correlation Coefficient Means |

As More Ice Cream Is Eaten... the Crime Rate Goes Up (or Association Versus Causality) |

Other Cool Correlations |

An Introduction to Reliability and Validity |

All About Measurement Scales |

Reliability—Doing It Again Until You Get It Right |

Validity—Whoa! What Is the Truth? |

A Last, Friendly Word |

Validity and Reliability: Really Close Cousins |

So You Want to Be a Scientist... |

The Null Hypothesis |

The Research Hypothesis |

What Makes a Good Hypothesis? |

Why Probability? |

The Normal Curve (aka the Bell-Shaped Curve) |

Our Favorite Standard Score: The z Score |

The Concept of Significance |

Significance Versus Meaningfulness |

An Introduction to Inferential Statistics |

An Introduction to Tests of Significance |

An Introduction to Tests of Significance |

Introduction to the One-Sample Z-Test |

Computing the Test Statistic |

Using the Excel Z.TEST Function to Compute the z Value |

Introduction to the t-Test for Independent Samples |

Computing the Test Statistic |

Using the Amazing Analysis ToolPak to Compute the t Value |

Special Effects: Are Those Differences for Real? |

Introduction to the t-Test for Dependent Samples |

Computing the Test Statistic |

Using the Amazing Analysis ToolPak to Compute the t Value |

Introduction to Analysis of Variance |

Computing the F-Test Statistic |

Using the Amazing Analysis ToolPak to Compute the F Value |

Introduction to Factorial Analysis of Variance |

The Main Event: Main Effects in Factorial ANOVA |

Even More Interesting: Interaction Effects |

Computing the ANOVA F Statistic Using the Amazing Analysis ToolPak |

Introduction to Testing the Correlation Coefficient |

Computing the Test Statistic |

What Is Prediction All About? |

The Logic of Prediction |

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

Computing the Regression Equation Using the Amazing Analysis ToolPak |

How Good Is Our Prediction? |

The More Predictors, the Better? Maybe |

Introduction to Nonparametric Statistics |

Introduction to One-Sample Chi-Square |

Computing the Chi-Square Test Statistic |

Other Nonparametric Tests You Should Know About |

Post Hoc Comparisons |

Multivariate Analysis of Variance |

Repeated Measures Analysis of Variance |

Analysis of Covariance |

Multiple Regression |

Logistic Regression |

Factor Analysis |

Data Mining |

Path Analysis |

Structural Equation Modeling |

Selecting the Perfect Statistics Software |

What’s Out There |

How About Studying Statistics in Stockholm? |

Calculators Galore! |

Who’s Who and What’s Happened |

It’s All Here |

HyperStat |

Data? You Want Data? |

More and More Resources |

Plain, But Fun |

Online Statistical Teaching Materials |

And, of Course, YouTube... |

### Supplements

** SAGE edge for Instructors** supports teaching by making it easy to integrate quality content and create a rich learning environment for students.

**Test banks**provide a diverse range of pre-written options as well as the opportunity to edit any question and/or insert personalized questions to effectively assess students’ progress and understanding- Editable, chapter-specific
**PowerPoint**offer complete flexibility for creating a multimedia presentation for the course^{®}slides **Lecture notes**summarize key concepts by chapter to ease preparation for lectures and class discussions**Sample course syllabi**for semester and quarter courses provide suggested models for structuring one’s course**Chapter-specific discussion questions**help launch classroom interaction by prompting students to engage with the material and by reinforcing important content.- Lively and stimulating
**ideas for class activities**that can be used in class to reinforce active learning. The activities apply to individual or group projects. - EXCLUSIVE! Access to full-text
**SAGE journal articles**have been carefully selected to support and expand on the concepts presented in each chapter to encourage students to think critically **Multimedia content**includes original SAGE videos that appeal to students with different learning styles- A
**Course cartridge**with bonus quizzes provides easy LMS integration

__SAGE edge____ for Students__

**provides a personalized approach to help students accomplish their coursework goals in an easy-to-use learning environment.**

- A complete online
**action plan**allows you to track your progress and enhance your learning experience **Learning objectives**reinforce the most important material- Mobile-friendly
**eFlashcards**strengthen understanding of key terms and concepts - Mobile-friendly practice
**quizzes**allow for independent assessment by students of their mastery of course material - Meaningful
**web and video resources**facilitate further exploration of topics, and responses to critical thinking questions __EXCLUSIVE__! Access to full-text**SAGE journal articles**that have been carefully selected to support and expand on the concepts presented in each chapter**Data files**allow you to follow along with the exercises in the book

Clearly explains statistical tests in a straight forward manner, making stats more accessible to undergraduate students. I have been separately integrating Excel into the class and this accomplishes both goals with only one required text.

**Kent School of Social Work, University Of Louisville**

This book is accessible and an easy to read for students research training. Readable and easy to follow.

**Health, The University of Worcester**

This book is amazing-I used it as a student and I'm now happy to pass the new edition on to my students.

**School of Info. & Library Studies SILS, University College Dublin**

This title gives hope to the students that struggle with statistics, however I could not use it for my introductory to Research Methods course. The amount of time consumed in learning to do research, lit reviews, etc, did not allow for the inclusion for this text. However, I see it as the first I would consider for my Advanced Research course.

My lack of adopting this as a text was not related to the quality of the text. I have requested that our campus library also purchase some copies of this item. I would highly recommend for a stats course or an advanced research methods course.

**Communication Arts Dept, Lee University**

Well organized for statistics. Author uses command language and humor to teach

**Emergency Medicine Dept, Univ Of New Mexico Sch Of Med**