Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 4 Describing Your Data 173

To create a boxplot of the price data:

1 Click Single Variable Charts from the StatPlus menu and then click

Boxplots.

The Boxplots command allows you to create boxplots on the basis of

values in separate columns or within a single column broken down

by the levels of a categorical variable. In this case you’ll use a single

column, Price, and a categorical variable, NE_Sector.

2 Verify that the Use column of category levels option button is

selected.

3 Click the Data Values button and choose Price from the list of range

names.

4 Click the Categories button and choose NE_Sector from the list of

range names.

5 Click the Output button, click the As a new chart sheet option but-

ton, and type Price Boxplot in the adjacent name box. Click the OK

button. Figure 4-34 shows the completed dialog box.

6 Click the OK button. The output from the Boxplot command is

shown in Figure 4-35.

Figure 4-34
The completed

Boxplots

dialog box