Data Analysis with Microsoft Excel: Updated for Office 2007

308 Fundamentals of Statistics Figure 7-28 Custom sort order 10 Click the OK button twice to return to the workbook. Now create ...

Chapter 7 Tables 309 Excel automatically sorts the Interest categories in the PivotTable in the proper order—least, low, some, h ...

310 Fundamentals of Statistics Use Excel’s CHITEST function to deter- mine whether this is enough evidence to reject a hypothesi ...

Chapter 7 Tables 311 The data in the Marriage workbook contain information on the heights of newly married couples. The study i ...

312 Fundamentals of Statistics c. Create a PivotTable of Political Party versus Gender, removing any blank categories from the t ...

313 Chapter 8 REGRESSION AND CORRELATION Objectives In this chapter you will learn to: Fit a regression line and interpret the c ...

T his chapter examines the relationship between two variables using linear regression and correlation. Linear regression estimat ...

Chapter 8 Regression and Correlation 315 Suppose that x is years on the job and y is salary. Then the y intercept (^1) x 502 is ...

316 Statistical Methods is as small as possible. This procedure is called the least-squares method. The values a and b that resu ...

Chapter 8 Regression and Correlation 317 Table 8-2 Calculating Least-Squares Estimates Function Description INTERCEPT(y, x) Calc ...

318 Statistical Methods 3 After you are fi nished working with the fi le, close it. Figure 8-2 Explore Regression worksheet Perf ...

Chapter 8 Regression and Correlation 319 Table 8-3 Data for the Breast Cancer Workbook Range Name Range Description Region A2:A1 ...

320 Statistical Methods Plotting Regression Data Before you calculate any regression statistics, you should always plot your dat ...

Chapter 8 Regression and Correlation 321 Now you’ll add a regression line to the data. To add a regression line: 1 Right-click a ...

322 Statistical Methods regression equation and r^2 value regression line Figure 8-7 Fitted regression line 3 Click the Display ...

Chapter 8 Regression and Correlation 323 the mortality index can be explained by the change in annual mean tempera- ture. The re ...

324 Statistical Methods 7 Click the New Worksheet Ply option button and type Regression Statistics in the accompanying text box. ...

Chapter 8 Regression and Correlation 325 The output is divided into six areas: regression statistics, analysis of vari- ance (AN ...

326 Statistical Methods This statistic will be covered more in depth in Chapter 9. Finally, the stan- dard error measures the si ...

Chapter 8 Regression and Correlation 327 The MS (mean square) column displays the sum of squares divided by the degrees of freed ...