Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use monthly adjusted close prices for the last 36 months to calculate the Standard Deviations (si) Given formula: If there is any missing data, just
Use monthly adjusted close prices for the last 36 months to calculate the Standard Deviations (si) |
Given formula:
If there is any missing data, just let me know!
Thanks!
B D High 55.59 46.235 42.25 43.9675 49.4225 52.12 53.8275 50.3925 Low 42.565 36.6475 35.5 41.4825 42.375 47.095 43.7475 42.5675 49.6025 E F Close Adj Close 44.645 43.25269 39.435 38.33848 41.61 40.453 43.2875 42.08386 47.4875 46.36507 50.1675 48.98173 43.7675 42.733 49.48 48.49652 53.26 52.20139 G Volume 3845305600 3595690000 3312349600 1890162400 2603925600 2024470800 2957826400 2060874800 1895406800 2724326400 2170268400 55.3425 54.5075 48.145 51.14776 52.185 55.9925 51.055 55.08809 e ou une 53.7825 2433210800 1793326000 62.29 1 Date 2 11/1/2018 3 12/1/2018 4 1/1/2019 5 2/1/2019 6 3/1/2019 7 4/1/2019 8 5/1/2019 9 6/1/2019 10 7/1/2019 11 8/1/2019 12 9/1/2019 13 10/1/2019 14 11/1/2019 15 12/1/2019 16 1/1/2020 17 2/1/2020 18 3/1/2020 19 4/1/2020 20 5/1/2020 21 6/1/2020 22 7/1/2020 8/1/2020 24 9/1/2020 25 10/1/2020 26 11/1/2020 27 12/1/2020 28 1/1/2021 29 2/1/2021 30 3/1/2021 4/1/2021 32 5/1/2021 33 6/1/2021 34 7/1/2021 35 8/1/2021 36 9/1/2021 37 10/1/2021 Open 54.7625 46.115 38.7225 41.74 43.57 47.91 52.47 43.9 50.7925 53.475 51.6075 56.2675 62.385 66.8175 74.06 76.075 70.57 61.625 71.5625 79.4375 91.28 108.2 132.76 117.64 109.11 121.01 133.52 133.75 123.75 123.66 64.0725 73.1875 64.0925 53.1525 2388794800 2934370400 3019279200 6280072400 3265299200 2805936000 59.225 71.4625 79.3025 56.605 62.4375 67 73.4925 81.9625 81.805 76 73.6325 81.06 93.095 106.415 131 137.98 125.39 121.99 138.79 145.09 137.88 128.72 137.07 89.145 107.8925 62.19 61.18549 66.8125 65.73332 73.4125 72.44356 77.3775 76.35623 68.34 67.438 63.5725 62.88232 73.45 72.65258 79.485 78.62207 91.2 90.45407 106.26 105.3909 129.04 127.9846 115.81 115.0699 108.86 108.1643 119.05 118.2892 132.69 132.0695 131.96 131.3429 121.26 120.6929 122.15 121.7604 131.46 131.0408 124.61 124.2126 23 103.1 107.72 107.32 120.01 126.38 118.39 116.21 122.49 122.25 3243375600 3020283200 4070061100 3885245100 2894666500 2123077300 2322189600 2240262000 1833855600 2650418200 1889857500 1711934900 31 132.04 134.07 137.41 150 123.13 136.96 136.7551 1606590000 135.76 145.86 145.6418 125.08 136.6 146.36 152.83 144.5 153.49 157.26 144.22 151.83 141.5 142.9 141.27 138.27 1918976500 1460744100 1797465800 477495200 151.6029 141.5 142.9 141.9 Ox = 2(x - 2)2 N-1 B D High 55.59 46.235 42.25 43.9675 49.4225 52.12 53.8275 50.3925 Low 42.565 36.6475 35.5 41.4825 42.375 47.095 43.7475 42.5675 49.6025 E F Close Adj Close 44.645 43.25269 39.435 38.33848 41.61 40.453 43.2875 42.08386 47.4875 46.36507 50.1675 48.98173 43.7675 42.733 49.48 48.49652 53.26 52.20139 G Volume 3845305600 3595690000 3312349600 1890162400 2603925600 2024470800 2957826400 2060874800 1895406800 2724326400 2170268400 55.3425 54.5075 48.145 51.14776 52.185 55.9925 51.055 55.08809 e ou une 53.7825 2433210800 1793326000 62.29 1 Date 2 11/1/2018 3 12/1/2018 4 1/1/2019 5 2/1/2019 6 3/1/2019 7 4/1/2019 8 5/1/2019 9 6/1/2019 10 7/1/2019 11 8/1/2019 12 9/1/2019 13 10/1/2019 14 11/1/2019 15 12/1/2019 16 1/1/2020 17 2/1/2020 18 3/1/2020 19 4/1/2020 20 5/1/2020 21 6/1/2020 22 7/1/2020 8/1/2020 24 9/1/2020 25 10/1/2020 26 11/1/2020 27 12/1/2020 28 1/1/2021 29 2/1/2021 30 3/1/2021 4/1/2021 32 5/1/2021 33 6/1/2021 34 7/1/2021 35 8/1/2021 36 9/1/2021 37 10/1/2021 Open 54.7625 46.115 38.7225 41.74 43.57 47.91 52.47 43.9 50.7925 53.475 51.6075 56.2675 62.385 66.8175 74.06 76.075 70.57 61.625 71.5625 79.4375 91.28 108.2 132.76 117.64 109.11 121.01 133.52 133.75 123.75 123.66 64.0725 73.1875 64.0925 53.1525 2388794800 2934370400 3019279200 6280072400 3265299200 2805936000 59.225 71.4625 79.3025 56.605 62.4375 67 73.4925 81.9625 81.805 76 73.6325 81.06 93.095 106.415 131 137.98 125.39 121.99 138.79 145.09 137.88 128.72 137.07 89.145 107.8925 62.19 61.18549 66.8125 65.73332 73.4125 72.44356 77.3775 76.35623 68.34 67.438 63.5725 62.88232 73.45 72.65258 79.485 78.62207 91.2 90.45407 106.26 105.3909 129.04 127.9846 115.81 115.0699 108.86 108.1643 119.05 118.2892 132.69 132.0695 131.96 131.3429 121.26 120.6929 122.15 121.7604 131.46 131.0408 124.61 124.2126 23 103.1 107.72 107.32 120.01 126.38 118.39 116.21 122.49 122.25 3243375600 3020283200 4070061100 3885245100 2894666500 2123077300 2322189600 2240262000 1833855600 2650418200 1889857500 1711934900 31 132.04 134.07 137.41 150 123.13 136.96 136.7551 1606590000 135.76 145.86 145.6418 125.08 136.6 146.36 152.83 144.5 153.49 157.26 144.22 151.83 141.5 142.9 141.27 138.27 1918976500 1460744100 1797465800 477495200 151.6029 141.5 142.9 141.9 Ox = 2(x - 2)2 N-1Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started