Spreadsheet: 65939d1266562271-standard-deviation-standarddev
Sheet: Sheet1

# Days | Close | Avg. Close(mean) | Deviation | Deviation Squared
1 | 40.39 | 62.52600790513834 | -22.13600790513834 | 490.0028459763472
2 | 37.64 | 62.52600790513834 | -24.88600790513834 | 619.3133894546081
3 | 39.22 | 62.52600790513834 | -23.30600790513834 | 543.170004474371
4 | 37.32 | 62.52600790513834 | -25.20600790513834 | 635.3428345138966
5 | 35.3 | 62.52600790513834 | -27.22600790513835 | 741.2555064506557
6 | 35.96 | 62.52600790513834 | -26.56600790513834 | 705.7527760158729
7 | 34.58 | 62.52600790513834 | -27.94600790513834 | 780.9793578340549
8 | 41.12 | 62.52600790513834 | -21.40600790513835 | 458.2171744348453
9 | 43.81 | 62.52600790513834 | -18.71600790513834 | 350.2889519052009
10 | 43.44 | 62.52600790513834 | -19.08600790513835 | 364.2756977550034
11 | 46.04 | 62.52600790513834 | -16.48600790513834 | 271.788456648284
12 | 45.71 | 62.52600790513834 | -16.81600790513834 | 282.7781218656752
13 | 42.16 | 62.52600790513834 | -20.36600790513835 | 414.7742779921576
14 | 41.99 | 62.52600790513834 | -20.53600790513834 | 421.7276206799044
15 | 41.56 | 62.52600790513834 | -20.96600790513834 | 439.5734874783234
16 | 41.69 | 62.52600790513834 | -20.83600790513835 | 434.1392254229876
17 | 40.17 | 62.52600790513834 | -22.35600790513834 | 499.791089454608
18 | 40.97 | 62.52600790513834 | -21.55600790513834 | 464.6614768063868 |  |  | Sum of Close | Mean |  | Sum of Dev Sqred
19 | 40.26 | 62.52600790513834 | -22.26600790513834 | 495.7751080316833 |  |  | 15819.08 | 62.52600790513834 |  | 45630.46886798417
20 | 40.88 | 62.52600790513834 | -21.64600790513834 | 468.5496582293115
21 | 40.03 | 62.52600790513834 | -22.49600790513834 | 506.0703716680468 |  |  |  |  | Dev. Sqr/# of days | 180.3575844584355
22 | 39.9 | 62.52600790513834 | -22.62600790513834 | 511.9362337233828
23 | 38.01 | 62.52600790513834 | -24.51600790513834 | 601.0346436048059 |  |  |  |  | StdDev | 13.42972763902662
24 | 36.09 | 62.52600790513834 | -26.43600790513834 | 698.8625139605367 |  |  |  |  | Monthly | 46.52194120521225
25 | 34.48 | 62.52600790513834 | -28.04600790513835 | 786.5785594150826 |  |  |  |  | Weekly | 96.84314323605282
26 | 38.12 | 62.52600790513834 | -24.40600790513835 | 595.6532218656754 |  |  |  |  | Yearly | 213.1903170491703
27 | 37.11 | 62.52600790513834 | -25.41600790513834 | 645.9734578340548
28 | 34.93 | 62.52600790513834 | -27.59600790513834 | 761.5396523004579
29 | 34.67 | 62.52600790513834 | -27.85600790513834 | 775.9571764111298
30 | 38.86 | 62.52600790513834 | -23.66600790513834 | 560.0799301660705
31 | 39.74 | 62.52600790513834 | -22.78600790513834 | 519.2021562530269
32 | 38.26 | 62.52600790513834 | -24.26600790513834 | 588.8391396522367
33 | 39.9 | 62.52600790513834 | -22.62600790513834 | 511.9362337233828
34 | 42.5 | 62.52600790513834 | -20.02600790513834 | 401.0409926166634
35 | 44.58 | 62.52600790513834 | -17.94600790513834 | 322.0591997312879
36 | 44.18 | 62.52600790513834 | -18.34600790513834 | 336.5760060553986
37 | 40.15 | 62.52600790513834 | -22.37600790513834 | 500.6857297708137
38 | 41.46 | 62.52600790513834 | -21.06600790513834 | 443.7766890593511
39 | 45.28 | 62.52600790513834 | -17.24600790513834 | 297.4247886640942
40 | 43.63 | 62.52600790513834 | -18.89600790513834 | 357.0591147510506
41 | 45.64 | 62.52600790513834 | -16.88600790513834 | 285.1372629723946
42 | 47.29 | 62.52600790513834 | -15.23600790513834 | 232.1359368854381
43 | 45.86 | 62.52600790513834 | -16.66600790513834 | 277.7558194941337
44 | 42.67 | 62.52600790513834 | -19.85600790513834 | 394.2610499289163
45 | 46.61 | 62.52600790513834 | -15.91600790513834 | 253.3193076364262
46 | 45.71 | 62.52600790513834 | -16.81600790513834 | 282.7781218656752
47 | 47.33 | 62.52600790513834 | -15.19600790513834 | 230.9186562530271
48 | 48.86 | 62.52600790513834 | -13.66600790513834 | 186.7597720633037
49 | 49.57 | 62.52600790513834 | -12.95600790513834 | 167.8581408380072
50 | 50.9 | 62.52600790513834 | -11.62600790513834 | 135.1640598103393
51 | 53.61 | 62.52600790513834 | -8.916007905138343 | 79.49519696448944
52 | 53.57 | 62.52600790513834 | -8.956007905138343 | 80.21007759690049
53 | 52.82 | 62.52600790513834 | -9.706007905138343 | 94.206589454608
54 | 54.05 | 62.52600790513834 | -8.476007905138346 | 71.84271000796772
55 | 52.37 | 62.52600790513834 | -10.15600790513835 | 103.1444965692326
56 | 48.71 | 62.52600790513834 | -13.81600790513834 | 190.8820744348452
57 | 48.79 | 62.52600790513834 | -13.73600790513834 | 188.6779131700231
58 | 48.64 | 62.52600790513834 | -13.88600790513834 | 192.8212155415645
59 | 52.15 | 62.52600790513834 | -10.37600790513834 | 107.6615400474934
60 | 52.52 | 62.52600790513834 | -10.00600790513834 | 100.1201941976909
61 | 51.17 | 62.52600790513834 | -11.35600790513834 | 128.9589155415645
62 | 48.42 | 62.52600790513834 | -14.10600790513834 | 198.9794590198254
63 | 49.98 | 62.52600790513834 | -12.54600790513835 | 157.4023143557939
64 | 52.24 | 62.52600790513834 | -10.28600790513834 | 105.8019586245684
65 | 49.79 | 62.52600790513834 | -12.73600790513834 | 162.2058973597464
66 | 49.1 | 62.52600790513834 | -13.42600790513834 | 180.2576882688372
67 | 49.63 | 62.52600790513834 | -12.89600790513834 | 166.3070198893906
68 | 49.87 | 62.52600790513834 | -12.65600790513835 | 160.1745360949243
69 | 50.26 | 62.52600790513834 | -12.26600790513834 | 150.4549499289164
70 | 45.9 | 62.52600790513834 | -16.62600790513834 | 276.4241388617227
71 | 48.73 | 62.52600790513834 | -13.79600790513835 | 190.3298341186397
72 | 48.65 | 62.52600790513834 | -13.87600790513834 | 192.5435953834618
73 | 49.65 | 62.52600790513834 | -12.87600790513834 | 165.7915795731851
74 | 51.54 | 62.52600790513834 | -10.98600790513834 | 120.6923696917622
75 | 49.99 | 62.52600790513834 | -12.53600790513834 | 157.151494197691
76 | 49.35 | 62.52600790513834 | -13.17600790513834 | 173.6071843162681
77 | 50.58 | 62.52600790513834 | -11.94600790513834 | 142.7071048696278
78 | 50.95 | 62.52600790513834 | -11.57600790513834 | 134.0039590198253
79 | 52.6 | 62.52600790513834 | -9.926007905138341 | 98.52563293286885
80 | 54.44 | 62.52600790513834 | -8.086007905138345 | 65.38352384195981
81 | 54.03 | 62.52600790513834 | -8.496007905138342 | 72.1821503241732
82 | 56.35 | 62.52600790513834 | -6.176007905138341 | 38.14307364433128
83 | 56.83 | 62.52600790513834 | -5.696007905138345 | 32.44450605539851
84 | 58.62 | 62.52600790513834 | -3.906007905138345 | 15.25689775500325
85 | 58.23 | 62.52600790513834 | -4.296007905138346 | 18.45568392101116
86 | 59.46 | 62.52600790513834 | -3.066007905138342 | 9.400404474370804
87 | 57.82 | 62.52600790513834 | -4.706007905138343 | 22.14651040322457
88 | 58.74 | 62.52600790513834 | -3.786007905138341 | 14.33385585777001
89 | 56.34 | 62.52600790513834 | -6.186007905138339 | 38.26669380243403
90 | 59.21 | 62.52600790513834 | -3.316007905138342 | 10.99590842693997
91 | 60.1 | 62.52600790513834 | -2.426007905138341 | 5.885514355793724
92 | 61.49 | 62.52600790513834 | -1.036007905138341 | 1.073312379509133
93 | 61.23 | 62.52600790513834 | -1.296007905138346 | 1.679636490181084
94 | 61.57 | 62.52600790513834 | -0.9560079051383426 | 0.9139511146870022
95 | 61.17 | 62.52600790513834 | -1.356007905138341 | 1.838757438797672
96 | 62.7 | 62.52600790513834 | 0.17399209486166 | 0.03027324907434889
97 | 62.92 | 62.52600790513834 | 0.3939920948616589 | 0.1552297708134784
98 | 64.79 | 62.52600790513834 | 2.263992094861663 | 5.125660205596104
99 | 66.64 | 62.52600790513834 | 4.113992094861658 | 16.92493095658421
100 | 68.03 | 62.52600790513834 | 5.503992094861658 | 30.29392898029963
101 | 68.17 | 62.52600790513834 | 5.643992094861659 | 31.8546467668609
102 | 66.05 | 62.52600790513834 | 3.523992094861654 | 12.41852028464743
103 | 68.86 | 62.52600790513834 | 6.333992094861657 | 40.11945585776996
104 | 68.38 | 62.52600790513834 | 5.853992094861653 | 34.26922344670272
105 | 68.81 | 62.52600790513834 | 6.283992094861659 | 39.48855664828383
106 | 70.64 | 62.52600790513834 | 8.113992094861658 | 65.83686771547747
107 | 71.47 | 62.52600790513834 | 8.943992094861656 | 79.99499459294779
108 | 72.28 | 62.52600790513834 | 9.753992094861658 | 95.14036178662373
109 | 72.25 | 62.52600790513834 | 9.723992094861657 | 94.556022260932
110 | 70.21 | 62.52600790513834 | 7.683992094861651 | 59.04373451389634
111 | 69.94 | 62.52600790513834 | 7.413992094861655 | 54.96727878267111
112 | 71.5 | 62.52600790513834 | 8.973992094861657 | 80.53253411863952
113 | 71.53 | 62.52600790513834 | 9.003992094861658 | 81.07187364433123
114 | 71.88 | 62.52600790513834 | 9.353992094861653 | 87.4971681107343
115 | 67.39 | 62.52600790513834 | 4.863992094861658 | 23.6584190988767
116 | 68.69 | 62.52600790513834 | 6.163992094861655 | 37.99479854551697
117 | 68.41 | 62.52600790513834 | 5.883992094861654 | 34.62136297239443
118 | 69.44 | 62.52600790513834 | 6.913992094861655 | 47.80328668780945
119 | 71.68 | 62.52600790513834 | 9.153992094861664 | 83.79557127278983
120 | 70.63 | 62.52600790513834 | 8.103992094861653 | 65.67468787358015
121 | 69.65 | 62.52600790513834 | 7.123992094861663 | 50.75126336765146
122 | 66.4 | 62.52600790513834 | 3.873992094861663 | 15.00781475105065
123 | 65.65 | 62.52600790513834 | 3.123992094861663 | 9.75932660875816
124 | 64.42 | 62.52600790513834 | 1.893992094861659 | 3.587206055398455
125 | 62.24 | 62.52600790513834 | -0.2860079051383408 | 0.08180052180162217
126 | 60.38 | 62.52600790513834 | -2.14600790513834 | 4.605349928916247
127 | 60.76 | 62.52600790513834 | -1.766007905138345 | 3.118783921011125
128 | 59.67 | 62.52600790513834 | -2.856007905138341 | 8.156781154212696
129 | 60.14 | 62.52600790513834 | -2.386007905138342 | 5.69303372338266
130 | 59.75 | 62.52600790513834 | -2.776007905138343 | 7.706219889390571
131 | 61.82 | 62.52600790513834 | -0.7060079051383426 | 0.4984471621178309
132 | 62.06 | 62.52600790513834 | -0.4660079051383406 | 0.2171633676514246
133 | 63.43 | 62.52600790513834 | 0.9039920948616569 | 0.8172017075723669
134 | 64.42 | 62.52600790513834 | 1.893992094861659 | 3.587206055398455
135 | 64.96 | 62.52600790513834 | 2.433992094861651 | 5.924317517849008
136 | 65.05 | 62.52600790513834 | 2.523992094861654 | 6.370536094924122
137 | 66.55 | 62.52600790513834 | 4.023992094861654 | 16.19251237950909
138 | 68.11 | 62.52600790513834 | 5.583992094861657 | 31.18096771547747
139 | 68.01 | 62.52600790513834 | 5.483992094861662 | 30.0741692965052
140 | 66.7 | 62.52600790513834 | 4.17399209486166 | 17.42221000796763
141 | 62.92 | 62.52600790513834 | 0.3939920948616589 | 0.1552297708134784
142 | 66.48 | 62.52600790513834 | 3.953992094861661 | 15.63405348622851
143 | 69.51 | 62.52600790513834 | 6.983992094861662 | 48.77614558109019
144 | 71.13 | 62.52600790513834 | 8.603992094861653 | 74.0286799684418
145 | 71.78 | 62.52600790513834 | 9.253992094861658 | 85.63636969176207
146 | 71.58 | 62.52600790513834 | 9.053992094861655 | 81.97477285381734
147 | 71.9 | 62.52600790513834 | 9.373992094861663 | 87.87172779452895
148 | 70.58 | 62.52600790513834 | 8.053992094861655 | 64.86678866409403
149 | 70.73 | 62.52600790513834 | 8.203992094861661 | 67.30548629255263
150 | 69.47 | 62.52600790513834 | 6.943992094861656 | 48.21902621350117
151 | 70.58 | 62.52600790513834 | 8.053992094861655 | 64.86678866409403
152 | 71.23 | 62.52600790513834 | 8.703992094861661 | 75.75947838741429
153 | 67.5 | 62.52600790513834 | 4.973992094861657 | 24.74059735974626
154 | 66.76 | 62.52600790513834 | 4.233992094861662 | 17.92668905935105
155 | 72.54 | 62.52600790513834 | 10.01399209486166 | 100.2800376759519
156 | 73.12 | 62.52600790513834 | 10.59399209486166 | 112.2326685059914
157 | 73.88 | 62.52600790513834 | 11.35399209486165 | 128.9131364901809
158 | 73.91 | 62.52600790513834 | 11.38399209486165 | 129.5952760158726
159 | 71.64 | 62.52600790513834 | 9.113992094861658 | 83.06485190520078
160 | 71.48 | 62.52600790513834 | 8.953992094861661 | 80.17397443484512
161 | 72.8 | 62.52600790513834 | 10.27399209486165 | 105.5549135652798
162 | 72.85 | 62.52600790513834 | 10.32399209486165 | 106.5848127747659
163 | 69.83 | 62.52600790513834 | 7.303992094861655 | 53.34830052180155
164 | 68.02 | 62.52600790513834 | 5.493992094861653 | 30.18394913840234
165 | 68.34 | 62.52600790513834 | 5.813992094861661 | 33.80250407911388
166 | 68.2 | 62.52600790513834 | 5.67399209486166 | 32.19418629255261
167 | 67.85 | 62.52600790513834 | 5.323992094861651 | 28.34489182614936
168 | 68.1 | 62.52600790513834 | 5.573992094861651 | 31.06938787358018
169 | 71.22 | 62.52600790513834 | 8.693992094861656 | 75.58549854551697
170 | 71.66 | 62.52600790513834 | 9.133992094861654 | 83.42981158899518
171 | 71.93 | 62.52600790513834 | 9.403992094861664 | 88.43506732022067
172 | 69.12 | 62.52600790513834 | 6.593992094861662 | 43.48073174709808
173 | 69.06 | 62.52600790513834 | 6.533992094861659 | 42.69305269571466
174 | 70.3 | 62.52600790513834 | 7.773992094861654 | 60.43495309097149
175 | 72.36 | 62.52600790513834 | 9.833992094861657 | 96.70740052180156
176 | 72.31 | 62.52600790513834 | 9.78399209486166 | 95.72650131231545
177 | 71.89 | 62.52600790513834 | 9.363992094861658 | 87.68434795263161
178 | 69.68 | 62.52600790513834 | 7.153992094861664 | 51.17960289334318
179 | 71.62 | 62.52600790513834 | 9.093992094861662 | 82.7006922214064
180 | 68.38 | 62.52600790513834 | 5.853992094861653 | 34.26922344670272
181 | 65.87 | 62.52600790513834 | 3.343992094861662 | 11.18228313049728
182 | 66.01 | 62.52600790513834 | 3.483992094861662 | 12.13820091705855
183 | 67.28 | 62.52600790513834 | 4.753992094861658 | 22.60044083800714
184 | 66.65 | 62.52600790513834 | 4.123992094861663 | 17.00731079848149
185 | 70.35 | 62.52600790513834 | 7.823992094861651 | 61.21485230045761
186 | 70.2 | 62.52600790513834 | 7.67399209486166 | 58.89015467199925
187 | 69.73 | 62.52600790513834 | 7.203992094861661 | 51.89750210282931
188 | 70.49 | 62.52600790513834 | 7.963992094861652 | 63.42517008701888
189 | 71.41 | 62.52600790513834 | 8.883992094861654 | 78.92531554156436
190 | 69.9 | 62.52600790513834 | 7.373992094861663 | 54.37575941508229
191 | 71.45 | 62.52600790513834 | 8.92399209486166 | 79.6376349091534
192 | 72.23 | 62.52600790513834 | 9.703992094861661 | 94.16746257713761
193 | 73.13 | 62.52600790513834 | 10.60399209486165 | 112.4446483478884
194 | 74.7 | 62.52600790513834 | 12.17399209486166 | 148.2060835257542
195 | 75.86 | 62.52600790513834 | 13.33399209486166 | 177.7953451858332
196 | 77.94 | 62.52600790513834 | 15.41399209486165 | 237.5911523004576
197 | 78.63 | 62.52600790513834 | 16.10399209486165 | 259.3385613913666
198 | 79.51 | 62.52600790513834 | 16.98399209486166 | 288.4559874783234
199 | 78.77 | 62.52600790513834 | 16.24399209486165 | 263.8672791779279
200 | 81.15 | 62.52600790513834 | 18.62399209486166 | 346.8530815494697
201 | 81.4 | 62.52600790513834 | 18.87399209486166 | 356.2275775969005
202 | 79.7 | 62.52600790513834 | 17.17399209486166 | 294.9460044743708
203 | 78.58 | 62.52600790513834 | 16.05399209486166 | 257.7306621818805
204 | 79.7 | 62.52600790513834 | 17.17399209486166 | 294.9460044743708
205 | 77.15 | 62.52600790513834 | 14.62399209486166 | 213.8611447905764
206 | 80.12 | 62.52600790513834 | 17.59399209486166 | 309.5485578340546
207 | 76.99 | 62.52600790513834 | 14.46399209486165 | 209.2070673202204
208 | 78.05 | 62.52600790513834 | 15.52399209486165 | 240.9943305613271
209 | 79.45 | 62.52600790513834 | 16.92399209486166 | 286.42150842694
210 | 80.23 | 62.52600790513834 | 17.70399209486166 | 313.4313360949242
211 | 79.8 | 62.52600790513834 | 17.27399209486165 | 298.3908028933429
212 | 77.65 | 62.52600790513834 | 15.12399209486166 | 228.7351368854381
213 | 79.43 | 62.52600790513834 | 16.90399209486166 | 285.7449487431456
214 | 78.99 | 62.52600790513834 | 16.46399209486165 | 271.063035699667
215 | 79.27 | 62.52600790513834 | 16.74399209486165 | 280.3612712727895
216 | 77.01 | 62.52600790513834 | 14.48399209486166 | 209.7860270040151
217 | 76.44 | 62.52600790513834 | 13.91399209486165 | 193.5991760158726
218 | 78.92 | 62.52600790513834 | 16.39399209486166 | 268.7629768063866
219 | 79.43 | 62.52600790513834 | 16.90399209486166 | 285.7449487431456
220 | 79.7 | 62.52600790513834 | 17.17399209486166 | 294.9460044743708
221 | 77.74 | 62.52600790513834 | 15.21399209486165 | 231.4655554625128
222 | 77.72 | 62.52600790513834 | 15.19399209486166 | 230.8573957787185
223 | 77.45 | 62.52600790513834 | 14.92399209486166 | 222.7255400474933
224 | 75.96 | 62.52600790513834 | 13.43399209486165 | 180.4721436048053
225 | 77.74 | 62.52600790513834 | 15.21399209486165 | 231.4655554625128
226 | 76.08 | 62.52600790513834 | 13.55399209486166 | 183.7107017075722
227 | 76.02 | 62.52600790513834 | 13.49399209486165 | 182.0878226561888
228 | 77.38 | 62.52600790513834 | 14.85399209486165 | 220.6410811542125
229 | 77.99 | 62.52600790513834 | 15.46399209486165 | 239.1350515099437
230 | 76.75 | 62.52600790513834 | 14.22399209486166 | 202.3219511146869
231 | 75.98 | 62.52600790513834 | 13.45399209486166 | 181.0099032886001
232 | 75.7 | 62.52600790513834 | 13.17399209486166 | 173.5540677154775
233 | 74.23 | 62.52600790513834 | 11.70399209486166 | 136.9834309565842
234 | 73.13 | 62.52600790513834 | 10.60399209486165 | 112.4446483478884
235 | 71.04 | 62.52600790513834 | 8.513992094861663 | 72.4880613913669
236 | 70.52 | 62.52600790513834 | 7.993992094861653 | 63.9039096127106
237 | 69.63 | 62.52600790513834 | 7.103992094861653 | 50.46670368385685
238 | 69.76 | 62.52600790513834 | 7.233992094861662 | 52.33064162852102
239 | 70.79 | 62.52600790513834 | 8.263992094861663 | 68.29356534393607
240 | 72.91 | 62.52600790513834 | 10.38399209486165 | 107.8272918261493
241 | 72.67 | 62.52600790513834 | 10.14399209486166 | 102.9005756206158
242 | 73.12 | 62.52600790513834 | 10.59399209486166 | 112.2326685059914
243 | 73.68 | 62.52600790513834 | 11.15399209486166 | 124.4115396522365
244 | 74.52 | 62.52600790513834 | 11.99399209486165 | 143.8558463716038
245 | 76.59 | 62.52600790513834 | 14.06399209486166 | 197.7958736443313
246 | 77.93 | 62.52600790513834 | 15.40399209486166 | 237.2829724585606
247 | 78.05 | 62.52600790513834 | 15.52399209486165 | 240.9943305613271
248 | 78.46 | 62.52600790513834 | 15.93399209486165 | 253.8921040791136
249 | 78.84 | 62.52600790513834 | 16.31399209486166 | 266.1463380712087
250 | 79.39 | 62.52600790513834 | 16.86399209486166 | 284.3942293755565
251 | 79.56 | 62.52600790513834 | 17.03399209486166 | 290.1568866878095
252 | 79.35 | 62.52600790513834 | 16.82399209486165 | 283.0467100079674
253 | 81.64 | 62.52600790513834 | 19.11399209486166 | 365.3446938024339