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. Test the significance of each independent variable using α = 0.05.
b. Construct a 95% confidence interval for each regression coefficient and interpret the meaning.

Transcribed Image Text:

10 ANOVA 5S 9526.63 7970.33 17496.96 12 Regression 13 Residual 14 Total 15 16 17 Intercept 18 TV 19 People 20 Years 24 27 39.3247 11.9025 7.399 0.8577 Coefficlents Standord Error 15.4384 3.2437 2.7922 1.2931