Skip to main content

Previous

Searching for particles and shadows

Next

Upward lightning and blue jets

MATHSKIT

Solving differential equations on a spreadsheet

Part 2

In Physics Review Vol. 33, No. 2 ‘Mathskit’ looked at how a spreadsheet can be used to solve a simple differential equation. Simon Carson now explains how to solve a more complicated equation from the A-level specifications, and looks at some applications

© PixieMe/stock.adobe.com

In a previous ‘Mathskit’ (Physics Review Vol. 33, No. 2, pp. 12–15) we looked at what a differential equation is, and how to solve a very simple one using a spreadsheet. Here we will look at one of the examples specifically mentioned in the mathematical requirements of current A-level specifications. The equation in question is this:

This equation tells us how fast x changes with time — this is what dx/dt means. We refer to this as the ‘rate of change’ of x. The right-hand side of the equation tells us that the rate of change of x is proportional to x itself, with a constant of proportionality λ (Greek letter lambda). The equation also tells us that x is decreasing with time because dx/dt is negative (assuming λ and x are positive).

Your organisation does not have access to this article.

Sign up today to give your students the edge they need to achieve their best grades with subject expertise

Subscribe

Previous

Searching for particles and shadows

Next

Upward lightning and blue jets

Related articles: