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.
Search JabSto ::




Custom Search