Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

> LD III ilil Paste BLUE 2 sensgwuuussmu Open recovered workbooks? Your recent changes were saved. Do you want D8 fx 0.00345300070018549 D E F

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
> LD III ilil Paste BLUE 2 sensgwuuussmu Open recovered workbooks? Your recent changes were saved. Do you want D8 fx 0.00345300070018549 D E F B G B C 1 Date D 2 1/3/20 0.013961 -0.01856 0.008396 0.00208 3 1/6/20 0.012863 -0.01856 0.006094 -0.00195 4 1/7/20 0.015526 -0.01444 0.00693 0.000511 5 1/8/20 0.014991 -0.0172 0.002713 0.000181 6 1/9/20 0.011965 -0.01336 0.004549 -0.00122 7 1/10/20 0.018239 -0.01237 0.000437 -0.00079 8 1/13/20 0.017496 -0.01205 0.0034531 -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.01958 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 33 2/19/20 0.010406 -0.01601 -0.002 0.00413 34 36 GLOSARAR Sheet2 SOR Sheet3 + -0.00046 2/20/20 0.011305 0.01393 0.0029380.00019 han Sheett - Paste BIU Open recovered workbooks? Your recent changes were saved. D D8 fx 0.00345300070018549 D E F 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 -0.01035 0.007536 -0.00077 2/12/20 0.010341 2/13/20 0.011683 -0.01259 0.004714 -0.00477 2/14/20 0.013216 0.01796 0.003597 -0.00085 0.00853 -0.002 2/18/20 0.012524 -0.01965 0.00413 -0.00046 2/19/20 0.010406 -0.01601 2/20/20 0.011305 -0.01393 0.002938 -0.00019 2/21/20 0.010201 0.01387 0.005465 -9.3E-05 2/24/20 0,018748 -0.01465 0.007741 0.003183 2/25/20 0.01314 -0.01637 0.008861 0.002306 2/26/20 0.0181 -0.01582 0.006638 0.004747 2/27/20 0.016461 -0.01643 0.001485 -0.0009 2/28/20 0.013598 0.01328 0.006462 0.00403 3/2/20 0.01203 -0.01645 0.007835 0.004027 3/3/20 0.010545 -0.01571 0.009544 0.002569 3/4/20 0.015177 -0.01433 0.005538 0.001569 3/5/20 0.01232 -0.01868 0.00059 0.004683 3/6/20 0.019738 0.01471 0.005614 -0.00309 3/9/20 0.015871 -0.01884 0.007982 0.000361 3/10/20 0.012827 -0.01547 0.001438 -0.00354 3/11/20 0.011776 -0.01485 0.005577 -0.00405 3/12/20 0.016283 -0.01371 0.00408 0.00455 3/13/20, 0.014263 -0.01953 0.00028 -0.0029 3/16/20 0.01945 -0.01382 0.001457 0.003559 3/17/20 0.010099 -0.01056 0.003486 0.004344 3/18/20 0.014504 -0.01104 0.005071 0.002022 3/19/20 0.010586 -0.01489 0.002135 -0.00157 3/20/20 0.015974 0.01032 0.006906 -0.00443 3/23/20 0.018882 -0.01934 0.007883 0.002857 3/24/20 0.011306 -0.01251 0.002239 -0.00481 3/25/20 0.019143 -0.01492 0.007347 +0.00494 3/26/20 0.012356 -0.01927 0.007377 3/27/20 0.017147 -0.01852 0.002366 0.00093 3/30/20 0.017015 -0.01028 0.001249 -0.00072 -0.00345 Sheet1 Sheet2 Sheet3 + G4 F Date 8 10 11 12 13 14 15 17 18 therm, 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 B C D E Y Z 1/3/20 0.007378 0.028375 -0.02663 1/6/20 0.008997 -0.023929 0.026726 1/7/20 0.000593 0.00952 -0.006039 1/8/20 0.010691 -0.028808 0.03196 1/9/20 0.013337 -0.040832 0.042505 1/10/20 -0,000746 0.010748 -0.006936 1/13/20 0.013226 -0.040594 0.042205 1/14/20 0.001059 0.001925 0.000593 1/15/20 0.006141 -0.017704 0.01898 1/16/20 0.015928 -0.045648 0.049623 1/17/20 0.008445 -0.024694 0.026288 1/21/20 0.001111 0.007574 -0.005787 1/22/20 0.003821 -0.004735 0.008429 1/23/20 0.004506 -0.010658 0.012692 1/24/20 -0.010467 0.041414 -0.038403 1/27/20 -0.019907 0.070536 0.058661 1/28/20 0.018234 0.058275 0.059431 1/29/20 0.001238 3.38E-OS 0,001587 1/30/20 0.008225 -0.021177 0.024058 1/31/20 -0,024034 0.084385 0.082414 2/3/20 0.013694 -0.040066 0.042541 2/4/20 0.02572 -0.083217 0.084378 2/5/20 0.02009 0.05559 0.066226 2/6/20 0.008057 -0.02253 0.024526 2/7/20 -0.004824 0.020775 -0.018607 2/10/20 0.014056 -0.040928 0.043662 2/11/20 0.005261 0.014093 0.015682 2/12/20 0.012783 -0.039042 0.040689 2/13/200.000823 0.002556 0.00011 2/14/20 0.006347 -0.014835 0.017753 2/18/20 -0.001408 0.005772 0.005278 2/19/20 0.010169 -0.032754 0.033281 2/20/20 -0.002425 0.013709 0.011114 2/21/20 -0.012062 0.044828 0.042694 2/24/20 -0.047403 0.15919 0158545 2/25/20 -0.042391 0.145277 -0.143442 2/26/20 -0.002256 0.011383 0.0096 2/27/20 0062653 0.211717 0.210351 2/28/200009204 0.033855 -0.03239 3/2/20 0.072223 0.234132 0237354 2/1/20 0015942 0.135026 0.132617 3/4/2000669 021967022135 3/5/20004733 01640 0.16116 020 0.01235 0.07707900 Sheet1 Sheet2 Sheet3 G4 A 44 45 46 47 48 49 SO 51 S2 53 54 55 56 S7 58 59 60 61 62 64 C D 3/5/20004733 0.16407 -0.16116 3/6/20 -0.02235 0.077079 0.075889 3/9/20 - 110923 0.371226 0370569 0.25363 2/10/20 0.076995 0.251042 1/11/200069884 0.236079 0.234634 3/12/20 0.119905 0.465114 0.467839 3/13/20 0.142812 0.46R541 04/2003 3/16/20 0.176693 0.589511 -0.589265 3/17/20 0.033224 0.305867 0.30812 3/18/20 0.074027 0.251622 0.249376 3/19/20 0.009859 0.028392 0.030457 3/20/20 0.061808 0.21324 0.209911 3/23/20 -0,041174 0.1413640 139463 3/24/20 0.144043 0.472955 0.476272 3/25/20 0.020642 0.065035 0.067314 3/26/20 0.096237 0.31746 0318998 3/27/20 -0.047521 0.153116 0.1609443 3/30/20 0.05.1952 -0.174053 0.176724 3/31/20 -0.020713 0.076594 0.07311 4/1/20 0.063077 0.213259 -0.211928 4/2/20 0.037854 0.119575 0.122839 4/1/20 -0.0163 0.068129 0.066655 4/6/20 0108379 0.359881 0.16052 4/7/20 0.00114513E-5 0.001776 4/1/20 0.05 0.175728 0.17845 4/9/20 0 02522-0.077412 0.04 4/11/200012058 0.046568 0.0456 4/14/2002 015685 0159616 4/15/20 0.6295560 2015-0.101287 4/16/200012012 0.0193 0.036753 4/17/20000321 0140628 0.142233 4/20/20 0.023274 0.00846 0.079338 4/21/200043236 0.145705 105596 4/22/20 0097478 124113 0.124489 4/220 0.00289000000 0.000154 4/24/10 0.004299-00 0.072751 4/21/20 0.0257111 001151 4/28/20 005152 002039 GB 4/29/200009561330150160523 4/30/200010056 0015430035168 5/1/20 0.038134 0.11172012954 5/9/200009556 00357 0.678161 0 0.01723 02 00560 290.007049 0908505506 11/20 GMT -066754 Sheet Sheet2 Sheet3 66 68 69 70 71 72 73 74 75 75 70 79 40 82 14 esc 0 Open recovered workbooks? Your recent changes were saved. G4 fx 85 85 87 88 89 90 91 92 93 94 95 96 92 98 99 100 101 202 103 104 105 5/4/200.009556 0.025367 0.028361 5/5/20 0.01723 -0.052982 0056026 5/6/20007049 0.029056 -0.026506 5/7/20 0.0201430.066754 0.067857 5/8/20 0.028435 0.091335 0.092927 3/11/20 0.000029 0.008319 0,010679 5/12/20 -0.027042 0.0983990.095202 5/13/20 -0.0230 0.033033 0.00025 5/14/200.0207690064896 0.056896 5/15/200.009477 0.028698 0.030033 5/18/20 0.05051 0.163927 0.165981 5/19/20 -0.013013 0.046584 -0.045104 5/20/20 0.02843 0.088738 0,09152 5/21/200.008656 0.034506 0.032113 5/22/200.006946 -0.017927 5/25/20 0.022176 0.068363 0.070327 5/27/20 0.025818 0.07.2009 0.082748 5/21/200.000239 0.006017 -0.003608 5/29/200.010205 0.077785 0.030662 6/1/20 0.009019 0.023528 0.026544 6/2/20 0.016123 -0.0097 0.051355 5/3/20 0.024105 0.077 0.078546 5/4/20 0.002113 0.010814 0.00034 6/5/20 0042676 0136292 0.139043 6/8/20 0.02181 069258 0.070847 6/9/20 -0.008023 0.029737 0.028355 5/10/20 0005217 0.020348 -0.016876 6/11/20 0.084711 0.27 -0.285425 w12/20 0022755 -0.0096 0.07241 15/20 0.016155 0.06867 6/16/200082228 0.101919 0.10142 6/17/20 0.000265 0.009312 0.00 11/20 0.00423 0.005912 0.011918 6/19/20 0.00001 0.022144 0.01943 6/22/20 0.012906 0.03859 0040637 6/23/200009203 0026305 0.028323 24/20 0.035568 0.134790 0.12192 w2/0 0.000093 0.061014 054201 5/26/2002 111331110 29/20 0.0639 051 0.083259 SOT 107 108 GOT 110 2010 112 113 114 115 116 117 STE GTE 9 120 121 122 123 124 125 126 127 120 129 Sheet Sheet2 Sheet3 Download the attached Excel file in Question 1. Question 3 is based on the data in Sheet 2. Round your answers to four decimal places. Form portfolios XY and XZ. XY puts 77% of wealth in X and 23% of wealth in Y. XZ puts 77% of wealth in X and 23% of wealth in Z. The volatilities (standard deviations of returns) of portfolios XY and XZ are and respectively Compare the volatilities of individual stocks to those of the portfolios. What is the takeaway? > LD III ilil Paste BLUE 2 sensgwuuussmu Open recovered workbooks? Your recent changes were saved. Do you want D8 fx 0.00345300070018549 D E F B G B C 1 Date D 2 1/3/20 0.013961 -0.01856 0.008396 0.00208 3 1/6/20 0.012863 -0.01856 0.006094 -0.00195 4 1/7/20 0.015526 -0.01444 0.00693 0.000511 5 1/8/20 0.014991 -0.0172 0.002713 0.000181 6 1/9/20 0.011965 -0.01336 0.004549 -0.00122 7 1/10/20 0.018239 -0.01237 0.000437 -0.00079 8 1/13/20 0.017496 -0.01205 0.0034531 -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.01958 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 33 2/19/20 0.010406 -0.01601 -0.002 0.00413 34 36 GLOSARAR Sheet2 SOR Sheet3 + -0.00046 2/20/20 0.011305 0.01393 0.0029380.00019 han Sheett - Paste BIU Open recovered workbooks? Your recent changes were saved. D D8 fx 0.00345300070018549 D E F 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 -0.01035 0.007536 -0.00077 2/12/20 0.010341 2/13/20 0.011683 -0.01259 0.004714 -0.00477 2/14/20 0.013216 0.01796 0.003597 -0.00085 0.00853 -0.002 2/18/20 0.012524 -0.01965 0.00413 -0.00046 2/19/20 0.010406 -0.01601 2/20/20 0.011305 -0.01393 0.002938 -0.00019 2/21/20 0.010201 0.01387 0.005465 -9.3E-05 2/24/20 0,018748 -0.01465 0.007741 0.003183 2/25/20 0.01314 -0.01637 0.008861 0.002306 2/26/20 0.0181 -0.01582 0.006638 0.004747 2/27/20 0.016461 -0.01643 0.001485 -0.0009 2/28/20 0.013598 0.01328 0.006462 0.00403 3/2/20 0.01203 -0.01645 0.007835 0.004027 3/3/20 0.010545 -0.01571 0.009544 0.002569 3/4/20 0.015177 -0.01433 0.005538 0.001569 3/5/20 0.01232 -0.01868 0.00059 0.004683 3/6/20 0.019738 0.01471 0.005614 -0.00309 3/9/20 0.015871 -0.01884 0.007982 0.000361 3/10/20 0.012827 -0.01547 0.001438 -0.00354 3/11/20 0.011776 -0.01485 0.005577 -0.00405 3/12/20 0.016283 -0.01371 0.00408 0.00455 3/13/20, 0.014263 -0.01953 0.00028 -0.0029 3/16/20 0.01945 -0.01382 0.001457 0.003559 3/17/20 0.010099 -0.01056 0.003486 0.004344 3/18/20 0.014504 -0.01104 0.005071 0.002022 3/19/20 0.010586 -0.01489 0.002135 -0.00157 3/20/20 0.015974 0.01032 0.006906 -0.00443 3/23/20 0.018882 -0.01934 0.007883 0.002857 3/24/20 0.011306 -0.01251 0.002239 -0.00481 3/25/20 0.019143 -0.01492 0.007347 +0.00494 3/26/20 0.012356 -0.01927 0.007377 3/27/20 0.017147 -0.01852 0.002366 0.00093 3/30/20 0.017015 -0.01028 0.001249 -0.00072 -0.00345 Sheet1 Sheet2 Sheet3 + G4 F Date 8 10 11 12 13 14 15 17 18 therm, 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 B C D E Y Z 1/3/20 0.007378 0.028375 -0.02663 1/6/20 0.008997 -0.023929 0.026726 1/7/20 0.000593 0.00952 -0.006039 1/8/20 0.010691 -0.028808 0.03196 1/9/20 0.013337 -0.040832 0.042505 1/10/20 -0,000746 0.010748 -0.006936 1/13/20 0.013226 -0.040594 0.042205 1/14/20 0.001059 0.001925 0.000593 1/15/20 0.006141 -0.017704 0.01898 1/16/20 0.015928 -0.045648 0.049623 1/17/20 0.008445 -0.024694 0.026288 1/21/20 0.001111 0.007574 -0.005787 1/22/20 0.003821 -0.004735 0.008429 1/23/20 0.004506 -0.010658 0.012692 1/24/20 -0.010467 0.041414 -0.038403 1/27/20 -0.019907 0.070536 0.058661 1/28/20 0.018234 0.058275 0.059431 1/29/20 0.001238 3.38E-OS 0,001587 1/30/20 0.008225 -0.021177 0.024058 1/31/20 -0,024034 0.084385 0.082414 2/3/20 0.013694 -0.040066 0.042541 2/4/20 0.02572 -0.083217 0.084378 2/5/20 0.02009 0.05559 0.066226 2/6/20 0.008057 -0.02253 0.024526 2/7/20 -0.004824 0.020775 -0.018607 2/10/20 0.014056 -0.040928 0.043662 2/11/20 0.005261 0.014093 0.015682 2/12/20 0.012783 -0.039042 0.040689 2/13/200.000823 0.002556 0.00011 2/14/20 0.006347 -0.014835 0.017753 2/18/20 -0.001408 0.005772 0.005278 2/19/20 0.010169 -0.032754 0.033281 2/20/20 -0.002425 0.013709 0.011114 2/21/20 -0.012062 0.044828 0.042694 2/24/20 -0.047403 0.15919 0158545 2/25/20 -0.042391 0.145277 -0.143442 2/26/20 -0.002256 0.011383 0.0096 2/27/20 0062653 0.211717 0.210351 2/28/200009204 0.033855 -0.03239 3/2/20 0.072223 0.234132 0237354 2/1/20 0015942 0.135026 0.132617 3/4/2000669 021967022135 3/5/20004733 01640 0.16116 020 0.01235 0.07707900 Sheet1 Sheet2 Sheet3 G4 A 44 45 46 47 48 49 SO 51 S2 53 54 55 56 S7 58 59 60 61 62 64 C D 3/5/20004733 0.16407 -0.16116 3/6/20 -0.02235 0.077079 0.075889 3/9/20 - 110923 0.371226 0370569 0.25363 2/10/20 0.076995 0.251042 1/11/200069884 0.236079 0.234634 3/12/20 0.119905 0.465114 0.467839 3/13/20 0.142812 0.46R541 04/2003 3/16/20 0.176693 0.589511 -0.589265 3/17/20 0.033224 0.305867 0.30812 3/18/20 0.074027 0.251622 0.249376 3/19/20 0.009859 0.028392 0.030457 3/20/20 0.061808 0.21324 0.209911 3/23/20 -0,041174 0.1413640 139463 3/24/20 0.144043 0.472955 0.476272 3/25/20 0.020642 0.065035 0.067314 3/26/20 0.096237 0.31746 0318998 3/27/20 -0.047521 0.153116 0.1609443 3/30/20 0.05.1952 -0.174053 0.176724 3/31/20 -0.020713 0.076594 0.07311 4/1/20 0.063077 0.213259 -0.211928 4/2/20 0.037854 0.119575 0.122839 4/1/20 -0.0163 0.068129 0.066655 4/6/20 0108379 0.359881 0.16052 4/7/20 0.00114513E-5 0.001776 4/1/20 0.05 0.175728 0.17845 4/9/20 0 02522-0.077412 0.04 4/11/200012058 0.046568 0.0456 4/14/2002 015685 0159616 4/15/20 0.6295560 2015-0.101287 4/16/200012012 0.0193 0.036753 4/17/20000321 0140628 0.142233 4/20/20 0.023274 0.00846 0.079338 4/21/200043236 0.145705 105596 4/22/20 0097478 124113 0.124489 4/220 0.00289000000 0.000154 4/24/10 0.004299-00 0.072751 4/21/20 0.0257111 001151 4/28/20 005152 002039 GB 4/29/200009561330150160523 4/30/200010056 0015430035168 5/1/20 0.038134 0.11172012954 5/9/200009556 00357 0.678161 0 0.01723 02 00560 290.007049 0908505506 11/20 GMT -066754 Sheet Sheet2 Sheet3 66 68 69 70 71 72 73 74 75 75 70 79 40 82 14 esc 0 Open recovered workbooks? Your recent changes were saved. G4 fx 85 85 87 88 89 90 91 92 93 94 95 96 92 98 99 100 101 202 103 104 105 5/4/200.009556 0.025367 0.028361 5/5/20 0.01723 -0.052982 0056026 5/6/20007049 0.029056 -0.026506 5/7/20 0.0201430.066754 0.067857 5/8/20 0.028435 0.091335 0.092927 3/11/20 0.000029 0.008319 0,010679 5/12/20 -0.027042 0.0983990.095202 5/13/20 -0.0230 0.033033 0.00025 5/14/200.0207690064896 0.056896 5/15/200.009477 0.028698 0.030033 5/18/20 0.05051 0.163927 0.165981 5/19/20 -0.013013 0.046584 -0.045104 5/20/20 0.02843 0.088738 0,09152 5/21/200.008656 0.034506 0.032113 5/22/200.006946 -0.017927 5/25/20 0.022176 0.068363 0.070327 5/27/20 0.025818 0.07.2009 0.082748 5/21/200.000239 0.006017 -0.003608 5/29/200.010205 0.077785 0.030662 6/1/20 0.009019 0.023528 0.026544 6/2/20 0.016123 -0.0097 0.051355 5/3/20 0.024105 0.077 0.078546 5/4/20 0.002113 0.010814 0.00034 6/5/20 0042676 0136292 0.139043 6/8/20 0.02181 069258 0.070847 6/9/20 -0.008023 0.029737 0.028355 5/10/20 0005217 0.020348 -0.016876 6/11/20 0.084711 0.27 -0.285425 w12/20 0022755 -0.0096 0.07241 15/20 0.016155 0.06867 6/16/200082228 0.101919 0.10142 6/17/20 0.000265 0.009312 0.00 11/20 0.00423 0.005912 0.011918 6/19/20 0.00001 0.022144 0.01943 6/22/20 0.012906 0.03859 0040637 6/23/200009203 0026305 0.028323 24/20 0.035568 0.134790 0.12192 w2/0 0.000093 0.061014 054201 5/26/2002 111331110 29/20 0.0639 051 0.083259 SOT 107 108 GOT 110 2010 112 113 114 115 116 117 STE GTE 9 120 121 122 123 124 125 126 127 120 129 Sheet Sheet2 Sheet3 Download the attached Excel file in Question 1. Question 3 is based on the data in Sheet 2. Round your answers to four decimal places. Form portfolios XY and XZ. XY puts 77% of wealth in X and 23% of wealth in Y. XZ puts 77% of wealth in X and 23% of wealth in Z. The volatilities (standard deviations of returns) of portfolios XY and XZ are and respectively Compare the volatilities of individual stocks to those of the portfolios. What is the takeaway

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Finance

Authors: Michael Fardon

1st Edition

1872962319, 1872962173, 978-1872962313, 978-1872962177

More Books

Students also viewed these Finance questions

Question

What is partial productivity? Total productivity?

Answered: 1 week ago