Q: The dataset posted below lists a sample of months and the advertising budget (in hundreds of dollars) for TV, radio and newspaper advertisements. Also included is whether a coupon was published for...

Q:
The dataset posted below lists a sample of months and the advertising budget (in hundreds of dollars) for TV, radio and newspaper advertisements. Also included is whether a coupon was published for that month and the resulting sales (in thousands of dollars).

a) Develop a multiple regression model predicting the sales based off the four predictor variables: TV, radio, and newspaper advertising budget and whether a coupon is used.   Recode Coupon as 0 = No and 1 = Yes.   Report the estimated regression equation (Solve in Excel)