Question

Rounded to the nearest whole number, what is the standard deviation for Google weekly closing prices from December 12, 2008 to December 4, 2009? Use the data set Google Closing Prices.xlsx (in section 11 of this module) to determine your answer. NOTE: The standard deviation function in Excel (for recent versions) has .p for a population and .s for a sample. we're treating everything as a sample!

4-Dec-09	585.01
27-Nov-09	579.76
20-Nov-09	569.96
13-Nov-09	572.05
6-Nov-09	551.1
30-Oct-09	536.12
23-Oct-09	553.69
16-Oct-09	549.85
9-Oct-09	516.25
2-Oct-09	484.58
25-Sep-09	492.48
18-Sep-09	491.46
11-Sep-09	472.14
4-Sep-09	461.3
28-Aug-09	464.75
21-Aug-09	465.24
14-Aug-09	460
7-Aug-09	457.1
31-Jul-09	443.05
24-Jul-09	446.72
17-Jul-09	430.25
10-Jul-09	414.4
2-Jul-09	408.49
26-Jun-09	425.32
19-Jun-09	420.09
12-Jun-09	424.84
5-Jun-09	444.32
29-May-09	417.23
22-May-09	393.5
15-May-09	390
8-May-09	407.33
1-May-09	393.69
24-Apr-09	389.49
17-Apr-09	392.24
9-Apr-09	372.5
3-Apr-09	369.78
27-Mar-09	347.7
20-Mar-09	330.16
13-Mar-09	324.42
6-Mar-09	308.57
27-Feb-09	337.99
20-Feb-09	346.45
13-Feb-09	357.68
6-Feb-09	371.28
30-Jan-09	338.53
23-Jan-09	324.7
16-Jan-09	299.67
9-Jan-09	315.07
2-Jan-09	321.32
26-Dec-08	300.36
19-Dec-08	310.17
12-Dec-08	315.76

Answer 1