Question
The data in the file Homework 2 Question 1 Data(image attached) , gives the additional profit for a product obtained by advertising in TV and
The data in the file Homework 2 Question 1 Data(image attached), gives the additional profit for a product obtained by advertising in TV and Newspaper. Determine a multiple linear regression model by applying the Regression tool in Excel Data Analysis. Use additional profit as the dependent variable and TV ads and newspaper ads as the two independent variables.
(a) State the multiple regression equation.
(b) Interpret the meaning of the slopes b1 and b2 for this problem.
(c) Interpret the meaning of Y-intercept b0 for this problem.
(d) Predict the average additional profit obtained for 40 TV ads and 45 newspaper ads?
(e) Determine the coefficient of multiple determination and interpret its meaning.
(f) Determine the adjusted R2adj and interpret its meaning.