Econ 301 Project 2

profilexbd1997
Researchquestions11lou.xlsx
Home>Mathematics homework help>Statistics homework help>Econ 301 Project 2

Q1 crime

Year Robbery
1976 95718
1977 84703
1978 83785 Robbery
1979 93471
1980 112273 Mean 76368.6875 How the rate of robbries in New york has changed over the years?
1981 120344 Median 88161.5
1982 107843 Sample Variance 888819778.737903
1983 94783 Skewness -0.3286775756
1984 89900 Range 89250
1985 89706
1986 91360
1987 89721
1988 97434 So the mean value of Robbries in Texas is 76368 From 1976 to 2007
1989 103983
1990 112380
1991 112342
1992 108154
1993 102122
1994 86617
1995 72492
1996 61822
1997 56094
1998 49125
1999 43821
2000 40539
2001 36555
2002 36653
2003 35790
2004 33506
2005 35179
2006 34489
2007 31094
https://portal.ct.gov/-/media/OPM/CJPPD/CjResearch/ProjectsORTrash/CrimeStatistcs/20080923CrimeInUS2007xls.xls?la=en

Robberies in Newyork

Robbery 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 95718 84703 83785 93471 112273 120344 107843 94783 89900 89706 91360 89721 97434 103983 112380 112342 108154 102122 86617 72492 61822 56094 49125 43821 40539 36555 36653 35790 33506 35179 34489 31094

Q2 crime

City Violent crime
Abernathy 4
Abilene 648 What was average of Voilent crimes in Texas in 2008?
Addison 94
Alamo 98 Mean 316
Alamo Heights 11 Standard deviation 822.8016744973
Alice 181
Allen 66
Alpine 12
Alto 5
Alton 21 It shows that average of 316 voilent crimes cases were witnessed In Texas in 2008
Alvarado 15
Alvin 65
Amarillo 1,474
Andrews 51
Angleton 86
Anna 3
Anson 6
Anthony 29
Aransas Pass 39
Arcola 6
Argyle 3
Arlington 2,262
Arp 0
Athens 66
Atlanta 40
Austin 3,935
Azle 45
Baird 0
Balch Springs 175
Balcones Heights 42
https://www2.fbi.gov/ucr/cius2008/documents/cius2008datatables.zip

Line Chart

Abernathy Abilene Addison Alamo Alamo Heights Alice Allen Alpine Alto Alton Alvarado Alvin Amarillo Andrews Angleton Anna Anson Anthony

Abernathy Abilene Addison Alamo Alamo Heights Alice Allen Alpine Alto Alton Alvarado Alvin Amarillo Andrews Angleton Anna Anson Anthony 4 648 94 98 11 181 66 12 5 21 15 65 1474 51 86 3 6 29

https://www2.fbi.gov/ucr/cius2008/documents/cius2008datatables.zip

Q1 health

YEAR STATE RATE DEATHS Bin
2017 AL 12.9 602 2
2017 AK 10.6 78 4 Quintiles
2017 AZ 6.6 441 6 Upper quintile 592.2 What is Ratio of death rates in different states of U.S in 2007?
2017 AR 9.8 278 8 Lower Quintile 43.6
2017 CA 5.1 2,022 10 90% Percentile 753.2 The upper quintile shows the 80% of data set While the Lower quintile shows the 20% of data set.
2017 CO 4.6 261 12
2017 CT 3.2 109 14
2017 DE 6.9 63 16 Bin Frequency
2017 FL 6.4 1,269 2 32
2017 GA 7.9 810 4 63
2017 HI 2.5 35 6 52
2017 ID 3 50 8 64
2017 IL 9 1,120 10 21
2017 IN 7.2 456 12 11
2017 IA 3.4 104 14 5
2017 KS 6.5 185 16 2
2017 KY 7.3 310 More 0
2017 LA 14.4 653
2017 ME 0 19
2017 MD 10.2 587
2017 MA 2.6 171
2017 MI 6.3 588
2017 MN 2.2 122
2017 MS 12.7 360
2017 MO 11.3 655
2017 MT 4.3 42
2017 NE 2.7 50
2017 NV 7.6 221
2017 NH 0 17
2017 NJ 4.1 352
2017 NM 8.5 173
2017 NY 3 577
2017 NC 6.9 679
2017 ND 0 15
2017 OH 7.5 828
2017 OK 8.5 318
2017 OR 3.1 127
2017 PA 6.6 791
2017 RI 0 19
2017 SC 9.3 444
2017 SD 4.2 34
2017 TN 8.8 557
2017 TX 5.8 1,653
2017 UT 2.6 79
2017 VT 0 15
2017 VA 5.4 455
2017 WA 3.6 266
2017 WV 6.5 112
2017 WI 3.7 202
2017 WY 0 19
2016 AL 11.8 544
2016 AK 7.3 54
2016 AZ 6.3 420
2016 AR 8.7 248
2016 CA 5.3 2,074
2016 CO 4.3 235
2016 CT 2.7 88
2016 DE 7 63
2016 FL 6.8 1,294
2016 GA 7.9 806
2016 HI 2.8 39
2016 ID 1.9 30
2016 IL 9.2 1,157
2016 IN 7.6 480
2016 IA 2.8 85
2016 KS 5.3 147
2016 KY 7.2 302
2016 LA 14.3 648
2016 ME 0 19
2016 MD 10.1 579
2016 MA 2.1 137
2016 MI 6.7 624
2016 MN 2.4 129
2016 MS 12.1 345
2016 MO 9.9 570
2016 MT 4.3 42
2016 NE 3.3 60
2016 NV 7.4 211
2016 NH 0 18
2016 NJ 4.6 395
2016 NM 9.4 185
2016 NY 3.6 696
2016 NC 7.4 735
2016 ND 0 17
2016 OH 6.5 721
2016 OK 8.6 322
2016 OR 3.3 129
2016 PA 6 723
2016 RI 2.3 25
2016 SC 9 426
2016 SD 4.7 38
2016 TN 8.8 563
2016 TX 6 1,669
2016 UT 2.5 80
2016 VT 0 11
2016 VA 5.5 455
2016 WA 2.9 216
2016 WV 6.3 108
2016 WI 4.8 256
2016 WY 0 17
2015 AL 10.2 473
2015 AK 8 62
2015 AZ 5.5 364
2015 AR 7.4 217
2015 CA 5 1,987
2015 CO 3.7 206
2015 CT 3.6 124
2015 DE 7.5 65
2015 FL 6.3 1,208
2015 GA 7.3 738
2015 HI 2.2 31
2015 ID 2 33
2015 IL 6.9 863
2015 IN 6 389
2015 IA 2.5 73
2015 KS 4.7 132
2015 KY 5.8 250
2015 LA 12.4 569
2015 ME 1.7 22
2015 MD 10.3 596
2015 MA 2.1 144
2015 MI 6.4 597
2015 MN 2.8 147
2015 MS 11.3 325
2015 MO 9.6 547
2015 MT 4 38
2015 NE 4 75
2015 NV 6.7 191
2015 NH 0 18
2015 NJ 4.5 388
2015 NM 8 157
2015 NY 3.4 671
2015 NC 6.1 593
2015 ND 3.1 22
2015 OH 6 669
2015 OK 8.5 324
2015 OR 3.4 138
2015 PA 5.6 673
2015 RI 2.8 28
2015 SC 9.5 448
2015 SD 4.2 35
2015 TN 7.2 460
2015 TX 5.6 1,538
2015 UT 2 60
2015 VT 0 16
2015 VA 4.5 374
2015 WA 3.4 239
2015 WV 4.5 80
2015 WI 4.5 243
2015 WY 0 17
2014 AL 8.1 374
2014 AK 4.7 37
2014 AZ 5 322
2014 AR 7.7 217
2014 CA 4.6 1,813
2014 CO 3.3 177
2014 CT 2.9 100
2014 DE 6.6 57
2014 FL 6.2 1,159
2014 GA 6.6 658
2014 HI 2.2 30
2014 ID 2.4 36
2014 IL 6.2 792
2014 IN 5.7 364
2014 IA 2.5 78
2014 KS 3.6 104
2014 KY 4.7 203
2014 LA 11.7 538
2014 ME 2 23
2014 MD 6.7 387
2014 MA 2 133
2014 MI 6.3 589
2014 MN 1.9 101
2014 MS 11.4 332
2014 MO 7.5 441
2014 MT 2.9 30
2014 NE 3.4 63
2014 NV 6.3 176
2014 NH 0 17
2014 NJ 4.4 372
2014 NM 6.8 135
2014 NY 3.4 662
2014 NC 5.6 551
2014 ND 0 15
2014 OH 5.2 578
2014 OK 6.6 250
2014 OR 2.4 99
2014 PA 5.2 620
2014 RI 2.5 27
2014 SC 7.6 363
2014 SD 3.1 26
2014 TN 6.5 417
2014 TX 5.2 1,389
2014 UT 2 61
2014 VT 0 16
2014 VA 4.1 339
2014 WA 3.1 211
2014 WV 5.9 103
2014 WI 3 166
2014 WY 4.4 24
2005 AL 9.6 433
2005 AK 5.2 37
2005 AZ 9 532
2005 AR 8 219
2005 CA 6.9 2,540
2005 CO 3.8 182
2005 CT 3.2 107
2005 DE 6.6 55
2005 FL 5.8 998
2005 GA 7.1 649
2005 HI 1.9 25
2005 ID 3.2 45
2005 IL 6.8 866
2005 IN 5.9 368
2005 IA 1.6 44
2005 KS 3.9 106
2005 KY 5.4 222
2005 LA 12.8 592
2005 ME 1.7 22
2005 MD 10.4 576
2005 MA 2.8 178
2005 MI 6.9 677
2005 MN 2.7 139
2005 MS 9 254
2005 MO 7.3 417
2005 MT 3.4 33
2005 NE 2.5 44
2005 NV 7.8 190
2005 NH 0 19
2005 NJ 5.1 427
2005 NM 7.9 152
2005 NY 4.7 901
2005 NC 7.6 661
2005 ND 0 11
2005 OH 5.6 630
2005 OK 6.1 214
2005 OR 2.9 102
2005 PA 6.3 749
2005 RI 3.1 32
2005 SC 7.9 337
2005 SD 2.9 22
2005 TN 8.3 495
2005 TX 6.5 1,501
2005 UT 2.4 63
2005 VT 0 12
2005 VA 6.4 490
2005 WA 3.6 231
2005 WV 5.4 93
2005 WI 4.3 236
2005 WY 0 16
blob:https://www.cdc.gov/2d8cec3d-990a-480e-aa69-7326c8178ece

Histogram

Frequency 2 4 6 8 10 12 14 16 More 32 63 52 64 21 11 5 2 0

Bin

Frequency

Q2 health

Year Stomach Pancreas† Mean Standard Deviation Coefficient of variation %
1970 14.5 14.0 14.3 0.32 2.26
1971 13.8 13.7 13.8 0.10 0.71 What is Comparison of Stomach and Pancreas† cancer rates from 1970 to 2014?
1972 13.4 13.4 13.4 0.03 0.26
1973 13.0 14.0 13.5 0.68 5.04
1974 12.7 13.4 13.1 0.47 3.60
1975 12.2 13.8 13.0 1.09 8.36
1976 12.0 13.6 12.8 1.14 8.95
1977 11.5 13.8 12.6 1.69 13.34
1978 11.0 13.6 12.3 1.85 15.00
1979 11.0 13.4 12.2 1.70 14.00
1980 10.6 13.2 11.9 1.80 15.09
1981 10.6 13.2 11.9 1.83 15.38
1982 10.3 13.1 11.7 1.98 16.96
1983 9.9 12.8 11.4 2.07 18.22
1984 9.9 13.0 11.4 2.17 19.01
1985 9.5 12.9 11.2 2.35 20.98
1986 9.4 12.5 10.9 2.13 19.48
1987 9.1 12.5 10.8 2.41 22.28
1988 8.8 12.5 10.7 2.61 24.49
1989 9.2 12.6 10.9 2.42 22.25
1990 8.9 12.6 10.8 2.62 24.34
1991 8.9 12.6 10.8 2.62 24.34
1992 8.1 12.6 10.4 3.18 30.74
1993 8.2 12.4 10.3 2.97 28.83 The higher the coefficient of variation, the greater the level of dispersion around the mean
1994 7.9 12.4 10.2 3.18 31.35
1995 7.7 12.1 9.9 3.11 31.43
1996 7.4 12.1 9.8 3.32 34.09
1997 7.2 12.2 9.7 3.54 36.45
1998 6.8 12.3 9.6 3.89 40.72
1999 6.6 12.3 9.5 4.03 42.65
2000 6.4 12.1 9.3 4.03 43.57
2001 6.1 12.2 9.2 4.31 47.14
2002 6.0 12.2 9.1 4.38 48.18
2003 5.7 12.1 8.9 4.53 50.85
2004 5.6 12.4 9.0 4.81 53.43
2005 5.3 12.4 8.9 5.02 56.73
2006 5.1 12.4 8.8 5.16 58.99
2007 5.0 12.6 8.8 5.37 61.07
2008 4.9 12.5 8.7 5.37 61.77
2009 4.7 12.4 8.6 5.44 63.68
2010 4.6 12.7 8.7 5.73 66.21
2011 4.4 12.5 8.5 5.73 67.78
2012 4.3 12.6 8.5 5.87 69.46
2013 4.3 12.4 8.4 5.73 68.59
2014 4.2 12.6 8.4 5.94 70.71
https://www.cancer.org/content/dam/cancer-org/research/cancer-facts-and-statistics/annual-cancer-facts-and-figures/2017/age-adjusted-cancer-death-rates-males-1930-2014.xlsx
Stomach 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 14.4864649338908 13.8406660105135 13.357349737247 12.9937667650313 12.7244330583482 12.219131880545 11.9605063662385 11.4537995190651 11.007063254383 10.9632109406008 10.6317953790959 10.5801102578666 10.2634372969467 9.89760516288597 9.89126788224623 9.53728338759035 9.44105940253992 9.11332275821161 8.81345560633988 9.17854564217344 8.9 8.9 8.1 8.2 7.9 7.7 7.4 7.2 6.8 6.6 6.4 6.1 6 5.7 5.6 5.3 5.1 5 4.9 4.7 4.6 4.4 4.3 4.3 4.2 Pancreas† 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 198 2 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 14.0314453685868 13.7024577935073 13.4061625910781 13.9545782637175 13.3896407105802 13.7547819837176 13.5760516040646 13.8402122627897 13.6200144500439 13.3717775199017 13.171467520149 13.1630926614562 13.0607693492904 12.8247786010728 12.96352 51446015 12.8603665346504 12.457169287532 12.5226566672073 12.5058795774546 12.6059697097624 12.6 12.6 12.6 12.4 12.4 12.1 12.1 12.2 12.3 12.3 12.1 12.2 12.2 12.1 12.4 12.4 12.4 12.6 12.5 12.4 12.7 12.5 12.6 12.4 12.6

Q1 education

State Area name Less than a high school diploma, 1970 High school diploma only, 1970 Some college (1-3 years), 1970 Four years of college or higher, 1970
US United States 52,373,312 34,158,051 11,650,730 11,717,266
AL Alabama 1,062,306 468,269 136,287 141,936 What was Educational attainment of U.S in 1970?
AL Autauga County 6,611 3,757 933 767
AL Baldwin County 18,726 8,426 2,334 2,038
AL Barbour County 8,120 2,242 581 861
AL Bibb County 5,272 1,402 238 302
AL Blount County 10,677 3,440 626 404
AL Bullock County 4,245 958 305 314
AL Butler County 8,353 2,459 499 541
AL Calhoun County 30,535 13,804 3,823 3,921 United states
AL Chambers County 13,616 4,816 927 847 Mean 27474839.75
AL Cherokee County 6,126 1,878 440 329 Median 22937658.5
AL Chilton County 10,285 2,805 538 415 Skewness 0.6861404108
AL Choctaw County 5,720 1,922 378 362 Range 40722582
AL Clarke County 8,459 3,485 800 738
AL Clay County 4,784 1,719 345 311
AL Cleburne County 4,431 1,198 272 162
AL Coffee County 10,790 4,861 1,332 1,040
AL Colbert County 15,050 7,986 2,151 1,554
AL Conecuh County 5,889 1,709 332 342
AL Coosa County 3,983 1,260 269 196
AL Covington County 13,470 4,333 1,014 918
AL Crenshaw County 5,595 1,295 385 296
AL Cullman County 20,137 6,244 1,405 1,113
AL Dale County 9,412 7,274 2,511 1,895
AL Dallas County 15,421 6,357 2,219 2,329
AL DeKalb County 17,375 4,853 861 884
AL Elmore County 11,066 4,755 1,063 967
AL Escambia County 12,205 4,721 836 886
AL Etowah County 31,249 14,834 3,927 2,765
AL Fayette County 6,552 2,043 438 360
AL Franklin County 9,158 3,413 558 467
AL Geneva County 8,446 2,921 486 554
AL Greene County 3,879 753 328 342
AL Hale County 5,803 1,322 309 391
AL Henry County 5,087 1,456 353 349
AL Houston County 17,385 8,637 2,189 2,133
AL Jackson County 15,217 4,476 877 716
AL Jefferson County 186,882 101,656 32,182 33,827
AL Lamar County 6,105 1,522 350 284
AL Lauderdale County 20,423 10,109 2,924 3,016
AL Lawrence County 9,757 3,115 485 328
AL Lee County 13,597 5,933 2,498 4,386
AL Limestone County 13,226 5,239 1,411 1,309
AL Lowndes County 4,077 919 272 275
AL Macon County 7,510 1,937 1,045 1,810
AL Madison County 34,090 28,255 12,537 17,289
AL Marengo County 7,786 2,557 757 761
AL Marion County 9,771 2,937 448 484
AL Marshall County 19,838 6,898 1,791 1,573
AL Mobile County 92,179 43,792 12,675 12,072
AL Monroe County 7,137 2,314 544 604
AL Montgomery County 39,981 26,418 10,034 11,119
AL Morgan County 22,039 11,946 3,403 3,418
https://www.ers.usda.gov/webdocs/DataFiles/48747/Education.xls?v=1754.5

United States Less than a high school diploma, 1970 High school diploma only, 1970 Some college (1-3 years), 1970 Four years of college or higher, 1970 52373312 34158051 11650730 11717266

https://www.ers.usda.gov/webdocs/DataFiles/48747/Education.xls?v=1754.5

Q2 Education

All Races Educational Attainment
Bachelor's degree Master's degree
Both Sexes
.18 years and over 49,368 20,797 Varience 1 z-Test: Two Sample for Means
..18 to 24 years 3,105 205 126,729,065 Is there any difference in Number of Becholar’s and Masters degree holders in U.S?
.25 years and over 46,262 20,592 Varience 2 Variable 1 Variable 2
..25 to 29 years 6,028 1,675 23985803.2590012 Mean 6904.6666666667 2961.2380952381
..30 to 34 years 5,356 2,197 Known Variance 126729065 23985803.26
..35 to 39 years 4,984 2,438 Observations 42 42
..40 to 44 years 4,622 2,273 Hypothesized Mean Difference 0
..45 to 49 years 4,612 2,198 z 2.0817116601
..50 to 54 years 4,247 1,937 P(Z<=z) one-tail 0.0186844075
..55 to 59 years 4,235 1,715 z Critical one-tail 1.644853627
..60 to 64 years 3,658 1,859 P(Z<=z) two-tail 0.0373688149
..65 to 69 years 3,295 1,707 z Critical two-tail 1.9599639845
..70 to 74 years 2,308 1,247
..75 years and over 2,918 1,346
Male As we can see Z value is < 0.05, SO Null Hypothesis is rejected. And we can conclude Mean values of both samples are different.
.18 years and over 23,223 9,117
..18 to 24 years 1,317 68
.25 years and over 21,906 9,049
..25 to 29 years 2,765 706
..30 to 34 years 2,492 903
..35 to 39 years 2,335 935
..40 to 44 years 2,134 959
..45 to 49 years 2,155 965
..50 to 54 years 1,996 878
..55 to 59 years 2,004 744
..60 to 64 years 1,703 856
..65 to 69 years 1,692 812
..70 to 74 years 1,180 606
..75 years and over 1,450 686
Female
.18 years and over 26,145 11,680
..18 to 24 years 1,788 137
.25 years and over 24,357 11,543
..25 to 29 years 3,264 969
..30 to 34 years 2,864 1,294
..35 to 39 years 2,650 1,503
..40 to 44 years 2,487 1,315
..45 to 49 years 2,456 1,233
..50 to 54 years 2,251 1,058
..55 to 59 years 2,231 971
..60 to 64 years 1,954 1,003
..65 to 69 years 1,603 895
..70 to 74 years 1,128 641
..75 years and over 1,468 660
https://www2.census.gov/programs-surveys/demo/tables/educational-attainment/2017/cps-detailed-tables/table-1-1.xlsx

Bachelor's degree 49368 3105 46262 6028 5356 4984 4622 4612 4247 4235 3658 3295 2308 2918 23223 1317 21906 2765 2492 2335 2134 2155 1996 2004 1703 1692 1180 1450 26145 1788 24357 3264 2864 2650 2487 2456 2251 2231 1954 1603 1128 1468 Master's degree 20797 205 20592 1675 2197 2438 2273 2198 1937 1715 1859 1707 1247 1346 9117 68 9049 706 903 935 959 965 878 744 856 812 606 686 11680 137 11543 969 1294 1503 1315 1233 1058 971 1003 895 641 660

https://www2.census.gov/programs-surveys/demo/tables/educational-attainment/2017/cps-detailed-tables/table-1-1.xlsx