Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 4 Describing Your Data 149

To create a stem and leaf plot:

1 Return to the data set by clicking the Housing Data worksheet tab.

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

Stem and Leaf.

This command allows you to create plots of variables located in dif-

ferent columns or within a single column, broken down by category

levels. You’ll do the latter in this case.

3 Verify that the Use column of category levels option button is se-

lected and then click the Data Values button and select Price from

the list of range names. Click OK.

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

range names. Click OK.

5 Click the Apply uniform stem values checkbox. This will apply the same

stem values to home prices both in the northeast sector and elsewhere.

6 Click the Add a summary plot checkbox. This will create a stem

and leaf plot of prices for all of the homes, regardless of location.

7 Click the Output button, click the New Worksheet option button, and type

Price StemLeaf in the New Worksheet name box. Click the OK button.

Figure 4-13 shows the completed Stem and Leaf dialog box.

Figure 4-13
The completed

stem and leaf

dialog box