Question

1 Approved Answer

Posted on Sep 08, 2024

The spreadsheet below contains the monthly stock returns for several different stocks, the S&P 500, and Treasuries between 2015 and 2019. Using these data and

The spreadsheet below contains the monthly stock returns for several different stocks, the S&P 500, and Treasuries between 2015 and 2019. Using these data and Excel estimate the beta for Barrick Gold over this time period. Round your answer to two decimals. image text in transcribed

Date Monthly Retums Monthly Retum on S&P 500 on Treasures Monthly Retums on Tesla Stock Monthly Retums on Alphabet Inc Monthly Retums on Lockheed Martin Monthly Retums on Walt Disney Monthly Retums on Walmart Monthly Retums on Barrick Gold Monthly Retums on AutoZone Monthly Retums on Yum! Brands Monthly Retums on Netflix 12/31/19 11/29/19 10/31/19 9/30/19 8/20/19 7/31/19 6/28/19 5/31/19 4/30/19 3/29/19 2/28/19 1/31/19 12/31/18 11/30/18 10/31/18 9/28/18 8/31/18 7/31/18 6/29/18 5/31/18 4/30/18 3/29/18 2/28/18 1/31/18 12/29/17 11/30/17 10/31/17 9/29/17 8/31/17 7/31/17 6/30/17 5/31/17 4/28/17 3/31/17 2/28/17 1/31/17 12/30/16 11/30/16 10/31/16 9/30/16 8/31/16 7/29/16 6/30/16 5/31/16 4/29/16 3/31/16 2/29/16 1/29/16 12/31/15 11/30/15 10/30/15 9/30/15 8/31/15 7/31/15 6/30/15 5/29/15 4/30/15 3/31/15 2/27/15 1/30/15 0.02859 0.034047 0.020432 0.017181 -0.018092 0.013128 0.06893 -0.065778 0.039313 0.017924 0.029729 0.078684 -0.091777 0.017859 -0.069403 0.004294 0.030253 0.036022 0.004842 0.021608 0.002719 0.026885 -0.038947 0.056179 0.009832 0.028083 0.022188 0.019303 0.000546 0.019349 0.004814 0.011576 0.009091 -0.000389 0.037198 0.017884 0.018201 0.034174 0.019426 -0.001234 -0.001219 0.03561 0.000906 0.015329 0.002699 0.065991 -0.004128 -0.050735 0.01753 0.000505 0.082983 -0.026443 -0.062581 0.019742 -0.021012 0.010491 0.008521 -0.017396 0.054893 -0.031041 0.0014 0.0012 0.0015 0.0018 0.0016 0.0019 0.0018 0.0021 0.0021 0.0019 0.0018 0.0021 0.0019 0.0018 0.0019 0.0015 0.0016 0.0016 0.0014 0.0014 0.0014 0.0012 0.0011 0.0011 0.0009 0.000 0.0009 0.0009 0.0009 0.0007 0.0006 0.0006 0.0005 0.0003 0.0004 0.0004 0.0003 0.0001 0.0002 0.0002 0.0002 0.0002 0.0002 0.0001 0.0001 0.0002 0.0002 0.0001 0.0001 0.267897 0.047695 0.307427 0.067639 -0.066222 0.081223 0.206848 -0.224266 -0.147109 -0.125109 0.041887 0.077464 -0.050445 0.039013 0.274011 -0.122290 0.011805 -0.130660 0.204474 -0.031201 0.104347 0.224246 -0.031752 0.137980 0.008095 -0.068410 -0.028056 -0.041585 0.100252 -0.105473 0.060409 0.085777 0.128530 0.113244 -0.007701 0.178951 0.128247 -0.042128 -0.030878 -0.037640 -0.097023 0.106039 -0.049053 -0.072811 0.047830 0.197155 0.003818 -0.203367 0.042343 0.112743 -0.166948 -0.002650 -0.064212 -0.007866 0.069617 0.109489 0.197489 -0.071653 0.001277 -0.084574 Monthly Retums on General Dynamics -0.029658 0.027941 -0.026870 -0.044649 0.028665 0.028270 0.130581 -0.100157 0.061791 -0.005522 -0.005550 0.094714 -0.149711 0.071329 -0.152452 0.058532 -0.031838 0.076605 -0.075851 0.001987 -0.084473 -0.006968 -0.000135 0.097665 -0.017909 0.020593 -0.008561 0.021008 0.025569 -0.004695 -0.025338 0.048816 0.039690 -0.013751 0.048211 0.053168 -0.015341 0.163261 0.023589 0.019314 0.036286 0.054941 -0.013181 0.009607 0.075436 -0.035958 0.018689 -0.021112 0.062133 -0.014268 0.082059 -0.028726 -0.047482 0.052368 0.015839 0.020682 0.016798 -0.021977 0.041814 -0.027540 0.024568 0.035592 0.033724 0.026008 -0.023490 0.125607 -0.020587 -0.071394 0.012929 0.047673 0.003180 0.077983 -0.053745 0.016401 0.097782 -0.020292 0.000754 0.091077 0.028258 0.066507 -0.014015 0.066025 -0.055738 0.118062 0.024466 0.004692 0.059983 0.021058 0.009490 0.023957 -0.058174 0.065014 0.092097 0.007714 0.033158 0.032352 0.018179 -0.033778 0.009327 0.013350 -0.002263 0.110808 -0.059289 0.061630 -0.069723 0.067615 -0.060812 -0.020991 0.021923 0.044724 0.168233 -0.015900 -0.011754 0.201917 -0.021800 -0.009733 -0.016750 -0.018625 0.044676 0.015425 Monthly Retums on Berkshire Hathaway 0.027519 0.036233 0.022791 0.028-8-84 -0.018104 -0.030419 0.071669 -0.086194 0.079229 -0.003259 -0.029856 0.017974 -0.061350 0.059456 -0.038422 0.013300 0.047256 0.069175 -0.017967 -0.011870 -0.028251 0.035939 -0.040588 0.086610 0.020926 0.089327 0.020856 0.012120 0.032920 0.031747 0.025197 0.002664 -0.008285 -0.028199 0.045205 0.007617 0.030046 0.098748 0.002405 -0.042257 0.045185 0.004494 0.024942 -0.033356 0.026001 0.053788 0.042164 -0.017391 0.017680 -0.015817 0.047921 0.035999 -0.053593 0.044667 -0.046322 0.006560 -0.018851 -0.016638 0.024622 -0.044845 -0.004220 0.044467 -0.034392 0.015490 0.066654 -0.003758 0.073847 0.022230 0.110508 -0.029895 0.075667 0.106363 -0.128449 0.029879 -0.150624 0.079742 -0.011316 0.103815 -0.060755 -0.013402 -0.050573 0041170 -0.001155 0.105280 0.006048 0.042056 -0.000419 0.016045 0.051621 0.052304 -0.012521 0.050102 0.006913 0.003826 0.067919 0.005551 -0.057719 0.083976 0.027782 -0.013375 -0.03 2090 0.018374 0.050544 0.023668 0.049120 0.026451 0.030521 -0.028321 0.009171 0.004458 0.060393 0.030470 -0.021342 0.114040 -0.012221 0.016613 -0.080607 0.014546 0.069959 -0.021810 -0.040045 0.166718 -0.003059 -0.050561 -0.040207 0.030435 0.057558 -0.035993 0.233631 -0.016040 0.011836 0.017054 -0.042947 0.005748 -0.018043 0.043921 -0.013561 0.091499 0.053684 -0.008572 -0.001095 0.026367 -0.050704 0.010790 0.033677 0.071670 -0.007710 -0.025988 0.079414 0.041976 -0.015657 0.066263 0.019490 0.029976 -0.005061 0.061696 0.059322 0.069371 0.001831 -0.016938 -0.015529 -0.011859 -0.014110 -0.039125 0.039774 0.039678 -0.003131 -0.088123 0.067683 -0.002374 0.112916 0.003141 -0.151000 0.057123 0.034158 0.015177 0.036514 0.007782 0.144239 -0.034292 0.002351 0.015606 -0.011955 0.038684 0.039953 -0.000996 0.089215 -0.008460 0.054445 -0.009395 0.032975 0.028771 -0.040758 -0.026227 0.067831 -0.020342 0.080130 0.041798 0.037579 -0.061045 -0.005732 -0.005777 -0.155628 0.079494 0.020878 0.113618 0.117353 0.000897 -0.017627 0.056950 -0.03 7150 0.052275 0.043008 0.023403 0.062781 -0.034433 -0.011501 0.005856 0.029118 0.009518 -0.014115 0.000685 0.031647 0.065949 -0.023653 0.039946 -0.000301 0.082545 0.050136 0.027952 -0.117212 0.001699 -0.093915 0.014803 -0.044971 -0.042153 -0.051054 -0.014178 0.012356 -0.010480 0.106548 0.029878 0.001731 -0.105779 0.194342 0.031072 0.269726 -0.020440 -0.072210 0.084552 -0.056012 -0.011078 0.067451 0.018327 0.132672 0.063340 -0.066130 -0.147753 -0.004549 -0.018560 0.081928 0.080729 -0.195801 -0.006220 0.050073 -0.044291 -0.101927 -0.105614 0.065642 0.062854 -0.038090 -0.008971 -0.119537 0.022067 0.009219 0.153942 0.063915 -0.144969 0.007336 0.041740 -0.220952 0.023888 0.273107 -0.133196 0.426362 -0.022318 0.403633 0.342818 0.005450 -0.042913 0.209119 -0.084892 -0.012748 -0.337711 -0.101180 -0.085254 0.187956 -0.158218 0.022692 0.188837 0.011368 0.029308 0.055098 -0.015494 -0.019011 0.021438 0.070450 -0.001167 0.004091 0.090685 0.108138 0.010736 0.036177 0.103072 -0.054441 0.011501 0.086956 0.051570 0.033281 0.039710 -0.037260 0.024115 -0.131584 0.076008 0.035835 0.164987 -0.009427 0.126164 0.021081 -0.053711 -0.058523 0.124633 -0.042680 -0.018329 0.015959 -0.082060 0.008440 0.055271 0.034074 0.035778 -0.088664 0.025358 0.041511 -0.003950 -0.039438 0.028558 0.009356 0.034344 0.053409 -0.000816 0.083694 0.010950 0.021471 0.051042 -0.009976 0.001427 -0.013926 0.061430 0.076588 -0.035777 0.000596 -0.006096 -0.103324 -0.028686 0.041593 0.016716 0.081290 0.015519 0.045887 0.056190 0.010002 0.022411 -0.003253 0.024002 -0.005500 0.045255 0.100391 0.013679 -0.038239 -0.062112 0.023141 0.046080 -0.033592 0.036515 -0.022283 0.125185 0.011411 -0.041786 0.017753 0.027386 0.015419 0.104791 0.033646 -0.021739 -0.003205 0.039475 -0.000946 0.051752 0.044268 0.001102 0.014426 0.083936 0.010111 0.031800 -0.022358 0.129433 0.001382 -0.003012 0.007447 0.022564 -0.107317 0.002256 -0.091044 -0.021203 -0.000333 0.048278 0.097180 -0.029466 0.122164 -0.002195 0.028316 0.094812 0.073948 -0.08.8953 -0.090529 -0.120585 0.070030 -0.073568 0.039208 -0.004300 0.054786 0.268.400 -0.064551 -0.051859 -0.193382 0.017542 0.089584 -0.137905 0.113282 0.125254 0.057931 0.013625 0.077987 0.408106 0.023350 -0.045054 0.083154 0.038006 -0.038258 0.215849 -0.08 3768 0.071419 0.029700 0.039963 0.010092 0.136591 0.058120 -0.063026 0.267073 0.011288 0.067945 -0.002514 -0.108121 0.139287 -0.119339 0.094422 0.017095 -0.197062 0.072570 0.137941 0.049584 -0.102321 0.006299 0.218026 0.052687 0.121402 0.335525 -0.122592 0.074943 0.293288 0 0 0 0 0 ol 0 0 0 0 0 0 0 Date Monthly Retums Monthly Retum on S&P 500 on Treasures Monthly Retums on Tesla Stock Monthly Retums on Alphabet Inc Monthly Retums on Lockheed Martin Monthly Retums on Walt Disney Monthly Retums on Walmart Monthly Retums on Barrick Gold Monthly Retums on AutoZone Monthly Retums on Yum! Brands Monthly Retums on Netflix 12/31/19 11/29/19 10/31/19 9/30/19 8/20/19 7/31/19 6/28/19 5/31/19 4/30/19 3/29/19 2/28/19 1/31/19 12/31/18 11/30/18 10/31/18 9/28/18 8/31/18 7/31/18 6/29/18 5/31/18 4/30/18 3/29/18 2/28/18 1/31/18 12/29/17 11/30/17 10/31/17 9/29/17 8/31/17 7/31/17 6/30/17 5/31/17 4/28/17 3/31/17 2/28/17 1/31/17 12/30/16 11/30/16 10/31/16 9/30/16 8/31/16 7/29/16 6/30/16 5/31/16 4/29/16 3/31/16 2/29/16 1/29/16 12/31/15 11/30/15 10/30/15 9/30/15 8/31/15 7/31/15 6/30/15 5/29/15 4/30/15 3/31/15 2/27/15 1/30/15 0.02859 0.034047 0.020432 0.017181 -0.018092 0.013128 0.06893 -0.065778 0.039313 0.017924 0.029729 0.078684 -0.091777 0.017859 -0.069403 0.004294 0.030253 0.036022 0.004842 0.021608 0.002719 0.026885 -0.038947 0.056179 0.009832 0.028083 0.022188 0.019303 0.000546 0.019349 0.004814 0.011576 0.009091 -0.000389 0.037198 0.017884 0.018201 0.034174 0.019426 -0.001234 -0.001219 0.03561 0.000906 0.015329 0.002699 0.065991 -0.004128 -0.050735 0.01753 0.000505 0.082983 -0.026443 -0.062581 0.019742 -0.021012 0.010491 0.008521 -0.017396 0.054893 -0.031041 0.0014 0.0012 0.0015 0.0018 0.0016 0.0019 0.0018 0.0021 0.0021 0.0019 0.0018 0.0021 0.0019 0.0018 0.0019 0.0015 0.0016 0.0016 0.0014 0.0014 0.0014 0.0012 0.0011 0.0011 0.0009 0.000 0.0009 0.0009 0.0009 0.0007 0.0006 0.0006 0.0005 0.0003 0.0004 0.0004 0.0003 0.0001 0.0002 0.0002 0.0002 0.0002 0.0002 0.0001 0.0001 0.0002 0.0002 0.0001 0.0001 0.267897 0.047695 0.307427 0.067639 -0.066222 0.081223 0.206848 -0.224266 -0.147109 -0.125109 0.041887 0.077464 -0.050445 0.039013 0.274011 -0.122290 0.011805 -0.130660 0.204474 -0.031201 0.104347 0.224246 -0.031752 0.137980 0.008095 -0.068410 -0.028056 -0.041585 0.100252 -0.105473 0.060409 0.085777 0.128530 0.113244 -0.007701 0.178951 0.128247 -0.042128 -0.030878 -0.037640 -0.097023 0.106039 -0.049053 -0.072811 0.047830 0.197155 0.003818 -0.203367 0.042343 0.112743 -0.166948 -0.002650 -0.064212 -0.007866 0.069617 0.109489 0.197489 -0.071653 0.001277 -0.084574 Monthly Retums on General Dynamics -0.029658 0.027941 -0.026870 -0.044649 0.028665 0.028270 0.130581 -0.100157 0.061791 -0.005522 -0.005550 0.094714 -0.149711 0.071329 -0.152452 0.058532 -0.031838 0.076605 -0.075851 0.001987 -0.084473 -0.006968 -0.000135 0.097665 -0.017909 0.020593 -0.008561 0.021008 0.025569 -0.004695 -0.025338 0.048816 0.039690 -0.013751 0.048211 0.053168 -0.015341 0.163261 0.023589 0.019314 0.036286 0.054941 -0.013181 0.009607 0.075436 -0.035958 0.018689 -0.021112 0.062133 -0.014268 0.082059 -0.028726 -0.047482 0.052368 0.015839 0.020682 0.016798 -0.021977 0.041814 -0.027540 0.024568 0.035592 0.033724 0.026008 -0.023490 0.125607 -0.020587 -0.071394 0.012929 0.047673 0.003180 0.077983 -0.053745 0.016401 0.097782 -0.020292 0.000754 0.091077 0.028258 0.066507 -0.014015 0.066025 -0.055738 0.118062 0.024466 0.004692 0.059983 0.021058 0.009490 0.023957 -0.058174 0.065014 0.092097 0.007714 0.033158 0.032352 0.018179 -0.033778 0.009327 0.013350 -0.002263 0.110808 -0.059289 0.061630 -0.069723 0.067615 -0.060812 -0.020991 0.021923 0.044724 0.168233 -0.015900 -0.011754 0.201917 -0.021800 -0.009733 -0.016750 -0.018625 0.044676 0.015425 Monthly Retums on Berkshire Hathaway 0.027519 0.036233 0.022791 0.028-8-84 -0.018104 -0.030419 0.071669 -0.086194 0.079229 -0.003259 -0.029856 0.017974 -0.061350 0.059456 -0.038422 0.013300 0.047256 0.069175 -0.017967 -0.011870 -0.028251 0.035939 -0.040588 0.086610 0.020926 0.089327 0.020856 0.012120 0.032920 0.031747 0.025197 0.002664 -0.008285 -0.028199 0.045205 0.007617 0.030046 0.098748 0.002405 -0.042257 0.045185 0.004494 0.024942 -0.033356 0.026001 0.053788 0.042164 -0.017391 0.017680 -0.015817 0.047921 0.035999 -0.053593 0.044667 -0.046322 0.006560 -0.018851 -0.016638 0.024622 -0.044845 -0.004220 0.044467 -0.034392 0.015490 0.066654 -0.003758 0.073847 0.022230 0.110508 -0.029895 0.075667 0.106363 -0.128449 0.029879 -0.150624 0.079742 -0.011316 0.103815 -0.060755 -0.013402 -0.050573 0041170 -0.001155 0.105280 0.006048 0.042056 -0.000419 0.016045 0.051621 0.052304 -0.012521 0.050102 0.006913 0.003826 0.067919 0.005551 -0.057719 0.083976 0.027782 -0.013375 -0.03 2090 0.018374 0.050544 0.023668 0.049120 0.026451 0.030521 -0.028321 0.009171 0.004458 0.060393 0.030470 -0.021342 0.114040 -0.012221 0.016613 -0.080607 0.014546 0.069959 -0.021810 -0.040045 0.166718 -0.003059 -0.050561 -0.040207 0.030435 0.057558 -0.035993 0.233631 -0.016040 0.011836 0.017054 -0.042947 0.005748 -0.018043 0.043921 -0.013561 0.091499 0.053684 -0.008572 -0.001095 0.026367 -0.050704 0.010790 0.033677 0.071670 -0.007710 -0.025988 0.079414 0.041976 -0.015657 0.066263 0.019490 0.029976 -0.005061 0.061696 0.059322 0.069371 0.001831 -0.016938 -0.015529 -0.011859 -0.014110 -0.039125 0.039774 0.039678 -0.003131 -0.088123 0.067683 -0.002374 0.112916 0.003141 -0.151000 0.057123 0.034158 0.015177 0.036514 0.007782 0.144239 -0.034292 0.002351 0.015606 -0.011955 0.038684 0.039953 -0.000996 0.089215 -0.008460 0.054445 -0.009395 0.032975 0.028771 -0.040758 -0.026227 0.067831 -0.020342 0.080130 0.041798 0.037579 -0.061045 -0.005732 -0.005777 -0.155628 0.079494 0.020878 0.113618 0.117353 0.000897 -0.017627 0.056950 -0.03 7150 0.052275 0.043008 0.023403 0.062781 -0.034433 -0.011501 0.005856 0.029118 0.009518 -0.014115 0.000685 0.031647 0.065949 -0.023653 0.039946 -0.000301 0.082545 0.050136 0.027952 -0.117212 0.001699 -0.093915 0.014803 -0.044971 -0.042153 -0.051054 -0.014178 0.012356 -0.010480 0.106548 0.029878 0.001731 -0.105779 0.194342 0.031072 0.269726 -0.020440 -0.072210 0.084552 -0.056012 -0.011078 0.067451 0.018327 0.132672 0.063340 -0.066130 -0.147753 -0.004549 -0.018560 0.081928 0.080729 -0.195801 -0.006220 0.050073 -0.044291 -0.101927 -0.105614 0.065642 0.062854 -0.038090 -0.008971 -0.119537 0.022067 0.009219 0.153942 0.063915 -0.144969 0.007336 0.041740 -0.220952 0.023888 0.273107 -0.133196 0.426362 -0.022318 0.403633 0.342818 0.005450 -0.042913 0.209119 -0.084892 -0.012748 -0.337711 -0.101180 -0.085254 0.187956 -0.158218 0.022692 0.188837 0.011368 0.029308 0.055098 -0.015494 -0.019011 0.021438 0.070450 -0.001167 0.004091 0.090685 0.108138 0.010736 0.036177 0.103072 -0.054441 0.011501 0.086956 0.051570 0.033281 0.039710 -0.037260 0.024115 -0.131584 0.076008 0.035835 0.164987 -0.009427 0.126164 0.021081 -0.053711 -0.058523 0.124633 -0.042680 -0.018329 0.015959 -0.082060 0.008440 0.055271 0.034074 0.035778 -0.088664 0.025358 0.041511 -0.003950 -0.039438 0.028558 0.009356 0.034344 0.053409 -0.000816 0.083694 0.010950 0.021471 0.051042 -0.009976 0.001427 -0.013926 0.061430 0.076588 -0.035777 0.000596 -0.006096 -0.103324 -0.028686 0.041593 0.016716 0.081290 0.015519 0.045887 0.056190 0.010002 0.022411 -0.003253 0.024002 -0.005500 0.045255 0.100391 0.013679 -0.038239 -0.062112 0.023141 0.046080 -0.033592 0.036515 -0.022283 0.125185 0.011411 -0.041786 0.017753 0.027386 0.015419 0.104791 0.033646 -0.021739 -0.003205 0.039475 -0.000946 0.051752 0.044268 0.001102 0.014426 0.083936 0.010111 0.031800 -0.022358 0.129433 0.001382 -0.003012 0.007447 0.022564 -0.107317 0.002256 -0.091044 -0.021203 -0.000333 0.048278 0.097180 -0.029466 0.122164 -0.002195 0.028316 0.094812 0.073948 -0.08.8953 -0.090529 -0.120585 0.070030 -0.073568 0.039208 -0.004300 0.054786 0.268.400 -0.064551 -0.051859 -0.193382 0.017542 0.089584 -0.137905 0.113282 0.125254 0.057931 0.013625 0.077987 0.408106 0.023350 -0.045054 0.083154 0.038006 -0.038258 0.215849 -0.08 3768 0.071419 0.029700 0.039963 0.010092 0.136591 0.058120 -0.063026 0.267073 0.011288 0.067945 -0.002514 -0.108121 0.139287 -0.119339 0.094422 0.017095 -0.197062 0.072570 0.137941 0.049584 -0.102321 0.006299 0.218026 0.052687 0.121402 0.335525 -0.122592 0.074943 0.293288 0 0 0 0 0 ol 0 0 0 0 0 0 0