Excel Case Study Direction: Use Microsoft Excel to answer the following questions (Excel Instructions are provided in different file) 1. Determinants of Sales: A firm wants to investigate the effect of advertising on sales. Data on sales and advertising expenditures are gathered for 20 stores. Given the variable sale (SALES, in $100) and the variable advertising expenditures (ADV, in $100), use the data file SALES to answer the following question: a. Construct a descriptive statistics table of the mean, standard deviation, minimum and maximum of the two variables. Interpret your findings. b. What is the correlation coefficient of SALES and ADV? Is the sign and magnitude of the coefficient consistent with expectation? Explain. c. Depict a scatter plot of the relationship between the two variables. Is your finding consistent with finding in (b)? Explain. d. What implication does this result have for the firm? Explain briefly.