 # Understanding Basic Statistics with Spreadsheets, 1st edition

• Michael J. Tagler

## Overview

Understanding basic statistics is essential for the behavioral science student. Understanding statistics involves knowing how to analyze, interpret, and make decisions about data collected from empirical research. Data collection is the foundation of science and statistics are the set of tools we use to make sense of the data.

Why Use Computer Spreadsheets to Understand and Perform Statistical Procedures?

The traditional approach to teaching and learning statistics involved the use of chalkboards, paper and pencil, and perhaps a hand-held calculator. The result was a computationally demanding, effortful, and unfortunately error-prone and frustrating experience for many students.  Understanding Basic Statistics with Spreadsheets directly addresses this challenge by teaching statistics in the context of computer spreadsheets:  a format that many students will find familiar and applicable to their future careers.

Chapter 1 Introduction and Performing Basic Spreadsheet Operations: Formulas and Functions

Chapter 2 Frequency Distributions and Histograms: Looking at Your Data!

Chapter 3 Measures of Central Tendency: Mean, Median, and Mode

Chapter 4 Measures of Variability: How Much Spread?

Chapter 5 Examining Distributions: The Normal and the Not-So-Normal

Chapter 6 Standard Scores: Comparing Apples to Oranges

(and lessons in how constants impact distributions)

Chapter 7 The Single-sample z and t Tests: Comparing a sample mean to a population mean

Chapter 8 Two Sample t Tests: Comparing two sample means

Chapter 9 One-Way Between Groups ANOVA: Comparing 2+ sample means

Chapter 10 Two-Way Between Groups ANOVA:

Analyzing data from studies with more than one categorical predictor

Chapter 11 Correlation and Regression: Describing Relationships and Predicting

Chapter 12 Chi-Square Tests: Analysis of Nominal Variables

## For teachers

All the material you need to teach your courses.

Discover teaching material