# Computing Simple Descriptive Statistics in Microsoft® Excel

## Chapter 3, Printout 1

1. Launch Excel.

2. Enter the data.

• In cell A1, type "Supplier 1." In cells A2-A7, enter the data for Supplier 1 (obtained from Table 3.13, p. 94).

• In cell B1, type "Supplier 2." In cells B2-B7, enter the data for Supplier 2.

Screenshot:

3. Display the descriptive statistics for Supplier 1.

• Select "Tools --> Data Analysis."

• In the dialog box that follows, select "Descriptive Statistics" from the list of choices and click "OK."

Screenshot:

• Fill out the next dialog box as follows:

Input Type Label Value
Input Range: \$A\$1:\$A\$7
Columns selected
Labels in First Row checked
Output Range: selected
Output Range: \$A\$11:\$B\$25
Summary statistics checked
Confidence Level for Mean: unchecked
Kth Largest: unchecked
Kth Smallest: unchecked

Screenshot:

• Click "OK."

Excel displays descriptive statistics for Supplier 1 in cells A11-B25.

Note: you can resize Column A to fit its contents by dragging the right-hand border of Column A's header.

Screenshot:

4. Display the descriptive statistics for Supplier 2.

• Follow the steps listed for Supplier 1, but make the following changes to the text fields in the second dialog box:

Input Type Label Value
Input Range: \$D\$1:\$D\$7
Output Range: \$D\$11:\$E\$25

Excel displays descriptive statistics for Supplier 2 in cells D11-E25.

Screenshot: