Assignment 2

xlsx

School

Humber College *

*We aren’t endorsed by this school

Course

3001

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

Uploaded by SargentBook16495

Assignment 2 Instructions Complete all your work in this Excel file You can add new work sheets Submit your assignment by the start of next week's class Submit your assignment via Blackboard Put your answers in the orange highlighted cells do not touch any cell highlighted green

Problem 1 Green County Population Age Group Deaths Population Expected Deaths 0-4 952 400,000 16% 952.00 5-24 640 1,000,000 41% 640.00 25-44 1,040 500,000 20% 1,040.00 45-64 2,023 250,000 10% 2,023.00 65-74 4,442 200,000 8% 4,442.00 75+ 6,887 100,000 4% 6,887.00 Total 15,984 2,450,000 100% 65 15,984.00 Questions For all questions in this problem, calculate rates per 10,000 1 Calculate the crude death rate for the Green County Population and the Standard Populations 2 Calculate the age-specific death rates for the Green County Population and the Standard Popu 3 Explain why the crude rates are different between the two populations when the age-specific 4 a. The Standardized Mortality Ratio for Green County b. The age-adjusted mortality rate for Green County ANSWERS Question 1 Crude death rates Green County answers 65 101 points 2.5 2.5 score Question 2 Age Specific death rates Age Group Green County 0-4 24 24 5-24 6 6 25-44 21 21 45-64 81 81 65-74 222 222 75+ 689 689 points 5 5 score Question 3 Population Distribution Age Specific Mortality Rate Using the Indirect Standardization method, calculate: Standard Population Standard Population Why are the crude rates different between the two populations when the age-specific rates

points 5 score Question 4 answer a. The Standardized Mortality Ratio for Green County is: 1 b. The age-adjusted mortality rate for Green County is 65 Why are the crude rates different between the two populations when the age-specific rates the same? Answer here: Because they have different size of population, which also lead to different size of death.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Standard Population Age Group Deaths Population 0-4 1,238 520,000 15% 5-24 832 1,300,000 38% 25-44 1,352 650,000 19% 45-64 2,023 250,000 7% 65-74 10,217 460,000 13% 75+ 19,284 280,000 8% Total 34,945 3,460,000 100% 101 ulations rates are the same Population Distribution Age Specific Mortality Rate are

points score 5 5 are

Problem 2 Population Data Study Populations Age Group SOUTH EAST NORTHEAST Atlantis 0 to 4 487,868 119,872 26,540 976,524 5 to 9 492,674 122,502 27,310 993,083 10 to 14 494,474 122,901 27,380 994,174 15 to 19 558,637 135,467 30,968 1,117,480 20 to 24 701,549 163,127 38,138 1,383,867 25 to 29 669,909 157,654 34,791 1,300,640 30 to 34 679,058 160,000 33,607 1,290,434 35 to 39 719,842 166,465 33,447 1,346,293 40 to 44 710,801 163,291 32,012 1,322,211 45 to 49 697,176 164,307 34,182 1,311,939 50 to 54 662,276 166,500 35,870 1,295,596 55 to 59 590,656 153,815 35,783 1,184,094 60 to 64 503,001 138,987 34,682 1,046,331 65 to 69 431,747 123,869 32,613 923,752 70 to 74 398,227 119,363 31,415 870,892 75 to 79 379,326 115,695 30,866 838,748 80 to 84 352,456 115,698 31,876 806,725 85 to 89 253,240 84,798 23,645 586,432 90 Plus 186,417 61,529 16,623 426,651 Total 9,969,334 2,555,840 591,748 20,015,866 Questions For all questions in this problem, calculate rates per 100,000 1 Calculate the crude mortality rate for the SOUTH, EAST, AND NORTHEAST Populations and 2 Calculate the age-specific mortality rates for the SOUTH, EAST, AND NORTHEAST Populatio 3 a. The Standardized Mortality Ratio for SOUTH, EAST, AND NORTHEAST Populations b. The age-adjusted mortality rate for SOUTH, EAST, AND NORTHEAST Populations ANSWERS Question 1 Crude death rates SOUTH EAST NORTHEAST Atlantis answers 239 217 379 244 points 2 2 2 2 score Standard Population Using the Indirect Standardization method, calculate:

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Question 2 Age Specific Mortality Rates Age Group SOUTH EAST NORTHEAST Atlantis 0 to 4 1 1 1 1 5 to 9 0 0 0 0 10 to 14 0 0 0 0 15 to 19 1 1 1 1 20 to 24 1 1 2 1 25 to 29 2 2 2 2 30 to 34 3 2 4 3 35 to 39 7 5 7 6 40 to 44 13 9 14 12 45 to 49 24 17 26 22 50 to 54 46 33 50 41 55 to 59 75 54 81 68 60 to 64 127 92 138 115 65 to 69 197 143 215 179 70 to 74 319 232 348 290 75 to 79 526 382 574 478 80 to 84 1,031 750 1,124 937 85 to 89 2,048 1,490 2,235 1,862 90 Plus 4,891 3,557 5,335 4,446 points 4 4 4 4 score Question 3 Standardized Mortality Ratios and Age Adjusted Mortality Rates SOUTH EAST NORTHEAST Atlantis 1.10 0.80 1.20 1.00 268 195 293 244 points 4 4 4 4 score Standardized Mortality Ratio Age Adjusted Mortality Rate

Deaths from Heart Disease Study Populations Age Group SOUTH EAST NORTHEAST Atlantis 0 to 4 4 1 0 8 5 to 9 1 0 0 2 10 to 14 0 0 0 0 15 to 19 4 1 0 8 20 to 24 10 2 1 18 25 to 29 14 2 1 25 30 to 34 22 4 1 39 35 to 39 48 8 2 82 40 to 44 91 15 4 155 45 to 49 165 28 9 282 50 to 54 302 55 18 536 55 to 59 441 84 29 804 60 to 64 636 128 48 1,203 65 to 69 851 178 70 1,655 70 to 74 1,270 277 109 2,525 75 to 79 1,994 442 177 4,009 80 to 84 3,632 867 358 7,558 85 to 89 5,187 1,263 528 10,921 90 Plus 9,117 2,189 887 18,970 Total 23,792 5,544 2,244 48,799 the Standard Populations ons and the Standard Populations Standard Population

Heart Disease Mortality Rates Study Populations Age Group SOUTH EAST NORTHEAST Atlantis Age Group 0 to 4 1 1 1 1 0 to 4 5 to 9 0 0 0 0 5 to 9 10 to 14 0 0 0 0 10 to 14 15 to 19 1 1 1 1 15 to 19 20 to 24 1 1 2 1 20 to 24 25 to 29 2 2 2 2 25 to 29 30 to 34 3 2 4 3 30 to 34 35 to 39 7 5 7 6 35 to 39 40 to 44 13 9 14 12 40 to 44 45 to 49 24 17 26 22 45 to 49 50 to 54 46 33 50 41 50 to 54 55 to 59 75 54 81 68 55 to 59 60 to 64 127 92 138 115 60 to 64 65 to 69 197 143 215 179 65 to 69 70 to 74 319 232 348 290 70 to 74 75 to 79 526 382 574 478 75 to 79 80 to 84 1,031 750 1,124 937 80 to 84 85 to 89 2,048 1,490 2,235 1,862 85 to 89 90 Plus 4,891 3,557 5,335 4,446 90 Plus Crude Rate Total Standard Population

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Expected at Standard Population Rate Study Populations SOUTH EAST NORTHEAST Atlantis 4 1 0 8 Actual Deaths 1 0 0 2 Expected Deaths 0 0 0 0 SMR 4 1 0 8 Age Adjusted Mortality Rate 9 2 0 18 13 3 1 25 20 5 1 39 44 10 2 82 83 19 4 155 150 35 7 282 274 69 15 536 401 104 24 804 578 160 40 1,203 774 222 58 1,655 1,154 346 91 2,525 1,813 553 148 4,009 3,302 1,084 299 7,558 4,716 1,579 440 10,921 8,288 2,736 739 18,970 21,629 6,930 1,870 48,799 Standard Population

Standardized Mortality Ratios Study Populations SOUTH EAST NORTHEAST Atlantis 23,792 5,544 2,244 48,799 21,629 6,930 1,870 48,799 Standard Population

Problem 3 Population Data Study Populations Age Group CENTRAL SOUTHWEST NORTHWEST Atlantis Age Group 0 to 4 216,535 112,536 13,173 976,524 0 to 4 5 to 9 222,133 115,325 13,139 993,083 5 to 9 10 to 14 221,545 115,009 12,865 994,174 10 to 14 15 to 19 247,689 130,009 14,710 1,117,480 15 to 19 20 to 24 302,609 159,691 18,753 1,383,867 20 to 24 25 to 29 277,507 143,998 16,781 1,300,640 25 to 29 30 to 34 268,058 134,466 15,245 1,290,434 30 to 34 35 to 39 276,649 134,718 15,172 1,346,293 35 to 39 40 to 44 273,066 128,907 14,134 1,322,211 40 to 44 45 to 49 273,867 128,230 14,177 1,311,939 45 to 49 50 to 54 281,231 134,663 15,056 1,295,596 50 to 54 55 to 59 263,770 125,841 14,229 1,184,094 55 to 59 60 to 64 239,536 117,162 12,963 1,046,331 60 to 64 65 to 69 215,603 108,086 11,834 923,752 65 to 69 70 to 74 206,298 104,581 11,008 870,892 70 to 74 75 to 79 200,200 101,824 10,837 838,748 75 to 79 80 to 84 195,299 100,397 10,999 806,725 80 to 84 85 to 89 141,440 74,793 8,516 586,432 85 to 89 90 Plus 101,730 54,445 5,907 426,651 90 Plus Total 4,424,765 2,224,681 249,498 20,015,866 Total Questions For all questions in this problem, calculate rates per 100,000 1 Calculate the crude mortality rate for the CENTRAL, SOUTHWEST, NORTHWEST Populations 2 Calculate the age-specific mortality rate for the CENTRAL, SOUTHWEST, NORTHWEST Popu 3 ANSWERS Question 1 Crude death rates CENTRAL SOUTHWEST NORTHWEST Atlantis answers 239 339 367 298 points 2 2 2 2 score Question 2 Age Specific Mortality Rates Standard Population Using the Direct Standardization method, calculate the age-standardized mortality rate for

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Age Group CENTRAL SOUTHWEST NORTHWEST Atlantis 0 to 4 1 2 2 2 5 to 9 2 2 2 2 10 to 14 2 2 2 2 15 to 19 3 4 4 3 20 to 24 2 3 4 3 25 to 29 3 4 5 4 30 to 34 7 10 11 10 35 to 39 11 15 17 15 40 to 44 22 31 34 30 45 to 49 39 54 60 52 50 to 54 74 102 113 98 55 to 59 137 190 211 183 60 to 64 228 316 349 304 65 to 69 351 487 538 468 70 to 74 531 736 814 707 75 to 79 759 1,053 1,164 1,012 80 to 84 1,064 1,475 1,631 1,418 85 to 89 1,433 1,988 2,198 1,911 90 Plus 1,726 2,394 2,647 2,302 points 4 4 4 2 score Question 3 Age Standardized Mortality Rates CENTRAL SOUTHWEST NORTHWEST Atlantis answers 224 310 343 298 points 2 2 2 2 score

Deaths from Cancer Study Populations S CENTRAL SOUTHWEST NORTHWEST Atlantis Age Group CENTRAL 3 2 0 19 0 to 4 1 3 3 0 21 5 to 9 2 3 3 0 21 10 to 14 2 6 5 1 38 15 to 19 3 7 5 1 43 20 to 24 2 8 6 1 52 25 to 29 3 20 14 2 126 30 to 34 7 31 21 3 199 35 to 39 11 60 40 5 390 40 to 44 22 107 69 8 681 45 to 49 39 207 137 17 1,270 50 to 54 74 362 240 30 2,168 55 to 59 137 545 370 45 3,176 60 to 64 228 757 526 64 4,325 65 to 69 351 1,095 769 90 6,161 70 to 74 531 1,520 1,072 126 8,489 75 to 79 759 2,077 1,481 179 11,442 80 to 84 1,064 2,027 1,487 187 11,208 85 to 89 1,433 1,756 1,303 156 9,821 90 Plus 1,726 10,596 7,551 915 59,649 Crude Rate s and the Standard Populations ulations Populations and the Standard Populations Standard Population r CENTRAL, SOUTHWEST, NORTHWEST Populations

Cancer Mortality Rates Study Populations SOUTHWEST NORTHWEST Atlantis Age Group 2 2 2 0 to 4 2 2 2 5 to 9 2 2 2 10 to 14 4 4 3 15 to 19 3 4 3 20 to 24 4 5 4 25 to 29 10 11 10 30 to 34 15 17 15 35 to 39 31 34 30 40 to 44 54 60 52 45 to 49 102 113 98 50 to 54 190 211 183 55 to 59 316 349 304 60 to 64 487 538 468 65 to 69 736 814 707 70 to 74 1,053 1,164 1,012 75 to 79 1,475 1,631 1,418 80 to 84 1,988 2,198 1,911 85 to 89 2,394 2,647 2,302 90 Plus Total Standard Population Age-Standardized Mortality Rate Standard Population

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Expected Cancer Deaths CENTRAL SOUTHWEST NORTHWEST Atlantis 14 19 21 19 16 22 24 21 16 22 24 21 28 40 44 38 32 45 49 43 39 54 60 52 95 132 145 126 149 207 229 199 293 406 449 390 511 708 783 681 952 1,320 1,460 1,270 1,626 2,255 2,493 2,168 2,382 3,303 3,652 3,176 3,244 4,498 4,974 4,325 4,621 6,407 7,085 6,161 6,367 8,829 9,762 8,489 8,581 11,899 13,158 11,442 8,406 11,656 12,889 11,208 7,366 10,214 11,294 9,821 44,736 62,035 68,596 59,649 20,015,866 20,015,866 20,015,866 20,015,866 224 310 343 298 Expected Deaths in Standard Population at Study Population's Rate Standard Population