ECON 3020

Spring 2013

Dr. Tufte

Homework 4

Due: at the start of class on Wednesday, February 20

1) Download nominal and real GDP from the Bureau of Economic Analysis website. Rename this spreadsheet something instructive (you know … including your last name, Homework 4, and ECON 3020). Of course, you can also just copy the data you already have in other spreadsheets.

2) Enter your T-number in the following blocks so that it ends in the last block on the right.

3) Write the value in the darker shaded cell on the far right in the empty box below:

1

9

3

4) Write the value in the lighter shaded cell on the far right in the empty box below:

2

0

0

5) Note that your entries for numbers 3 and 4 look like years. Write out the two years: ______________ to ________________. This is the sample of real GDP data that you will be working with for this homework (and other forthcoming homeworks). Note that it will be close to your neighbors and friends, but is unlikely to be exactly the same. This means that your results should be close enough to be generally comparable to your friends and neighbors, but not close enough that you could copy their results.

6) I am assuming that, to start out with, your years are in column A and your annual real GDP series is in column C. Copy the real GDP to column I. Take natural logs of that column and put them in column J. Label that column “Natural Logs of Annual Real GDP”. Copy your years to column K. Label that column “Deterministic Trend”.

7) Run a regression in which the Natural Logs of Annual Real GDP are the “Input Y Range” and Deterministic Trend is the “Input X Range”. 

8) Clean up your regression as directed in the Handbook.

9) Print and turn in only the worksheet which contains your regression.