Mgmt 4950: Final Project Proposal

MGMT 4950: FINAL PROJECT PROPOSAL

Date:xxxxxx

Group Member Names:xxxxxxxx

Datafile Name: Life Expectancy at Birth

Description:This data was collected by the Measure of America Project which is a part of the Social Science Research Council. The data we selected was for all states, genders, and ages for Americans citizens in the year of 2010. Our goal is to determine which selected independent variables are the best predictors of life expectancy in the United States per state in 2010. Our plan is to divide up each group of over variables (e.g. poverty, education, race/population, health) and then run separate regressions on the group independent variables with the dependent variable. The final step will be to put all the most significant independent variables in one model then run a stepwise test on the data to get the most predictive model.

Research questions: 1, …; 2,….; 3, ….

Number of cases:1050

Variable Names: / Y = LIFE_EXP
X1 = LESS_HS
X2 = ATLEAST_HS
X3 = ATLEAST_BA
X4 = GRAD_DEG
X5 = S_ENROLL
X6 = TOTAL_POP
X7 = UND6_POV
X8 = OVER65_POV
X9 = EDS_K12
X10 = PS_ENROLL / X11= WHT_POP
X12= BLK_POP
X13= LAT_POP
X14= ASN_POP
X15= NAT_POP
X16= OTR_POP
X17= SMOKING
X18= B_DRINK
X19= DIABETES
X20= OBESITY
X21= CHILD_IMM_RATE

*All data are in percentage form

Variable(s) in red maybe deleted from data set

The Data (also attached in another excel file):

DEPENDENT VARIABLES FOR EACH STATE

Life Expectancy at Birth (years) / State
75.4 / Alabama
78.3 / Alaska
79.6 / Arizona
76.0 / Arkansas
80.8 / California
80.0 / Colorado
80.8 / Connecticut
78.4 / Delaware
76.5 / District of Columbia
79.4 / Florida
77.2 / Georgia
81.3 / Hawaii
79.5 / Idaho
79.0 / Illinois
77.6 / Indiana
79.7 / Iowa
78.7 / Kansas
76.0 / Kentucky
75.7 / Louisiana
79.2 / Maine
78.8 / Maryland
80.5 / Massachusetts
78.2 / Michigan
81.1 / Minnesota
75.0 / Mississippi
77.5 / Missouri
78.5 / Montana
79.8 / Nebraska
78.1 / Nevada
80.3 / New Hampshire
80.3 / New Jersey
78.4 / New Mexico
80.5 / New York
77.8 / North Carolina
79.5 / North Dakota
77.8 / Ohio
75.9 / Oklahoma
79.5 / Oregon
78.5 / Pennsylvania
79.9 / Rhode Island
77.0 / South Carolina
79.5 / South Dakota
76.3 / Tennessee
78.5 / Texas
80.2 / Utah
80.5 / Vermont
79.0 / Virginia
79.9 / Washington
75.4 / West Virginia
80.0 / Wisconsin
78.3 / Wyoming
Total Population / Children Under 6 Living in Poverty (%) / Adults 65 and Older Living in Poverty (%) / Economically Disadvantaged Students (% public K-12) / Preschool Enrollment
(% enrolled ages 3 and 4)
4,779,736 / 31.9 / 10.7 / 53.0 / 46.9
710,231 / 17.8 / 5.7 / 38.0 / 43.0
6,392,017 / 27.5 / 7.7 / 45.0 / 32.4
2,915,918 / 32.5 / 10.2 / 60.0 / 49.8
37,253,956 / 23.6 / 9.7 / 53.0 / 50.8
5,029,196 / 20.9 / 8.1 / 40.0 / 48.9
3,574,097 / 15.8 / 6.6 / 34.0 / 64.4
897,934 / 22.4 / 7.7 / 48.0 / 47.3
601,723 / 27.4 / 13.1 / 72.0 / 73.6
18,801,310 / 26.5 / 9.9 / 56.0 / 51.6
9,687,653 / 28.8 / 10.7 / 57.0 / 50.9
1,360,301 / 16.0 / 6.8 / 47.0 / 54.6
1,567,582 / 23.9 / 7.9 / 45.0 / 36.6
12,830,632 / 22.1 / 8.4 / 44.0 / 56.0
6,483,802 / 25.3 / 6.8 / 47.0 / 40.2
3,046,355 / 19.4 / 6.7 / 39.0 / 50.6
2,853,118 / 22.0 / 7.7 / 48.0 / 47.5
4,339,367 / 31.6 / 11.2 / 57.0 / 48.5
4,533,372 / 32.1 / 11.5 / 66.0 / 55.0
1,328,361 / 22.0 / 9.5 / 43.0 / 39.1
5,773,552 / 15.2 / 7.7 / 40.0 / 51.7
6,547,629 / 17.0 / 8.7 / 34.0 / 62.3
9,883,640 / 27.6 / 8.0 / 46.0 / 49.3
5,303,925 / 17.4 / 8.3 / 37.0 / 46.3
2,967,297 / 37.8 / 11.9 / 71.0 / 54.5
5,988,927 / 26.0 / 9.1 / 44.0 / 43.0
989,415 / 24.2 / 7.0 / 41.0 / 37.2
1,826,341 / 22.2 / 7.5 / 43.0 / 45.0
2,700,551 / 26.4 / 7.6 / 48.0 / 28.4
1,316,470 / 13.8 / 6.1 / 25.0 / 51.5
8,791,894 / 16.8 / 7.2 / 33.0 / 67.3
2,059,179 / 32.9 / 12.0 / 67.0 / 42.9
19,378,102 / 23.7 / 10.9 / 48.0 / 60.1
9,535,483 / 28.8 / 9.9 / 50.0 / 49.5
672,591 / 20.5 / 12.1 / 32.0 / 37.6
11,536,504 / 28.2 / 7.7 / 43.0 / 46.3
3,751,351 / 28.4 / 9.3 / 60.0 / 46.0
3,831,074 / 24.7 / 7.9 / 51.0 / 43.7
12,702,379 / 21.8 / 7.9 / 39.0 / 49.7
1,052,567 / 22.7 / 8.2 / 43.0 / 56.5
4,625,364 / 31.9 / 9.8 / 55.0 / 48.9
814,180 / 21.4 / 11.1 / 37.0 / 38.1
6,346,105 / 29.4 / 9.7 / 55.0 / 44.5
25,145,561 / 28.7 / 10.7 / 50.0 / 43.0
2,763,885 / 16.7 / 6.0 / 38.0 / 40.5
625,741 / 23.5 / 6.8 / 37.0 / 55.4
8,001,024 / 17.5 / 7.4 / 37.0 / 49.5
6,724,540 / 21.1 / 6.9 / 40.0 / 43.2
1,852,994 / 30.2 / 9.9 / 51.0 / 32.2
5,686,986 / 22.8 / 7.1 / 39.0 / 45.3
563,626 / 18.5 / 6.8 / 37.0 / 40.7

INDEPENDENT VARIABLE POVERTY/RESORCE

INDEPENDENT VARIABLES EDUCATION

Less Than High School (%) / At Least High School Diploma
(%) / At Least Bachelor's Degree
(%) / Graduate Degree
(%) / School Enrollment
(%)
17.9 / 82.1 / 21.9 / 8.0 / 76.1
9.0 / 91.0 / 27.9 / 9.4 / 71.2
14.4 / 85.6 / 25.9 / 9.2 / 74.1
17.1 / 82.9 / 19.5 / 6.3 / 75.7
19.3 / 80.7 / 30.1 / 11.0 / 78.4
10.3 / 89.7 / 36.4 / 13.0 / 77.5
11.4 / 88.6 / 35.5 / 15.3 / 81.9
12.3 / 87.7 / 27.8 / 11.3 / 78.3
12.6 / 87.4 / 50.1 / 26.9 / 74.6
14.5 / 85.5 / 25.8 / 9.2 / 77.5
15.7 / 84.3 / 27.3 / 9.8 / 77.2
10.1 / 89.9 / 29.5 / 9.6 / 74.9
11.7 / 88.3 / 24.4 / 7.7 / 76.1
13.1 / 86.9 / 30.8 / 11.5 / 79.7
13.0 / 87.0 / 22.7 / 8.1 / 76.9
9.4 / 90.6 / 24.9 / 7.9 / 79.0
10.8 / 89.2 / 29.8 / 10.5 / 78.4
18.1 / 81.9 / 20.5 / 8.1 / 74.7
18.1 / 81.9 / 21.4 / 7.0 / 75.2
9.7 / 90.3 / 26.8 / 9.5 / 77.7
11.9 / 88.1 / 36.1 / 16.4 / 78.5
10.9 / 89.1 / 39.0 / 16.7 / 81.2
11.3 / 88.7 / 25.2 / 9.6 / 79.2
8.2 / 91.8 / 31.8 / 10.3 / 79.2
19.0 / 81.0 / 19.5 / 7.1 / 76.1
13.1 / 86.9 / 25.6 / 9.5 / 76.6
8.3 / 91.7 / 28.8 / 9.0 / 75.7
9.6 / 90.4 / 28.6 / 9.0 / 80.2
15.3 / 84.7 / 21.7 / 7.4 / 71.8
8.5 / 91.5 / 32.8 / 12.4 / 79.4
12.0 / 88.0 / 35.4 / 13.3 / 81.3
16.7 / 83.3 / 25.0 / 10.8 / 74.7
15.1 / 84.9 / 32.5 / 14.0 / 79.1
15.3 / 84.7 / 26.5 / 8.7 / 76.2
9.7 / 90.3 / 27.6 / 7.9 / 74.1
11.9 / 88.1 / 24.6 / 8.9 / 77.9
13.8 / 86.2 / 22.9 / 7.5 / 75.7
11.2 / 88.8 / 28.8 / 10.5 / 76.0
11.6 / 88.4 / 27.1 / 10.4 / 78.6
16.5 / 83.5 / 30.2 / 12.2 / 79.1
15.9 / 84.1 / 24.5 / 8.8 / 76.4
10.4 / 89.6 / 26.3 / 7.7 / 76.2
16.4 / 83.6 / 23.1 / 8.5 / 75.3
19.3 / 80.7 / 25.9 / 8.6 / 76.3
9.4 / 90.6 / 29.3 / 9.4 / 76.9
9.0 / 91.0 / 33.6 / 13.3 / 77.6
13.5 / 86.5 / 34.2 / 14.2 / 76.9
10.2 / 89.8 / 31.1 / 11.1 / 74.9
16.8 / 83.2 / 17.5 / 6.6 / 75.5
9.9 / 90.1 / 26.3 / 9.0 / 78.0
7.7 / 92.3 / 24.1 / 8.4 / 73.4

INDEPENDENT VARIABLES RACE POPULATION

White not Latino Population (%) / Latino Population (%) / African American Population (%) / Asian American Population (%) / Native American Population (%) / Population some other race or races (%)
67.0 / 3.9 / 26.0 / 1.1 / 0.5 / 1.4
64.1 / 5.5 / 3.1 / 5.3 / 14.4 / 7.6
57.8 / 29.6 / 3.7 / 2.7 / 4.0 / 2.1
74.5 / 6.4 / 15.3 / 1.2 / 0.7 / 1.8
40.1 / 37.6 / 5.8 / 12.8 / 0.4 / 3.2
70.0 / 20.7 / 3.8 / 2.7 / 0.6 / 2.3
71.2 / 13.4 / 9.4 / 3.8 / 0.2 / 2.0
65.3 / 8.2 / 20.8 / 3.2 / 0.3 / 2.2
34.8 / 9.1 / 50.0 / 3.5 / 0.2 / 2.4
57.9 / 22.5 / 15.2 / 2.4 / 0.3 / 1.9
55.9 / 8.8 / 30.0 / 3.2 / 0.2 / 1.8
22.7 / 8.9 / 1.5 / 37.7 / 0.2 / 29.0
84.0 / 11.2 / 0.6 / 1.2 / 1.1 / 1.9
63.7 / 15.8 / 14.3 / 4.5 / 0.1 / 1.6
81.5 / 6.0 / 9.0 / 1.6 / 0.2 / 1.7
88.7 / 5.0 / 2.9 / 1.7 / 0.3 / 1.5
78.2 / 10.5 / 5.7 / 2.3 / 0.8 / 2.4
86.3 / 3.1 / 7.7 / 1.1 / 0.2 / 1.6
60.3 / 4.2 / 31.8 / 1.5 / 0.6 / 1.5
94.4 / 1.3 / 1.1 / 1.0 / 0.6 / 1.5
54.7 / 8.2 / 29.0 / 5.5 / 0.2 / 2.4
76.1 / 9.6 / 6.0 / 5.3 / 0.2 / 2.8
76.6 / 4.4 / 14.0 / 2.4 / 0.6 / 2.0
83.1 / 4.7 / 5.1 / 4.0 / 1.0 / 2.1
58.0 / 2.7 / 36.9 / 0.9 / 0.5 / 1.0
81.0 / 3.5 / 11.5 / 1.6 / 0.4 / 2.0
87.8 / 2.9 / 0.4 / 0.6 / 6.1 / 2.3
82.1 / 9.2 / 4.4 / 1.7 / 0.8 / 1.7
54.1 / 26.5 / 7.7 / 7.1 / 0.9 / 3.7
92.3 / 2.8 / 1.0 / 2.1 / 0.2 / 1.5
59.3 / 17.7 / 12.8 / 8.2 / 0.1 / 1.9
40.5 / 46.3 / 1.7 / 1.3 / 8.5 / 1.7
58.3 / 17.6 / 14.4 / 7.3 / 0.3 / 2.1
65.3 / 8.4 / 21.2 / 2.2 / 1.1 / 1.8
88.9 / 2.0 / 1.1 / 1.0 / 5.3 / 1.6
81.1 / 3.1 / 12.0 / 1.7 / 0.2 / 1.9
68.7 / 8.9 / 7.3 / 1.7 / 8.2 / 5.3
78.5 / 11.7 / 1.7 / 3.6 / 1.1 / 3.3
79.5 / 5.7 / 10.4 / 2.7 / 0.1 / 1.6
76.4 / 12.4 / 4.9 / 2.8 / 0.4 / 3.1
64.1 / 5.1 / 27.7 / 1.3 / 0.4 / 1.6
84.7 / 2.7 / 1.2 / 0.9 / 8.5 / 1.9
75.6 / 4.6 / 16.5 / 1.4 / 0.3 / 1.6
45.3 / 37.6 / 11.5 / 3.8 / 0.3 / 1.5
80.4 / 13.0 / 0.9 / 2.0 / 1.0 / 2.8
94.3 / 1.5 / 0.9 / 1.3 / 0.3 / 1.7
64.8 / 7.9 / 19.0 / 5.5 / 0.3 / 2.5
72.5 / 11.2 / 3.4 / 7.1 / 1.3 / 4.4
93.2 / 1.2 / 3.4 / 0.7 / 0.2 / 1.4
83.3 / 5.9 / 6.2 / 2.3 / 0.9 / 1.5
85.9 / 8.9 / 0.8 / 0.8 / 2.1 / 1.6

INDEPENDENT VARIABLES HEALTH/WELLNESS

Smoking (% age 18 and older) / Binge Drinking (% adults in past 30 days) / Diabetes (% age 18 and older) / Obesity (% age 20 and older) / Child Immunization Rate (%)
24.3 / 13.7 / 11.2 / 32.0 / 83.1
22.9 / 20.8 / 6.7 / 27.4 / 79.2
19.3 / 17.6 / 7.8 / 25.1 / 84.6
27.0 / 14.1 / 9.5 / 30.9 / 81.4
13.7 / 18.6 / 8.5 / 23.8 / 86.8
18.3 / 20.1 / 6.0 / 20.7 / 86.5
17.1 / 17.9 / 6.8 / 24.5 / 88.2
21.8 / 20.3 / 8.3 / 28.8 / 84.3
20.8 / 25 / 8.0 / 23.8 / 84.6
19.3 / 17.1 / 9.5 / 26.6 / 88.5
21.2 / 16.6 / 9.9 / 28.0 / 79.0
16.8 / 21.5 / 8.2 / 21.9 / 81.5
17.2 / 16.6 / 7.0 / 27.1 / 77.6
20.9 / 23 / 8.3 / 27.1 / 82.2
25.6 / 17.8 / 9.6 / 30.8 / 85.3
20.4 / 23.1 / 7.0 / 29.0 / 84.2
22.0 / 17 / 8.1 / 29.6 / 85.7
29.0 / 16.1 / 9.9 / 30.4 / 86.0
25.7 / 16.1 / 10.7 / 33.4 / 87.7
22.8 / 17.3 / 8.3 / 27.8 / 90.3
19.1 / 18 / 8.7 / 28.3 / 89.1
18.2 / 20.6 / 7.2 / 22.7 / 87.2
23.3 / 19.7 / 9.1 / 31.3 / 86.4
19.1 / 22.1 / 5.9 / 25.7 / 87.3
26.0 / 14.2 / 11.3 / 34.9 / 82.4
25.0 / 19.2 / 9.1 / 30.3 / 82.0
22.1 / 20.8 / 6.5 / 24.6 / 74.4
20.0 / 22.7 / 7.8 / 28.4 / 84.9
22.9 / 18.6 / 8.6 / 24.5 / 76.0
19.4 / 18.7 / 7.2 / 26.2 / 90.0
16.8 / 18.2 / 8.4 / 23.7 / 80.6
21.5 / 16.4 / 7.9 / 26.3 / 85.2
18.1 / 19.6 / 8.4 / 24.5 / 84.4
21.8 / 15.2 / 9.3 / 29.1 / 84.1
21.9 / 23.8 / 7.6 / 27.8 / 81.0
25.1 / 20.1 / 9.9 / 29.7 / 86.1
26.1 / 16.5 / 10.1 / 31.1 / 78.7
19.7 / 16.5 / 6.9 / 26.7 / 79.7
22.4 / 18.3 / 8.8 / 28.6 / 88.1
20.0 / 19.7 / 7.4 / 25.4 / 88.4
23.1 / 15.4 / 10.1 / 30.8 / 84.7
23.0 / 22.1 / 6.6 / 28.1 / 84.3
23.0 / 10 / 10.4 / 29.2 / 87.7
19.2 / 18.9 / 9.7 / 30.4 / 83.0
11.8 / 12 / 6.1 / 24.4 / 83.1
19.1 / 18.5 / 6.4 / 25.4 / 79.8
20.9 / 17.9 / 7.9 / 29.2 / 80.3
17.5 / 17.8 / 6.9 / 26.5 / 82.7
28.6 / 10.1 / 11.9 / 32.4 / 84.8
20.9 / 24.3 / 7.2 / 27.7 / 88.2
23.0 / 18.9 / 7.4 / 25.0 / 73.7

1