TABLE 17-5
You worked as an intern at We Always Win Car Insurance Company last summer. You
notice that individual car insurance premiums depend very much on the age of the
individual, the number of traffic tickets received by the individual, and the population
density of the city in which the individual lives. You performed a regression analysis in
EXCEL and obtained the following information:
Referring to Table 17-5, the residual mean squares (MSE) that are missing in the
ANOVA table should be ________.
TABLE 16-6
The president of a chain of department stores believes that her stores’ total sales have
been showing a linear trend since 1993. She uses Microsoft Excel to obtain the partial
output below. The dependent variable is sales (in millions of dollars), while the
independent variable is coded years, where 1993 is coded as 0, 1994 is coded as 1, etc.
SUMMARY OUTPUT