Microsoft Office Tutorials and References

In Depth Information

**Enable the Analysis ToolPak Add-In**

Enable the Analysis

ToolPak Add-In

You can access a number of powerful statistical

analysis tools by loading the Analysis ToolPak

add-in. The Analysis ToolPak consists of 19

statistical tools, including the following:

Correlation — Returns the correlation

coefficient, which is a measure of the

relationship between two sets of data.

Covariance — Returns the average of the

products of deviations for each data point pair.

Covariance is a measure of the relationship

between two sets of data.

Descriptive Statistics — Generates a report

showing various statistics (such as median,

mode, and standard deviation) for a set of data.

Exponential Smoothing — Returns a

predicted value based on the forecast for

the previous period, adjusted for the error in

that period.

Histogram — Calculates individual and

cumulative frequencies for a range of data and

a set of data bins.

Moving Average — Smoothes a data series by

averaging the series values over a specified

number of preceding periods.

Random Number Generation — Fills a range

with independent random numbers.

Rank and Percentile — Creates a table

containing the ordinal and percentage rank of

each value in a set.

Regression — Performs a linear regression

analysis that fits a line through a set of values

using the least squares method.

1
Click the File tab.

2
Click Options.

1

2

The Excel Options dialog

box appears.

3
Click Add-Ins.

4
In the Manage

drop-down list, click

Excel Add-ins.

5
Click Go.

3

4

5