Question

1.The following problems will use a monthly data (not seasonally adjusted) on total clothing sales in the United States from January 1992 to December 2012. This data can be found from United States Census Bureau survey of "Monthly Retail Trade and Food Services" (category 4481).

1. Import the data intoStatafrom Excel. Generate and format your time variable for the monthly data. LetStataknow you are using time series data.Draw a time series graph of clothing sales (cloth) against time (your date variable). Comment on the various time series components of the graph.
2. UsingStata, generate the trend variablet(=_n). Now fit a deterministic trend model using the linear trend variable alone (when looking at the best trend model, do not include any other explanatory variables). Generate the information criteria, the fitted values graph, and the residuals graph.
3. Fit a quadratic trend model by addingt2to the model in part b. Generate the information criteria, the fitted values graph, and the residuals graph. Explain which model (linear trend or quadratic trend) is the better trend model and why?

2.We want to check if there is a break in the trend around the infamous Lehman Brothers crash in September 2008. Construct a dummy variable (D) that takes zeros before September 2008 and ones after that. Also, generatetD, the interactive dummy variable, constructed astD. Choose the model that you picked in the previous question and add the trend dummy variable (D) and the interaction term (txD). All regressions are estimated over the sample period from January 1992 through December 2012.

1. Comment on the significance of difference in the intercept and the slope before and after September 2008. Test (jointly) if there is evidence of any structural break in the trend. Write down null and alternative hypothesis. Calculate the test statistic, carry out the test, and state your conclusions.
2. Draw a graph showing the shape of the trend suggested by the regression above. Draw a graph of the residuals and comment on the shape of the residuals. Is there any obvious pattern that we are missing in our model?
3. Create seasonal dummies for January through December to account for seasonality. Add to your previous model the seasonal dummies using December as the season of reference (i.e. dropping December to avoid the dummy variable trap). Generate the information criteria, the fitted values graph and the residuals graph. Comment on what the output is telling us about the seasonality present in the data. Does your answer to parta, change?
4. Write down the estimated regression equation from part c. Construct a 1-step ahead (January 2013) forecast for monthly clothing sales for the United States using this model

cloth time

4852 1992m1

5159 1992m2

6024 1992m3

6682 1992m4

6768 1992m5

6534 1992m6

6551 1992m7

7486 1992m8

6878 1992m9

7514 1992m10

8201 1992m11

12721 1992m12

5439 1993m1

5284 1993m2

6349 1993m3

7112 1993m4

7128 1993m5

6725 1993m6

6905 1993m7

7386 1993m8

7093 1993m9

7535 1993m10

8499 1993m11

12672 1993m12

5128 1994m1

5425 1994m2

7099 1994m3

7014 1994m4

6947 1994m5

6947 1994m6

6834 1994m7

7766 1994m8

7177 1994m9

7718 1994m10

8810 1994m11

13296 1994m12

5331 1995m1

5472 1995m2

6944 1995m3

7079 1995m4

7190 1995m5

7087 1995m6

6805 1995m7

7727 1995m8

7558 1995m9

7425 1995m10

8988 1995m11

13102 1995m12

5325 1996m1

6050 1996m2

7189 1996m3

7278 1996m4

7648 1996m5

7277 1996m6

7000 1996m7

8304 1996m8

7495 1996m9

8024 1996m10

9114 1996m11

13008 1996m12

5785 1997m1

5902 1997m2

7640 1997m3

7110 1997m4

7916 1997m5

7444 1997m6

7540 1997m7

8802 1997m8

7797 1997m9

8436 1997m10

9522 1997m11

13828 1997m12

6224 1998m1

6366 1998m2

7736 1998m3

8414 1998m4

8436 1998m5

7983 1998m6

8211 1998m7

9128 1998m8

8040 1998m9

8993 1998m10

10031 1998m11

14566 1998m12

6559 1999m1

6871 1999m2

8673 1999m3

8903 1999m4

9171 1999m5

8624 1999m6

8817 1999m7

9712 1999m8

8917 1999m9

9427 1999m10

10528 1999m11

15479 1999m12

6683 2000m1

7470 2000m2

9283 2000m3

9420 2000m4

9496 2000m5

9156 2000m6

8872 2000m7

10340 2000m8

9683 2000m9

9823 2000m10

11492 2000m11

16379 2000m12

7211 2001m1

7820 2001m2

9492 2001m3

9676 2001m4

9674 2001m5

9292 2001m6

9055 2001m7

10567 2001m8

8910 2001m9

9815 2001m10

11212 2001m11

16484 2001m12

7468 2002m1

7971 2002m2

10178 2002m3

9517 2002m4

9882 2002m5

9530 2002m6

9338 2002m7

10804 2002m8

9139 2002m9

10461 2002m10

11703 2002m11

16843 2002m12

7920 2003m1

7941 2003m2

9949 2003m3

9992 2003m4

10522 2003m5

9853 2003m6

10140 2003m7

11175 2003m8

10042 2003m9

10875 2003m10

12209 2003m11

17743 2003m12

8682 2004m1

9133 2004m2

10893 2004m3

10974 2004m4

10998 2004m5

10396 2004m6

10796 2004m7

11380 2004m8

10579 2004m9

11695 2004m10

12823 2004m11

18940 2004m12

8932 2005m1

9501 2005m2

11744 2005m3

11544 2005m4

11502 2005m5

11479 2005m6

11267 2005m7

12148 2005m8

11142 2005m9

12387 2005m10

13649 2005m11

20280 2005m12

9489 2006m1

9824 2006m2

12148 2006m3

12495 2006m4

12204 2006m5

12178 2006m6

12107 2006m7

12948 2006m8

12435 2006m9

12964 2006m10

14375 2006m11

21379 2006m12

10335 2007m1

10531 2007m2

13563 2007m3

12757 2007m4

13423 2007m5

12806 2007m6

12537 2007m7

13737 2007m8

12564 2007m9

13209 2007m10

15317 2007m11

20843 2007m12

10488 2008m1

11107 2008m2

13237 2008m3

12688 2008m4

13822 2008m5

12597 2008m6

12835 2008m7

13774 2008m8

11911 2008m9

12600 2008m10

14178 2008m11

18700 2008m12

10144 2009m1

10538 2009m2

11784 2009m3

12354 2009m4

12783 2009m5

11567 2009m6

12085 2009m7

13007 2009m8

11794 2009m9

13065 2009m10

13887 2009m11

18800 2009m12

9931 2010m1

10605 2010m2

13174 2010m3

12951 2010m4

13173 2010m5

12211 2010m6

12724 2010m7

13213 2010m8

12366 2010m9

13222 2010m10

15169 2010m11

20141 2010m12

10201 2011m1

11407 2011m2

13760 2011m3

13912 2011m4

13698 2011m5

13324 2011m6

13473 2011m7

13957 2011m8

13486 2011m9

13872 2011m10

15916 2011m11

21877 2011m12

10752 2012m1

12720 2012m2

15342 2012m3

14148 2012m4

14753 2012m5

14190 2012m6

13890 2012m7

15358 2012m8

13911 2012m9

14453 2012m10

16824 2012m11

21966 2012m12