Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 11 Times Series 435

5 Click the General tab and click the Columns option button to dis-

play the statistics by columns rather than by rows.

6 Click the Input button and select Fahrenheit from the list of range

names. Click OK.

Now you’ll break down the statistics by decade.

7 Click the By button and select Decade from the range names list.

Click OK.

8 Click the Output button and direct the output to a new worksheet

named Temps by Decade.

9 Click OK.

Excel generates the table shown in Figure 11-3.

Figure 11-3
Temperature

statistics by

decade

Now that you’ve calculated the per-decade averages create a scatter plot

of the values.

To create a scatter plot of the decade averages:

1 Select the nonadjacent cell range B3:B15;D3:D15 from the table of

decade statistics.

2 Click the Line button from the Charts group on the Insert tab and

click the fi rst chart subtype (Line).

3 Move the line chart to a new chart sheet named Decades Chart.