Go to http://finance.yahoo.com/, enter the symbol MS (Morgan Stanley), and retrieve stock price data at the beginning

Question:

Go to http://finance.yahoo.com/, enter the symbol MS (Morgan Stanley), and retrieve stock price data at the beginning of the last 20 quarters. Then go to http://research.stlouisfed.org/fred2/ and retrieve interest rate data at the beginning of the last 20 quarters for the three-month Treasury bill. Record the data on an Excel spreadsheet. Derive the quarterly return of Morgan Stanley. Derive the quarterly change in the interest rate. Apply regression analysis in which the quarterly return of Morgan Stanley is the dependent variable and the quarterly change in the interest rate is the independent variable (see Appendix B for more information about using regression analysis). Is there a positive or negative relationship between the interest rate movement and the stock return of Morgan Stanley? Is the relationship significant? Offer an explanation for this relationship.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: