\fA fast-food chain decided to carry out an experiment to assess the influence of advertising expenditure on sales. Different relative changes in advertising expenditure, compared to the previous year, were mad in eight regions of the country, and resulting changes in sales levels were observed. The companying table shows the results. 2 Increase in advertising 0 14 10 9 8 6 1 expenditure (%) Increase in Sales (6) 2.4 7.2 10.3 9.1 10.2 4.1 7.6 2.7 a. Use Excel's Doto Analysis to get the descriptive statistics for each variable. b. Calculate the sample covariance and correlation. Show your work by constructing a table as on page 77 of the course packet. You may construct the table in Excel and use "=sum" function to get the sums _(x - x) , E() ->)(x -x)(): - y) for the formulas of the sample covariance and the correlation. C. Use Excel's functions "=covariance.s()" and "=correl()" to get the sample covariance and the correlation. Compare your results with part b. d. Determine the dependent and the independent variable for the regression model. Write down the regression model. e. Use Excel to draw the scatter diagram with the fitted line. Label your horizontal and vertical axes. f. Use the table in part b to calculate the intercept and slope for the regression. Write the estimated regression equation. h. Interpret the estimated slope and intercept. i. Predict the percent in sales if the increase in advertising expenditure is 5%. j. Calculate the standard error of the regression. Show your work as the table on page 88 of the course packet. You may use Excel to construct the table and use "=sum" function. k. Construct a table to show the calculation of SST, SSR, and SSE as the table on page 92 of the course packet and prove SST = SSR + SSE. You may use Excel to construct the table. I. Use the value from part k to calculate the coefficient of determination and explain its meaning. m. Use the values of )(x - x)