The data in the following table were adapted from the file labeled Stock Comparison, and consist of a sample of 12 monthly adjusted stock prices for technology company Apple, Inc., and consumer-goods company Procter & Gamble (P&G) from June 1, 2013 to May 1, 2014.

Date	Apple Adjusted Stock Price	P&G Adjusted Stock Price
6/1/2013	44.44	65.71
7/1/2013	50.71	68.54
8/1/2013	54.60	66.98
9/1/2013	56.00	65.00
10/1/2013	61.40	69.44
11/1/2013	65.32	72.99
12/1/2013	68.69	70.55
1/1/2014	61.29	66.40
2/1/2014	64.43	68.68
3/1/2014	68.57	70.38
4/1/2014	75.39	72.08
5/1/2014	80.87	71.11

A) Determine the mean stock price for each company.

B) Determine the sample stock price variance for each company.

C) Determine the sample stock price standard deviation for each company.

D) Which company had the higher mean stock price over the 12-month period?

E) Based on the standard deviation, which companys stock price had less variability over the time period?

F) Compute the coefficient of variation for each companys stock price, and state which stock price had less variability over the 12-month period?

G) In your opinion, in which company would a prospective investor be more interested in investing? Why?

- Please also show us how to do this on excel -

-Thank you-