REGRESSION AND COEFFICIENT

QUESTION

This is a theoretical and applied econometrics project to help you familiarize yourself with the recent materials covered in class and an econometric software of your choice.

You must answer all questions. You should prepare a word-processed report as your answer. Give full details of results obtained and any inferences which have been drawn from them. Computer codes used could also be included as part of your results or in an appendix to the assignment (depending on the relevance and length of the programs). You must also include short excerpts of the computer output (or graphs) to justify your answers. The final report should not exceed 10 pages including printouts of estimation outputs, printouts of code and mathematical proofs. It should be submitted in PDF format

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

References

Campbell, J. Y. (2003). Consumption-based asset pricing. In Constantinides, G., Harris, M., and Stulz, R. M., editors, Handbook of the Economics of Finance, volume 1 of Handbook of the Economics of Finance, chapter 13, pages 803{887. Elsevier.

Yogo, M. (2004). Estimating the elasticity of intertemporal substitution when instruments are weak. The Review of Economics and Statistics, 86(3):797{810.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The elasticity of intertemporal substitution (EIS) in consumption is a parameter of prime importance in macroeconomics and _nance. In macroeconomics, it relates current and ex- pected future real interest rates to the current level of aggregate demand in the intertemporal IS equation. In _nance, in the consumption and portfolio choice problem of an in_nite-lived investor, the EIS is the key parameter in the optimal consumption rule. The EIS, denoted by  , is estimated from the following model

_ct+1 = _i +  ri;t+1 + ui;t+1 (1)

where _ct+1 is the consumption growth at time t + 1, ri;t+1 is the real return on asset i at t + 1, and _i is a constant. The error ui;t+1 is correlated with the regressor, the real return on asset. The interest is in ascertaining whether   < 1. When the EIS is less (greater) than 1, the investors optimal consumption-wealth ratio is increasing (decreasing) in expected returns. Further information can be found in Yogo (2004) and Campbell (2003). Estimate the EIS in equation (1) using two asset returns separately: the real interest rate (rf ) and the real aggregate stock return (re) for France and then for the UK (4 equations to estimate). The real stock return is constructed as log of the gross stock return deated by the consumer price index. The real interest rate is constructed in the same way, using an available proxy for the short-term interest rate. Real consumption growth is the _rst di_erence in log real consumption per capita. The following variables could also be used as potential instruments: nominal interest rate, ination, consumption growth, and log dividend-price ratio. Be careful in indexing time t of your instruments appropriately (ie: do you need to lag these instrument?). The data is available in \Data Assignment2.xls”. When answering your questions, state any assumptions you need to make and show all your workings. You are welcome to use di_erent software packages (e.g. Matlab, R, Gretl, Stata, etc.) for di_erent parts of the question if it is helpful to you.

 

(a) Estimate the model by OLS and report your results.

(b) Do you need instrumental variables? Select a set of instruments and justify your choice.

(c) Re-estimate the equation by generalized instrumental variables, treating the two asset returns as endogenous:

i. Are the estimates signi_cantly di_erent from the OLS ones? Perform a Hausman test for the hypothesis that the two asset returns can be treated as exogenous.

ii. Verify that the IV estimates may also be obtained by two-stages OLS regression. Are the reported standard errors the same? Explain why or why not.

(d) Test for the overidentifying restrictions for the IV estimation you performed. How do you interpret the results of this test?

(e) Are your instruments any good? Could you use other instruments or more instruments?

Perform any relevant test and re-estimate the equation if necessary.

(f) Test for heteroskedasticity and serial correlation. If your tests reject the null(s), correct for the problem(s) by computing the appropriate variance-covariance and the appropri- ate estimator. Justify the estimator your are using in comparison to the other estimator you used above. [Hint: the best answers to this question will use an iterative procedure.]

SOLUTION

ASSIGNMENT

 

PART A- OLS REGRESSION

COUNTRY EXPLANATORY VARIABLE EIS R SQUARE S.E
FRANCE REAL INTEREST RATE -.139 .008 .014
  REAL AGGREGATE STOCK RETURN -.014 .013 .014
UK REAL INETERST RATE .189 .050 .012
  REAL AGGREGATE STOCK RETURN .015 .015 .012

 

 

PART B

Yes we do need the use of instrumental variables because the error term of the regression equation is correlated with the explanatory variables, which in this case is the real rate of return and the real aggregate stock return. This violates the OLS assumption that the covariance between the explanatory variables and the error term is equal to zero. Hence the OLS estimates are not consistent.

We can use nominal interest rate, inflation, consumption growth and log dividend price ratio as the IVs as these are correlated with the asset returns and uncorrelated with the error term as well as exogenous.

 

PART C- GENERALIZED INSTRUMENTAL VARIABLE METHOD

 

FRANCE

2SLS

 

!ST STAGE- regressing the real interest rate on all the instrumental variables

Model Summaryb

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

Change Statistics

R Square Change

F Change

df1

df2

Sig. F Change

1

1.000a

1.000

1.000

4.90E-9

1.000

99039575971734.700

4

110

.000

a. Predictors: (Constant), dc, inf, rf, dp
 
b. Dependent Variable: rrf

 

 

Coefficientsa

Model

Unstandardized Coefficients

Standardized Coefficients

t

Sig.

Collinearity Statistics

B

Std. Error

Beta

Tolerance

VIF

1 (Constant)

6.657E-009

.000

 

1.104

.272

   
dp

1.627E-009

.000

.000

1.044

.299

.302

3.315

rf

1.000

.000

.812

13368662.890

.000

.684

1.462

inf

-1.000

.000

-1.173

-12627339.039

.000

.293

3.418

dc

-2.163E-008

.000

.000

-.668

.506

.984

1.016

  1. Dependent Variable: rrf

 

 

Regression of real aggregate stock return on all the instrumental variables

 

Model Summaryb

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

Change Statistics

R Square Change

F Change

df1

df2

Sig. F Change

1

.265a

.070

.036

.11100527101

.070

2.071

4

110

.089

a. Predictors: (Constant), dc, inf, rf, dp
b. Dependent Variable: rr
 

 

Coefficientsa

Model

Unstandardized Coefficients

Standardized Coefficients

t

Sig.

Collinearity Statistics

B

Std. Error

Beta

Tolerance

VIF

1 (Constant)

-.270

.137

 

-1.979

.050

   
dp

-.082

.035

-.388

-2.319

.022

.302

3.315

rf

.721

1.695

.047

.425

.671

.684

1.462

inf

1.978

1.794

.187

1.102

.273

.293

3.418

dc

-.716

.734

-.090

-.975

.332

.984

1.016

a. Dependent Variable: rr

 

Final step- to regress the dependent variable which is the growth in consumption on the two predicted variables.

 

 

Model Summaryb

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

Change Statistics

R Square Change

F Change

df1

df2

Sig. F Change

1

.432a

.187

.172

.01298548449

.187

12.855

2

112

.000

a. Predictors: (Constant), Unstandardized Predicted Value, Unstandardized Predicted Value
  1. Dependent Variable: dc

 

 

Coefficientsa

Model

Unstandardized Coefficients

Standardized Coefficients

t

Sig.

Collinearity Statistics

B

Std. Error

Beta

Tolerance

VIF

1 (Constant)

.007

.002

 

4.751

.000

   
Unstandardized Predicted Value

.112

.142

.072

.789

.432

.874

1.144

Unstandardized Predicted Value

-.216

.043

-.452

-4.962

.000

.874

1.144

a. Dependent Variable: dc

 

U>uu

 

u

 

 

 

 

 

 

 

 

 

2SLS FOR U.K

 

1ST step is to regress  rrf to all the instrumental variables

Model Summaryb

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

Change Statistics

R Square Change

F Change

df1

df2

Sig. F Change

1

1.000a

1.000

1.000

5.26E-9

1.000

230953827044612.800

4

112

.000

a. Predictors: (Constant), dc, dp, rf, inf
b. Dependent Variable: rrf

 

 

Coefficientsa

Model

Unstandardized Coefficients

Standardized Coefficients

t

Sig.

Collinearity Statistics

B

Std. Error

Beta

Tolerance

VIF

1 (Constant)

-8.904E-009

.000

 

-1.142

.256

   
dp

-2.377E-009

.000

.000

-1.069

.287

.538

1.859

rf

1.000

.000

.463

11544525.908

.000

.674

1.485

inf

-1.000

.000

-1.094

-26227591.512

.000

.622

1.607

dc

-1.160E-008

.000

.000

-.275

.783

.854

1.171

  1. Dependent Variable: rrf

 

 

Regress rr to all the instrumental variables

 

Model Summaryb

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

Change Statistics

R Square Change

F Change

df1

df2

Sig. F Change

1

.259a

.067

.034

.10456704085

.067

2.019

4

112

.097

a. Predictors: (Constant), dc, dp, rf, inf
b. Dependent Variable: rr

 

 

Coefficientsa

Model

Unstandardized Coefficients

Standardized Coefficients

t

Sig.

Collinearity Statistics

B

Std. Error

Beta

Tolerance

VIF

1 (Constant)

-.346

.155

 

-2.235

.027

   
dp

-.105

.044

-.296

-2.375

.019

.538

1.859

rf

2.256

1.721

.146

1.311

.193

.674

1.485

inf

.308

.758

.047

.406

.685

.622

1.607

dc

.803

.836

.095

.960

.339

.854

1.171

a. Dependent Variable: rr

 

Last step is to regress the dependent variable on the two predicted values.

 

 

Model Summaryb

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

Change Statistics

R Square Change

F Change

df1

df2

Sig. F Change

1

.479a

.229

.216

.01112179969

.229

16.939

2

114

.000

a. Predictors: (Constant), Unstandardized Predicted Value, Unstandardized Predicted Value
b. Dependent Variable: dc

 

 

 

Coefficientsa

Model

Unstandardized Coefficients

Standardized Coefficients

t

Sig.

Collinearity Statistics

B

Std. Error

Beta

Tolerance

VIF

1 (Constant)

.001

.001

 

.912

.364

   
Unstandardized Predicted Value

.046

.075

.054

.607

.545

.862

1.161

Unstandardized Predicted Value

.208

.040

.456

5.147

.000

.862

1.161

a. Dependent Variable: dc

 

 

 

 

 

 

 

 

HAUSMANN TEST

FRANCE

 

 

 

 

Comment- hence Ho= the variable rrf is exogenous is accepted because the p value is greater than .05 significant level.

 

Similarly for rr we have

 

 

 

COMMENT- here Ho= the variable rr is exogenous is not accepted as the pvalue is greater than .05. hence rr is endogenous

 

U.K

 

 

 

COMMENT_ – here the p value is greater than .05 hence the null hypothesis is accepted that the rrf is exogenous.

Similarly we can test for rr

 

 

Here the p value is lower than .05 , hence we reject the null hypothesis that rr is exogenous.

 

TEST FOR OVERIDENTIFYING RESTRICTIONS

FRANCE

here we perform the regression of err_1 or the IV residuals on all the instruments.

We calculate the rsquare and multiply it with the sample size to get the test statistic.

 

 

Model Summaryb

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

Change Statistics

R Square Change

F Change

df1

df2

Sig. F Change

1

.932a

.869

.864

.00543136

.869

181.628

4

110

.000

a. Predictors: (Constant), dc, inf, rf, dp
b. Dependent Variable: Error for dc, MOD_2 Equation 1

Here the test statistic is .869*115=99,935 which is higher than the critical value of chi square at 5% level of significance and 3 d.f i.e 7.814. which means there are misspecification error or the instruments are invalid  here.

 

Here we perform the regression of err2 or the IV residuals on all the instruments.

 

 

Model Summaryb

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

Change Statistics

R Square Change

F Change

df1

df2

Sig. F Change

1

1.000a

.999

.999

.00045442

.999

27797.700

4

110

.000

a. Predictors: (Constant), dc, inf, rf, dp
b. Dependent Variable: Error for dc, MOD_3 Equation 1

 

Now here the r square is .999*115= 114885 which is much higher than the critical value of chisquare at 5% level and 3 d.f i.e 7.814.  hence the same conclusion as above applies here.

U.K

When rrf is used as an explanatory variable

here we perform the regression of err_1 or the IV residuals on all the instruments.

We calculate the r square and multiply it with the sample size to get the test statistic.

 

Model Summaryb

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

Change Statistics

R Square Change

F Change

df1

df2

Sig. F Change

1

1.000a

1.000

1.000

0E-8

1.000

3940649673949156.000

4

112

.000

a. Predictors: (Constant), dc, dp, rf, inf
b. Dependent Variable: Error for dc, MOD_4 Equation 1

 

Hence here also the test statistic is greater than the critical value of chi square. therefore there is some misspecification error or the instruments are not valid here.

When rr is used as an explanatory variable

here we perform the regression of err_2 or the IV residuals on all the instruments.

We calculate the r square and multiply it with the sample size to get the test statistic.

 

Model Summaryb

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

Change Statistics

R Square Change

F Change

df1

df2

Sig. F Change

1

.803a

.644

.632

.00879518

.644

50.734

4

112

.000

a. Predictors: (Constant), dc, dp, rf, inf
  1. Dependent Variable: Error for dc, MOD_5 Equation 1

Here also there  is some model specification error or the instruments are invalid.

 

Heteroskedasticity test

 

France

Using rrf as the explanatory variable

 

Model Summaryb

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

Change Statistics

R Square Change

F Change

df1

df2

Sig. F Change

1

.204a

.042

.033

.00101

.042

4.903

1

113

.029

a. Predictors: (Constant), pre32
b. Dependent Variable: ERR_12

 

Coefficientsa

Model

Unstandardized Coefficients

Standardized Coefficients

t

Sig.

Collinearity Statistics

B

Std. Error

Beta

Tolerance

VIF

1 (Constant)

6.534E-005

.000

 

.562

.575

   
pre32

2.814

1.271

.204

2.214

.029

1.000

1.000

a. Dependent Variable: ERR_12

 

There is a presence of heteroskedasticity since p value of pre32 is less than .05.

similarly using rr as the dependent variable we have

 

 

Coefficientsa

Model

Unstandardized Coefficients

Standardized Coefficients

t

Sig.

Collinearity Statistics

B

Std. Error

Beta

Tolerance

VIF

1 (Constant)

-7.226E-006

.000

 

-1.658

.100

   
pr_42

1.111

.004

.999

260.508

.000

1.000

1.000

a. Dependent Variable: err_22

Since the p value of pre42 is less than .05 we reject the null hypothesis, hence there is a presence of heteroskedasticity.

 

 

U.K

Using rrf as the explanatory variable

 

Coefficientsa

Model

Unstandardized Coefficients

Standardized Coefficients

t

Sig.

Collinearity Statistics

B

Std. Error

Beta

Tolerance

VIF

1 (Constant)

.000

.000

 

2.632

.010

   
pre_32

.411

.447

.086

.921

.359

1.000

1.000

a. Dependent Variable: err_12

 

Here the p value of pre_32 is greater than .05. hence the null hypothesis is not rejected and there is no presence of heteroskedacticity.

 

Using rr as the explanatory variable.

 

 

 

Coefficientsa

Model

Unstandardized Coefficients

Standardized Coefficients

t

Sig.

Collinearity Statistics

B

Std. Error

Beta

Tolerance

VIF

1 (Constant)

.000

.000

 

3.630

.000

   
pre_42

.020

.026

.072

.775

.440

1.000

1.000

a. Dependent Variable: er_22

 

 

Here the p value of pre_42 is greater than .05. hence we do not reject the null hypothesis. Hence there is no presence of heteroskedasticity.

LH15

“The presented piece of writing is a good example how the academic paper should be written. However, the text can’t be used as a part of your own and submitted to your professor – it will be considered as plagiarism.

But you can order it from our service and receive complete high-quality custom paper.  Our service offers ECONOMICS  essay sample that was written by professional writer. If you like one, you have an opportunity to buy a similar paper. Any of the academic papers will be written from scratch, according to all customers’ specifications, expectations and highest standards.”

Please  Click on the  below links to Chat Now  or fill the Order Form !
order-now-new                        chat-new (1)