Econ excel homework checking
|
State |
U-rate |
Poverty |
|
Alabana |
3.7 |
15.8 |
|
Alaska |
6.5 |
12.1 |
|
Arizona |
5.1 |
15.5 |
|
Arkansas |
3.8 |
15.6 |
|
Califonia |
4.2 |
13.4 |
|
Colorado |
3.7 |
8.7 |
|
Connecticut |
3.8 |
9.9 |
|
Delaware |
3.4 |
10.6 |
|
District of Columbia |
5.5 |
15.5 |
|
Florida |
3.5 |
14.3 |
|
Georgia |
3.9 |
15.6 |
|
Hawaii |
2.7 |
10.2 |
|
Idaho |
2.9 |
11.7 |
|
Illinois |
4.3 |
11.3 |
|
Indiana |
3.5 |
12.3 |
|
Lowa |
2.4 |
9.7 |
|
Kansas |
3.4 |
13.4 |
|
Kentucky |
4.1 |
16.4 |
|
Louisiana |
4.9 |
20 |
|
Maine |
3.4 |
12.3 |
|
Maryland |
3.7 |
8.2 |
|
Massachusetts |
3 |
10.6 |
|
Michigan |
4 |
12.2 |
|
Minnesota |
3.1 |
8.6 |
|
Mississippi |
4.8 |
19.5 |
|
Missouri |
3.2 |
11.3 |
|
Montana |
3.8 |
11.1 |
|
Nebraska |
2.8 |
10.1 |
|
Nevada |
4.3 |
12.3 |
|
New Hampshire |
2.4 |
6.7 |
|
New Jersey |
4 |
9.7 |
|
New Mexico |
5.1 |
18.7 |
|
New York |
3.9 |
13.2 |
|
North Carolina |
3.9 |
14.4 |
|
North Dakota |
2.4 |
11 |
|
Ohio |
4.6 |
13.3 |
|
Oklahoma |
3.3 |
13.8 |
|
Oregon |
4.4 |
11.3 |
|
Pennsylvania |
4 |
11.5 |
|
Rhode Island |
3.9 |
11.8 |
|
South Carolina |
3.2 |
14.6 |
|
South Dakota |
2.9 |
12.9 |
|
Tennessee |
3.2 |
13.7 |
|
Texas |
3.8 |
14 |
|
Utah |
3 |
8.8 |
|
Vermont |
2.4 |
10.2 |
|
Virginia |
2.9 |
10.8 |
|
Washington |
4.5 |
10.7 |
|
West Virginia |
5.2 |
16.6 |
|
Wisconsin |
2.9 |
10.5 |
|
Wyoming |
3.9 |
11 |
1. (y)=a+bx
2. a) slope(b)
N= 53(no of values)
X=U-rate
Y=Poverty
N∑xy-(∑x)(∑y)
N∑x2-(∑x)2
∑x=191.2
∑y=637.4
∑xy=2457.37
∑x2=753.9
(53)x(2457.37)-(191.2)x(282)
(53)x(753.7)-(191.7)
76322.21
39754.4
b= 1.91984309
b) intercept (a)
(a)= ∑y-b(∑x)
N
637.4-1.91984309(191.2)
53
637.4 - 367.0739988
53
a=5.100490589
5.100490589+1.91984309 X
3. The poverty variation is more compared to the Unemployment rate
4. It is coefficient because predictor variables increases with the response
5. Chart
6.
Arizona 5.1 15.5
Califonia 4.2 13.4
Idaho 2.9 11.7
Nevada 4.3 12.3
Oreegon 4.4 11.3
Utah 3 8.8
Washington 4.5 10.7
The regression in these western states is predictable on the unemployment rate compared to poverty.
The regression equation is residual.
The coefficient determination can be interpreted
7. The regression in question 6 above is predictable and overfitting. The regression is polynominal where the independent variables are more than one in each state.
8. The coefficients are coefficients because they are increasing more than one in each state of dependent over independent.
9. The dummy variable are better fit than regression without dummy because
Their effects are analyzed in effects to multiple regression analysis.
Dependents on interpreted variables.
Indicates all values
Variables against States
U-rate Alabana Alaska Arizona Arkansas Califonia Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Lowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montaana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oreegon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont virginia Washington West Virginia Wisconsin Wyoming 3.7 6.5 5.0999999999999996 3.8 4.2 3.7 3.8 3.4 5.5 3.5 3.9 2.7 2.9 4.3 3.5 2.4 3.4 4.0999999999999996 4.9000000000000004 3.4 3.7 3 4 3.1 4.8 3.2 3.8 2.8 4.3 2.4 4 5.0999999999999996 3.9 3.9 2.4 4.59999999999999 96 3.3 4.4000000000000004 4 3.9 3.2 2.9 3.2 3.8 3 2.4 2.9 4.5 5.2 2.9 3.9 Poverty Alabana Alaska Arizona Arkansas Califonia Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Lowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montaana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oreegon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont virginia Washington West Virginia Wisconsin Wyoming 15.8 12.1 15.5 15.6 13.4 8.6999999999999993 9.9 10.6 15.5 14.3 15.6 10.199999999999999 11.7 11.3 12.3 9.6999999999999993 13.4 16.399999999999999 20 12.3 8.1999999999999993 10.6 12.2 8.6 19.5 11.3 11.1 10.1 12.3 6.7 9.6999999999999993 18.7 13.2 14.4 11 13.3 13.8 11.3 11.5 11.8 14.6 12.9 13.7 14 8.8000000000000007 10.199999999999999 10.8 10.7 16.600000000000001 10.5 11
States
Variables