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.