Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Scenario: There has been a dangerous virus outbreak in 11 U.S. cities (see Outbreak Cases listed below ). The number of cases were reported over
Scenario: There has been a dangerous virus outbreak in 11 U.S. cities (see Outbreak Cases listed below). The number of cases were reported over a 3-month time period. Consider the steps involved in an outbreak investigation and use descriptive epidemiology to create a hypothesis based on the data provided.
Can you help me with addressing each point below to support your hypothesis?
- Using Microsoft Excel or any chart software, create a bar chart of the total number of cases across the states.
- Identify the prevalence rate per 100,000 for the top 5 infected states.
- Explain other data or information that would be useful.
- Provide recommendation(s) based on the data provided.
States | Month 1 Cases | Month 2 Cases | Month 3 Cases | 3 Months Total of Cases | Gender - 3 months total |
CA | 200 | 1000 | 1530 | 2730 | 62% Male |
FL | 112 | 900 | 968 | 1980 | 58% Male |
TX | 225 | 1000 | 1275 | 2500 | 67% Male |
NY | 1000 | 2500 | 500 | 4000 | 55% Male |
AZ | 95 | 500 | 300 | 895 | 45% Male |
LA | 75 | 250 | 125 | 450 | 32% Male |
CO | 125 | 500 | 150 | 775 | 48% Male |
UT | 50 | 100 | 130 | 280 | 52% Male |
NV | 200 | 500 | 200 | 900 | 50% Male |
GA | 100 | 400 | 65 | 565 | 45% Male |
OK | 250 | 1000 | 250 | 1500 | 60% Male |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started