Using Regression analysis to calculate Beta as a measure of systematic risk in CAPM. Here is the details attached in this file

Step 3: Calculate percentage change in price:

To calculate percentage change in price of your stock, and percentage change in the index of the market (i.e. DJIA)-rule: (new price old) /old 100. Make sure to set the formula in the first cell in excel, then do copy and paste. (i.e. =(b3-b2)/b2*100), then copy that cell, and paste it all the way down.