Excel’s Statistical Tools
Excel comes with 81 statistical functions and 59 mathematical functions.
There are also functions devoted to business and engineering problems. The
statistical functions that basic Excel provides include descriptive statistics
such as means, standard deviations, and rank statistics. There are also
cumulative distribution and probability density functions for a variety of
distributions, both continuous and discrete.
The Analysis ToolPak is an add-in that is included with Excel. If you
have not loaded the Analysis ToolPak, you will have to install it from your
original Excel installation.
The Analysis ToolPak adds the following capabilities to Excel:
Analysis of variance, including one-way, two-way without replication,
and two-way balanced with replication
Correlation and covariance matrices
Tables of descriptive statistics
One-parameter exponential smoothing
Histograms with user-defi ned bin values
Moving averages
Random number generation for a variety of distributions
Rank and percentile scores
Multiple linear regression
Random sampling
t tests, including paired and two sample, assuming equal and unequal
variances
z tests
In this book we make extensive use of the Analysis ToolPak for multiple
linear regression problems and analysis of variance.StatPlus™
Since the Analysis ToolPak does not do everything that an introductory sta-
tistics course requires, this textbook comes with an additional add-in called
the StatPlus™ Add-In that fi lls in some of the gaps left by basic Excel 2007
and the Analysis ToolPak.
Additional commands provided by the StatPlus Add-In give users the
ability to:
Create random sets of data
Manipulate data columns
Create random samples from large data sets
Generate tables of univariate statistics• • • • • • • • • • • • • • • •
vi Preface