Скачать или смотреть [Math] The monthly closing stock prices rounded to the nearest dollar for Starbucks Corp and Panera

[Math] The monthly closing stock prices (rounded to the nearest dollar) for Starbucks Corp. and Panera Bread Co. for the first six months of 2010 are reported in the following table. Month Starbucks Corp. Panera Bread Co. January 2010 71 February 2010 73 March 2010 76 April 2010 78 May 2010 81 June 2010 75 a. Calculate the sample mean, the sample variance, and the sample standard deviation for each firm's stock price. Show your work as the table on page 20 of the course packet. You may construct the table in Excel and use =sum function. Don't use other functions and Data Analysis. b. Calculate the range for Starbucks stock prices and the range for Panera Bread stock prices. c. Get the descriptive statistics for each firm's stock price using Data Analysis in Excel. You can use the Excel results to check your calculations in part a and b. d. Which firm's stock price had greater relative dispersion as measured by the standard deviation e. Calculate the sample covariance and the sample correlation. Show your work as the table on page 25 of the course packet. You may construct the table in Excel and use =sum function. Don't use other functions and Data Analysis. f. Use Excel's statistical functions to get the sample covariance and the sample correlation. You can use the Excel results to check your calculation for part e. g. Use Excel to get a scatterplot. h. Based on the correlation and the scatterplot, what type of relationship exists between the stock prices for the two firms