Regression

Regression
Part 1: Recall the weak form of the efficient markets hypothesis. It states that there is no useful information in past prices or returns that would allow us to forecast future returns. You will test this hypothesis with a time series of daily returns for Apple.

Suppose you could forecast future stock prices by examining patterns in past prices or returns. This would be a great way to make money, and there is a field of study, technical analysis, where practitioners try to identify recurring patterns in stock prices and returns. However, there is a considerable body of evidence suggesting there is no useful memory in past prices. Let’s do a quick experiment. The spreadsheet attached to this assignment contains two years of daily stock returns for Apple. The experiment is simple. Is today’s return explained by the returns generated over each of the previous five trading days?

The regression approach can be modeled like this:

Rt = a + b1(Rt-1) + b2(Rt-2) + b3(Rt-3) + b4(Rt-4) + b5(Rt-5) + e

The spreadsheet contains 502 daily returns. These are your Rt, or dependent variables. You will need to create five additional columns with the lagged returns. The lagged returns are just those occurring 1, 2, 3, 4, and 5 days prior to a particular value of Rt. Note that this means you must discard the first 5 observations. It’s not until the 5th day of your sample that you can compute a complete set of independent variables.

What are the null and alternative hypotheses associated with this test?
Run the regression described above. Discuss your results. Do they support the weak form of the efficient markets hypothesis? Why or why not?
Attach a copy of the Excel output for your regression analysis.
Click the hyperlink below to download the file to your computer.

Problem Set 3

Instructions

To download the file to your computer:

Right-click on the link.
Choose Save Target As (for IE) or Save Link As (for Firefox) from the options and the Save As screen appears. Specify the folder in which you would like to save your file.
Click Save.
To view the file from its current location, simply click the hyperlink above.

Part 2: Recall the analysis of our sample of small cap growth oriented mutual funds in Lesson 2. The data behind this analysis is linked to a slide within the lesson. In the analysis presented in Lesson 2, we ran two regressions. The first employed logtna (the log of total net assets under management, column E) and a number of control variables to explain returns on our sample of funds. The second regression added [logtna – avg.logtna]2, denoted on the spreadsheet as size_sq (column F).

Rerun the first regression using the raw (unlogged) values of total net assets (column D on the spreadsheet instead of column E). Use the control variables in columns G through J as well. (Note: You may want to rearrange the columns before running the new regression.)
Before rerunning the second regression, recreate the values for the quadratic term, size_sq (column F) using raw (unlogged) values of total net assets. In other words, create a variable: [tna – avg.tna]2.Now rerun the second regression.
Calculate VIFs for each independent variable. Is multicollinearity a problem with this regression?
Discuss your results for both of the new regressions focusing on the expected signs and significance of the independent variables. Also discuss any differences between these results and the original regressions that used the logged values of total net assets.

Order from us and get better grades. We are the service you have been looking for.