# help me to answer the question below 9

Introduction

The Primary goal of the project is for students to gain comfort in using statistical software packages to conduct an empirical analysis of a particular firm. Specific goals are for students to (1) become familiar with sources of economic and financial information and in particular the Wharton Research Data Services (WRDS) Database, (2) practice their writing skills, (3) develop hands on, statistical estimation and modeling skills using excel (e.g., data analysis, regression analysis). The project is an individual assignment and late submissions will not be accepted. Please provide explanations for answers to all questions.

Background material: Chapter 4, 5 in McGuigan, Moyer and Harris

1. Data collection from WRDS database

2. Regression Analysis

For this question, you will need the data analysis tool pack in excel, please download it to your version of excel for your operating system before answering the questions listed below.

a.Please, separately, determine the estimated regression line for a regression with the stock return as the dependent variable and the following list as independent variables:

a.Excess market return

b.Small minus big

c.High minus low

b.Please determine the estimated regression line with the stock return as the dependent variable and the risk free rate, excess market return, small minus big, and high minus low as the independent variables in one single regression model.

c.Which regression coefficients are statistically significant? Is the overall model significant?

d.What is the adjusted R-squared for the model? How does it compare to the adjusted R-squared for each model estimated in a? Is your answer to part b different from your answers to part a? Why or Why not?

3. Forecasting

a.Using only data covering the period 1980 through 2000, please determine the estimated regression line with the stock return as the dependent variable and the risk free rate, excess market return, small minus big, and high minus low as the independent variables in one single regression model.

b.Please use the model to predict stock price return from 2001 to 2017 and compute the root mean squared error using the deviation between the actual stock price return over this period and the model-predicted stock price return over the same period.

4. Discussion

Using

interpret and discuss the strength of the relationship between stock

price returns for your firm and each of the three variables. In

particular, please consider whether or not you think that the three

variables do a good job in explaining and predicting stock returns for

your firm. Please also explain why you think the model produced all

results from questions 2 and 3 that it did