Skip to content.

UPV/EHU

Sections
Personal tools

assignments

Assignment 1: Understanding the role of Econometrics

Write a small essay (1 page?45 lines max.) with your views on David Hendry's "Econometrics: alchemy or science?"


Assignment 2: Running your first regression in Gretl

  • Look in the Internet for a data set of two variables x and y that you think they might be related: (that is, y ? f(x) )
  • Download the econometric program Gretl
  • Read gretl's primer
  • Carry out a single regression of y on x ( y = f (x) + u )
  • Interpret your results.

Assignment 3a: Estimating a SLRM (Single Linear Regression Model)

Data file h-Editorial-en contains 40 quarterly observations from four variables (*):

  • S (book Sales in thousands of euros),
  • P (average Price in euros),
  • C (average price of the Competition in euros) and
  • A (Advertising expenditure in euros)

as follows:


Book sales (St)

Average price (Pt)

Average price of the competition (Ct)

Advertising expenditure (At)

Book sales (St)

Average price (Pt)

Average price of the competition (Ct)

Advertising expenditure (At)
1992:1 275.5 98.6 105.5 1868 1997:1 229.9 99.2 108.5 1903
1992:2 285.6 96.6 104.4 2157 1997:2 342.9 86.4 98.10 2489
1992:3 336.8 102.0 115.6 2541 1997:3 361.9 92.7 122.8 2770
1992:4 333.4 91.9 102.7 2561 1997:4 301.3 100.9 106.9 2493
1993:1 357.0 105.6 106.1 3103 1998:1 332.5 101.7 108.3 2701
1993:2 325.2 102.8 100.2 2661 1998:2 343.2 95.3 114.4 2497
1993:3 362.2 102.1 97.2 2757 1998:3 421.9 98.6 114.9 3192
1993:4 232.0 99.1 93.3 1403 1998:4 401.9 102.5 107.5 3086
1994:1 252.2 100.3 94.6 1856 1999:1 421.8 101.0 108.5 3533
1994:2 322.1 104.8 109.4 2123 1999:2 361.7 96.9 109.4 2864
1994:3 297.3 85.6 94.7 2181 1999:3 393.6 98.3 114.6 3181
1994:4 298.9 103.0 111.4 2520 1999:4 287.6 91.8 118.2 1855
1995:1 246.8 100.4 105.0 2134 2000:1 380.0 77.8 106.8 2575
1995:2 322.4 93.8 118.3 2473 2000:2 495.6 81.6 131.4 3723
1995:3 383.5 99.7 102.1 3125 2000:3 452.6 86.6 101.5 3268
1995:4 321.8 104.6 110.6 2753 2000:4 404.9 93.0 146.2 3025
1996:1 351.5 100.0 97.3 2869 2001:1 421.3 83.7 114.2 3173
1996:2 381.1 103.7 91.8 3301 2001:2 333.7 93.7 119.3 2387
1996:3 412.5 96.7 96.8 3043 2001:3 379.1 94.5 116.5 2839
1996:4 217.5 105.5 102.2 1538 2001:4 407.0 97.7 113.5 3352

You must load/open the data file into Gretl in the usual way:

&mouse;File ? Open data ? User file? or &ctrl;+&keyo;? h-Editorial-en.xls

and do the following?

3a.1 Regress Sales on Price only:

St = ?0 + ?1 Pt + ut

  1. What sign do you expect for ?1?
  2. Plot a scatter graph of S against P and comment
  3. Run the OLS regression: do the results agree with your expectations?
  4. Interpret the estimated coefficients
  5. Show that the regression line crosses the point of averages (X?,Y?)
  6. What is the value of the coefficient of determination? Interpret this value.

3a.2 Regress Sales on Advertising expenditure only:

St = ?0 + ?2 At + ut

  • Repeat the process in 3a.1 above for this model, and interpret the results, etc.
    1. ?
    2. ?


Assignment 3b: Estimating & Testing a GLRM (General Linear Regression Model)

St = ?0 + ?1 Pt + ?2 At + ?3 Ct + ut

  1. Repeat the process described in Assignment 3a for the full GLR Model, and interpret the results, etc.
    1. ?
    2. ?
  2. Compare the results obtained to those from the previous SLR Models. Are they the same? Why?
  3. Obtain an estimate for the variance of the error term
  4. Obtain the Variance-covariance matrix of the OLS estimators
  5. Table of observed values, fitted vales and residuals
  6. Estimate the variances of the estimators of the coefficients ?1 and ?2
  7. Estimate the covariance of ?^1 and ?^2
  8. Plot of Sales observations against fitted values
  9. Plot of OLS residuals
  10. Obtain their frequency distribution. Do they appear Normally distributed?
  11. Plot of residuals against Price


Assignment 3c: Testing of hypothesis in a GLRM

In the same model as in Assignment 3b above:

  1. Test for the individual significance of all variables.
  2. Perform an overall significance test of the whole regression.
  3. Test the hypothesis ?1 + ?2 = ?3.


Assignment 3d: Prediction with the GLRM

In the same model as in Assignment 3b and 3c above:

  1. Let us suppose that since the last recorded date neither our prices nor those of the competition have changed but our advertising expenditure has been cut by 10%. What consequences would that have on our sales?
  2. Part of the board believe that the firm can still keep the previous target of 425000 ? in sales for this book. Do you agree with that opinion? (Hint: construct a suitable confidence interval).


Assignment 4a: Qualitative information in the GLRM (seasonal effects)

In the same model as in Assignments 3b to 3d above, consider the possibility that book sales may increase significantly during the Summer:

  1. Modify the model to take this qualitative information into account. Describe in detail the suggested modifications.
  2. What signs do you expect for the new coefficients (if any)?
  3. Interpret all the coefficients in your new model.
  4. Run the OLS regression: do the results agree with your expectations?
  5. Test whether book sales do actually increase during the Summer.


Assignment 4b: Qualitative information in the GLRM (transversal effects)

Given the characteristics of the book the firm wants to consider the possibility that Women tend to read more than Men. In order to study how this may affect book sales the firm's sales director asks you to design a survey to collect the relevant information from a sample of 500 of their readers:

  1. What variables would you include in the survey? Describe in detail the suggested quantitative as well as qualitative variables.
  2. Write down a GLRM that takes all the relevant information into account.
  3. Interpret all the coefficients in your new model.
  4. What signs do you expect for the coefficients in the model?
  5. What if Women do read more than Men but only during the Summer? Modify your survey accordingly and write down the appropriate linear regression model.
  6. What if Women's marginal propensity to consume books (i.e. read) is higher than that of Men? Include new variable(s) to take into account this possibility.


Note:

(*)As in Alonso, Fernández & Gallastegui's book Econometría, pp. 14 & 42. Appendix B of this book, p.383, shows full resolution of many questions related to this course that are illustrated with this data set.