# Question

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. Interpret the meaning of all three regression coefficients.

b. Predict the average cable bill for a household with three televisions, with five people in residence, and six years of being a customer.

a. Interpret the meaning of all three regression coefficients.

b. Predict the average cable bill for a household with three televisions, with five people in residence, and six years of being a customer.

## Answer to relevant Questions

Consider the following set of dependent and independent variables. These data can also be found in the Excel file Prob 151.xlsx. a. Using PHStat, identify the SST, SSR, and SSE. b. Calculate the multiple coefficient of ...A finance executive would like to determine if a relationship exists between the current earnings per share (EPS) of a bank and the following independent variables: • Total assets ($ billions) • Previous period’s ...Consider the following set of dependent and independent variables. These data can also be found in the Excel file Prob 151.xlsx. a. Using PHStat, construct a regression model using both independent variables. b. Test the ...A finance executive would like to determine if a relationship exists between the current earnings per share (EPS) of a bank and the following independent variables: • Total assets ($ billions) • Previous period’s ...Suppose the Bank of Delaware would like to develop a regression model to predict a person’s credit score based on his or her age, weekly income, education level (high school, bachelor’s degree, graduate degree), and ...Post your question

0