Microsoft Office Tutorials and References

In Depth Information

**Using the Descriptive Statistics tool**

Figure 17-6
Click the Data Analysis button on the Data tab to display the Data Analysis

dialog box.

Using the Descriptive Statistics tool

The Descriptive Statistics tool provides a table of statistics that shows the general

tendencies and variability for one or more sets of input values. For each variable in the input

range, this toolâ€™s output range includes a detailed list of statistics, as shown in Figure 17-7.

To use the Descriptive Statistics tool, click the Data Analysis button on the Data tab on

the ribbon, select Descriptive Statistics, and click OK. The Descriptive Statistics dialog box

shown in Figure 17-7 appears.

Figure 17-7
We used the Descriptive Statistics tool to generate this table of statistics describing

the column of 1,000 values contained in column A.