Question: Download the gross federal debt (FYGFD) from FRED website. The link for this data series is

http://research.st|ouisfed.orngredZZseriesZ FYGFD?cid=5

1. Draw a line graph of the gross federal debt.
2. Get the regression printout for the linear trend model with FYGFD, not the growth of FYGFD, as the dependent variable.
3. Write the regression model and estimated equation for part b.
4. Predict the values of federal debt for 2017 and 2017, based on the above linear trend model.
5. Get the regression printout for the exponential trend model with FYGFD, not the growth of FYGFD, as the dependent variable.
6. Write the regression model and estimated equation for part 8.
7. Predict the values of federal debt for 2016 and 2017 based on the above exponential trend model. Note that you need use "=exp" function in Excel to convert the predicted values from the above printout into the predictions of the level of federal debt.
8. Generate the growth of FYGFD and get the line graph of the growth of FYGFD. Don’t print the data of the growth.
9. Get the regression printout for the AR(1) model for the growth of FYGFD.
10. Write the regression model and estimated equation for part i.
11. Predict the growth of debt for 2016 and 2017 based on the results from the AR(1) model in part i.
12. Predict the value of debt for 2016 and 2017 using the results in parts i and k.

Price: $2.99

Solution: The downloadable solution consists of 5 pages
Deliverable: Word Document