Data Analysis with Microsoft Excel: Updated for Office 2007

368 Statistical Methods find that it helps to make the variance more constant, but the regression results are about the same. Ca ...

Chapter 9 Multiple Regression 369 The plots are shown in a cascading format, in which the plot title is often the only visible e ...

370 Statistical Methods Normal Errors and the Normal Plot What about the assumption of normal errors? Usually, if there is a pro ...

Chapter 9 Multiple Regression 371 Summary of Calc Analysis What main conclusions can you make about the calculus data, now that ...

372 Statistical Methods In this example, you use salary as the dependent variable, using four other quantitative variables as pr ...

Chapter 9 Multiple Regression 373 Using a SPLOM to See Relationships To get a sense of the relationships among the variables for ...

374 Statistical Methods Focus on the last row because it shows the relationships of the other variables to salary. Years employe ...

Chapter 9 Multiple Regression 375 You might wonder why the variable Age Hired is used instead of em- ployee age. The problem wit ...

376 Statistical Methods Multiple Regression What happens when you throw all four predictors into the regression pot? To specify ...

Chapter 9 Multiple Regression 377 Interpreting the Regression Output The R^2 of 0.732 shows that the regression explains 73.2% o ...

378 Statistical Methods There does not appear to be a problem with nonconstant variance. At least, there is not a big change in ...

Chapter 9 Multiple Regression 379 To create a normal probability plot of the residuals: 1 Click the Male Faculty Regression shee ...

380 Statistical Methods Are Female Faculty Underpaid? Being satisfi ed with the validity of the regression on males, let’s go ah ...

Chapter 9 Multiple Regression 381 To see whether females are paid about the same salary that would be pre- dicted if they were m ...

382 Statistical Methods Out of 37 female faculty, only 5 have salaries greater than what would be predicted if they were males, ...

Chapter 9 Multiple Regression 383 On the basis of the descriptive statistics, you can conclude that the female faculty are paid, ...

384 Statistical Methods 3 Give a chart title of Residuals vs. Age Hired, and label the x axis Age Hired and the y axis Residuals ...

Chapter 9 Multiple Regression 385 This plot shows a salary defi ciency that depends very much on the age at which a female was h ...

386 Statistical Methods Use Excel’s FINV function to calculate the critical value for the following F distributions (assume tha ...

Chapter 9 Multiple Regression 387 a company understate the calorie content? f. Save your changes to the workbook and write a rep ...