Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
Chapter 4 Describing Your Data 137

3 Select the range G2:G3, drag the fi ll handle down to cell G20, and
release the mouse button.
The values 50,000–230,000, should be now entered into the cell
range G2:G20.
4 Click Descriptive Statistics from the StatPlus menu and then click
Frequency Tables.
5 Click the Data Values button and select Price as the data variable.
6 Click the Bin Values button.
7 Click the Use Range References option button, select the range
G1:G20, and then click OK.
8 Click the <= bin and > previous bin option button to control how
the bin counts are determined.
9 Click the Output button, click the Cells option button, and select
cell G1. Click the OK button.
10 Click the OK button to start generating the frequency table with your
customized bin values. Figure 4-5 displays the new frequency table.

Figure 4-5
Frequency
table with
user-defined


bin values
Free download pdf