Suppose in $2014,$ you invested $$12,000$ equally among the six stocks in the "Returns" file. If you did not make any further contributions, or withdrawals from this investment, the beta of the portfolio at the end of $2023$ is closest to$?$

None of the answers presented are correct

$2\mathrm{.}03$

$5\mathrm{.}01$

$3\mathrm{.}11$

This file represents the closing prices of several stocks on the last day of the year over the last ten years. The file also has the closing value of the S&P $500$ over the last ten years and the percentage rate of return for the $3-$month T$-$Bill over the same period.

You will use this file for several questions on this exam.

Returns.$xlsx{?}_{(})darr$

The file is copied as well, in case you cannot open it via the file download. If necessary, you can copy and paste this into an excel.

$\backslash$table$[[$lear$,$Nvi,,,SFT$,,OG,,$ple,Dul,,JNJ$,$S&P $500],[023,$$$,61\mathrm{.}52,,397\mathrm{.}58,$$$,141\mathrm{.}64,$$$,184\mathrm{.}16,$$$,93\mathrm{.}81,$$ $156\mathrm{.}44,4845\mathrm{.}65],[22,$$$,19\mathrm{.}53,,247\mathrm{.}81,$$$,99\mathrm{.}76,,143\mathrm{.}31,$$$,96\mathrm{.}06,$$$156\mathrm{.}15,4076\mathrm{.}60],[021,$$$,24\mathrm{.}45,,310\mathrm{.}98,$$$,135\mathrm{.}54,,172\mathrm{.}59,$$$,94\mathrm{.}80,$$$160\mathrm{.}41,4515\mathrm{.}55],[20,$$$,12\mathrm{.}96,,231\mathrm{.}96,$$$,91\mathrm{.}68,$$$,129\mathrm{.}50,$$$,81\mathrm{.}58,$$$148\mathrm{.}15,3714\mathrm{.}2],[11$s$,$$$,5\mathrm{.}89,,170\mathrm{.}23,$$$,71\mathrm{.}63,$$$,75\mathrm{.}29,$$$,81\mathrm{.}18,131\mathrm{.}62,3225\mathrm{.}52],[18,$$$,3\mathrm{.}57,$$$,104\mathrm{.}43,$$$,55\mathrm{.}76,$$$,39\mathrm{.}89,$$$,69\mathrm{.}95,3,],[17,$$$,6\mathrm{.}08,$$$,95\mathrm{.}01,$$$,58\mathrm{.}43,$$$,39\mathrm{.}53,$$$,59\mathrm{.}75,$$$115\mathrm{.}69,28],[16,$$$,2\mathrm{.}69,$$$,64\mathrm{.}65,$$$,39\mathrm{.}79,$$$,28\mathrm{.}20,$$$,57\mathrm{.}35,$$$,92\mathrm{.}41,2278\mathrm{.}87],[,$$$,0\mathrm{.}71,$$$,55\mathrm{.}09,$$$,37\mathrm{.}11,$$$,22\mathrm{.}13,$$$,52\mathrm{.}70,82\mathrm{.}88,1994\mathrm{.}99],[,$$$,0\mathrm{.}46,$$$,\mathrm{.}4,,6\mathrm{.}62,$$$,26\mathrm{.}19,$$$,58\mathrm{.}41,77\mathrm{.}18,7]]$

T$-$Bill

$5\mathrm{.}07\%$

$2\mathrm{.}02\%$

$0\mathrm{.}05\%$

$0\mathrm{.}35\%$

$2\mathrm{.}06\%$

$1\mathrm{.}94\%$

$0\mathrm{.}93\%$

$0\mathrm{.}32\%$

$0\mathrm{.}05\%$

$0\mathrm{.}03\%$

suppose in $2014,$ you inested $$12000$ among the six stocks, if you didnt make further xontributions or withdrawls from tgis investment, the beta of the portfoluo at the end of $2023$ is closest to$?$