1. What is the alpha of Security A?

2. What is the standard deviation of the residuals for Security A?

Pls show solution and regression in excel thank you!

Security \begin{tabular}{crrrr} \cline { 2 - 4 } Month & A & B & C & S\&P \\ \hline 1 & 12.05 & 25.20 & 31.67 & 12.28 \\ 2 & 15.27 & 2.86 & 15.82 & 5.99 \\ 3 & -4.12 & 5.45 & 10.58 & 2.41 \\ 4 & 1.57 & 4.56 & -14.43 & 4.48 \\ 5 & 3.16 & 3.72 & 31.98 & 4.41 \\ 6 & -2.79 & -0.72 & 4.43 \\ 7 & -8.97 & 50.79 & -19.64 & -6.77 \\ 8 & -1.18 & -10.00 & -2.11 \\ 9 & 1.07 & -11.51 & 3.46 \\ 10 & 12.75 & 1.52 & 5.63 & 6.16 \\ 11 & 7.48 & -4.67 & 2.47 \\ 12 & -0.94 & 3.97 & -1.15 \\ \hline \end{tabular}