Our exponential regression calculator is here for you whenever you need to determine the exponential regression model of a data set, i.e., in other words, to find the exponential curve of best fit. What is exponential regression? Keep reading as we not only provide you with the exponential regression formula, but also explain how to calculate exponential regression and explain in what situations the exponential fit proves useful. As a bonus, we show you how to derive the exponential regression equation so that you don't need to learn it by heart. 😉
What is the exponential regression?
The aim of exponential regression is to find an exponential curve that best fits a given set of data points. This is very similar to linear regression, where we look for the (straight) line of best fit, or to quadratic regression, where we look for the best-fitting parabola.
There are lots of situations where the data follows neither a straight line nor a parabola, but an exponential curve seems to be just right; these are processes that grow slowly in the beginning and then accelerate rapidly, or whose decay begins rapidly and then slows down as time passes. Examples include investment growth, temperatures of cooling objects, and radioactive decay.
Exponential regression model
x be the explanatory variable and
y the response variable. The exponential regression equation reads
y = a * bˣ, where
a ≠ 0 and
b > 0,
b ≠ 1. The coefficients
b must be so chosen that the equation corresponds to the exponential curve of best fit for the dataset,
(x₁, y₁), ..., (xₙ, yₙ):
In the next section we tell you how to find the coefficients
b. Let's discuss their meaning here:
ais the value predicted by the exponential regression model for
x = 0;
b > 1, the exponential fit describes an exponential growth; and
0 < b < 1, the exponential fit describes an exponential decay.
Note, that we have
a * bˣ⁺¹ = a * b * bˣ, so, if
x increases by
1 unit, then
y is multiplied by
b. This is in stark contrast to the linear regression
y = m * x + c, where an increase in
1 unit results in the value of
m (slope) being added to
How to calculate the exponential regression formula?
We've discussed the equation for exponential fit, but how to calculate exponential regression once we have collected some data? The trick is to:
- Transform our data so that it allows a linear model.
- Determine that linear model, e.g., with the method of least squares.
- Transform the data along with the model back to the original form.
Exponential regression formula for the data
(x, y) is
y = exp(c) * exp(m * x),
m is the slope and
c is the intercept of the linear regression model fitted to the data
(x, ln(y)). See the next section to check the details of the derivation.
Exponential regression equation: derivation
With the exponential regression model, we strive to explain our data with the help of the equation in the form
y = a * bˣ. Here we show you how the exponential regression formula can be derived. To determine the coefficients
b, follow these steps:
Take the logarithm of both sides of the equation, we have the following equivalent equation:
ln(y) = ln(a * bˣ).
The properties of logarithms give:
ln(y) = ln(a) + ln(bˣ)
ln(y) = ln(a) + x * ln(b).
We have expressed
ln(y)as a linear function of
x, with slope
Find the best-fit line for
(x, ln(y)). Let's say it reads
ln(y) = c + x * m.
Look for the
ln(a) = cand
ln(b) = m.
b, take the exponent (antilogarithm) of the slope
a = exp(c)and
b = exp(m).
How to use this exponential regression calculator?
- Enter your data into the calculator. You can input up to 30 data points (new rows will appear as you fill out the fields). Remember that we need at least 3 points (both coordinates!) to fit a model.
- A scatter plot with your data appears along with the exponential curve of best fit.
- Below the graph, you can find the exponential regression equation for your data.
- If need be, go to the
advanced modeto increase the precision (number of significant figures) with which the coefficient are computed. The default precision is set to 4 sig figs.