Three major analysis I will look for in your project is as follows:

(1) Test if Ha: beta >1 (or beta<1). In Chapter 14, most of cases, we were testing Ha: beta>0, beta<0, or beta not equal to 0. And EXCEL stats functions can only outputs on the later cases (in another words, you need to modify a little bit to what you get from the EXCEL function). Therefore, make sure you are in the right track of testing beta > 1 (or beta<1).

(2) Test if Ha: beta for stock 1 > beta for stock 2 (or vise versa). In Chapter 10, we have a test for mu1 > mu2 (or vise versa) by using the T-test (xbar-ybar)/sqrt(var(xbar)+var(ybar)). You need to come up a similar T-test for testing betas by the T-test (b1 from stock1 - b1 from stock2)/sqrt(var(b1 for stock 1)+var(b1 for stock 2)). Think a little bit deeper and you can get all of those figures from your EXCEL printout.

(3) Residual analysis for (a) y-yhat follows a bell shaped distribution (draw its histogram as learned in Chapter 3, and the textbook's discussion was sort of wrong) (b) mean is 0 (from Chapter 9), (d) variance = constant (we did not learn it in this semester, but we can look into the residual plot as discussed in the textbook) (e) independent ( we did not learn it in this semester either, but we can look into the residual plot as discussed in the textbook also.)