Ex: yX, ; E X X, b. Standard deviations 3 Manually calculate the , , and a 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's SST. b. The sum of squares due to regression SSR C. The standard error of the estimated regression equation s. Calculate the standard error of the estimated coefficients , en B2. C. The Durbin-Watson-statistic: DW. f. The determination coefficient R5. The adjusted multiple determination coefficients R 5. 6. . Calculate the r-values of the estimated , - and ,-coefficients. b. Are these significant at the 5 %-level? 7. Is autocorrelation present in the residuals? B. Calculate the MPE- and MAPE-values for your estimated model