Part V: Analyzing Data with Excel
782
l (^) Covariance
l Descriptive statistics
l (^) Exponential smoothing
l F-Test
l (^) Fourier analysis
l Histogram
l (^) Moving average
l Random number generation
l (^) Rank and percentile
l Regression
l (^) Sampling
l t-Test (three types)
l (^) z-Test
As you can see, the Analysis ToolPak add-in brings a great deal of functionality to Excel. These
procedures have limitations, however, and in some cases, you may prefer to create your own for-
mulas to do some calculations.
Installing the Analysis ToolPak Add-in
The Analysis ToolPak is implemented as an add-in. Before you can use it, though, you need to
make sure that the add-in is installed. Click the Data tab. If you see an Analysis group, showing
Data Analysis, the Analysis ToolPak is installed. If you can’t access Data ➪ Analysis ➪ Data
Analysis, install the add-in by following these steps:- Choose File ➪ Options to display the Excel Options dialog box.
- In the Excel Options dialog box, click the Add-Ins tab.
- At the bottom of the dialog box, select Excel Add-Ins from the Manage drop-down
list and then click Go. Excel displays the Add-Ins dialog box. - In the Add-Ins dialog box, place a check mark next to Analysis ToolPak.
- Click OK to close the Add-Ins dialog box.
Tip
Pressing Alt+TI is a much quicker way to display the Add-Ins dialog box. n