# Data visualization in a time of pandemic - #2: Visualizing exponential growth

This is a multi-chapter post!

**Chapter 1**: Finding reliable data**Chapter 2**: Visualizing exponential growth**Chapter 3:**Mapping the virus**Chapter 4:**We need to talk about flattening the curve**Chapter 5:**On top of the outbreak with daunting dashboards**Chapter 6:**Viral scrollytelling

## Chapter 2: Visualizing exponential growth

Let me warn you in advance: this will probably be the most theoretical and mathematical chapter of this entire blog post. We’ll have a short look at the underlying scientific principles of a pandemic and analyze how this translates to visualizing data. If that’s not really your thing, it’s totally okay to just look at the pictures and then skip to the next chapter! 😉

### A mathematical approach to pandemics

A pandemic disease is a complex thing to model. We live in a world of nearly 8 billion people in over 230 countries, connected with each other through 100.000 daily plane flights and an equally mind-boggling number of train and bus rides. Nevertheless, many experts have attempted to model the spread of a disease in a closely-connected world.

For example, professor biostatistics Kurt Barbé models the pandemic spread through a first order differential equation, resulting in the number of active infections following a Gaussian curve, with its typical bell shaped profile:

*Different scenarios for the coronavirus spread in Belgium, as modeled by professor Kurt Barbé (March 18, 2020).*

This is a simplified but not unrealistic model. For example, if we look at the number of active COVID-19 cases in China, where the peak has nearly passed, we can see that the Gaussian profile is a pretty good approximation (the sudden increase in the number of cases on February 13 is the result of a change in reporting methodology).

*Evolution of the number of active SARS-CoV-2 infections in China.*

We can assume that if the number of active infections follows a Gaussian-shaped profile, the number of new infections and the number of deaths will also follow Gaussian profiles. If we plot cumulative data, such as the total number of confirmed cases or the total number of deaths, this will follow an S-shaped cumulative function profile — the integral of the Gaussian function. For example, the total number of deaths by COVID-19 in China looks like this:

*Evolution of the total number of COVID-19-related deaths in China.*

Crucially, at the start of such peaks and S-curves, the shape will follow an approximately exponential profile, with the number of infections or the number of deaths doubling every few days at a constant acceleration. That’s the reason why we are seeing so many graphs appearing which show the number of infections on a logarithmic scale — such as the one below by John Burn-Murdoch for the Financial Times. On such a log-scale, exponential growth will appear as straight lines. The steeper the line, the more rapidly the growth is accelerating.

*Financial Times graphic by John Burn-Murdoch on the growth of the number of coronavirus cases in different countries.*

Which brings us to the following point of discussion: is using a logarithmic scale a good idea?

### Logarithmic scales: yes or no?

Using logarithmic scales in a data visualization is sometimes frowned upon, as it has some obvious drawbacks:

- Requires additional explanation when communicating towards a general public, which might not be familiar with this type of plot.
- Not a good way
*at all*to compare values with each other.

However, there are specific cases where the use of logarithmic scales might be justified: when the underlying mechanism behind the data is multiplicative in nature, leading to (more or less) exponential growth. This is exactly the case in the early outbreak stage of a contagious disease (when only a minor fraction of the population is infected).

For example, a patient infected with smallpox will infect on average 5 other people. This is the basic reproduction number of the infection. These 5 people will — on average — each infect 5 new people, or 25 in total. These 25 will infect 5 x 25 = 125, and so on, and so on. For the novel coronavirus, early estimates of the basic reproduction number range between 1.4 and 3.9, which is higher than a seasonal flu (0.9–2.1), but much lower than for example measles (12–18).

The basic reproduction number is influenced by many different factors which cannot be controled, such as the incubation time and the infectiousness of the disease. However, it also depends on the number of susceptible people that affected patients are in contact with. This is the main reasoning behind social distancing measures to ‘flatten the curve’ (more about flattening the curve visuals in a later chapter): the lower the number of people an infected patient comes in contact with, the lower the reproduction number and the slower the disease will spread through the population.

As many countries are currently in the early exponential growth phase of the epidemic, and taking measures to reduce the reproduction number, this is an appropriate opportunity to plot the number of infections (and the number of deaths) on a logarithmic scale. It enables us to quickly evaluate in which countries measures are more effective and the disease is spreading less rapidly, such as Japan or Singapore:

*Number of confirmed coronavirus cases per country, on a linear-logarithmic scale.*

*Basic reproduction number of well-known infectious diseases. (Source: Wikipedia)
*

As an additional benefit, linear-logarithmic plots like these can educate the general public about the exponential nature of the disease in its early stage. This avoids more sensation-oriented headlines such as *‘More new infections today than ever before!’*. While this is true, it doesn’t have to mean things are getting out of control. Everything might be entirely as expected, or even improving. As Hans Rosling notes in his bestseller Factfulness (if you haven’t read it, do it immediately!): **things can be both better and bad**.

A final note on logarithmic scales before I shut up about it and we can move on to more exciting things. As the infection continuous to spread, a growing fraction of the population will become either already infected, or immune when they have been infected in the past but survived. Also, vaccines can be developed, or increasingly strict measures of social distancing and quarantine can be enforced. In practice, this means the *effective* reproduction number will drop, the exponential growth will start to decelerate and the number of infections will reach a peak and start dropping again. When this happens, the usefulness of logarithmic scales has reached its end.

*Even Bill agrees.*

### But aren't absolute numbers meaningless?

By now, I have created many different visuals related to the novel coronavirus, and one of the most pervasive comments concerns the use of absolute numbers. Many people argue that we cannot directly compare numbers between countries without correcting for the population count. This sounds relatively convincing — how on earth can we compare the number of deaths between a tiny country such as Belgium, and a massive nation like China?

However, this is a multifaceted question without a definitive answer. Let me list the major arguments for both approaches:

**We must use relative numbers, because:**

- The number of infections and deaths in a country depends on the size of that country.
- We want to evaluate the stress the pandemic will put on a country’s healthcare system, which can usually only support a certain fraction of the population being infected.

**We must use absolute numbers, because:**

- The rate at which a disease spreads depends on the population density and the level of social distancing, but has nothing to do with the population number. In this regard, country borders are pretty arbitrary ways of grouping people, anyway.
- Relative numbers will create pretty meaningless ‘outliers’ for some very small countries.
- Should we plot the relative or the absolute number of infections?

In my impression, most data visualizers follow the approach of using absolute numbers when plotting the total number of infections. The above-mentioned John Burn-Murdoch also agrees:

*Thanks for backing me up here, John!*

Nevertheless, using relative numbers can be very useful for other use cases such as:

- Showing the number of tests performed per capita.
- Showing the available number of doctors, hospital beds, intensive care beds,… per capita.
- Comparing how hard different countries are currently hit by the crisis.

For example, comparing the number of COVID-19 tests performed by country in absolute and relative numbers reveals some interesting insights:

Nevertheless, using relative numbers can be very useful for other use cases such as:

- Showing the number of tests performed per capita.
- Showing the available number of doctors, hospital beds, intensive care beds,… per capita.
- Comparing how hard different countries are currently hit by the crisis.

For example, comparing the number of COVID-19 tests performed by country in absolute and relative numbers reveals some interesting insights:

*Number of tests performed per country and per 1.000 inhabitants. (Source: Our World in Data)
*

This is a multi-chapter blog post!

Continue reading:

**Chapter 1:**Finding reliable data**Chapter 2:**Visualizing exponential growth**Chapter 3:**Mapping the virus**Chapter 4:**We need to talk about flattening the curve**Chapter 5:**On top of the outbreak with daunting dashboards**Chapter 6:**Viral scrollytelling

For all your comments, suggestions, errors, links and additional information, you can contact me at koen@baryon.be or via Twitter at @koen_vde.

*Disclaimer: I am not a medical doctor or a virologist. I am a physicist running my own business (**Baryon**) focused on information design.*

* *

# Read more:

### Can you use Excel to create a powerful chart?

Spreadsheet tools such as Microsoft Excel or Numbers might not be the first thing on your mind when considering data visualization tools, but they can be pretty solid choices to build data visuals. Don’t let anyone convince you that using Excel to create data visuals is unprofessional.

9 January 2023

### Choosing the right font for your data visual

Fonts evoke emotions: there are very sophisticated fonts, playful fonts, attention-grabbing fonts, and elegant handwritten fonts. Using the wrong type of font can have a lot of impact. In data visualization the implications of typography are mainly focused on readability. Labels and annotations can easily become so small they get hard to read. Above all else, we should choose a font which is readable at small sizes.

2 January 2023

### Three roles of colour in a data visual

Colour is one of the most crucial tools we have to turn a normal chart into a powerful chart with a clear message, a chart which tells a story rather than simply presenting the information.

26 December 2022

### 7 different goals for your chart

A crucial step in building a powerful chart is choosing the right type of chart. A lot of charts don’t work because they simply use the wrong type of chart. To avoid this trap, we must ask ourselves a basic question: what’s the ultimate goal of our data visual? What do we want to show with our data?

19 December 2022

### Making a data visual noise-free

Removing noise from a data visual is not only about taking things away such as gridlines, axes or legends. That’s just one part of it, which we could call removing physical noise. Improving the signal-to-noise ratio is often also about adding little things that help our audience better understand the visual. We are helping them by removing mental noise, or mental barriers.

12 December 2022

### Three tips to create powerful charts in Excel

Creating charts in Excel can be a very powerful tool for making sense of complex data sets, and for visualizing them. But the default options are not always the most pretty or effective ones. Here are our top three tips to create better Excel charts.

8 December 2022

## We are really into visual communication!

Every now and then we send out a newsletter with latest work, handpicked inspirational infographics, must-read blog posts, upcoming dates for workshops and presentations, and links to useful tools and tips. Leave your email address here and we’ll add you to our mailing list of awesome people!