Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

Econometrics Problem

工作表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

Need assignment help for this question?

If you need assistance with writing your essay, we are ready to help you!

OUR PROCESS

Order

Payment

Writing

Delivery

Why Choose Us: Cost-efficiency, Plagiarism free, Money Back Guarantee, On-time Delivery, Total Сonfidentiality, 24/7 Support, 100% originality

 

 

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