Question

HD Adj Close Price
$                   94.43
$                 103.78
$                 102.75
$                   97.25
$                 101.28
$                 101.02
$                 106.95
$                 106.43
$                 105.54
$                 113.56
$                 122.97
$                 121.47
$                 116.02
$                 114.51
$                 123.10
$                 124.20
$                 122.56
$                 119.06
$                 128.90
$                 125.06
$                 120.60
$                 114.35
$                 121.28
$                 126.33
$                 129.63
$                 136.53
$                 138.34
$                 147.97
$                 145.52
$                 146.25
$                 142.63
$                 142.89
$                 156.86
$                 158.99
$                 172.46
$                 182.69
$                 193.65
$                 175.69
$                 171.81
$                 179.15
$                 180.84
$                 190.19
$                 192.55
$                 195.72
$                 202.97
$                 172.33
$                 176.68
$                 169.36
$                 180.90
$                 182.49
$                 189.14
$                 202.28
$                 188.53
$                 206.52
$                 213.69

What is the standard deviation for Home Depot, Inc. (HD),?

Note: Enter your answer in percentages rounded off to two decimal points. Do not enter % in the answer box. If your answer is negative, do enter the negative sign.

Answer 1

Statement showing standard deviation

Sr no	HD Adj Close Price (x)	X-X	X-X^2
1	94.43	-52.82	2,789.95
2	103.78	-43.47	1,889.64
3	102.75	-44.50	1,980.25
4	97.25	-50.00	2,500.00
5	101.28	-45.97	2,113.24
6	101.02	-46.23	2,137.21
7	106.95	-40.30	1,624.09
8	106.43	-40.82	1,666.27
9	105.54	-41.71	1,739.72
10	113.56	-33.69	1,135.02
11	122.97	-24.28	589.52
12	121.47	-25.78	664.61
13	116.02	-31.23	975.31
14	114.51	-32.74	1,071.91
15	123.1	-24.15	583.22
16	124.2	-23.05	531.30
17	122.56	-24.69	609.60
18	119.06	-28.19	794.68
19	128.9	-18.35	336.72
20	125.06	-22.19	492.40
21	120.6	-26.65	710.22
22	114.35	-32.90	1,082.41
23	121.28	-25.97	674.44
24	126.33	-20.92	437.65
25	129.63	-17.62	310.46
26	136.53	-10.72	114.92
27	138.34	-8.91	79.39
28	147.97	0.72	0.52
29	145.52	-1.73	2.99
30	146.25	-1.00	1.00
31	142.63	-4.62	21.34
32	142.89	-4.36	19.01
33	156.86	9.61	92.35
34	158.99	11.74	137.83
35	172.46	25.21	635.54
36	182.69	35.44	1,255.99
37	193.65	46.40	2,152.96
38	175.69	28.44	808.83
39	171.81	24.56	603.19
40	179.15	31.90	1,017.61
41	180.84	33.59	1,128.29
42	190.19	42.94	1,843.84
43	192.55	45.30	2,052.09
44	195.72	48.47	2,349.34
45	202.97	55.72	3,104.72
46	172.33	25.08	629.01
47	176.68	29.43	866.12
48	169.36	22.11	488.85
49	180.9	33.65	1,132.32
50	182.49	35.24	1,241.86
51	189.14	41.89	1,754.77
52	202.28	55.03	3,028.30
53	188.53	41.28	1,704.04
54	206.52	59.27	3,512.93
55	213.69	66.44	4,414.27
	8098.65		65,634.10

Here expected return = X = 8098.65/55 = 147.25

Standard deviation = [sum of( x-X)^2 /n-n]^0.5

=[65634.1/55-1]^0.5

=1215.45^0.5

=34.86%