Skip main navigation

Exercising with numbers: solution

In this article Jakob Zinsstag explains the solution for the exercise presented in the previous step.
© University of Basel

Here you find the solution to the exercise of the previous step. If desired, you may download a completed spreadsheet.

The formulas should be:
(S_{(T+1)})= B2 + ($F$2 * (B2+C2+D2)) – ($E$2 * B2 * C2) – ($F$2 * B2)
(I_{(T+1)})= C2 + ($E$2 * B2 * C2) – ($F$2 * C2) – ($G$2 * C2)
(R_{(T+1)}) = D2 + ($G$2 * C2) – ($F$2 * D2)

The graph should look like this:
Graph showing the solution of the exercise Time dependent changes in the numbers of susceptible, infectious and recovered individuals. © Jakob Zinsstag

Answer on the dynamics:
We observe an initial epidemic peak and then an on-going low level of transmission.

Answer on shortfalls:
The formula works with non-integer numbers. In principle, there should only be integers if we assume individuals. This problem can be overcome if we assume that we deal with large numbers, for example, a million people instead of one thousand. The model uses discrete time steps, which is a good approximation if the time steps are short (like days) but performs poorly if the time steps represent years.

© University of Basel
This article is from the free online

One Health: Connecting Humans, Animals and the Environment

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education