Microsoft Office Tutorials and References
In Depth Information
Enable the Analysis ToolPak Add-In
Enable the Analysis
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
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.
The Excel Options dialog
3 Click Add-Ins.
4 In the Manage
drop-down list, click
5 Click Go.