Additional Profit	TV ads	Newspaper ads
$18,500.00	0	50
$20,400.00	40	0
$24,000.00	30	30
$36,800.00	50	35
$32,050.00	25	38
$28,875.00	40	25
$46,250.00	45	45
$54,000.00	48	52
$35,000.00	55	20
$54,200.00	60	30
$72,000.00	65	45
$68,000.00	60	40

1. The data in the Excel file Homework 2 Question 1 Data, posted with this assignment, 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 b₁ and b₂ for this problem.

(c) Interpret the meaning of Y-intercept b₀ 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 and interpret its meaning.

Note: Please include the Excel worksheet with all the details with your answer.