Are the New York City and Pittsburgh meanweek 7excess death rates significantly different?
Calculate a 95% confidence interval for the difference mu(NYC)- mu(PITT). Assume n(NYC) = 50, n(Pitt) = 35, s(NYC) = 239, s(Pitt) = 214.Use 1 decimal place.
lower bound of confidence interval=??
AutoSave OFF 3Pandemic Flu GIS (2) Q Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Calibri (Body) v 11 AA = ab Wrap Text General Insert v Ex AP- O. x Delete v Paste BIUV DV Av Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data X V fx Conditional Formatting D G H M N 0 Q U V w Z AA AB From Table B in Collins, S. D., Frost, W. H., Gover, M. & Sydenstricker, E. Mortality from Influenza and Pneumonia in 50 Large Cities of the United States 1910-1929. Public Health Reports 45, 2277-2328 (1930) excess weekly latitude longitude city week ending week number death rate (annual basis) 41.795342 87.626953 CHICAGO 14-Sep-1918 -53 41.795342 -87.626954 CHICAG 21-Sep-191 -50 41.795342 -87.626955 CHICAGO 28-Sep-1918 77 10 -87.626956 CHICAGO 5-Oct-1918 720 11 41.795342 -87.626957 CHICAGO 12-Oct-1918 1967 12 41.795342 -87.626958 CHICAGO 19-Oct-1918 4063 3 41.795342 -87.626959 CHICAGO 26-Oct-1918 4573 14 42.855565 -78.903809 BUFFALO 14-Sep-1918 13 15 42.855565 -78.90381 BUFFALO 21-Sep-1918 51 16 42.855565 -78.903811 BUFFALO 28-Sep-1918 89 17 42.855565 -78.903812 BUFFALO 5-Oct-1918 422 18 42.855565 -78.903813 BUFFALO 12-Oct-1918 1809 19 42.855565 -78.903814 BUFFALO 19-Oct-1918 5506 20 -78.903815 BUFFALO 26-Oct-1918 7544 21 40.709514 -74.025879 NEW YORK 4-Sep-1918 -24 22 -74.02588 NEW YORK 21-Sep-1918 6 23 40.709514 -74.025881 NEW YORK 28-Sep-1918 83 24 40.709514 -74.025882 NEW YORK 5-Oct-1918 592 25 40.709514 -74.025883 NEW YORK 2-Oct-1918 1904 26 40.709514 -74.025884 NEW YORK 19-Oct-1918 3896 27 -74.025885 NEW YORK 26-Oct-1918 4830 28 36.168627 -86.77002 NASHVILLE 4-Sep-1918 23 29 36.168627 -86.770021 NASHVILLE 1-Sep-1918 40 30 36. 168627 -86.770022 NASHVILLE 28-Sep-1918 48 31 36.168627 -86.770023 NASHVILLE 5-Oct-1918 128 32 36.168627 -86.770024 NASHVILLE 12-Oct-1918 3650 33 36.168627 -86.770025 NASHVILLE 8494 34 19-Oct-1918 -86.770026 NASHVILLE 26-Oct-1918 OUT D WN H V Q UI P W N H 36. 168627 5531 35 -80.024414 PITTSBURGH 14-Sep-1918 -15 36 40.409035 -80.024415 PITTSBURGH 1-Sep-191 18 37 40.409035 -80.024416 PITTSBURGH 28-Sep-1918 153 38 40.409035 -80.024417 PITTSBURGH 5 -Oct - 1918 445 39 40.409035 -80.024418 PITTSBURGH 12-Oct-1918 829 40 40.409035 -80.024419 PITTSBURGH 19-Oct-1918 3280 41 40.409035 -80.02442 PITTSBURGH 26-Oct-1918 4940 42 -90.065918 NEW ORLEANS 14-Sep-1918 -22 43 29.892726 -90.065919 NEW ORLEANS 1-Sep-191 -30 44 29.892726 VOUDWNH YOU -90.06592 NEW ORLEANS 28-Sep-1918 - 54 45 29.892726 -90.065921 NEW ORLEANS 5-Oct-1918 296 46 29.892726 -90.065922 NEW ORLEANS 12-Oct-1918 1865 47 -90.065923 NEW ORLEANS 19-Oct-1918 8441 48 -90.065924 NEW ORLEANS 26-Oct-1918 9218 49 50 51 52 53 54 55 56 D Sheet1 + Ready Average: 1768.718555 Count: 260 Sum: 371430.8966 + 80%
