Covid-19 Evening Stats, April 06
My main motive for this private statistics series is the desire to observe the changes in the registered Covid-19 cases and the time course of the disease. The media report the maximum numbers and changes from the previous day, but only the long-term observation provides information about when and how strongly the political measures are working.
I have added two additional curves to my chart. One (light blue) shows the course of the percentage changes compared to the previous day, the other shows the development of the Basic reproduction number R₀ (dark red), as reported by the Robert Koch Institute (RKI).

Today’s Covid-19 situation in Germany: new cases (light blue bars), daily change [%] (light blue curve), all cases (dark blue curve), deaths (black), and trend of Basic reproduction number R₀ (reported by RKI)
Sum of confirmed cases (dark blue curve): The development of this amount/number is suitable for showing a country-specific course of the epidemic, but not for international comparisons. The number of cases depends mainly on the number of tests. However, the number does not say anything about the actual amount of infected persons. Its disadvantage is that when the quantity of tests is increased, the curve loses its power as a sample. Another drawback for the statistics: the curve rises and rises, often due to the increase in tests alone, and due to the large total number of cases, the desired flattening can hardly be detected.
Daily change of confirmed cases (light blue bars): A change can be read much more directly from the course of the daily new cases registered. However, the disadvantage built in here is that with the steady increase in the total of registered cases, the absolute numbers of the daily plus are also increasing. Example: If we are in the double digits, the increase of 20 cases from one day to the next sounds small … but it means +50% if there were 40 cases the day before. The jump from 10,000 to 11,000 cases is equivalent to 1,000 new cases, but only a +10% increase. Conclusion: Percentage is the solution.
Daily change of confirmed cases [%], Doubling time (light blue curve): The percentage change in the number of new daily cases most visibly illustrates any trend reversal in the case numbers. Based on the percentage, the doubling time of the virus can be calculated very quickly (see also Fontblog: Ganz einfach die Ausbreitung des Virus ausrechnen). To do this, divide 72 by the percentage of the daily change: 72/Δ%. With the recent 4% (April 5), the current doubling time is 18 days.
Growth rate: Virologists have deduced from experience in China and Italy that the number of reported cases – unchecked – doubles every 3 days. The growth rate is therefore calculated by dividing the number of cases of the current day by the number of cases 3 days before.
Basic reproduction number R₀: The basic reproduction number of an infection can be thought of as the expected number of cases directly generated by one case in a population where all individuals are susceptible to infection. The definition describes the state where no other individuals are infected or immunized (naturally or through vaccination). R₀ is not a biological constant as it is also affected by other factors such as environmental conditions and the behavior of the infected population. Since I have no possibility to calculate R₀, I use the data of the RKI.

Covid-19 situation in Berlin, April 6: recovered (green), quarantine (blue), hospital (orange), ICU (yellow), deaths (black)
The April 6 table:

Covid-19 Table Germany and Berlin, April 6
Author’s note: The above values are purely speculative estimations using simple mathematical modelling (based on registered cases/deaths) and are not confirmed by health authorities nor any other national public authority.
Covid-19 Evening Stats, April 05
My main motivation for this personal statistic series was the desire to know and determine the changes in the registered cases and the course of the Covid-19 disease. From the media we learn daily maximum numbers and changes to the previous day. But only when we look at a long-term observation and interpret it correctly can we join in the discussion about the relaxation of political measures.
Since yesterday I have integrated two additional curves into my statistics. One (light blue) shows the course of the percentage changes compared to the previous day, the other one shows the change of the Basic Reproduction Number R₀ (dark red) as reported by the Robert Koch Institute (RKI).

Today’s Covid-19 situation in Germany: new cases (light blue), total cases (dark blue), deaths (black), Basic reproduction number R₀ trend (dark red line), and % new cases (light blue line)
Benefit and weakness of the statistical coronavirus parameters
Sum of confirmed cases (dark blue curve): The development of this amount/number is suitable for showing a country-specific course of the epidemic, but not for international comparisons. The number of cases depends mainly on the number of tests. However, the number does not say anything about the actual amount of infected persons. Its disadvantage is that when the quantity of tests is increased, the curve loses its power as a sample. Another drawback for the statistics: the curve rises and rises, often due to the increase in tests alone, and due to the large total number of cases, the desired flattening can hardly be detected.
Daily change of confirmed cases (light blue bars): A change can be read much more directly from the course of the daily new cases registered. However, the disadvantage built in here is that with the steady increase in the total of registered cases, the absolute numbers of the daily plus are also increasing. Example: If we are in the double digits, the increase of 20 cases from one day to the next sounds small … but it means +50% if there were 40 cases the day before. The jump from 10,000 to 11,000 cases is equivalent to 1,000 new cases, but only a +10% increase. Conclusion: Percentage is the solution.
Daily change of confirmed cases [%], Doubling time (light blue curve): The percentage change in the number of new daily cases most visibly illustrates any trend reversal in the case numbers. Based on the percentage, the doubling time of the virus can be calculated very quickly (see also Fontblog: Ganz einfach die Ausbreitung des Virus ausrechnen). To do this, divide 72 by the percentage of the daily change: 72/Δ%. With the recent 4% (April 5), the current doubling time is 18 days.
Growth rate: Virologists have deduced from experience in China and Italy that the number of reported cases – unchecked – doubles every 3 days. The growth rate is therefore calculated by dividing the number of cases of the current day by the number of cases 3 days before.
Basic reproduction number R₀: The basic reproduction number of an infection can be thought of as the expected number of cases directly generated by one case in a population where all individuals are susceptible to infection. The definition describes the state where no other individuals are infected or immunized (naturally or through vaccination). R₀ is not a biological constant as it is also affected by other factors such as environmental conditions and the behavior of the infected population. Since I have no possibility to calculate R₀, I use the data of the RKI.

Covid-19 situation in Berlin, April 5: recovered (green), quarantine (blue), hospital (orange), ICU (yellow), deaths (black)
The table:
Covid Morning Stats April 04

Yesterday’s progression of Covid19 in Germany: new cases (light blue), all cases (dark blue), deaths (black), and [NEW] trend of the Basic reproduction number R₀ (reported by RKI)

Covid19 situation in Berlin, April 4: recovered (green), quarantine (blue), hospital (orange), ICU (yellow), deaths (black)

Covid19 Table GER and BER April 4
Covid Morning Stats April 02

Yesterday’s Covid-19 spreadsheet: registered Cases and Deaths (incl. growth rates) for Germany and Berlin

Progression of Covid19 new cases (light blue), all cases (dark blue), and deaths (black) in Germany, April 2

Covid19 situation in Berlin, April 2: recovered (green), quarantine (blue), hospital (orange), ICU (yellow), deaths (black)
Daily Covid19 Stats Nº 22

Progression of Covid19 new cases, all cases, and deaths in Germany, April 1
End of Day Summary (22). Yesterday night I decided to set the publication date of my charts (Twitter & blog) from evening to morning because the figure sources are too much in motion at the end of the day.
The picture above shows the increase of the registered Covid19 cases in Germany, from March 9–April 1. The focus is on the daily new cases (light blue bars), where the flattening of the infections is more apparent than in the dark blue curve with the summed cases. The deaths are now visualised with a black, scaled line in order to better recognise the growth; on the line you see the cumulated case numbers.

Covid19 situation Berlin, April 1: healed (green), in quarantine (blue), in hospital (orange), in ICU (yello), deaths
The second picture (above) is dedicated to the coronavirus conditions in my hometown Berlin. At the suggestion of some Twitter followers, I have now added up the total number of registered cases against 5 subgroups: the cured (green), the people in domestic quarantine (blue), the Covid19 patients (orange), the severe ICU cases (yellow) and the deaths (black with figures).
You can hardly see it in this presentation, but in the table below: The growth rate in Berlin has now been constant for three days at 1.2 (corresponds to a doubling in about 10 days). Surprisingly, deaths in the city are not growing exponentially but linearly in the last 4 days.
The complete Picture (table):
Today, the number of registered cases in Germany has risen by 6,173, and thus the development ha2 increased to a higher growth rate of ×1.3. Let us hope that this can be explained by the large increase in tests. We have to consider: If the number of tests increases dramatically, it naturally distorts the course of our sample.
The increase in the number of deaths has also slowed today, to ×1.5 (from ×1.6 yesterday), which means a doubling in 5 days.
Author’s note: The above values are purely speculative estimations using simple mathematical modelling (based on registered cases/deaths) and are not confirmed by health authorities nor any other national public authority.
Ganz einfach die Ausbreitung des Virus ausrechnen
Aus den Medien erfahren wir nicht nur die tägliche gemeldeten Coronavirus-Fallzahlen und die Todesfälle, sondern auch etwas über die Ausbreitungsgeschwindigkeit der Krankheit. In dem Zusammenhang ist meist von einer »Verdopplung der Fälle« die Rede. Anlässlich des Starts meiner Serie (Warum eine eigene Coronavirus-Statistik?) hatte ich bereits zwei statistische Eigenschaften der Epidemie erwähnt, die sich aus den Erfahrungen in China und Italien ergeben haben und die Verdopplung aufgreifen. Bei ungebremster Ausbreitung gilt:
- Die Zahl der gemeldete Fälle verdoppelt sich alle 3 Tage
- Die Zahl der Toten verdoppelt sich alle 2 Tage
Die Zeitspanne, in der sich die Zahl an Mikroben in einer Population verdoppelt, nennen Mikrobiologen Generationszeit. Der Anstieg der Individuenzahl wird in der exponentiellen Phase durch eine Gleichung beschrieben, die wie die Zinsenzins-Formel funktioniert. Als Faustformel wenden Banker und Sparer in diesem Zusammenhang gerne die 72er-Regel an. Mit ihr lässt sich näherungsweise hochrechnen, nach wie vielen Jahren sich eine verzinsliche Kapitalanlage im Nennwert verdoppelt, durch den Effekt des Zinseszins (was heute – bei Zinsen von 0,001 % – eine utopische Kalkulation darstellt). Dazu teilt man 72 durch die Prozentzahl des jährlichen Zinssatzes des angelegten Betrages.
Und genau so lässt sich die Ausbreitungsgeschwindigkeit des Coronavirus ausrechnen:

Die Formel für die schnelle Berechnung einer Generationszeit, mit t=Zeit [gemessen in Tagen] und ∆= [Prozent Veränderung zum Vortag]
Die prozentuale Steigerung aus den beiden Tagen ergibt sich, wenn man die größere Zahl durch die kleinere dividiert (71.108 : 66.885), machht 1,063… und entspricht einem Zuwachs von 6,3 %. Dann einfach die 72 durch 6,3 teilen, was eine Verdopplung der registrierten Coronavirus-Fälle in 11, 4 Tagen ergibt.
Angela Merkel hat in einem Audiopodcast am Samstag das Ziel ausgegeben, ab einem dauerhaften Wachstum > 10 Tage über eine Lockerung der Maßnahmen nachzudenken … wir sind auf dem besten Weg dahin.