[D Paste BIU. CA lili THI ilil A Open recovered workbooks? Your recent changes were saved. Do you want to c D8 fx 0.00345300070018549 A DE F G 1 Date B C D 1/3/20 0.013961 -0.01856 0.008396 0.00208 1/6/20 0.012863 -0.01856 0.006094 -0.00195 1/7/20 0.015526 -0.01444 0.00693 0.000511 1/8/20 0.014991 -0.0172 0.002713 0.000181 1/9/20 0.011965 -0.01336 0.004549 -0.00122 1/10/20 0.018239 -0.01237 0.000437 -0.00079 8 1/13/20 0.017496 -0.01205 0.003453 -0.00247 9 1/14/20 0.010823 -0.0123 0.005618 -0.00452 10 1/15/20 0.01969 -0.01011 0.00406 -0.00467 11 1/16/20 0.019168 -0.01523 0.003106 0.004921 12 1/17/20 0.013303 -0.0165 0.005118 0.002412 13 1/21/20 0.016397 0.01625 0.004727 0.001057 14 1/22/20 0.016421 -0.01081 0.002805 0.00492 15 1/23/20 0.014991 -0.0137 0.007499 -0.00385 16 1/24/20 0.010162 -0.01381 0.005081 0.00122 17 1/27/20 0.013093 0.01436 0.008621 0.00109 18 1/28/20 0.017437 -0.01451 0.008916 0.00415 19 1/29/20 0.017574 -0.01104 0.009829 0.003898 20 1/30/20 0.012254 0.01051 0.008385 0.003742 21 1/31/20 0.016635 -0.01865 0.002227 -0.00089 22 2/3/20 0.017519 -0.01872 0.002236 0.004533 23 2/4/20 0.014618 0.01093 0.001307 -0.00291 24 2/5/20 0.011627 0.01547 0.008128 0.004186 25 2/6/20 0.013617 0.01524 0.002976 0,000851 26 2/7/20 0.015334 0.01025 0.005155 0.00093 27 2/10/20 0.016011 -0.01968 0.007786 -0.00344 28 2/11/20 0.011683 -0.01801 0.001136 -0.00251 29 2/12/20 0.010341 -0.01035 0.007536 0.00077 30 2/13/20 0.011683 -0.01259 0.004714 0.00477 31 2/14/20 0.013216 -0.01796 0.003597 0.00085 32 2/18/20 0.012524 0.01965 0.00853 -0.002 33 2/19/20 0.010406 -0.01601 0.00413 -0.00046 34 2/20/20 0.011305 -0.01393 0.002938 0.00019 25 honnan ANAK Sheet1 Sheet2 Sheet3 + G Calibri (Body) 11 ' BI UN Av Paste E Open recovered workbooks? Your recent changes were saved. Do you want D8 v $* 0.00345300070018549 A D E F 30 2/13/20 0.011683 -0.01259 0.004714 -0.00477 31 2/14/20 0.013216 -0.01796 0.003597 -0.00085 32 2/18/20 0.012524 -0.01965 0.00853 -0.002 33 2/19/20 0.010406 -0.01601 0.00413 -0.00046 34 2/20/20 0.011305 -0.01393 0.002938 -0.00019 35 2/21/20 0.010201 -0.01387 0.005465 -9.3E-05 36 2/24/20 0.018748 -0.01465 0.007741 0.003183 37 2/25/20 0.01314 -0.01637 0.008861 0.002306 38 2/26/20 0.0181 -0.01582 0.006638 0.004747 39 2/27/20 0.016461 -0.01643 0.001485 -0.0009 40 2/28/20 0.013598 -0.01328 0.006462 0.00403 41 3/2/20 0.01203 -0.01645 0.007835 0.004027 42 3/3/20 0.010545 +0.01571 0.009544 0.002569 43 3/4/20 0.015177 -0.01433 0.005538 0.001569 44 3/5/20 0.01232 -0.01868 0.00059 0.004683 45 3/6/20 0.019738 -0.01471 0.005614 -0.00309 46 3/9/20 0.015871 -0.01884 0.007982 0.000361 47 3/10/20 0.012827 0.01547 0.001438 -0.00354 48 3/11/20 0.011776 -0.01485 0.005577 -0.00405 49 3/12/20 0.016283 -0.01371 0.00408 -0.00455 50 3/13/20 0.014263 -0.01953 0.00028 -0.0029 51 3/16/20 0.01945 -0.01382 0.001457 0.003559 52 3/17/20 0.010099 0.01056 0.003486 0.004344 53 3/18/20 0.014504 .001104 0.005071 0.002022 54 3/19/20 0.010586 -0.01489 0.002135 -0.00157 55 3/20/20 0.015974 0.01032 0.006906 -0.00443 56 3/23/20 0.018882 0.01934 0.007883 0.002857 57 3/24/20 0.011306 -0.01251 0.002239 -0.00481 58 3/25/20 0.0191430.01492 0.007347 -0.00494 59 3/26/20 0.012356 -0.01927 0.007377 60 0.00093 3/27/20 0.017147 -0.01852 0.002366 61 -0.00345 3/30/20 0.017015 -0.01028 0.001249 62 -0.00072 63 Sheet Sheet2 Sheet3 hw7 part 1 -1.xlsx Download the attached Excel file in Question 1. Question 1 is based on the data in Sheet 1. Round your answers to four decimal places. The volatilities (standard deviations of returns) of stocks A, B and Care and respectively. [D Paste BIU. CA lili THI ilil A Open recovered workbooks? Your recent changes were saved. Do you want to c D8 fx 0.00345300070018549 A DE F G 1 Date B C D 1/3/20 0.013961 -0.01856 0.008396 0.00208 1/6/20 0.012863 -0.01856 0.006094 -0.00195 1/7/20 0.015526 -0.01444 0.00693 0.000511 1/8/20 0.014991 -0.0172 0.002713 0.000181 1/9/20 0.011965 -0.01336 0.004549 -0.00122 1/10/20 0.018239 -0.01237 0.000437 -0.00079 8 1/13/20 0.017496 -0.01205 0.003453 -0.00247 9 1/14/20 0.010823 -0.0123 0.005618 -0.00452 10 1/15/20 0.01969 -0.01011 0.00406 -0.00467 11 1/16/20 0.019168 -0.01523 0.003106 0.004921 12 1/17/20 0.013303 -0.0165 0.005118 0.002412 13 1/21/20 0.016397 0.01625 0.004727 0.001057 14 1/22/20 0.016421 -0.01081 0.002805 0.00492 15 1/23/20 0.014991 -0.0137 0.007499 -0.00385 16 1/24/20 0.010162 -0.01381 0.005081 0.00122 17 1/27/20 0.013093 0.01436 0.008621 0.00109 18 1/28/20 0.017437 -0.01451 0.008916 0.00415 19 1/29/20 0.017574 -0.01104 0.009829 0.003898 20 1/30/20 0.012254 0.01051 0.008385 0.003742 21 1/31/20 0.016635 -0.01865 0.002227 -0.00089 22 2/3/20 0.017519 -0.01872 0.002236 0.004533 23 2/4/20 0.014618 0.01093 0.001307 -0.00291 24 2/5/20 0.011627 0.01547 0.008128 0.004186 25 2/6/20 0.013617 0.01524 0.002976 0,000851 26 2/7/20 0.015334 0.01025 0.005155 0.00093 27 2/10/20 0.016011 -0.01968 0.007786 -0.00344 28 2/11/20 0.011683 -0.01801 0.001136 -0.00251 29 2/12/20 0.010341 -0.01035 0.007536 0.00077 30 2/13/20 0.011683 -0.01259 0.004714 0.00477 31 2/14/20 0.013216 -0.01796 0.003597 0.00085 32 2/18/20 0.012524 0.01965 0.00853 -0.002 33 2/19/20 0.010406 -0.01601 0.00413 -0.00046 34 2/20/20 0.011305 -0.01393 0.002938 0.00019 25 honnan ANAK Sheet1 Sheet2 Sheet3 + G Calibri (Body) 11 ' BI UN Av Paste E Open recovered workbooks? Your recent changes were saved. Do you want D8 v $* 0.00345300070018549 A D E F 30 2/13/20 0.011683 -0.01259 0.004714 -0.00477 31 2/14/20 0.013216 -0.01796 0.003597 -0.00085 32 2/18/20 0.012524 -0.01965 0.00853 -0.002 33 2/19/20 0.010406 -0.01601 0.00413 -0.00046 34 2/20/20 0.011305 -0.01393 0.002938 -0.00019 35 2/21/20 0.010201 -0.01387 0.005465 -9.3E-05 36 2/24/20 0.018748 -0.01465 0.007741 0.003183 37 2/25/20 0.01314 -0.01637 0.008861 0.002306 38 2/26/20 0.0181 -0.01582 0.006638 0.004747 39 2/27/20 0.016461 -0.01643 0.001485 -0.0009 40 2/28/20 0.013598 -0.01328 0.006462 0.00403 41 3/2/20 0.01203 -0.01645 0.007835 0.004027 42 3/3/20 0.010545 +0.01571 0.009544 0.002569 43 3/4/20 0.015177 -0.01433 0.005538 0.001569 44 3/5/20 0.01232 -0.01868 0.00059 0.004683 45 3/6/20 0.019738 -0.01471 0.005614 -0.00309 46 3/9/20 0.015871 -0.01884 0.007982 0.000361 47 3/10/20 0.012827 0.01547 0.001438 -0.00354 48 3/11/20 0.011776 -0.01485 0.005577 -0.00405 49 3/12/20 0.016283 -0.01371 0.00408 -0.00455 50 3/13/20 0.014263 -0.01953 0.00028 -0.0029 51 3/16/20 0.01945 -0.01382 0.001457 0.003559 52 3/17/20 0.010099 0.01056 0.003486 0.004344 53 3/18/20 0.014504 .001104 0.005071 0.002022 54 3/19/20 0.010586 -0.01489 0.002135 -0.00157 55 3/20/20 0.015974 0.01032 0.006906 -0.00443 56 3/23/20 0.018882 0.01934 0.007883 0.002857 57 3/24/20 0.011306 -0.01251 0.002239 -0.00481 58 3/25/20 0.0191430.01492 0.007347 -0.00494 59 3/26/20 0.012356 -0.01927 0.007377 60 0.00093 3/27/20 0.017147 -0.01852 0.002366 61 -0.00345 3/30/20 0.017015 -0.01028 0.001249 62 -0.00072 63 Sheet Sheet2 Sheet3 hw7 part 1 -1.xlsx Download the attached Excel file in Question 1. Question 1 is based on the data in Sheet 1. Round your answers to four decimal places. The volatilities (standard deviations of returns) of stocks A, B and Care and respectively