Econometrics Problem
matt19960605工作表1
State | Poverty Rate(%,2016) | Transfer Payment Spending per capita(2016) | % of College Graduation Completion Rate | Unemployment Rate(%,2016) | Inflation Rate (%) |
Alabama | 16.2 | 4866.8 | 84.3 | 4.2 | 2 |
Alaska | 12.6 | 5163.8 | 92.1 | 7.2 | 1.5 |
Arizona | 16.1 | 3160.8 | 86 | 5.0 | 2.7 |
Arkansas | 16.0 | 3135.9 | 84.8 | 3.5 | 1.6 |
California | 13.9 | 6152.0 | 81.8 | 5.1 | 1.5 |
Colorado | 8.5 | 5716.1 | 90.7 | 2.4 | 1.1 |
Connecticut | 9.8 | 7501.4 | 89.9 | 4.8 | 2.1 |
Delaware | 11.6 | 8095.0 | 88.4 | 4.9 | 3.1 |
District of Columbia | 16.3 | 24675.0 | 89.3 | 6.4 | 3.7 |
Florida | 13.0 | 3699.2 | 86.9 | 4.0 | 2.8 |
Georgia | 15.4 | 3724.7 | 85.4 | 4.7 | 2.7 |
Hawaii | 9.3 | 8072.5 | 91 | 2.6 | 2.6 |
Idaho | 11.1 | 4114.3 | 89.5 | 2.9 | 1.4 |
Illinois | 12.1 | 6031.9 | 87.9 | 5.0 | 1.9 |
Indiana | 11.8 | 4262.1 | 87.8 | 3.5 | 1.2 |
Iowa | 9.8 | 5871.1 | 91.5 | 3.3 | 0.9 |
Kansas | 11.2 | 4389.0 | 90.2 | 3.9 | 3.1 |
Kentucky | 15.2 | 8427.6 | 84.2 | 5.4 | 3 |
Louisiana | 20.2 | 5206.9 | 83.4 | 5.3 | 2.7 |
Maine | 12.7 | 5385.4 | 91.6 | 3.8 | 2.6 |
Maryland | 7.1 | 6646.9 | 89.4 | 3.9 | 1.8 |
Massachusetts | 9.6 | 8684.0 | 89.8 | 4.2 | 1.6 |
Michigan | 11.1 | 5309.8 | 89.6 | 3.9 | 2.2 |
Minnesota | 8.7 | 5522.3 | 92.4 | 3.8 | 2.4 |
Mississippi | 21.1 | 5774.0 | 82.3 | 5.3 | 2.5 |
Missouri | 13.0 | 4796.6 | 88.4 | 4.0 | 2.7 |
Montana | 11.7 | 5824.4 | 92.8 | 3.9 | 3 |
Nebraska | 9.6 | 4883.1 | 90.7 | 2.8 | 2.8 |
Nevada | 10.1 | 4115.8 | 85.1 | 4.9 | 2.9 |
West Virginia | 20.6 | 4545.2 | 85 | 5.1 | 1.5 |
New Mexico | 20.0 | 5002 | 84.2 | 6.2 | 1 |
Tennessee | 17.3 | 3935 | 85.5 | 3.0 | 1.7 |
Oklahoma | 17.3 | 6264 | 86.9 | 4.5 | 2.4 |
Texas | 16.4 | 5555 | 81.9 | 4.0 | 2.3 |
New Hamspshire | 6.4 | 5253.5 | 92 | 2.7 | 2.7 |
New Jersey | 9.4 | 6306.4 | 88.6 | 4.5 | 2.8 |
Statistics_ All Variables
SUMMARY OUTPUT | ||||||||
Regression Statistics | ||||||||
Multiple R | 0.7948129261 | |||||||
R Square | 0.6317275875 | |||||||
Adjusted R Square | 0.5842085665 | |||||||
Standard Error | 2.5229058765 | |||||||
Observations | 36 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 4 | 338.4733240946 | 84.6183310236 | 13.2942046064 | 0.0000020357 | |||
Residual | 31 | 197.3166759054 | 6.3650540615 | |||||
Total | 35 | 535.79 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | 78.4949794001 | 13.8371106681 | 5.6727868471 | 0.0000031218 | 50.2740061332 | 106.715952667 | 50.2740061332 | 106.715952667 |
Transfer Payment Spending per capita(2016) | 0.0000259 | 0.0001436348 | 0.1802592635 | 0.858122265 | -0.0002670536 | 0.0003188366 | -0.0002670536 | 0.0003188366 |
% of College Graduation Completion Rate | -0.7922713154 | 0.1490721059 | -5.3146852017 | 0.0000087107 | -1.09630588 | -0.4882367509 | -1.09630588 | -0.4882367509 |
Unemployment Rate(%,2016) | 0.9975868841 | 0.4609496245 | 2.1641993637 | 0.038269398 | 0.0574739268 | 1.9376998415 | 0.0574739268 | 1.9376998415 |
Inflation Rate (%) | -0.109729749 | 0.6537636789 | -0.1678431405 | 0.8677968961 | -1.443089563 | 1.223630065 | -1.443089563 | 1.223630065 |
Statistics_Without Inflation
SUMMARY OUTPUT | SUMMARY OUTPUT | ||||
Regression Statistics | Regression Statistics | ||||
Multiple R | Multiple R | ||||
R Square | R Square | ||||
Adjusted R Square | Adjusted R Square | ||||
Standard Error | Standard Error | ||||
Observations | Observations | ||||
ANOVA | ANOVA | ||||
SS | MS | F | Significance F | ||
Regression | Regression | 338.294012121 | 112.764670707 | 18.2711026253 | 0.0000004334 |
Residual | Residual | 197.495987879 | 6.1717496212 | ||
Total | Total | 535.79 | |||
Standard Error | t Stat | P-value | Lower 95% | ||
Intercept | Intercept | 13.5980587289 | 5.7617038084 | 0.0000021661 | 50.6496475342 |
Transfer Payment Spending per capita(2016) | Transfer Payment Spending per capita(2016) | 0.0001341543 | 0.1360771408 | 0.8926127622 | -0.0002550081 |
% of College Graduation Completion Rate | % of College Graduation Completion Rate | 0.1467628787 | -5.4016467403 | 0.000006174 | -1.0917074263 |
Unemployment Rate(%,2016) | Unemployment Rate(%,2016) | 0.4537097515 | 2.193846255 | 0.0356249701 | 0.0711929181 |
Corrlation_Matrix
Poverty Rate(%,2016) | Transfer Payment Spending per capita(2016) | % of College Graduation Completion Rate | Unemployment Rate(%,2016) | Inflation Rate (%) | |
Poverty Rate(%,2016) | 1 | ||||
Transfer Payment Spending per capita(2016) | 0.0101435866 | 1 | |||
% of College Graduation Completion Rate | -0.7483872952 | 0.1527945612 | 1 | ||
Unemployment Rate(%,2016) | 0.5150768672 | 0.336325191 | -0.3551978792 | 1 | |
Inflation Rate (%) | -0.0126427556 | 0.3612857487 | 0.0624293537 | 0.1411399557 | 1 |
ScatterPlot
Transfer Payment Spending per capita(2016) | % of College Graduation Completion Rate | Unemployment Rate(%,2016) | Inflation Rate (%) | Poverty Rate(%,2016) |
4866.8 | 84.3 | 4.2 | 2 | 16.2 |
5163.8 | 92.1 | 7.2 | 1.5 | 12.6 |
3160.8 | 86 | 5 | 2.7 | 16.1 |
3135.9 | 84.8 | 3.5 | 1.6 | 16 |
6152 | 81.8 | 5.1 | 1.5 | 13.9 |
5716.1 | 90.7 | 2.4 | 1.1 | 8.5 |
7501.4 | 89.9 | 4.8 | 2.1 | 9.8 |
8095 | 88.4 | 4.9 | 3.1 | 11.6 |
24675 | 89.3 | 6.4 | 3.7 | 16.3 |
3699.2 | 86.9 | 4 | 2.8 | 13 |
3724.7 | 85.4 | 4.7 | 2.7 | 15.4 |
8072.5 | 91.0 | 2.6 | 2.6 | 9.3 |
4114.3 | 89.5 | 2.9 | 1.4 | 11.1 |
6031.9 | 87.9 | 5 | 1.9 | 12.1 |
4262.1 | 87.8 | 3.5 | 1.2 | 11.8 |
5871.1 | 91.5 | 3.3 | 0.9 | 9.8 |
4389 | 90.2 | 3.9 | 3.1 | 11.2 |
8427.6 | 84.2 | 5.4 | 3 | 15.2 |
5206.9 | 83.4 | 5.3 | 2.7 | 20.2 |
5385.4 | 91.6 | 3.8 | 2.6 | 12.7 |
6646.9 | 89.4 | 3.9 | 1.8 | 7.1 |
8684 | 89.8 | 4.2 | 1.6 | 9.6 |
5309.8 | 89.6 | 3.9 | 2.2 | 11.1 |
5522.3 | 92.4 | 3.8 | 2.4 | 8.7 |
5774 | 82.3 | 5.3 | 2.5 | 21.1 |
4796.6 | 88.4 | 4 | 2.7 | 13 |
5824.4 | 92.8 | 3.9 | 3 | 11.7 |
4883.1 | 90.7 | 2.8 | 2.8 | 9.6 |
4115.8 | 85.1 | 4.9 | 2.9 | 10.1 |
4545.2 | 85.0 | 5.1 | 1.5 | 20.6 |
5002 | 84.2 | 6.2 | 1 | 20 |
3935 | 85.5 | 3 | 1.7 | 17.3 |
6264 | 86.9 | 4.5 | 2.4 | 17.3 |
5555 | 81.9 | 4 | 2.3 | 16.4 |
5253.5 | 92.0 | 2.7 | 2.7 | 6.4 |
6306.4 | 88.6 | 4.5 | 2.8 | 9.4 |
Scatterplot
Poverty Rate(%,2016) 2 1.5 2.7 1.6 1.5 1.1000000000000001 2.1 3.1 3.7 2.8 2.7 2.6 1.4 1.9 1.2 0.9 3.1 3 2.7 2.6 1.8 1.6 2.2000000000000002 2.4 2.5 2.7 3 2.8 2.9 1.5 1 1.7 2.4 2.2999999999999998 2.7 2.8 16.2 12.6 16.100000000000001 16 13.9 8.5 9.8000000000000007 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
Inflation rate
Poverty
ScatterPlot
Poverty Rate(%,2016) 4.2 7.2 5 3.5 5.0999999999999996 2.4 4.8 4.9000000000000004 6.4 4 4.7 2.6 2.9 5 3.5 3.3 3.9 5.4 5.3 3.8 3.9 4.2 3.9 3.8 5.3 4 3.9 2.8 4.9000000000000004 5.0999999999999996 6.2 3 4.5 4 2.7 4.5 16.2 12.6 16.100000000000001 16 13.9 8.5 9.8000000000000007 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
Unemployment Rate (%)
Poverty
ScatterPlot
Poverty Rate(%,2016) 88.4 89.3 86.9 85.4 91 89.5 87.9 87.8 91.5 90.2 84.2 83.4 91.6 89.4 89.8 89.6 92.4 82.3 88.4 92.8 90.7 85.1 85 84.2 85.5 86.9 81.900000000000006 92 88.6 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
% of College Graduation
Poverty
ScatterPlot
Poverty Rate(%,2016) 4866.8 5163.8 3160.8 3135.9 6152 5716.1 7501.4 8095 24675 3699.2 3724.7 8072.5 4114.3 6031.9 4262.1000000000004 5871.1 4389 8427.6 5206.8999999999996 5385.4 6646.9 8684 5309.8 5522.3 5774 4796.6000000000004 5824.4 4883.1000000000004 4115.8 4545.2 5002 3935 6264 5555 5253.5 6306.4 16.2 12.6 16.100000000000001 16 13.9 8.5 9.8000000000000007 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
Transfer Payment Spending
Poverty
Scatterplot
Poverty Rate(%,2016) 2 1.5 2.7 1.6 1.5 1.1000000000000001 2.1 3.1 3.7 2.8 2.7 2.6 1.4 1.9 1.2 0.9 3.1 3 2.7 2.6 1.8 1.6 2.2000000000000002 2.4 2.5 2.7 3 2.8 2.9 1.5 1 1.7 2.4 2.2999999999999998 2.7 2.8 16.2 12.6 16.100000000000001 16 13.9 8.5 9.8000000000000007 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
Inflation rate
Poverty
ScatterPlot
Poverty Rate(%,2016) 4.2 7.2 5 3.5 5.0999999999999996 2.4 4.8 4.9000000000000004 6.4 4 4.7 2.6 2.9 5 3.5 3.3 3.9 5.4 5.3 3.8 3.9 4.2 3.9 3.8 5.3 4 3.9 2.8 4.9000000000000004 5.0999999999999996 6.2 3 4.5 4 2.7 4.5 16.2 12.6 16.100000000000001 16 13.9 8.5 9.8000000000000007 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
Unemployment Rate (%)
Poverty
ScatterPlot
Poverty Rate(%,2016) 88.4 89.3 86.9 85.4 91 89.5 87.9 87.8 91.5 90.2 84.2 83.4 91.6 89.4 89.8 89.6 92.4 82.3 88.4 92.8 90.7 85.1 85 84.2 85.5 86.9 81.900000000000006 92 88.6 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
% of College Graduation
Poverty
ScatterPlot
Poverty Rate(%,2016) 4866.8 5163.8 3160.8 3135.9 6152 5716.1 7501.4 8095 24675 3699.2 3724.7 8072.5 4114.3 6031.9 4262.1000000000004 5871.1 4389 8427.6 5206.8999999999996 5385.4 6646.9 8684 5309.8 5522.3 5774 4796.6000000000004 5824.4 4883.1000000000004 4115.8 4545.2 5002 3935 6264 5555 5253.5 6306.4 16.2 12.6 16.100000000000001 16 13.9 8.5 9.8000000000000007 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
Transfer Payment Spending
Poverty
Scatterplot
Poverty Rate(%,2016) 2 1.5 2.7 1.6 1.5 1.1000000000000001 2.1 3.1 3.7 2.8 2.7 2.6 1.4 1.9 1.2 0.9 3.1 3 2.7 2.6 1.8 1.6 2.2000000000000002 2.4 2.5 2.7 3 2.8 2.9 1.5 1 1.7 2.4 2.2999999999999998 2.7 2.8 16.2 12.6 16.100000000000001 16 13.9 8.5 9.8000000000000007 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
Inflation rate
Poverty
ScatterPlot
Poverty Rate(%,2016) 4.2 7.2 5 3.5 5.0999999999999996 2.4 4.8 4.9000000000000004 6.4 4 4.7 2.6 2.9 5 3.5 3.3 3.9 5.4 5.3 3.8 3.9 4.2 3.9 3.8 5.3 4 3.9 2.8 4.9000000000000004 5.0999999999999996 6.2 3 4.5 4 2.7 4.5 16.2 12.6 16.100000000000001 16 13.9 8.5 9.8000000000000007 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
Unemployment Rate (%)
Poverty
ScatterPlot
Poverty Rate(%,2016) 88.4 89.3 86.9 85.4 91 89.5 87.9 87.8 91.5 90.2 84.2 83.4 91.6 89.4 89.8 89.6 92.4 82.3 88.4 92.8 90.7 85.1 85 84.2 85.5 86.9 81.900000000000006 92 88.6 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
% of College Graduation
Poverty
ScatterPlot
Poverty Rate(%,2016) 4866.8 5163.8 3160.8 3135.9 6152 5716.1 7501.4 8095 24675 3699.2 3724.7 8072.5 4114.3 6031.9 4262.1000000000004 5871.1 4389 8427.6 5206.8999999999996 5385.4 6646.9 8684 5309.8 5522.3 5774 4796.6000000000004 5824.4 4883.1000000000004 4115.8 4545.2 5002 3935 6264 5555 5253.5 6306.4 16.2 12.6 16.100000000000001 16 13.9 8.5 9.8000000000000007 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
Transfer Payment Spending
Poverty
Scatterplot
Poverty Rate(%,2016) 2 1.5 2.7 1.6 1.5 1.1000000000000001 2.1 3.1 3.7 2.8 2.7 2.6 1.4 1.9 1.2 0.9 3.1 3 2.7 2.6 1.8 1.6 2.2000000000000002 2.4 2.5 2.7 3 2.8 2.9 1.5 1 1.7 2.4 2.2999999999999998 2.7 2.8 16.2 12.6 16.100000000000001 16 13.9 8.5 9.8000000000000007 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
Inflation rate
Poverty
ScatterPlot
Poverty Rate(%,2016) 4.2 7.2 5 3.5 5.0999999999999996 2.4 4.8 4.9000000000000004 6.4 4 4.7 2.6 2.9 5 3.5 3.3 3.9 5.4 5.3 3.8 3.9 4.2 3.9 3.8 5.3 4 3.9 2.8 4.9000000000000004 5.0999999999999996 6.2 3 4.5 4 2.7 4.5 16.2 12.6 16.100000000000001 16 13.9 8.5 9.8000000000000007 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
Unemployment Rate (%)
Poverty
ScatterPlot
Poverty Rate(%,2016) 88.4 89.3 86.9 85.4 91 89.5 87.9 87.8 91.5 90.2 84.2 83.4 91.6 89.4 89.8 89.6 92.4 82.3 88.4 92.8 90.7 85.1 85 84.2 85.5 86.9 81.900000000000006 92 88.6 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
% of College Graduation
Poverty
ScatterPlot
Poverty Rate(%,2016) 4866.8 5163.8 3160.8 3135.9 6152 5716.1 7501.4 8095 24675 3699.2 3724.7 8072.5 4114.3 6031.9 4262.1000000000004 5871.1 4389 8427.6 5206.8999999999996 5385.4 6646.9 8684 5309.8 5522.3 5774 4796.6000000000004 5824.4 4883.1000000000004 4115.8 4545.2 5002 3935 6264 5555 5253.5 6306.4 16.2 12.6 16.100000000000001 16 13.9 8.5 9.8000000000000007 11.6 16.3 13 15.4 9.3000000000000007 11.1 12.1 11.8 9.8000000000000007 11.2 15.2 20.2 12.7 7.1 9.6 11.1 8.6999999999999993 21.1 13 11.7 9.6 10.1 20.6 20 17.3 17.3 16.399999999999999 6.4 9.4
Transfer Payment Spending
Poverty