Complete this exam with all the requirements, Its for quantitive class, do all exercises no AI$.$

To take this exam, please follow the instructions below.

$$Read each case carefully.

$$Due date: $6$th of December $8$:$00$ hrs$.$

$$You have to complete this one in excel and make your analysis in word.

$$The exam grade is $20$ points.

Instructions: Answer all the questions clearly and justify your calculations. Use the provided data and show the development of the applied formulas.

Case Study: Sales Prediction

The company Sabores del Campo wants to predict sales for its line of natural juices based on advertising and promotional expenses. The historical data is as follows:

Here is the table in the image

Questions:

Build a multiple linear regression model where the independent variables are advertising and promotional expenses, and the dependent variable is sales. a$)$ Define the equation of the model.

b$)$ Perform the calculations to determine the coefficients of the model.

Interpret the obtained coefficients. What do they mean in the business context?

Based on the model, estimate the sales if the company plans to spend $$4,500$ on advertising and $$5,500$ on promotions.