44

profileMathStat Genius
Economics_Project_DUE_ppp_working___AAAA.xlsx
Home>Biology homework help>44

INFANT MORTALITY

1. Have infant mortality rates have decreased in United States 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.139
1964 24.577
1965 24.016
1966 23.454
1967 22.893
1968 22.331
1969 21.428
1970 20.524
1971 19.621
1972 18.717
1973 17.814
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.14
1951 68.33
1952 68.52
1953 68.71
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.31
1968 70.36
1969 70.572
1970 70.784
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.474
1980 73.698
1981 73.922
1982 74.146
1983 74.37
1984 74.474
1985 74.578
1986 74.682
1987 74.786
1988 74.89
1989 75.042
1990 75.194
1991 75.346
1992 75.498
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.038
2003 77.18
2004 77.382
2005 77.584
2006 77.786
2007 77.988
2008 78.19
2009 78.34
2010 78.49
2011 78.64
2012 78.79
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.pdf
https://www.macrotrends.net/countries/USA/united-states/life-expectancy https://www.cdc.gov/nchs/data/hus/2017/015.pdf

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 NEW YORK CITY PUBLIC SCHOOLS NY 66.7
0622710 LOS ANGELES UNIFIED CA 59.7
7200030 PUERTO RICO DEPARTMENT OF EDUCATION PR 60.8
1709930 CITY OF CHICAGO 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 GWINNETT COUNTY GA 71.1
4816230 DALLAS ISD TX 61.6
2400480 MONTGOMERY COUNTY PUBLIC SCHOOLS MD 90.8
3704720 WAKE 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-FAIRBANKS 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