Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 8 Regression and Correlation 319

Table 8-3 Data for the Breast Cancer Workbook

Range Name Range Description

Region A2:A17 A number indicating the region where the data have

been collected

Temperature B2:B17 The mean annual temperature of the region

Mortality C2:C17 Mortality index for neoplasms of the female breast

for the region

You’ve been asked to determine whether there is evidence of a linear

relationship between the mean annual temperature in the region and the

mortality index. Is the mortality index different for women who live in re-

gions with different temperatures?

To open the Breast Cancer workbook:

1 Open the Breast Cancer workbook from the Chapter08 folder.

2 Save the workbook as Breast Cancer Regression. The workbook

appears as shown in Figure 8-3.

breast cancer

mortality index

annual mean

temperature of the

region in degrees

Fahrenheit

Figure 8-3
The Breast Cancer
workbook