Missouri COVID-19

For a Statistics project, I took raw COVID data from John Hopkins University on May 20, 2020. With the data, I found the general statistics and then compared how cases are going up in Missouri every month.

StateConfirmedDeathsPopulationCasesPerCapita
Alabama1305252247797362.73069475
Alaska401107102310.564605037
Arizona1490674763920172.33197127
Arkansas500310729159181.715754695
California859973497372539562.30839914
Colorado22797129950291964.532931308
Connecticut390173529357409710.91660355
Delaware81943108979349.125392289
District of Columbia755140770574910.69927127
Florida474712096188013102.524877256
Georgia39801169796876534.108425436
Hawaii6431713603010.4726895003
Idaho25067715675821.598640454
Illinois1004184525128306327.826426633
Indiana29274186464838024.514943547
Iowa1562039330463555.127439186
Kansas850720228531182.981650251
Kentucky816737643393671.88207174
Louisiana35316260845333727.790227672
Maine18197313283611.369356673
Maryland42323212357735527.330496027
Massachusetts889706066654762913.5881248
Michigan53009506098836405.363307445
Minnesota1767078653039253.331495072
Mississippi1196757029672974.032963333
Missouri1152864059889271.92488571
Montana478169894150.4831137591
Nebraska1112213818263416.089771844
Nevada738837727005512.735738003
New Hampshire386819013164702.938160383
New Jersey15077610749879189417.14943333
New Mexico631728320591793.067727478
New York354370286361937810218.28713669
North Carolina2026272695354832.124905471
North Dakota2095496725913.114820151
Ohio294361781115365042.551552879
Oklahoma553229937513511.474668726
Oregon380114438310740.992149982
Pennsylvania681264770127023795.36324731
Rhode Island13356538105256712.68897847
South Carolina917540746253641.983627667
South Dakota4177468141805.130315164
Tennessee1841230563461052.90130718
Texas516731426251455612.054955147
Utah77109027638852.789551664
Vermont944546257411.50861139
Virginia32908107580010244.112973539
Washington18971103767245402.821159514
West Virginia15676918529940.8456584317
Wisconsin1341348156869862.35854282
Wyoming787115636261.396315997

The Table above is the raw data I extracted but I added the population of each state and then calculated the cases per capita by dividing the confirmed cases by the population. This allows you to compare each state equally.

After getting the raw data I did the statistical analysis on the confirmed cases and cases per capita.

Confirmed Cases

Min.401
Q15268
Median13052
Q334112
Max354370
Mean30364
Inter-Q28844
Standard Div5513.53
Missouri11528
Missouri Z-3.416323118

The data above is the analysis from the confirmed cases. The analysis is for all 50 states.

Confirmed Cases per Capita

Min.0.4727
Q11.9543
Median2.9013
Q35.2468
Max18.2871
Mean4.4639
Inter-Q3.2925
Standard Div4.101132
Missouri1.92488571
Missouri Z-0.6191008458

The data above is the analysis from the confirmed cases per capita. The analysis is for all 50 states.

Missouri Predictions

After I did the analysis for all 50 states I focused on the rise of cases in Missouri from April to September. Then I predicted the number of cases in the future if the rise in cases stays the same. More than likely the cases will be higher or lower than the predicted number. If the state implements safety precautions the curve could flatten out. If the state does nothing and people keep taking it less and less seriously than more then likely the curve will get stepper.

Above are the data and graphs I used to predicate the cases at the beginning of October and End. The two highlighted boxes are the predictions.

I predict there will be 130,278 cases in Missouri on the first of October. On the 21st I predict there will be 166,268 cases.

Leave a Reply