Comcast would like to develop the ability to predict the monthly cable bill for a customer. A multiple regression model was developed using a random sample of customers using the following independent variables: TV: the number of televisions in the household People: the number of people living in the household Years: the number of years that the household has been a Comcast customer The following figure shows the regression output from Excel.

a. Calculate the multiple coefficient of determination.

b. Test the significance of the overall regression model using α = 0.05.

c. Calculate the adjusted multiple coefficient of determination.

Transcribed Image Text:

10 ANOVA 12 Regression 13 Residual 14 Total 15 9526.63 970.33 24 27 Coefficients Standard Error ntercet 39.324715.4384 18. TV 19 People 20 Years 39.3247 1.9025 7.3994 0.8577 3.2437 2.7922 1.2931