Economics_Project_DUE_ppp_working___AAAA.xlsx
INFANT MORT
Don't use plagiarized sources. Get Your Custom Essay on
44
Just from $13/Page
AL |
ITY
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
1. Have infant mortality rates have decreased in United
| State |
s since
| 1950 |
?”,
Statistical Metrics |
|
| Year |
Infant Mortality Rate |
Mean |
1950
| 31.951 |
Median |
|
| 1951 |
31.355 |
Sample Variance |
|
| 1952 |
30.758 |
Standard deviation |
|
| 1953 |
30.162 |
Coeffecient of Variation |
|
| 1954 |
29.566 |
|
| 1955 |
28.969 |
|
| 1956 |
28.373 |
|
| 1957 |
27.776 |
|
| 1958 |
27.18 |
|
| 1959 |
26.772 |
|
| 1960 |
26.364 |
|
| 1961 |
25.955 |
|
| 1962 |
25.547 |
|
| 1963 |
| 25.1 |
39
|
| 1964 |
24.577 |
|
| 1965 |
24.016 |
|
| 1966 |
23.454 |
|
| 1967 |
22.893 |
|
| 1968 |
22.331 |
|
| 1969 |
21.428 |
|
| 1970 |
| 20.5 |
24
|
| 1971 |
19.621 |
|
| 1972 |
18.717 |
|
| 1973 |
| 17.8 |
14
|
| 1974 |
17.066 |
|
| 1975 |
16.317 |
|
| 1976 |
15.569 |
|
| 1977 |
14.82 |
|
| 1978 |
14.072 |
|
| 1979 |
13.544 |
|
| 1980 |
13.016 |
|
| 1981 |
12.487 |
|
| 1982 |
11.959 |
|
| 1983 |
11.431 |
|
| 1984 |
11.2 |
|
| 1985 |
10.968 |
|
| 1986 |
10.737 |
|
| 1987 |
10.505 |
|
| 1988 |
10.274 |
|
| 1989 |
9.954 |
|
| 1990 |
9.634 |
|
| 1991 |
9.314 |
|
| 1992 |
8.994 |
|
| 1993 |
8.674 |
|
| 1994 |
8.428 |
|
| 1995 |
8.182 |
|
| 1996 |
7.935 |
|
| 1997 |
7.689 |
|
| 1998 |
7.443 |
|
| 1999 |
7.353 |
|
| 2000 |
7.263 |
|
| 2001 |
7.173 |
|
| 2002 |
7.083 |
|
| 2003 |
6.993 |
|
| 2004 |
6.951 |
|
| 2005 |
6.909 |
|
| 2006 |
6.868 |
|
| 2007 |
6.826 |
|
| 2008 |
6.784 |
|
| 2009 |
6.619 |
|
| 2010 |
6.454 |
|
| 2011 |
6.289 |
|
| 2012 |
6.124 |
|
| 2013 |
5.959 |
|
| 2014 |
5.93 |
|
| 2015 |
5.901 |
|
| 2016 |
5.873 |
|
| 2017 |
5.844 |
|
| 2018 |
5.815 |
|
| 2019 |
5.748 |
sources |
https://www.macrotrends.net/countries/USA/united-states/infant-mortality-rate |
https://www.macrotrends.net/countries/USA/united-states/infant-mortality-rate
Sheet1
| 2.Has the life expectancy increased in United States since 1950?”, |
Year
| Life Expectancy from Birth (Years) |
1950
|
| 68.1 |
4
1951
|
| 68.3 |
3
1952
| 68.52 |
1953
|
|
| 68.7 |
1
1954
|
| 68.9 |
1955
| 69.09 |
1956
| 69.28 |
1957
| 69.47 |
1958
| 69.66 |
1959
| 69.75 |
1960
| 69.84 |
1961
| 69.93 |
1962
| 70.02 |
1963
| 70.11 |
1964
| 70.16 |
1965
| 70.21 |
1966
| 70.26 |
1967
|
| 70.3 |
1
1968
| 70.36 |
1969
|
| 70.5 |
72
1970
|
| 70.7 |
84
1971
| 70.996 |
1972
| 71.208 |
1973
| 71.42 |
1974
| 71.786 |
1975
| 72.152 |
1976
| 72.518 |
1977
| 72.884 |
1978
| 73.25 |
1979
|
| 73.4 |
74
1980
| 73.698 |
1981
| 73.922 |
1982
| 74.146 |
1983
| 74.37 |
1984
|
| 74.4 |
74
1985
| 74.578 |
1986
| 74.682 |
1987
| 74.786 |
1988
| 74.89 |
1989
|
| 75.0 |
42
1990
| 75.194 |
1991
|
| 75.3 |
46
1992
|
|
| 75.4 |
98
1993
| 75.65 |
1994
| 75.814 |
1995
| 75.978 |
1996
| 76.142 |
1997
| 76.306 |
1998
| 76.47 |
1999
| 76.612 |
2000
| 76.754 |
2001
| 76.896 |
2002
|
| 77.0 |
38
2003
| 77.18 |
2004
| 77.382 |
2005
| 77.584 |
2006
|
| 77.7 |
86
2007
| 77.988 |
2008
| 78.19 |
2009
| 78.34 |
2010
| 78.49 |
2011
| 78.64 |
2012
|
| 78.7 |
9
2013
| 78.94 |
2014
| 78.914 |
2015
| 78.888 |
2016
| 78.862 |
2017
| 78.836 |
2018
| 78.81 |
2019
| 78.87 |
Source |
https://www.macrotrends.net/countries/USA/united-states/life-expectancy |
https://www.cdc.gov/nchs/data/hus/2017/015 |
https://www.macrotrends.net/countries/USA/united-states/life-expectancy
https://www.cdc.gov/nchs/data/hus/2017/015
Completion rate
| Research question |
What was the graduation rate in the 100 largest public elementary and secondary school districts in the United States in the school year 2009-2010?” |
| Public high school |
| Averaged Freshman |
| Agency ID |
Name of reporting district |
State
Graduation Rate5 |
| 3620580 |
| NE |
W YORK CITY PUBLIC
SC |
HOOLS
NY |
66.7 |
| 0622710 |
LOS ANGELES UNIFIED |
|
|
|
|
|
|
|
|
|
| CA |
59.7 |
| 7200030 |
PUERTO RI
|
|
|
| CO |
DE
PA |
RTMENT OF EDUCATION
PR |
| 60.8 |
| 1709930 |
CITY OF C
| HI |
CAGO SD 299
IL |
69.5 |
| 1200390 |
DADE |
|
|
|
|
|
|
|
|
|
|
|
|
| FL |
68.3
| 3200060 |
CLARK COUNTY SCHOOL DISTRICT |
| NV |
56.4 |
| 1200180 |
BROWARD |
FL
| 74.0 |
| 4823640 |
HOUSTON ISD |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TX |
66.2 |
| 1200870 |
HILLSBOROUGH |
FL 70.5
| 1500030 |
HAWAII DEPARTMENT OF EDUCATION |
HI 75.4
| 1201440 |
ORANGE |
FL 68.1
| 1201500 |
PALM BEACH |
FL 78.7
| 5101260 |
FAIRFAX CO PBLC SCHS |
|
|
|
|
| VA |
91.9 |
| 4218990 |
PHILADELPHIA CITY SD |
PA
58.9 |
| 1302550 |
G
| WI |
NNETT COUNTY
|
|
|
|
| GA |
| 71.1 |
| 4816230 |
DALLAS ISD |
TX
61.6 |
| 2400480 |
MONTGOMERY COUNTY PUBLIC SCHOOLS |
|
|
|
|
| MD |
90.8 |
| 3704720 |
W
| AK |
E COUNTY SCHOOLS
|
|
|
| NC |
85.0 |
| 3702970 |
CHARLOTTE-MECKLENBURG SCHOOLS |
NC 70.3
| 0634320 |
SAN DIEGO UNIFIED |
CA 70.7
| 2400510 |
PRINCE GEORGE’S COUNTY PUBLIC SCHOOLS |
MD
70.6 |
| 1200480 |
DUVAL |
FL
61.0 |
| 4702940 |
MEMPHIS |
|
|
| TN |
71.6 |
| 1301290 |
COBB COUNTY |
GA
80.3 |
| 1201560 |
PINELLAS |
FL
66.1 |
| 4816110 |
CYPRESS-FAIRBAN
| KS |
ISD
TX
| 86.0 |
| 2400120 |
BALTIMORE COUNTY PUBLIC SCHOOLS |
MD
84.0 |
| 1301740 |
DEKALB COUNTY |
GA
64.1 |
| 2102990 |
JEFFERSON COUNTY |
KY |
75.0
| 3500060 |
ALBUQUERQUE PUBLIC SCHOOLS |
NM |
64.4 |
| 1201590 |
POLK |
FL
68.4 |
| 4833120 |
NORTHSIDE ISD |
TX
| 81.4 |
| 2612000 |
DETROIT CITY SCHOOL DISTRICT |
MI |
49.6 |
| 1302280 |
FULTON COUNTY |
GA
81.0 |
| 0622500 |
LONG BEACH UNIFIED |
CA 74.0
| 0804800 |
JEFFERSON COUNTY SCHOOL DISTRICT NO. R-1 |
CO
|
| 83.6 |
| 4808940 |
AUSTIN ISD |
TX
72.4 |
| 2400090 |
BALTIMORE CITY PUBLIC SCHOOLS |
MD
61.2 |
| 5509600 |
MILWAUKEE SCHOOL DISTRICT |
WI
64.2 |
| 1201080 |
LEE |
FL
72.3 |
| 4819700 |
FORT WORTH ISD |
TX
65.4 |
| 0803360 |
SCHOOL DISTRICT NO. 1 IN THE COUNTY OF DENVER AND STATE OF C |
CO
63.4 |
| 5103130 |
PRINCE WM CO PBLC SCHS |
VA 83.6
| 0614550 |
FRESNO UNIFIED |
CA 60.8
| 4703180 |
DAVIDSON COUNTY |
TN 75.4
| 2400060 |
ANNE ARUNDEL COUNTY PUBLIC SCHOOLS |
MD
81.8 |
| 3701920 |
GUILFORD COUNTY SCHOOLS |
NC
85.1 |
| 1200150 |
BREVARD |
FL
78.0 |
| 5103840 |
VA BEACH CITY PBLC SCHS |
VA
77.2 |
| 4502310 |
GREENVILLE 01 |
SC
68.2 |
| 4900360 |
GRANITE DISTRICT |
|
|
| UT |
64.6 |
| 4900210 |
DAVIS DISTRICT |
UT
82.4 |
| 4819650 |
FORT BEND ISD |
TX
86.3 |
| 0404970 |
MESA UNIFIED DISTRICT |
| AZ |
68.7
| 1201530 |
PASCO |
FL
67.8 |
| 4900030 |
ALPINE DISTRICT |
UT
79.1 |
| 4832940 |
NORTH EAST ISD |
TX
82.1 |
| 3200480 |
WASHOE COUNTY SCHOOL DISTRICT |
NV
54.0 |
| 1201710 |
SEMINOLE |
FL
77.6 |
| 4808700 |
ARLINGTON ISD |
TX
68.8 |
| 4818300 |
EL PASO ISD |
TX 75.3
| 4807710 |
ALDINE ISD |
TX
62.7 |
| 0102370 |
MOBILE COUNTY |
AL
65.8 |
| 0612330 |
ELK GROVE UNIFIED |
CA
88.3 |
| 1201920 |
VOLUSIA |
FL
65.5 |
| 5102250 |
LOUDOUN CO PBLC SCHS |
VA
96.6 |
| 0803450 |
DOUGLAS COUNTY SCHOOL DISTRICT, NO. RE 1 |
CO
95.0 |
| 5100840 |
CHESTERFIELD CO PBLC SCHS |
VA
87.6 |
| 4825170 |
KATY ISD |
TX
96.7 |
| 4820340 |
GARLAND ISD |
TX 83.6
| 0635310 |
SANTA ANA UNIFIED |
CA 73.4
| 4702220 |
KNOX COUNTY |
TN
81.3 |
| 2502790 |
BOSTON |
MA |
68.7
| 0408800 |
TUCSON UNIFIED DISTRICT |
AZ 68.9
| 4838730 |
SAN ANTONIO ISD |
TX
63.3 |
| 0634410 |
SAN FRANCISCO UNIFIED |
CA
79.5 |
| 4835100 |
PLANO ISD |
TX
86.9 |
| 0634170 |
SAN BERNARDINO CITY UNIFIED |
CA
54.3 |
| 0607440 |
CAPISTRANO UNIFIED |
CA
91.8 |
| 3700011 |
CUMBERLAND COUNTY SCHOOLS |
NC
78.5 |
| 3904380 |
COLUMBUS CITY SCHOOL DISTRICT |
| OH |
57.7 |
| 3701500 |
FORSYTH COUNTY SCHOOLS |
NC
77.8 |
| 4834320 |
PASADENA ISD |
TX 71.1
| 1201470 |
OSCEOLA |
FL 74.4
| 0609850 |
CORONA-NORCO UNIFIED |
CA
95.3 |
| 0802910 |
CHERRY CREEK, SCHOOL DISTRICT NO. 5, IN THE COUNTY OF ARAPAH |
CO
87.3 |
| 4827300 |
LEWISVILLE ISD |
TX 86.0
| 2400420 |
HOWARD COUNTY PUBLIC SCHOOLS |
MD
92.5 |
| 1301230 |
CLAYTON COUNTY |
GA
50.7 |
| 4815000 |
CONROE ISD |
TX
84.3 |
| 0200180 |
ANCHORAGE SCHOOL DISTRICT |
AK 77.7
| 5101890 |
HENRICO CO PBLC SCHS |
VA 81.4
| 4811680 |
BROWNSVILLE ISD |
TX
71.8 |
| 1300120 |
ATLANTA PUBLIC SCHOOLS |
GA
| 58.6 |
| 4900420 |
JORDAN DISTRICT |
UT
47.8 |
| 3174820 |
OMAHA PUBLIC SCHOOLS |
NE 58.6
| 3904378 |
CLEVELAND MUNICIPAL |
OH
45.3 |
| 2012990 |
WICHITA |
KS 77.0
| 4703810 |
SHELBY COUNTY |
TN
80.6 |
| 0614880 |
GARDEN GROVE UNIFIED |
CA
85.2 |
| Data source |
:
https://nces.ed.gov/ccd/tables/2009-10_Dropout_and_completer_data_for_100_LSD_table.asp |
https://nces.ed.gov/ccd/tables/2009-10_Dropout_and_completer_data_for_100_LSD_table.asp
Sheet3
| Research Question |
2. Did all the states have the same student-teacher ratio in the public elementary school in the school year 2007- 08?” |
| State |
Elementary student-Teacher Ratio |
| Alabama |
20.1 |
| Alaska |
22.9 |
| Arizona |
| 18.9 |
| Arkansas |
19.9 |
| California |
20.7 |
| Colorado |
20.8 |
| Connecticut |
| 14.1 |
| Delaware |
| 20.4 |
| Florida |
| 25.3 |
| Georgia |
16.6 |
| Hawaii |
21.2 |
| Idaho |
23.5 |
| Illinois |
25.1
| Indiana |
21.8 |
| Iowa |
17.3 |
| Kansas |
19.5 |
| Kentucky |
20.4
| Louisiana |
| 13.8 |
| Maine |
11.0 |
| Maryland |
15.9 |
| Massachusetts |
13.4 |
| Michigan |
29.3 |
| Minnesota |
| 21.1 |
| Mississippi |
22.2 |
| Missouri |
| 18.0 |
| Montana |
13.8
| Nebraska |
13.7 |
| Nevada |
24.8 |
| New Hampshire |
12.1 |
| New Jersey |
18.8 |
| New Mexico |
14.3 |
| New York |
18.1 |
| North Carolina |
19.4 |
| North Dakota |
12.6 |
| Ohio |
23.8 |
| Oklahoma |
20.0 |
| Oregon |
18.4 |
| Pennsylvania |
18.9
| Rhode Island |
18.0
| South Carolina |
38.6 |
| South Dakota |
14.1
| Tennessee |
14.7 |
| Texas |
21.1
| Utah |
32.9 |
| Vermont |
17.8
| Virginia |
25.3
| Washington |
25.6 |
| West Virginia |
20.5
| Wisconsin |
21.0 |
| Wyoming |
16.4 |
Data source
https://nces.ed.gov/pubs2010/2010309/tables/table_04.asp |
https://nces.ed.gov/pubs2010/2010309/tables/table_04.asp
