Microsoft Excel provides a set of data analysis tools - called the Analysis ToolPak - that you can use to save huge amounts of time when you perform complex statistical analyses.
However, there is one catch (see WARNING below).

You input the data and parameters for each analysis; the tool uses the appropriate statistical functions and then displays the results in an output table. Some tools generate charts in addition to output tables.

Before using an analysis tool, you must arrange the data you want to analyze in columns or rows on your worksheet. This is your input range.

If the Data Analysis command is not on the Excel Tools menu, you need to install the Analysis ToolPak:

1. On the Tools menu, click Add-Ins.
2. Select the Analysis ToolPak check box.
3. Install.

To use the Analysis ToolPak:

1. On the Tools menu, click Data Analysis.
2. In the Analysis Tools box, click the tool you want to use.
3. Enter the input range and the output range, and then select the options you want: