Using the Regression tool in the Excel Data Analysis pack, run a CAPM model regression of the retail portfolio. CAPM requires just a single factor, the excess return on the market, as the independent variable.

What is the beta of the retail portfolio?

\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G \\ \hline 1 & & Mkt-RF & SMB & HML & RF & & Rtail \\ \hline 2 & 201807 & 0.0319 & -0.0223 & 0.0047 & 0.0016 & & 0.0356 \\ \hline 3 & 201808 & 0.0344 & 0.0113 & -0.0398 & 0.0016 & & 0.0916 \\ \hline 4 & 201809 & 0.0006 & -0.0228 & -0.0169 & 0.0015 & & 0.0061 \\ \hline 5 & 201810 & -0.0768 & -0.0477 & 0.0344 & 0.0019 & & -0.1025 \\ \hline 6 & 201811 & 0.0169 & -0.0068 & 0.0028 & 0.0018 & & 0.0159 \\ \hline 7 & 201812 & -0.0957 & -0.0237 & -0.0185 & 0.002 & & -0.0919 \\ \hline 8 & 201901 & 0.084 & 0.0289 & -0.0046 & 0.0021 & & 0.0884 \\ \hline 9 & 201902 & 0.034 & 0.0205 & -0.0267 & 0.0018 & & -0.0008 \\ \hline 10 & 201903 & 0.011 & -0.0303 & -0.041 & 0.0019 & & 0.0386 \\ \hline 11 & 201904 & 0.0397 & -0.0174 & 0.0214 & 0.0021 & & 0.0492 \\ \hline 12 & 201905 & -0.0694 & -0.0131 & -0.0235 & 0.0021 & & -0.0702 \\ \hline 13 & 201906 & 0.0693 & 0.0027 & -0.0072 & 0.0018 & & 0.0717 \\ \hline 14 & 201907 & 0.0119 & -0.0193 & 0.0047 & 0.0019 & & 0.0047 \\ \hline 15 & 201908 & -0.0258 & -0.0237 & -0.0477 & 0.0016 & & -0.0015 \\ \hline 16 & 201909 & 0.0143 & -0.0097 & 0.0674 & 0.0018 & & 0.0078 \\ \hline 17 & 201910 & 0.0206 & 0.0029 & -0.0192 & 0.0016 & & 0.0161 \\ \hline 18 & 201911 & 0.0387 & 0.0079 & -0.02 & 0.0012 & & 0.0207 \\ \hline 19 & 201912 & 0.0277 & 0.0073 & 0.0177 & 0.0014 & & 0.0127 \\ \hline 20 & 202001 & -0.0011 & -0.0311 & -0.0623 & 0.0013 & & 0.0113 \\ \hline 21 & 202002 & -0.0813 & 0.0107 & -0.0379 & 0.0012 & & -0.061 \\ \hline 22 & 202003 & -0.1339 & -0.0486 & -0.1395 & 0.0013 & & -0.0437 \\ \hline 23 & 202004 & 0.1365 & 0.0247 & -0.0126 & 0 & & 0.1864 \\ \hline 24 & 202005 & 0.0558 & 0.0247 & -0.0489 & 0.0001 & & 0.0425 \\ \hline 25 & 202006 & 0.0246 & 0.027 & -0.0217 & 0.0001 & & 0.0538 \\ \hline 26 & 202007 & 0.0577 & -0.0232 & -0.0137 & 0.0001 & & 0.1047 \\ \hline 27 & 202008 & 0.0763 & -0.0022 & -0.0296 & 0.0001 & & 0.0814 \\ \hline 28 & 202009 & -0.0363 & 0.0004 & -0.0268 & 0.0001 & & -0.0456 \\ \hline 29 & 202010 & -0.021 & 0.0437 & 0.0422 & 0.0001 & & -0.0292 \\ \hline 30 & 202011 & 0.1247 & 0.0581 & 0.0213 & 0.0001 & & 0.0758 \\ \hline 31 & 202012 & 0.0463 & 0.0489 & -0.015 & 0.0001 & & 0.0108 \\ \hline 32 & 202101 & -0.0003 & 0.0734 & 0.0297 & 0.0001 & & 0.008 \\ \hline 33 & 202102 & 0.0278 & 0.0206 & 0.0717 & 0 & & -0.0317 \\ \hline 34 & 202103 & 0.0308 & -0.0237 & 0.0739 & 0 & & 0.0536 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G \\ \hline 5 & 202104 & 0.0493 & -0.032 & -0.0095 & 0 & & 0.0746 \\ \hline 6 & 202105 & 0.0029 & -0.0025 & 0.0709 & 0 & & -0.0282 \\ \hline 37 & 202106 & 0.0275 & 0.017 & -0.0783 & 0 & & 0.0373 \\ \hline 38 & 202107 & 0.0127 & -0.0399 & -0.0178 & 0 & & -0.008 \\ \hline 39 & 202108 & 0.0291 & -0.0043 & -0.0015 & 0 & & 0.0294 \\ \hline 40 & 202109 & -0.0437 & 0.0072 & 0.0509 & 0 & & -0.0441 \\ \hline 41 & 202110 & 0.0665 & -0.0234 & -0.0049 & 0 & & 0.0551 \\ \hline 42 & 202111 & -0.0155 & -0.0132 & -0.0045 & 0 & & 0.0204 \\ \hline 43 & 202112 & 0.031 & -0.0165 & 0.0326 & 0.0001 & & -0.0039 \\ \hline 44 & 202201 & -0.0625 & -0.0593 & 0.1275 & 0 & & -0.0924 \\ \hline 45 & 202202 & -0.0229 & 0.0221 & 0.0308 & 0 & & -0.0179 \\ \hline 46 & 202203 & 0.0305 & -0.016 & -0.018 & 0.0001 & & 0.0335 \\ \hline 47 & 202204 & -0.0946 & -0.014 & 0.0617 & 0.0001 & & -0.1141 \\ \hline 48 & 202205 & -0.0034 & -0.0183 & 0.0839 & 0.0003 & & -0.0564 \\ \hline 49 & 202206 & -0.0843 & 0.021 & -0.0598 & 0.0006 & & -0.085 \\ \hline 50 & 202207 & 0.0957 & 0.028 & -0.041 & 0.0008 & & 0.1627 \\ \hline 51 & 202208 & -0.0377 & 0.0137 & 0.003 & 0.0019 & & -0.0345 \\ \hline 52 & 202209 & -0.0935 & -0.0079 & 0.0006 & 0.0019 & & -0.0766 \\ \hline 53 & 202210 & 0.0783 & 0.0009 & 0.0805 & 0.0023 & & 0.0206 \\ \hline 54 & 202211 & 0.046 & -0.034 & 0.0138 & 0.0029 & & 0.0302 \\ \hline 55 & 202212 & -0.0641 & -0.0068 & 0.0132 & 0.0033 & & -0.0897 \\ \hline 56 & 202301 & 0.0665 & 0.0502 & -0.0405 & 0.0035 & & 0.1094 \\ \hline 57 & 202302 & -0.0258 & 0.0121 & -0.0078 & 0.0034 & & -0.0553 \\ \hline 58 & 202303 & 0.0251 & -0.0559 & -0.0901 & 0.0036 & & 0.0356 \\ \hline 59 & 202304 & 0.0061 & -0.0334 & -0.0003 & 0.0035 & & 0.0169 \\ \hline 60 & 202305 & 0.0035 & 0.0153 & -0.078 & 0.0036 & & 0.0194 \\ \hline 61 & 202306 & 0.0646 & 0.0155 & -0.002 & 0.004 & & 0.0803 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G \\ \hline 1 & & Mkt-RF & SMB & HML & RF & & Rtail \\ \hline 2 & 201807 & 0.0319 & -0.0223 & 0.0047 & 0.0016 & & 0.0356 \\ \hline 3 & 201808 & 0.0344 & 0.0113 & -0.0398 & 0.0016 & & 0.0916 \\ \hline 4 & 201809 & 0.0006 & -0.0228 & -0.0169 & 0.0015 & & 0.0061 \\ \hline 5 & 201810 & -0.0768 & -0.0477 & 0.0344 & 0.0019 & & -0.1025 \\ \hline 6 & 201811 & 0.0169 & -0.0068 & 0.0028 & 0.0018 & & 0.0159 \\ \hline 7 & 201812 & -0.0957 & -0.0237 & -0.0185 & 0.002 & & -0.0919 \\ \hline 8 & 201901 & 0.084 & 0.0289 & -0.0046 & 0.0021 & & 0.0884 \\ \hline 9 & 201902 & 0.034 & 0.0205 & -0.0267 & 0.0018 & & -0.0008 \\ \hline 10 & 201903 & 0.011 & -0.0303 & -0.041 & 0.0019 & & 0.0386 \\ \hline 11 & 201904 & 0.0397 & -0.0174 & 0.0214 & 0.0021 & & 0.0492 \\ \hline 12 & 201905 & -0.0694 & -0.0131 & -0.0235 & 0.0021 & & -0.0702 \\ \hline 13 & 201906 & 0.0693 & 0.0027 & -0.0072 & 0.0018 & & 0.0717 \\ \hline 14 & 201907 & 0.0119 & -0.0193 & 0.0047 & 0.0019 & & 0.0047 \\ \hline 15 & 201908 & -0.0258 & -0.0237 & -0.0477 & 0.0016 & & -0.0015 \\ \hline 16 & 201909 & 0.0143 & -0.0097 & 0.0674 & 0.0018 & & 0.0078 \\ \hline 17 & 201910 & 0.0206 & 0.0029 & -0.0192 & 0.0016 & & 0.0161 \\ \hline 18 & 201911 & 0.0387 & 0.0079 & -0.02 & 0.0012 & & 0.0207 \\ \hline 19 & 201912 & 0.0277 & 0.0073 & 0.0177 & 0.0014 & & 0.0127 \\ \hline 20 & 202001 & -0.0011 & -0.0311 & -0.0623 & 0.0013 & & 0.0113 \\ \hline 21 & 202002 & -0.0813 & 0.0107 & -0.0379 & 0.0012 & & -0.061 \\ \hline 22 & 202003 & -0.1339 & -0.0486 & -0.1395 & 0.0013 & & -0.0437 \\ \hline 23 & 202004 & 0.1365 & 0.0247 & -0.0126 & 0 & & 0.1864 \\ \hline 24 & 202005 & 0.0558 & 0.0247 & -0.0489 & 0.0001 & & 0.0425 \\ \hline 25 & 202006 & 0.0246 & 0.027 & -0.0217 & 0.0001 & & 0.0538 \\ \hline 26 & 202007 & 0.0577 & -0.0232 & -0.0137 & 0.0001 & & 0.1047 \\ \hline 27 & 202008 & 0.0763 & -0.0022 & -0.0296 & 0.0001 & & 0.0814 \\ \hline 28 & 202009 & -0.0363 & 0.0004 & -0.0268 & 0.0001 & & -0.0456 \\ \hline 29 & 202010 & -0.021 & 0.0437 & 0.0422 & 0.0001 & & -0.0292 \\ \hline 30 & 202011 & 0.1247 & 0.0581 & 0.0213 & 0.0001 & & 0.0758 \\ \hline 31 & 202012 & 0.0463 & 0.0489 & -0.015 & 0.0001 & & 0.0108 \\ \hline 32 & 202101 & -0.0003 & 0.0734 & 0.0297 & 0.0001 & & 0.008 \\ \hline 33 & 202102 & 0.0278 & 0.0206 & 0.0717 & 0 & & -0.0317 \\ \hline 34 & 202103 & 0.0308 & -0.0237 & 0.0739 & 0 & & 0.0536 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G \\ \hline 5 & 202104 & 0.0493 & -0.032 & -0.0095 & 0 & & 0.0746 \\ \hline 6 & 202105 & 0.0029 & -0.0025 & 0.0709 & 0 & & -0.0282 \\ \hline 37 & 202106 & 0.0275 & 0.017 & -0.0783 & 0 & & 0.0373 \\ \hline 38 & 202107 & 0.0127 & -0.0399 & -0.0178 & 0 & & -0.008 \\ \hline 39 & 202108 & 0.0291 & -0.0043 & -0.0015 & 0 & & 0.0294 \\ \hline 40 & 202109 & -0.0437 & 0.0072 & 0.0509 & 0 & & -0.0441 \\ \hline 41 & 202110 & 0.0665 & -0.0234 & -0.0049 & 0 & & 0.0551 \\ \hline 42 & 202111 & -0.0155 & -0.0132 & -0.0045 & 0 & & 0.0204 \\ \hline 43 & 202112 & 0.031 & -0.0165 & 0.0326 & 0.0001 & & -0.0039 \\ \hline 44 & 202201 & -0.0625 & -0.0593 & 0.1275 & 0 & & -0.0924 \\ \hline 45 & 202202 & -0.0229 & 0.0221 & 0.0308 & 0 & & -0.0179 \\ \hline 46 & 202203 & 0.0305 & -0.016 & -0.018 & 0.0001 & & 0.0335 \\ \hline 47 & 202204 & -0.0946 & -0.014 & 0.0617 & 0.0001 & & -0.1141 \\ \hline 48 & 202205 & -0.0034 & -0.0183 & 0.0839 & 0.0003 & & -0.0564 \\ \hline 49 & 202206 & -0.0843 & 0.021 & -0.0598 & 0.0006 & & -0.085 \\ \hline 50 & 202207 & 0.0957 & 0.028 & -0.041 & 0.0008 & & 0.1627 \\ \hline 51 & 202208 & -0.0377 & 0.0137 & 0.003 & 0.0019 & & -0.0345 \\ \hline 52 & 202209 & -0.0935 & -0.0079 & 0.0006 & 0.0019 & & -0.0766 \\ \hline 53 & 202210 & 0.0783 & 0.0009 & 0.0805 & 0.0023 & & 0.0206 \\ \hline 54 & 202211 & 0.046 & -0.034 & 0.0138 & 0.0029 & & 0.0302 \\ \hline 55 & 202212 & -0.0641 & -0.0068 & 0.0132 & 0.0033 & & -0.0897 \\ \hline 56 & 202301 & 0.0665 & 0.0502 & -0.0405 & 0.0035 & & 0.1094 \\ \hline 57 & 202302 & -0.0258 & 0.0121 & -0.0078 & 0.0034 & & -0.0553 \\ \hline 58 & 202303 & 0.0251 & -0.0559 & -0.0901 & 0.0036 & & 0.0356 \\ \hline 59 & 202304 & 0.0061 & -0.0334 & -0.0003 & 0.0035 & & 0.0169 \\ \hline 60 & 202305 & 0.0035 & 0.0153 & -0.078 & 0.0036 & & 0.0194 \\ \hline 61 & 202306 & 0.0646 & 0.0155 & -0.002 & 0.004 & & 0.0803 \\ \hline \end{tabular}