Modelling · Topic 9 of 9
Exponential Relationships
Theory
While linear models have a constant rate of change, exponential models describe situations where a quantity changes at a rate proportional to its current size.
- Exponential Growth: As the input increases steadily, the output increases by progressively larger amounts (e.g., the spread of a virus, or population growth).
- Exponential Decay: As the input increases steadily, the output decreases by progressively smaller amounts (e.g., the value of a car depreciating, or a hot drink cooling down).
1. The Structure of an Exponential Model
The defining feature of an exponential model is that the independent variable (usually time, , or ) is the power (the exponent). Models typically take one of two forms:
- Without 'e': Written as .
- is the starting (initial) value.
- is the multiplier (e.g., a 12% increase means ; a 15% decrease means ).
- With 'e': Written as .
- '' is a mathematical constant (approximately 2.718) built into scientific calculators.
- is the starting (initial) value.
- If the power is positive, the model shows growth. If the power is negative (e.g., ), the model shows decay.
2. Evaluating an Exponential Formula
"Evaluating" simply means substituting a given value for the independent variable into the formula to predict an outcome. Because the power involves an unknown, the numbers in exponential growth models get very large, very quickly.
3. Exponential Models in Spreadsheets (Excel)
- When entering a formula into Excel that contains '', you must use the
EXPcommand, and the power must be placed inside brackets. For example, the formula would be typed into Excel as= 400 * EXP(0.5*A2). - Crucial Excel Rule: Excel cannot produce an exponential trendline on a graph if your dataset includes the exact coordinate (0,0). The exponential trendline option will be completely greyed out. You must delete the (0,0) value from your columns to get the option back.
Worked examples
Example 1
Example 1: Interpreting an Exponential Model (Without 'e')
A conservation charity is monitoring the population of a rare breed of bird on an island. They model the population, , after years using the formula:
(a) State the initial population of the birds when the monitoring began.
(b) State whether this model represents exponential growth or decay, and state the annual percentage change.
Solutions:
- (a) The initial population is 450 birds (the number outside the bracket).
- (b) This model represents exponential growth because the multiplier (1.08) is greater than 1. The population is increasing by 8% each year.
Example 2
Example 2: Evaluating a Model (With 'e')
A scientist is testing a new water purification chemical. The concentration of bacteria, (in units per ml), remaining in the water minutes after the chemical is added is modelled by the formula:
(a) State the initial concentration of the bacteria.
(b) Calculate the expected concentration of bacteria remaining after 45 minutes.
Solutions:
- (a) The initial concentration is 8500 units per ml.
- (b) Substitute into the formula:
(Make sure you know how to find the button on your specific calculator!)
Example 3
Example 3: Spreadsheet Troubleshooting
A student is using Excel to model the spread of a computer virus on a school network. They have set up two columns: 'Time in Hours' and 'Computers Infected'. Their very first entry in the table is time = 0, computers infected = 0. When the student highlights their data and inserts a scatter graph, they find that the option to add an 'Exponential Trendline' is greyed out and cannot be clicked. Explain why this has happened and how the student can fix the issue.
Solution: Excel cannot calculate an exponential trendline if the dataset includes the exact coordinate (0,0). To fix this and make the trendline option available again, the student simply needs to delete the (0,0) data point from their spreadsheet.