DATE
Consumption
1999-01-01
1999-04-01
1999-07-01
1999-10-01
2000-01-01
2000-04-01
2000-07-01
2000-10-01
2001-01-01
2001-04-01
2001-07-01
2001-10-01
2002-01-01
2002-04-01
2002-07-01
2002-10-01
2003-01-01
2003-04-01
2003-07-01
2003-10-01
2004-01-01
2004-04-01
2004-07-01
2004-10-01
2005-01-01
2005-04-01
2005-07-01
2005-10-01
2006-01-01
2006-04-01
2006-07-01
2006-10-01
2007-01-01
2007-04-01
2007-07-01
2007-10-01
2008-01-01
2008-04-01
2008-07-01
2008-10-01
2009-01-01
2009-04-01
2009-07-01
2009-10-01
2010-01-01
2010-04-01
2010-07-01
2010-10-01
2011-01-01
2011-04-01
2011-07-01
Investment
6102.040
6230.641
6335.310
6467.039
6618.217
6711.911
6819.984
6918.606
6995.298
7042.250
7070.337
7187.320
7217.715
7307.955
7397.135
7472.958
7567.160
7661.458
7820.927
7913.453
8048.777
8147.108
8283.335
8448.621
8551.735
8701.145
8868.089
8955.295
9100.153
9227.649
9353.772
9427.368
9572.138
9678.713
9798.383
9937.140
10004.445
10129.869
10159.078
9906.942
9814.969
9805.502
9939.406
10004.996
10101.822
10208.145
10300.754
10430.304
10558.195
10673.018
10755.029
1396.781
1382.234
1421.323
1474.075
1459.751
1579.425
1562.866
1563.709
1458.191
1447.091
1408.206
1311.672
1357.026
1360.583
1356.155
1348.717
1346.251
1347.458
1382.746
1439.497
1441.378
1514.464
1550.315
1601.102
1671.795
1636.287
1660.103
1760.056
1813.902
1842.209
1880.093
1874.539
1892.517
1955.645
1980.705
1983.092
1947.416
1945.622
1928.245
1785.167
1534.146
1408.848
1374.250
1531.194
1581.413
1677.133
1792.266
1784.453
1752.323
1834.855
1849.869
Government Purchases
2931.044
2959.520
3004.028
3086.823
3074.397
3129.768
3152.254
3210.083
3280.819
3358.217
3377.367
3436.530
3508.647
3554.587
3598.998
3681.871
3744.177
3808.760
3839.406
3869.703
3947.702
3982.852
4050.203
4093.920
4201.029
4240.850
4375.914
4393.619
4456.559
4508.744
4557.261
4555.974
4747.079
4792.841
4859.514
4934.382
4991.989
5366.788
5236.250
5452.409
5533.429
5680.717
5641.212
5693.133
5804.974
5872.568
5825.414
5834.793
5848.004
5906.467
5852.866
2011-10-01
2012-01-01
2012-04-01
2012-07-01
2012-10-01
2013-01-01
2013-04-01
2013-07-01
2013-10-01
2014-01-01
2014-04-01
2014-07-01
2014-10-01
2015-01-01
2015-04-01
2015-07-01
2015-10-01
2016-01-01
2016-04-01
2016-07-01
2016-10-01
2017-01-01
2017-04-01
2017-07-01
2017-10-01
2018-01-01
2018-04-01
2018-07-01
2018-10-01
2019-01-01
2019-04-01
2019-07-01
2019-10-01
2020-01-01
2020-04-01
2020-07-01
2020-10-01
2021-01-01
2021-04-01
2021-07-01
2021-10-01
2022-01-01
2022-04-01
2022-07-01
10809.186
10959.301
11005.055
11059.393
11165.703
11265.599
11290.973
11379.188
11518.351
11618.108
11784.687
11934.297
12053.809
12083.904
12224.707
12347.752
12397.543
12495.078
12637.360
12759.058
12881.566
13049.405
13133.989
13260.313
13490.728
13677.349
13850.838
13988.794
14102.937
14145.897
14323.749
14482.196
14619.042
14440.160
13049.766
14388.701
14586.036
15131.484
15813.545
16147.297
16517.976
16874.769
17261.338
17500.328
2020.724
2059.961
2121.544
2118.301
2088.141
2165.853
2186.216
2277.357
2306.812
2292.638
2405.971
2466.175
2477.643
2566.637
2547.921
2532.408
2475.279
2420.252
2416.830
2416.959
2493.605
2468.759
2532.510
2598.042
2641.237
2693.864
2726.411
2829.619
2847.606
2907.525
2939.822
2955.681
2879.650
2808.043
2304.917
2770.281
2865.622
2781.919
2822.478
2961.612
3302.550
3435.229
3405.518
3439.786
5879.574
5835.737
5825.191
5834.161
5872.514
5836.000
5846.239
5864.665
5868.619
5904.824
5974.243
6045.984
6081.506
6112.126
6059.788
6225.731
6245.980
6318.634
6320.457
6412.654
6462.249
6506.591
6535.748
6639.427
6694.391
6786.814
6901.148
6988.095
7074.886
7216.024
7296.565
7379.130
7463.582
7502.143
10784.221
9690.565
8459.436
10998.545
9468.937
9156.734
8720.098
8250.420
8688.168
8808.806
Net Exports
-212.559
-247.530
-276.403
-301.708
-356.583
-362.501
-393.867
-411.343
-402.653
-364.015
-370.634
-369.688
-386.884
-428.259
-447.548
-496.289
-525.262
-519.870
-518.994
-523.694
-565.975
-617.581
-652.672
-700.336
-696.655
-707.210
-750.961
-804.786
-790.818
-794.042
-823.284
-737.668
-739.273
-745.806
-728.954
-729.699
-771.248
-776.404
-787.354
-628.474
-420.992
-358.368
-423.998
-473.254
-509.192
-542.514
-553.943
-523.586
-568.476
-581.092
-567.111
-601.788
-602.271
-565.241
-523.083
-515.874
-500.212
-499.345
-482.952
-435.068
-511.282
-506.491
-490.466
-531.908
-526.916
-508.803
-543.012
-526.066
-514.394
-491.683
-485.079
-533.843
-532.956
-553.787
-518.423
-541.767
-576.427
-543.359
-618.199
-634.322
-599.911
-615.702
-584.841
-514.683
-522.725
-526.273
-692.412
-768.588
-808.606
-834.396
-889.143
-914.708
-1116.682
-1035.565
-901.365
Department of Accounting, Finance, and Economics
ECON 211- PRINCIPLES OF MACROECONOMICS all 2022
Research Project
2. Fred Graph
With the attached excel file, use the data components of GDP to evaluate the equation of GDP,
that is:
?? = ?? + ?? + ?? + (?? ? ??)
Next, show a graphical representation of these variables and check that ?? = ?? + ?? + ?? + (?? ?
??)
Finally, identify and describe business cycle phases from GDP graph obtained previously.
3. Written Report on the GDP
Draft a two-page report on the GDP behavior over the period 1999-01 to 2022 and describe
business cycle over the same period. First, you should describe the steps taken to construct the
graphs. In your analysis, describe the business cycle present in the GDP data, that is, describe
recession period (decrease in GDP of more than 6 month), expansion (increase in GDP), peak
(the highest GDP during the expansion), and trough (lowest GDP during the recession).
Use the GDP equation and data on GDP components to evaluate the equation. Create different
visualizations using each of the variables over the last decade (1999-2022) to show the
relationship between GDP and each of its components. Which components seems to determine
the behavior of the GDP? How can you identify unemployment or inflation from the GDP
graph?
Next, determine the GDP share of consumption, GDP share of investment, GDP share of
government spending, and GDP share of net exports. What GDP component has the largest
share? What have you learned about measuring GDP from this assignment? Be sure to cite, using
APA, any findings to back your argument and provide a bibliography.

Purchase answer to see full
attachment