1.Place the quantity (Y_t), price (P_t) and advertising (R_t) data from Table 1 in a Microsoft Excel spread sheet and calculate the following values:

2 Manually calculate the following values in deviation form:

a. Sum values

b. Standard deviations

3 Manually calculate the₁,₂and-coefficient values.

4 Prepare a correlation matrix for the variables: quantity, price, and advertising expenditures.

5 In a Spreadsheet, manually calculate the following values:

a. The total sum of the square'sSST.

b. The standard error of the estimated regression equations_e.

c. Calculate the standard error of the estimated coefficients ₁en ₂.

d. The Durbin-Watson-statistic:DW.

6 Further manually calculate the following values:

a. Sum of the squares due to regressionSSR

b. The determination coefficientR5.

c. The adjusted multiple determination coefficientsR_a5.

7 a. Calculate thet-values of the estimated ₁- and ₂-coefficients.

b. Are these significant at the 5 %-level?

8 Is autocorrelation present in the residuals?

9 Calculate theMPE- andMAPE-values for your estimated model.

10 Present your estimated model in a formal way with the associated accuracy measurements.

Product C: Quantity, Price, Advertising, and Rival Price Quantity Price Advertising Rival (x 1 000) (x 1 000) price t Y Pt PF 2019 5.399 12.75 10.250 12.75 2 5.408 12.75 10.250 12.75 3 5.323 11.75 10.000 11.50 4 5.340 11.75 10.100 11.50 U 5.520 11.50 10.400 11.25 6 5.487 11.88 10.270 1175 5.509 12.38 10.400 1213 8 5.559 11.75 10.750 11.50 9 5.450 11.75 10.270 11.50 10 5.454 10.88 10.270 10.38 11 5.467 10.38 10.270 9.38 12 5.527 10.00 10.400 9.00 2020 5.587 10.00 10.800 8.25 2 5.620 9.75 10.820 8.50 3 5.569 9.75 10.750 8.50 5.666 9.75 10.820 9.50 5.733 10.00 11.100 10.50 JOU 5.714 10.00 11.000 10.50 5.736 10.25 11.100 10.50 8 5.812 10.00 11.750 10.13 9 5.742 9.50 11.100 9.75 10 5.742 9.00 11.100 9.50 11 5.776 8.75 11.500 9.75 12 5.725 8.75 11.000 10.00