Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 11 Times Series 433

To open the Global Temperature workbook:

1 Open the Global Temperature workbook from the Chapter11 data

folder.

2 Save the workbook as Global Temperature Analysis. The workbook

appears as shown in Figure 11-1.

Figure 11-1
The Global
Temperature
workbook

Plotting the Global Temperature Time Series

Before doing any computations, it is best to explore the time series graphi-

cally. You’ll plot the average annual temperatures in degrees Fahrenheit.

To plot the annual average temperature readings:

1 Select the nonadjacent range A1:A129;D1:D129.

2 Click the Scatter button from the Charts group on the Insert tab.

3 Click the third scatter chart subtype (Scatter with Smooth lines).

4 Scroll up to the top of the window, and with the chart still selected,

click the Move Chart button from the Location group on the Design

tab of the Chart Tools ribbon. Move the chart to a new chart sheet

named Temperature Chart.