View the step-by-step solution to:


Recall the weak form of the efficient markets hypothesis. It states that there is no useful information in past

pricesor 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) + eThe 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 one, two, three, four, and five days prior to a particular value of Rt. Note that this means you must discard the first five observations. It's not until the fifth day of your sample that you can compute a complete set of independent variables.1.What are the null and alternative hypotheses associated with this test?2.Run the regression described above. Discuss your results. Do they support the weak form of the efficient markets hypothesis? Why or whynot?3.Attach a copy of the Excel output for your regression analysis.Download and save theProblem Set 3 (EXCEL)file to your computer.Part2: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 (thelog 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

22FINA6206:FinanceSeminarsize_sq (column F).1.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.)2.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.3.Calculate VIFs for each independent variable.Is multicollinearity a problem with this regression?4.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.Submit your answers using the drop box in the Assignments area of the course.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question