Data Analysis with Microsoft Excel: Updated for Office 2007

348 Statistical Methods good way to locate problem banks before it is too late. e. Save your changes to the workbook and write a ...

Chapter 8 Regression and Correlation 349 during 1991. INC90 is the percentage net income for 1990, and similarly, INC91 is the p ...

350 Statistical Methods the correlation between the month number and the average draft number. How do the values of the correlat ...

Chapter 8 Regression and Correlation 351 The Highway workbook contains data on highway fatalities per million vehicle miles fro ...

352 Objectives In this chapter you will learn to: Use the F distribution Fit a multiple regression equation and interpret the re ...

Chapter 9 Multiple Regression 353 Regression Models with Multiple Parameters In Chapter 8, you used simple linear regression to ...

354 Statistical Methods 2 Click F from the Table of Contents column. Review the material and scroll to the bottom of the workshe ...

Chapter 9 Multiple Regression 355 To change the p value: 1 Click the Critical Value box, type 0.10, and then press Enter. This g ...

356 Statistical Methods Notice that walks have a coeffi cient of 0.39, and singles have a coeffi - cient of 0.47, so a walk has ...

Chapter 9 Multiple Regression 357 You can use the Analysis ToolPak Regression command to perform a multiple regression on the da ...

358 Statistical Methods 6 Click OK. Figure 9-2 The completed Regression dialog box Excel creates a new sheet, Multiple Reg, whic ...

Chapter 9 Multiple Regression 359 There are many different parts to an ANOVA table. At this point, you should just concentrate o ...

360 Statistical Methods The R Square value in cell B5 (.372) is the coeffi cient of determination R^2 discussed in the previous ...

Chapter 9 Multiple Regression 361 Coeffi cients and the Prediction Equation At this point you know the model is statistically si ...

362 Statistical Methods Notice the Gender Code coeffi cient, 2.627, which shows the effect of gen- der if the other variables ar ...

Chapter 9 Multiple Regression 363 predictors can be predicted from the others, any single predictor can be eliminated without lo ...

364 Statistical Methods Now create a scatter plot of the data in the range H1:I81. To create the scatter plot of the observed sc ...

Chapter 9 Multiple Regression 365 3 Click the y-axis button and select Calc from the list of range names and click the OK button ...

366 Statistical Methods Does it appear that the range of values is narrower for large values of pre- dicted calculus score? If t ...

Chapter 9 Multiple Regression 367 This plot is useful for verifying the regression assumptions. For example, the fi rst assumpti ...