1). Consider the stock marked as stock number 5. Using the regression function in Excel to calculate the alpha of this stock. (answer in PERCENT with at least three (3) decimal places, e.g. "0.145" means 0.145% monthly alpha; Note that if your return data is in decimals then the regression will tell you the alpha in decimals, not in percent, in which case you will need to multiply your answer by 100.)

2). What is the beta of an equal-weighted portfolio of all 5 stocks (i.e., the same 1/5 fraction of dollars invested in every stock--and rebalanced every period so that the portfolio weights remains the same)? (answer with at least three decimal places, e.g. 1.361)