Question1.Place the quantity ( Y t ), price ( P t ) and advertising ( R t )… 1.Place the quantity (Yt), price (Pt) and advertising (Rt) 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 valuesb. Standard deviations3 Manually calculate the1,2anda-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 equationse.c. Calculate the standard error of the estimated coefficients 1en 2.d. The Durbin-Watson-statistic:DW.6 Further manually calculate the following values:a. Sum of the squares due to regressionSSRb. The determination coefficientR5.c. The adjusted multiple determination coefficientsRa5.7 a. Calculate thet-values of the estimated 1- and 2-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) pricet 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.7510.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 … Show more… Show moreMathStatistics and Probability BADM 2000
