please show how to do this in excel, thank you!

7-13 Consider the data contained in the table below, which lists 30 mont excess returns to two different actively managed stock portfolios (A and B) and three different common risk factors (1, 2, and 3). Period 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Portfolio A 1.11% 7.60 5.06 1.15 -2.07 4.17 -0,72 -15.43 6.05 7.75 7.81 9.52 5.35 -3.19 5.31 2.43 -2.90 6.48 -3.40 -1.18 -1.55 6.10 1.96 7.27 4.81 1.05 Portfolio B 0.00% 6.55 5.95 0.38 -1.56 2.44 -2.39 -15.41 4.12 6.69 5.60 4.93 2.79 -0.62 2.64 7.35 0.10 3.57 -0.59 -3.98 0.18 5.29 2.34 7.08 -2.70 -2.12 Factor 1 0.02% 6.89 4.82 0.58 -2.86 2.88 -2.66 -16.15 6.00 7.08 5.76 5.93 3.56 -4.22 3.34 4.39 -2.43 4.77 -3.43 -1.27 -2.76 5.83 3.18 7.73 -4.47 2.48 Factor 2 -1.01% 0.19 -1.53 0.46 -3.58 -3.45 -4.45 -5.84 0.03 -3.31 1.26 -0.36 1.20 -5.59 -3.75 2.87 3.49 3.37 2.00 -1.19 3.33 -6.59 7.77 6.88 4.03 21.52 Factor 3 -1.75% -1.19 1.97 0.26 4,30 -1.50 -1.83 5.62 -3.74 -2.92 -3.70 -4.89 -6.06 1.68 -3.04 2.83 3.03 -4.40 0.80 -1.19 -3.17 -3.23 -8.12 -9.15 -0.26 -11.96

\begin{tabular}{|c|c|c|c|c|c|} \hline Froliad & Rortalio A & & tarfer 1 & reckor) & Iactiser \\ \hline 1 & & oos & 6026 & -8.615 & 4.196 \\ \hlinez & & 6.33 & sin & an & -1.19 \\ \hline 3 & sin & sin & Ant & itss & int \\ \hline 4 & 1.13 & osn & ose & & \\ \hline 3 & & & -284 & 3x & 60 \\ \hline & 4.1) & 24 & 2m & 3.45 & 1.50 \\ \hline 7 & 0x & 9Ns & 2k & 4.41 & \\ \hline & 15(4) & 15.4! & -46.11 & & 10 \\ \hline? & on & An & 600 & & 174 \\ \hline 10 & & 6.6 & & & 26 \\ \hline 11 & 721 & 360 & 3N & 120 & ore \\ \hline u & & & 203 & x & + \\ \hline 13 & & 2n & & 120 & 606 \\ \hline 14 & -315 & 98 & 4x & -350 & ita \\ \hline is & S3: & 2.64 & 34 & 3n & 394 \\ \hline 16 & & ln & & 24 & 20 \\ \hline ir & nn & 0.10 & & 3 & ins \\ \hline is & 16 & 39 & 4n & 3x & 440 \\ \hline 17 & & as & -3.40 & 200 & 300 \\ \hlinem & -1.16 & & & & -1.18 \\ \hline 21 & -135 & sin & 70 & in & [3.37 \\ \hline 22 & 6.14 & 120 & ser & 4s & 1n \\ \hlinen & in & 214 & 31 & 2n & tin \\ \hline 24 & m & 704 & m & ens & 0.11 \\ \hlinen & 14 & 2n & (4) & & 928 \\ \hline 26 & 105 & 212 & 245 & 2153 & -1148 \\ \hline \end{tabular} Cimintion betares is 3 \begin{tabular}{|c|c|c|c|c|c|} \hline Period & Portfolio A & Portfolio B & Factor 1 & Factor 2 & Factor 3 \\ \hline 1 & 1.11% & 0.00% & 0.02% & 1.01% & 1.75% \\ \hline 2 & 7.60 & 6.55 & 6.89 & 0.19 & -1.19 \\ \hline 3 & 5.06 & 5.95 & 4.82 & -1.53 & 1.97 \\ \hline 4 & 1.15 & 0.38 & 0.58 & 0.46 & 0.26 \\ \hline 5 & -2.07 & -1.56 & -2.86 & -3.58 & 4.30 \\ \hline 6 & 4.17 & 2.44 & 2.88 & -3.45 & -1.50 \\ \hline 7 & -0.72 & -2.39 & -2.66 & -4.45 & -1.83 \\ \hline 8 & -15.43 & -15.41 & -16.15 & -5.84 & 5.62 \\ \hline 9 & 6.05 & 4.12 & 6.00 & 0.03 & -3.74 \\ \hline 10 & 7.75 & 6.69 & 7.08 & -3.31 & -2.92 \\ \hline 11 & 7.81 & 5.60 & 5.76 & 1.26 & -3.70 \\ \hline 12 & 9.52 & 4.93 & 5.93 & -0.36 & -4.89 \\ \hline 13 & 5.35 & 2.79 & 3.56 & 1.20 & -6.06 \\ \hline 14 & -3.19 & -0.62 & -4.22 & -5.59 & 1.68 \\ \hline 15 & 5.31 & 2.64 & 3.34 & -3.75 & -3.04 \\ \hline 16 & 2.43 & 7.35 & 4.39 & 2.87 & 2.83 \\ \hline 17 & -2.90 & 0.10 & -2.43 & 3.49 & 3.03 \\ \hline 18 & 6.48 & 3.57 & 4.77 & 3.37 & -4.40 \\ \hline 19 & -3.40 & -0.59 & -3.43 & 2.00 & 0.80 \\ \hline 20 & -1.18 & -3.98 & -1.27 & -1.19 & -1.19 \\ \hline 21 & -1.55 & 0.18 & -2.76 & 3.33 & -3.17 \\ \hline 22 & 6.10 & 5.29 & 5.83 & -6.59 & -3.23 \\ \hline 23 & 1.96 & 2.34 & 3.18 & 7.77 & -8.12 \\ \hline 24 & 7.27 & 7.08 & 7.73 & 6.88 & -9.15 \\ \hline 25 & -4.81 & -2.70 & -4.47 & 4.03 & -0.26 \\ \hline 26 & 1.05 & -2.12 & 2.48 & 21.52 & -11.96 \\ \hline 27 & 9.07 & 5.31 & 5.07 & -16.71 & 7.86 \\ \hline 28 & -4.34 & -2.86 & -6.32 & -7.48 & 8.58 \\ \hline 29 & -3.35 & -0.72 & -4.35 & -5.92 & 5.45 \\ \hline 30 & 3.88 & 1.86 & 4.58 & 13.29 & -8.80 \\ \hline \end{tabular}