Microsoft Office Tutorials and References
In Depth Information
After the installation is complete, the Data Analysis item appears in the Analysis group
on the Data tab.
You then click the item representing the type of data analysis you want to perform, click
OK, and use the commands in the resulting dialog box to analyze your data.
In this exercise, you’ll use the Analysis ToolPak to generate descriptive statistics of driver
sorting time data.
SET UP You need the DriverSortTimes_start workbook located in your Chapter08
practice file folder to complete this exercise. Open the DriverSortTimes_start
workbook, and save it as DriverSortTimes . Then follow the steps.
1. On the Data tab, in the Analysis group, click Data Analysis .
The Data Analysis dialog box opens.
2. Click Descriptive Statistics , and then click OK .
The Descriptive Statistics dialog box opens.
3. Click in the Input Range field, and then select cells C3:C17 .
$C$3:$C$17 appears in the Input Range field.