Perform a statistical analysis
- On the Tools menu, click Data Analysis.
If Data Analysis is not available, load the Analysis ToolPak.
- On the Tools menu, click Add-Ins.
-
In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.
- If necessary, follow the instructions in the setup program.
- In the Data Analysis dialog box, click the name of the analysis tool you want to use, then click OK.
- In the dialog box for the tool you selected, set the analysis options you want.
You can use the Help button on the dialog box to get more information about the options.