Cover

Title Page

Copyright

About the Authors

Preface

Acknowledgments

Contents

Chapter 1 GETTING STARTED WITH EXCEL

Getting Started

Excel and Spreadsheets

Excel Workbooks and Worksheets

Worksheet Cells

Printing from Excel

Saving Your Work

Excel Add-Ins

Features of StatPlus

Exiting Excel

Chapter 2 WORKING WITH DATA

Data Entry

Data Formats

Formulas and Functions

Cell References

Range Names

Sorting Data

Querying Data

Importing Data from Text Files

Importing Data from Databases

Exercises

Chapter 3 WORKING WITH CHARTS

Introducing Excel Charts

Introducing Scatter Plots

Editing a Chart

Identifying Data Points

Creating Bubble Plots

Breaking a Scatter Plot into Categories

Plotting Several Variables

Exercises

Chapter 4 DESCRIBING YOUR DATA

Variables and Descriptive Statistics

Frequency Tables

Working with Histograms

Working with Stem and Leaf Plots

Distribution Statistics

Working with Boxplots

Exercises

Chapter 5 PROBABILITY DISTRIBUTIONS

Probability

Probability Distributions

Random Variables and Random Samples

The Normal Distribution

Excel Worksheet Functions

Parameters and Estimators

The Sampling Distribution

The Central Limit Theorem

Exercises

Chapter 6 STATISTICAL INFERENCE

Confi dence Intervals

Hypothesis Testing

The t Distribution

Applying the t Test to Paired Data

Applying a Nonparametric Test to Paired Data

The Two-Sample t Test

Testing for Equality of Variance

Applying the t Test to Two-Sample Data

Applying a Nonparametric Test to Two-Sample Data

Final Thoughts about Statistical Inference

Exercises

Chapter 7 TABLES

PivotTables

Two-Way Tables

Computing Expected Counts

The Pearson Chi-Square Statistic

Other Table Statistics

Validity of the Chi-Square Test with Small Frequencies

Tables with Ordinal Variables

Exercises

Chapter 8 REGRESSION AND CORRELATION

Simple Linear Regression

Exploring Regression

Performing a Regression Analysis

Checking the Regression Model

Correlation

Creating a Correlation Matrix

Creating a Scatter Plot Matrix

Exercises

Chapter 9 MULTIPLE REGRESSION

Regression Models with Multiple Parameters

Regression Example:Predicting Grades

Testing Regression Assumptions

Regression Example:Sex Discrimination

Exercises

Chapter 10 ANALYSIS OF VARIANCE

One-Way Analysis of Variance

Analysis of Variance Example:Comparing Hotel Prices

Comparing Means

Comparing Means with a Boxplot

One-Way Analysis of Variance and Regression

Two-Way Analysis of Variance

A Two-Factor Example

Two-Way Analysis Example:Comparing Soft Drinks

Summary

Exercises

Chapter 11 TIME SERIES

Time Series Concepts

Time Series Example:The Rise in Global Temperatures

The Autocorrelation Function

Moving Averages

Simple Exponential Smoothing

Two-Parameter Exponential Smoothing

Seasonality

Seasonal Example:Liquor Sales

Three-Parameter Exponential Smoothing

Optimizing the Exponential Smoothing Constant(optional)

Exercises

Chapter 12 QUALITY CONTROL

Statistical Quality Control

Control Charts

The x Chart

The Range Chart

The C Chart

The P Chart

Control Charts for Individual Observations

The Pareto Chart

Exercises

APPENDIX

Excel Reference

Bibliography

Index

Quick Reference Guide