Chapter $8$ Estimating Alpha and Beta.xIsx

Use the above excel file, compute returns of AAPL, WMT and SPY$.$ Return is defined as $"[$price this month divided by price last month$]-1".$

SPY is the market return.

Then use regression analysis to compute the alpha and beta of AAPL and WMT$.$

Upload your excel file back. highlight the alpha and beta and their t$-$values.