522
The Analysis ToolPak add-ins that come with Excel enable you to perform
basic statistical analysis. None of the output from the Analysis ToolPak is
updated for changing data, so if the source data change, you will have to
rerun the command. To use the Analysis ToolPak, you must fi rst verify that
it is available to your workbook.To check whether the Analysis ToolPak is available:1 Click the Offi ce button and click Excel Options.
2 Click Add-Ins from the list of Excel Options and then click the Go
button next to the Manage Excel Add-Ins list box.
3 Select the Analysis ToolPak checkbox from the Add-Ins dialog box
to activate the Analysis ToolPak add-in and click the OK button.
4 Verify that the add-in is activated by clicking the Data tab and
verifying that the Data Analysis button appears in the Analysis
group.The rest of this section documents each Analysis ToolPak command,
showing each corresponding dialog box and describing the features of the
command.Output Options
All the dialog boxes that produce output share the following output storage
options:Output Range
Click to send output to a cell in the current worksheet, and then type the
cell; Excel uses that cell as the upper left corner of the range.New Worksheet Ply
Click to send output to a new worksheet; then type the name of the
worksheet.Excel’s Data Analysis ToolPak