Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
Preface vii

Create statistical charts including boxplots, histograms, and normal
probability plots
Create quality control charts
Perform one-sample and two-sample t tests and z tests
Perform non-parametric analyses
Perform time series analyses, including exponential and seasonal
smoothing
Manipulate charts by adding data labels and breaking charts down into
categories
Perform non parametric analyses
Create and analyze tabular data
A full description of these commands is included in the Appendix’s
Reference section and through on-line help available with the application.

Concept Tutorials

Included with the StatPlus add-in are ten interactive Excel tutorials that pro-
vide students a visual and hands-on approach to learning statistical concepts.
These tutorials cover:
Boxplots
Probability
Probability distributions
Random samples
Population statistics
The Central Limit Theorem
Confi dence intervals
Hypothesis tests
Exponential smoothing
Linear regression

• • • • • • • • • • • • • • • • • •
Free download pdf