2.2 Statistical Analysis
We statistically analyzed our dataset with various methods of data analysis and visualized those data to provide a proper understanding of the COVID‐19 outbreak worldwide. Our exploit analysis was carried out by Johns Hopkins University with the 2019 coronavirus dataset (January–April 2020). Here, between 22 January 2020 and 17 April 2020, we present an effort to visualize and analyze the results. COVID‐19 has so far propagated nearly 185 Countries / Regions, 83 Cities / Provinces have been registered, and 264 separate geographical locations combined. By using time-series data estimated the number of specific cases, such as confirmed infected, deaths, and recovered around the globe and the top 10 countries in the world.
Worldwide the total confirmed cases are 2,152,646, and the global average rate is 0.38. The reported cases of the world’s top 10 countries are listed below with global percentage on time-series data. The confirmed infected cases of the top 10 countries in the world are listed below with the global percentage. In this case, the US ranked first with a total of 667,801, the Global percentage is 31.02, and with a total of 184,948, the Global percentage of 8.59, Spain is second.
################################################################################
##### TS-CONFIRMED Cases – Data dated: 2020-04-16 :: 2020-04-17 13:36:46
################################################################################
Number of Countries/Regions reported: 185
Number of Cities/Provinces reported: 83
Unique number of geographical locations combined: 264
——————————————————————————–
Worldwide ts-confirmed Totals: 2152646
——————————————————————————–
Country.Region Province.State Totals GlobalPerc LastDayChange t-2 t-3 t-7 t-14 t-30
1 US 667801 31.02 31451 28680 27051 35098 31824 1362
2 Spain 184948 8.59 7304 5103 2442 5051 7134 2162
3 Italy 168941 7.85 3786 2667 2972 3951 4585 4207
4 France 145960 6.78 12490 3217 5955 4342 5233 1391
5 Germany 137698 6.40 2945 3394 1287 3990 6365 3070
6 United Kingdom 103093 4.79 4617 4603 5252 8681 4450 676
7 Iran 77995 3.62 1606 1512 1574 1972 2715 1192
8 Turkey 74193 3.45 4801 4281 4062 4747 2786 51
9 China Hubei 67803 3.15 0 0 0 0 0 1
10 Belgium 34809 1.62 1236 2454 530 1684 1422 243
——————————————————————————–
Global Perc. Average: 0.38 (sd*: 2.15)
Global Perc. Average in top 10 : 7.73 (sd: 8.49)
sd* - Standard deviation
================================================================================
The estimated number of deaths worldwide is 143,800, with a global average of 3.61. For this situation, the US occupied the first place with 32,916 counts, and with 22,170 counts, Italy was second in the top 10 countries around the world. The total number of cases recovered is 542,107 worldwide. In this scenario, Germany ranked first, with a total of 77,000, and with a total of 74,797, Spain placed second in the top 10 countries of the world.
The aggregated data for various cases such as confirmed infected, dead, recovered and active in the top 10 countries around the world are then computed and shown below. In this scenario, the number of countries reported is 185, the number of cities / provinces listed is 138 and the total number of geographic locations combined is 3042. The aggregated data for confirmed infected cases of the top 10 countries worldwide are provided below. In this case, Spain is in the first position, with an estimate of 184,948, while Italy is in the second position, with an estimate of 168,941.
############################################################################################################################
AGGREGATED Data – ORDERED BY CONFIRMED Cases – Data dated: 2020-04-16 :: 2020-04-17 13:36:51
############################################################################################################################
Number of Countries/Regions reported: 185
Number of Cities/Provinces reported: 138
Unique number of geographical locations combined: 3042
—————————————————————————————————————————-
Combined_Key Confirmed Perc.Confirmed Deaths Perc.Deaths Recovered Perc.Recovered Active Perc.Active
1 Spain 184948 8.59 19315 10.44 74797 40.44 90836 49.11
2 Italy 168941 7.85 22170 13.12 40164 23.77 106607 63.10
3 France 145960 6.78 17920 12.28 32812 22.48 95228 65.24
4 Germany 137698 6.40 4052 2.94 77000 55.92 56646 41.14
5 New York City, New York, US 123146 5.72 11477 9.32 0 0.00 111669 90.68
6 United Kingdom 103093 4.79 13729 13.32 0 0.00 89364 86.68
7 Iran 77995 3.62 4869 6.24 52229 66.96 20897 26.79
8 Turkey 74193 3.45 1643 2.21 7089 9.55 65461 88.23
9 Hubei, China 67803 3.15 3222 4.75 64435 95.03 146 0.22
10 Belgium 34809 1.62 4857 13.95 7562 21.72 22390 64.32
============================================================================================================================
In aggregate death-related results, Italy ranks first with a count of 22,170 and Spain ranks second with a count of 19,315 out of the top 10 countries in the world. In the aggregated recovered cases, Germany is in the first place with a total of 77,000, and Spain is in the second position with a total of 74,797 out of the top 10 countries in the world. In aggregate active cases, the United States (New York) ranked first with 111,669 counts and Italy ranked second with 106,607 counts from the top 10 countries around the world. The overall summary of confirmed infected, fatal and recovered cases with respect to time series in terms of totals, average and standard deviations is provided below.
******************************** OVERALL SUMMARY*************************
**************************************************************************
**** Time Series TOTS ****
ts-confirmed ts-deaths ts-recovered
2152646 143800 542107
6.68% 25.18%
**** Time Series AVGS ****
ts-confirmed ts-deaths ts-recovered
8153.96 544.7 2168.43
6.68% 26.59%
**** Time Series SDS ****
ts-confirmed ts-deaths ts-recovered
46373.8 3069.33 9782.04
6.62% 21.09%
* Statistical estimators computed considering 250 independent reported entries
**************************************************************************
From a statistical data analysis, it can be understood that 5% of deaths and 8% of recoveries occurred in reported cases in the United States. In Spain, 10% of deaths and 40% of recoveries occurred in confirmed cases. 13% of the deaths and 24% of those recovered from Italy and 3% of the deaths and 56% of those recovered from Germany occurred in the reported case.