Hi$!$ This is a multi$-$part question, and I don't know much about how to manipulate Excel as I need to$.$ I have included the question in its entirety and a screenshot showing all columns but just some rows of the data. Thanks!

$1$ Excel: CAPM and Fama$-$French estimation $[6$ points$]$ Download the file PS$3\_$data.xlsx$,$ that contains return from $1986$ to $2014$ of the market portfolio, the FamaFrench factors SMB and HML$,$ and a portfolio of stocks of firms producing Non$-$Durable goods $($food$,$ tobacco, etc$).$ Data are monthly, and in level $($i$.$e$.,$ not in $\backslash \%).$ Upload your spreadsheet on the course website, and provide the answers to the following questions on paper. $1.$ Estimate the single$-$factor model for Non$-$Durable goods producers. $($a$)$ Provide the following results: alpha, beta. $($HINT: recall that, before running the regression, you should compute the return on the market portfolio in excess of the risk$-$free rate, and the return on the Non$-$Durable goods producers portfolio in excess of the risk$-$free rate$)[1\mathrm{.}5$ points$]($b$)$ Is the estimate for alpha statistically different from zero $($use a $\backslash (95\backslash \%\backslash )$ confidence level$)?$ Explain briefly. $[0\mathrm{.}5$ points$]($c$)$ The alpha is the return of non$-$durable portfolio in excess of the compensation for risk $($i$.$e$.,$ the compensation measured by beta$*[$market risk premium$]).$ Because we are working with monthly data, the alpha is a monthly return. Compound the monthly alpha obtained in the regression to compute the annual effective annual alpha, that is$,$ the effective annual return in excess of the compensation for risk. $($HINT: just compound the alpha using the appropriate formula that accounts for compounding$)[0\mathrm{.}5$ points$]2.$ Now estimate the Fama$-$French $3-$factor model for Non$-$Durable goods producers. $($a$)$ Provide the following results: alpha, beta for each of the three factor. $[\backslash (\backslash$mathbf$\{1.5\}\backslash )$ points$]($b$)$ Is the estimate for alpha statistically different from zero $($use a $\backslash (95\backslash \%\backslash )$ confidence level$)?$ Explain briefly. $[0\mathrm{.}5$ points$]($c$)$ Compound the monthly alpha obtained in the regression to compute the annual effective annual alpha, that is$,$ the effective annual return in excess of the compensation for risk. $[$HINT: the alpha estimated using Fama$-$French should be smaller than the alpha estimated using the single$-$factor model$][0\mathrm{.}5$ points$]3.$ Your results for the market factor beta $($for both the CAPM and the $3-$factor model$)$ should be a$)$ Are Non$-$Durable goods producers more or less volatile than the market? $[0\mathrm{.}5$ points$]($b$)$ Why are Non$-$Durable goods producers more$/$less volatile than the market? $[$Difficult$]$ Your answer should be based on economic considerations about Non$-$Durable goods producers $-$ try to write an answer that does not mention CAPM, Fama$-$French, or factor models and that can be understood even by somebody who is not taking this finance class. $[0\mathrm{.}5$ points$]$