questions are in picture swell as the table.

1. Place the quantity (E), price (R) and advertising (1%,) data from Table l in a Microsoft Excel spread sheet and calculate the following values: EYE: 17; 2X\": 31; XX\": 32 {=1 [:1 1:1 2 Manually calculate the following values in deviation form: a. Sum values zyz b. Standard deviations 3 Manually calculate the )3], g and a-coefcient values. 4 Prepare a correlation matrix for the variables: quantity, price, and advertising expenditures. 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