SNHU Rate of Growth of Real GDP Inflation and Unemployment Excel Spreadsheet Attached is an example. *** Using the attached spreadsheet as a template, and

SNHU Rate of Growth of Real GDP Inflation and Unemployment Excel Spreadsheet Attached is an example.
***
Using the attached spreadsheet as a template, and relying on the information contained in the Module Three lecture notes, download data from FRED for the following three key macroeconomic variables and produce a forecast of each for the next two years.
The rate of growth of real GDP (GDPC1 and use the percent change from a year ago).
The rate of  rate of growth of real GDP (CPIAUCSL and use the percent change from a year ago).
The unemployment rate (UNRATE).
Your assignment should consist of a single Excel spreadsheet with three tabs, one for each of the three variables. Each tab should contain the original data, any intermediate data you choose to use, and a graph showing your forecast appended to the actual data as in the template provided. It should also contain a brief verbal description of your reasoning.
The submission must be your own work. However, you are free to discuss the assignment in the general questions conference. FRED Graph Observations
Federal Reserve Economic Data
Link: http://research.stlouisfed.org/fred2
Help: http://research.stlouisfed.org/fred2/help-faq
Economic Research Division
Federal Reserve Bank of St. Louis
PAYEMS
All Employees: Total nonfarm (PAYEMS), Thousands, Monthly, Seasonally Adjusted
Frequency: Monthly
observation_date
PAYEMS
2000-01-01
2000-02-01
2000-03-01
2000-04-01
2000-05-01
2000-06-01
2000-07-01
2000-08-01
2000-09-01
2000-10-01
2000-11-01
2000-12-01
2001-01-01
2001-02-01
2001-03-01
2001-04-01
2001-05-01
2001-06-01
2001-07-01
2001-08-01
2001-09-01
2001-10-01
2001-11-01
2001-12-01
2002-01-01
2002-02-01
2002-03-01
2002-04-01
2002-05-01
2002-06-01
2002-07-01
2002-08-01
2002-09-01
2002-10-01
2002-11-01
2002-12-01
2003-01-01
2003-02-01
2003-03-01
2003-04-01
2003-05-01
Pre
Differences
130781
130902
131374
131660
131885
131839
132002
132005
132127
132116
132347
132485
132469
132530
132500
132219
132175
132047
131922
131762
131518
131193
130901
130723
130591
130444
130420
130335
130328
130373
130276
130260
130205
130331
130339
130183
130266
130108
129896
129847
129841
121
472
286
225
-46
163
3
122
-11
231
138
-16
61
-30
-281
-44
-128
-125
-160
-244
-325
-292
-178
-132
-147
-24
-85
-7
45
-97
-16
-55
126
8
-156
83
-158
-212
-49
-6
2003-06-01
2003-07-01
2003-08-01
2003-09-01
2003-10-01
2003-11-01
2003-12-01
2004-01-01
2004-02-01
2004-03-01
2004-04-01
2004-05-01
2004-06-01
2004-07-01
2004-08-01
2004-09-01
2004-10-01
2004-11-01
2004-12-01
2005-01-01
2005-02-01
2005-03-01
2005-04-01
2005-05-01
2005-06-01
2005-07-01
2005-08-01
2005-09-01
2005-10-01
2005-11-01
2005-12-01
2006-01-01
2006-02-01
2006-03-01
2006-04-01
2006-05-01
2006-06-01
2006-07-01
2006-08-01
2006-09-01
2006-10-01
2006-11-01
2006-12-01
2007-01-01
2007-02-01
2007-03-01
2007-04-01
2007-05-01
2007-06-01
2007-07-01
2007-08-01
2007-09-01
129839
129864
129822
129925
130128
130146
130270
130420
130463
130801
131051
131361
131442
131489
131610
131770
132121
132185
132317
132453
132693
132835
133195
133364
133610
133979
134174
134237
134321
134655
134813
135094
135411
135698
135880
135891
135971
136173
136358
136514
136506
136711
136891
137094
137182
137400
137479
137620
137687
137638
137612
137681
-2
25
-42
103
203
18
124
150
43
338
250
310
81
47
121
160
351
64
132
136
240
142
360
169
246
369
195
63
84
334
158
281
317
287
182
11
80
202
185
156
-8
205
180
203
88
218
79
141
67
-49
-26
69
2007-10-01
2007-11-01
2007-12-01
2008-01-01
2008-02-01
2008-03-01
2008-04-01
2008-05-01
2008-06-01
2008-07-01
2008-08-01
2008-09-01
2008-10-01
2008-11-01
2008-12-01
2009-01-01
2009-02-01
2009-03-01
2009-04-01
2009-05-01
2009-06-01
2009-07-01
2009-08-01
2009-09-01
2009-10-01
2009-11-01
2009-12-01
2010-01-01
2010-02-01
2010-03-01
2010-04-01
2010-05-01
2010-06-01
2010-07-01
2010-08-01
2010-09-01
2010-10-01
2010-11-01
2010-12-01
2011-01-01
2011-02-01
2011-03-01
2011-04-01
2011-05-01
2011-06-01
2011-07-01
2011-08-01
2011-09-01
2011-10-01
2011-11-01
2011-12-01
2012-01-01
137772
137899
137983
137996
137913
137841
137656
137423
137245
137014
136747
136313
135804
135002
134383
133563
132837
132041
131381
130995
130493
130193
129962
129726
129505
129450
129320
129281
129246
129438
129715
130173
129981
129932
129873
129844
130015
130108
130260
130328
130563
130757
130974
131027
131047
131132
131132
131249
131366
131483
131600
131717
91
127
84
13
-83
-72
-185
-233
-178
-231
-267
-434
-509
-802
-619
-820
-726
-796
-660
-386
-502
-300
-231
-236
-221
-55
-130
-39
-35
192
277
458
-192
-49
-59
-29
171
93
152
68
235
194
217
53
20
85
0
117
2012-02-01
2012-03-01
2012-04-01
2012-05-01
2012-06-01
2012-07-01
2012-08-01
2012-09-01
2012-10-01
2012-11-01
2012-12-01
2013-01-01
2013-02-01
140000
138000
136000
134000
132000
130000
128000
126000
124000
131835
131952
132069
132186
132303
132420
132537
132654
132771
132888
133005
133123
133240
Total Non-Farm Employment Actual and Forecast
Seasonally Adjusted
Actual
Presentation
Forecast
130781
130902
131374
131660
131885
131839
132002
132005
132127
132116
132347
132485
132469
132530
132500
132219
132175
132047
131922
131762
131518
131193
130901
130723
130591
130444
130420
130335
130328
130373
130276
130260
130205
130331
130339
130183
130266
130108
129896
129847
129841
129839
129864
129822
129925
130128
130146
130270
130420
130463
130801
131051
131361
131442
131489
131610
131770
132121
132185
132317
132453
132693
132835
133195
133364
133610
133979
134174
134237
134321
134655
134813
135094
135411
135698
135880
135891
135971
136173
136358
136514
136506
136711
136891
137094
137182
137400
137479
137620
137687
137638
137612
137681
137772
137899
137983
137996
137913
137841
137656
137423
137245
137014
136747
136313
135804
135002
134383
133563
132837
132041
131381
130995
130493
130193
129962
129726
129505
129450
129320
129281
129246
129438
129715
130173
129981
129932
129873
129844
130015
130108
130260
130328
130563
130757
130974
131027
131047
131132
131132
131249
131366
131483
131600
131717
131835
131952
132069
132186
132303
132420
132537
132654
132771
132888
133005
133123
133240
ual and Forecast
Actual
Forecast

Purchase answer to see full
attachment