Project 3

profilecaonigeDJ
a494533693Econ301Project3Fall1PPT.xlsx

National Economy

How does the GDP for USA compare to that of that of Britain?
Time USA GDP GBR GDP
1970 1073303 197804.2058
1971 1164850 215072.8153
1972 1279110 234022.1758
1973 1425376 262912.8569
1974 1545243 279512.134
1975 1684904 300885.1951
1976 1873412 326681.88
1977 2081826 355456.8452
1978 2351599 396445.4041
1979 2627334 445400.3057
1980 2857307 475785.9604
1981 3207042 516790.3233
1982 3343789 559751.0876
1983 3634038 606233.1195
1984 4037613 642401.4346
1985 4338979 690520.1657
1986 4579631 726434.773
1987 4855215 783897.6238
1988 5236438 858193.9289
1989 5641580 914752.9743
1990 5963144 955939.9907
1991 6158129 977529.5913
1992 6520327 1003545.6363
1993 6858559 1053282.1115
1994 7287236 1117514.1057
1995 7639749 1190685.1009
1996 8073122 1271055.7233
1997 8577552 1343618.6774
1998 9062817 1382460.7914
1999 9630663 1432714.2155
2000 10252347 1555186.1897
2001 10581822 1640973.6769
2002 10936418 1725817.4194
2003 11458246 1805030.5834
2004 12213730 1917490.3382
2005 13036637 1973200.2228
2006 13814609 2115462.7526
2007 14451860 2183078.946
2008 14712845 2265855.8606
2009 14448932 2179887.2377
2010 14992052 2280975.351
2011 15542582 2350795.5756
2012 16197007 2440476.6487
2013 16784851 2563271.0401
2014 17527258 2665876.3074
2015 18224780 2768619.3899
2016 18715040 2856266.937
2017 19519424 2997685.2602
2018 20580223 3056736.5106
Mean 8542868.36734694 1323673.21226122
median 7287236 1117514.1057
Sample variance 34211279301983.8 760217429156.316
standard deviation 5849040.88735784 871904.483963878
coefficient of variation 0.6846694384 0.6587007094
range 19506920 2858932.3048
percentiles
25th 3343789 559751.0876
50th 7287236 1117514.1057
75th 13814609 2115462.7526
Quintiles
1st 2765317.8 463631.69852
2nd 5705892.8 922990.37758
3rd 9517093.8 1422663.53068
4th 14556254 2216189.71184
5th 20580223 3056736.5106
Skewness 0.4494688303 0.4396658407
Source: https://data.oecd.org/gdp/gross-domestic-product-gdp.htm

Trend of GDP for USA and GBR

USA GDP 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 1073303 1164850 1279110 1425376 1545243 1684904 1873412 2081826 2351599 2627334 2857307 3207042 3343789 3634038 4037613 4338979 4579631 4855215 5236438 5641580 5963144 6158129 6520327 6858559 7287236 7639749 8073122 8577552 9062817 9630663 10252347 10581822 10936418 11458246 12213730 13036637 13814609 14451860 14712845 14448932 14992052 15542582 16197007 16784851 17527258 18224780 18715040 19519424 20580223 GBR GDP 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 197804.2058 215072.81529999999 234022.1758 262912.85690000001 279512.13400000002 300885.19510000001 326681.88 355456.84519999998 396445.40409999999 445400.30570000003 475785.96039999998 516790.32329999999 559751.08759999997 606233.11950000003 642401.43460000004 690520.16570000001 726434.77300000004 783897.62379999994 858193.92890000006 914752.9743 955939.99069999997 977529.59129999997 1003545.6363 1053282.1115000001 1117514.1057 1190685.1009 1271055.7233 1343618.6773999999 1382460.7914 1432714.2154999999 1555186.1897 1640973.6769000001 1725817.4194 1805030.5833999999 1917490.3382000001 1973200.2228000001 2115462.7525999998 2183078.946 2265855.8605999998 2179887.2376999999 2280975.3509999998 2350795.5756000001 2440476.6486999998 2563271.0400999999 2665876.3073999 998 2768619.3898999998 2856266.9369999999 2997685.2601999999 3056736.5106000002 https://data.oecd.org/gdp/gross-domestic-product-gdp.htm

Wealth Income and Poverty

Race and Hispanic origin of householder and year
$200,000 and over
1967 1.1
1968 1.0
1969 1.3
1970 1.4
1971 1.3
1972 1.7
1973 1.8
1974 1.5
1975 1.4
1976 1.6
1977 1.7
1978 1.9
1979 2.0
1980 1.7
1981 1.7
1982 2.0
1983 2.1
1984 2.3
1985 2.5
1986 2.9
1987 3.1
1988 3.4
1989 3.6
1990 3.4
1991 3.1
1992 3.2
1993 3.7
1994 4.1
1995 4.1
1996 4.3
1997 4.9
1998 5.3
1999 6.0
2000 5.9
2001 5.9
2002 5.6
2003 5.9
2004 5.7
2005 5.9
2006 6.2
2007 6.1
2008 5.7
2009 5.8
2010 5.6
2011 5.5
2012 5.6
2013 6.5
2013 5.7
2014 6.5
2015 7.0
2016 7.7
2017 8.6
2017 8.1
2018 8.5
Mean 4.1
median 3.9
Sample variance 4.7960062893
standard deviation 2.1899786048
coefficient of variation 0.5348658736
range 7.6
percentiles
25th 1.925
50th 3.9
75th 5.875
Quintiles
1st 1.7
2nd 3.12
3rd 5.46
4th 5.9
5th 8.6
Skewness 0.2422340277
Source: https://www.census.gov/library/publications/2019/demo/p60-266.html
Table A-2
Percentage of wealthy Americans 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2013 2014 2015 2016 2017 2017 2018 1.1000000000000001 1 1.3 1.4 1.3 1.7 1.8 1.5 1.4 1.6 1.7 1.9 2 1.7 1.7 2 2.1 2.2999999999999998 2.5 2.9 3.1 3.4 3.6 3.4 3.1 3.2 3.7 4.0999999999999996 4.0999999999999996 4.3 4.9000000000000004 5.3 6 5.9 5.9 5.6 5.9 5.7 5.9 6.2 6.1 5.7 5.8 5.6 5.5 5.6 6.5 5.7 6.5 7 7.7 8.6 8.1 8.5

Percentage

https://www.census.gov/library/publications/2019/demo/p60-266.html

Business Statistics

Source: https://fred.stlouisfed.org/series/CP#0
observation_date CP
1980 207.274
1981 206.310
1982 181.034
1983 197.468
1984 216.763
1985 208.039
1986 174.323
1987 218.088
1988 264.090
1989 264.982
1990 282.235
1991 311.504
1992 330.647
1993 350.898
1994 429.034
1995 490.802
1996 527.354
1997 572.125
1998 506.273
1999 538.501
2000 513.164
2001 518.939
2002 627.911
2003 756.378
2004 979.169
2005 1285.370
2006 1413.731
2007 1359.859
2008 1123.169
2009 1263.326
2010 1561.483
2011 1537.152
2012 1821.235
2013 1788.739
2014 1857.164
2015 1740.349
2016 1739.838
2017 1813.552
2018 1843.713
Mean 821.1
median 527.4
Sample variance 381179.473886677
standard deviation 617.3973387428
coefficient of variation 0.7519364967
range 1,682.8
percentiles
25th 273.6085
50th 527.354
75th 1386.7945
Quintiles
1st 245.6893
2nd 493.8963
3rd 730.68475
4th 1546.8841
5th 1857.16375
Skewness 0.583939406

Trend in Corporate Tax

CP 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 207.27375000000001 206.30975000000001 181.0335 197.46825000000001 216.76325 208.03925000000001 174.32300000000001 218.08824999999999 264.08999999999997 264.98174999999998 282.23525000000001 311.50425000000001 330.64675 350.89774999999997 429.0335 490.80225000000002 527.35400000000004 572.12450000000001 506.27249999999998 538.50075000000004 513.16425000000004 518.93899999999996 627.91075000000001 756.37824999999998 979.16875000000005 1285.3697500000001 1413.7304999999999 1359.8585 1123.1692499999999 1263.3254999999999 1561.4829999999999 1537.1514999999999 1821.23525 1788.739 1857.1637499999999 1740.3485000000001 1739.838 1813.55225 1843.713

Labor Statistics

Source: https://data.bls.gov/pdq/SurveyOutputServlet
Year Unemployment
1980 7.2
1981 7.6
1982 9.7
1983 9.6
1984 7.5
1985 7.2
1986 7
1987 6.2
1988 5.5
1989 5.3
1990 5.6
1991 6.9
1992 7.5
1993 6.9
1994 6.1
1995 5.6
1996 5.4
1997 4.9
1998 4.5
1999 4.2
2000 4
2001 4.7
2002 5.8
2003 6
2004 5.5
2005 5.1
2006 4.6
2007 4.6
2008 5.8
2009 9.3
2010 9.6
2011 8.9
2012 8.1
2013 7.4
2014 6.2
2015 5.3
2016 4.9
2017 4.4
2018 3.9
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.2870467181
R Square 0.0823958184
Adjusted R Square 0.0575957054
Standard Error 1.5954810899
Observations 39
ANOVA
df SS MS F Significance F
Regression 1 8.4573603239 8.4573603239 3.3223968908 0.0764309813
Residual 37 94.1857165992 2.5455599081
Total 38 102.6430769231
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 88.9808906883 45.3782625908 1.9608703729 0.0574543907 -2.9642022478 180.9259836244 -2.9642022478 180.9259836244
X Variable 1 -0.0413765182 0.0227001218 -1.8227443295 0.0764309813 -0.0873713335 0.004618297 -0.0873713335 0.004618297

Unemployment Rate (%)

unemployment rate (%) 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 7.2 7.6 9.6999999999999993 9.6 7.5 7.2 7 6.2 5.5 5.3 5.6 6.9 7.5 6.9 6.1 5.6 5.4 4.9000000000000004 4.5 4.2 4 4.7 5.8 6 5.5 5.0999999999999996 4.5999999999999996 4.5999999999999996 5.8 9.3000000000000007 9.6 8.9 8.1 7.4 6.2 5.3 4.9000000000000004 4.4000000000000004 3.9

Unemployment rate (%)

Government

Government spending varies across agencies
Source: https://www.whitehouse.gov/omb/historical-tables/ Source: https://www.whitehouse.gov/omb/historical-tables/
Year Department of Agriculture Department of Commerce Department of Defense--Military Programs Department of Education Department of Energy Department of Health and Human Services
1980 912 75451 7087 567 7260 4472
1981 976 91691 7862 641 11756 4456 SUMMARY OUTPUT
1982 1099 109418 8520 710 11656 3944
1983 1055 115366 29854 787 10590 4552 Regression Statistics
1984 1193 139911 17651 866 10990 4936 Multiple R 0.9924716754
1985 1309 163688 16793 966 10586 4804 R Square 0.9850000265
1986 1536 178076 19316 1071 11025 4774 Adjusted R Square 0.9821875315
1987 1547 178684 16524 1180 10692 5037 Standard Error 1.5217164354
1988 1644 200406 18113 1342 11165 5138 Observations 39
1989 1736 227402 18709 1499 11386 5194
1990 1821 253915 17276 1646 12083 5814 ANOVA
1991 2064 274606 19008 1997 12472 6082 df SS MS F Significance F
1992 2230 291005 24943 2308 15515 6531 Regression 6 4865.9001308889 810.9833551482 350.2228502703 9.7676439131373E-28
1993 2429 296825 28143 2628 16933 6879 Residual 32 74.0998691111 2.3156209097
1994 2605 305550 31164 2677 17830 7064 Total 38 4940
1995 2814 346875 31037 2903 17608 7479
1996 2988 362862 30694 3059 16195 6776 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
1997 3093 377491 34309 3259 14458 6763 Intercept 1980.0244291455 1.8580876992 1065.6248518172 2.21229689336129E-74 1976.2396283727 1983.8092299182 1976.2396283727 1983.8092299182
1998 3143 389005 37542 3459 14414 7222 Department of Agriculture 0.0020469041 0.0013258851 1.5438020226 0.1324691666 -0.0006538355 0.0047476437 -0.0006538355 0.0047476437
1999 3246 385045 40021 3789 15879 7783 Department of Commerce 0.0000113106 0.0000051082 2.2142226481 0.0340584168 0.0000009056 0.0000217156 0.0000009056 0.0000217156
2000 3448 390524 45121 4057 14971 7998 Department of Defense--Military Programs -0.0000065257 0.0000165591 -0.3940846611 0.696132525 -0.0000402554 0.0000272041 -0.0000402554 0.0000272041
2001 3662 388268 40007 4381 16319 7743 Department of Education 0.0024861241 0.0014181654 1.7530565036 0.0891688582 -0.0004025843 0.0053748325 -0.0004025843 0.0053748325
2002 4155 371187 45816 4828 17669 9739 Department of Energy -0.000228142 0.0001758491 -1.2973734956 0.2037783504 -0.0005863348 0.0001300509 -0.0005863348 0.0001300509
2003 4690 368256 46333 5127 19379 9193 Department of Health and Human Services 0.0001708635 0.0004968616 0.3438855882 0.7331817974 -0.0008412104 0.0011829375 -0.0008412104 0.0011829375
2004 5092 375844 49008 5389 19892 8606
2005 5403 410240 54556 5547 21271 9292
2006 5510 464675 53252 5823 19649 9037
2007 5488 490589 54917 6006 20116 10469
2008 5785 548797 58602 6347 21400 9817
2009 5958 701775 78657 6645 23683 11775
2010 6719 444338 70758 7181 30778 13164
2011 7146 538707 155316 7293 31371 13519
2012 7255 464714 188241 7227 32484 12891
2013 7417 399068 109849 7063 24731 9607
2014 7053 446897 81184 6893 23638 11279
2015 6837 485623 87359 7137 25424 12340
2016 6902 526116 93240 7499 25860 12583
2017 7215 546397 93328 7569 25800 12154
2018 7167 629472 87863 7778 26482 13212