Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1

318 Statistical Methods


3 After you are fi nished working with the fi le, close it.


Figure 8-2
Explore
Regression
worksheet

Performing a Regression Analysis


The Breast Cancer workbook contains data from a 1965 study analyzing
the relationship between mean annual temperature and the mortality rate
for women with a certain type of breast cancer. The subjects came from 16
different regions in Great Britain, Norway, and Sweden. Table 8-3 presents
the data.
Free download pdf