Skip to content
FiftyCalc Free calculators for all 50 states

Exponential Regression Calculator

Test cases replayed : 2 of 2 match · Methodology · No outside source listed

Enter up to six (x, y) points with positive y values. The calculator fits the exponential curve through them, gives the growth or decay rate per unit of x and predicts y at a new x.

Result

Sample figures

Fitted model—

Initial value a (y at x = 0) —

  • Continuous rate b (per unit of x)—
  • Growth factor eᵇ, so y = a·(eᵇ)ˣ—
  • Change in y per unit of x (%)—
  • r² of the fit of ln y on x—
  • Predicted y at that x—

Estimate for planning only, not tax, legal, financial or medical advice. This calculator uses the method explained on this page.

Exponential Regression Calculator

Number of points used

Number of points used: choose 3 points, 4 points, 5 points or 6 points. Prefilled example: 6 points.

x₁: enter a number. Prefilled example: 0.

y₁ (positive): enter a number. Prefilled example: 3.

x₂: enter a number. Prefilled example: 1.

y₂ (positive): enter a number. Prefilled example: 6.

x₃: enter a number. Prefilled example: 2.

y₃ (positive): enter a number. Prefilled example: 12.

x₄: enter a number. Prefilled example: 3.

y₄ (positive): enter a number. Prefilled example: 24.

x₅: enter a number. Prefilled example: 4.

y₅ (positive): enter a number. Prefilled example: 48.

x₆: enter a number. Prefilled example: 5.

y₆ (positive): enter a number. Prefilled example: 96.

x value to predict y for: enter a number. Prefilled example: 6.

How to use this calculator

Fill in the fields in this order; each step takes you to its field.

  1. Number of points used: choose 3 points, 4 points, 5 points or 6 points.
  2. x₁: enter a number.
  3. y₁ (positive): enter a number.
  4. x₂: enter a number.
  5. y₂ (positive): enter a number.
  6. x₃: enter a number.
  7. y₃ (positive): enter a number.
  8. x₄: enter a number.
  9. y₄ (positive): enter a number.
  10. x₅: enter a number.
  11. y₅ (positive): enter a number.
  12. x₆: enter a number.
  13. y₆ (positive): enter a number.
  14. x value to predict y for: enter a number.
  15. Read the result: Fitted model; the panel also shows Initial value a (y at x = 0), Continuous rate b (per unit of x), Growth factor eᵇ, so y = a·(eᵇ)ˣ, Change in y per unit of x (%), r² of the fit of ln y on x and Predicted y at that x.

How this calculator works

Taking logarithms turns y = a·e^(bx) into ln y = ln a + b x, a straight line. Ordinary least squares on the points (x, ln y) gives b = (nΣx ln y − Σx Σln y) ÷ (nΣx² − (Σx)²) and ln a = (Σln y − bΣx) ÷ n. This is the usual exponential regression of graphing calculators and spreadsheets (Excel LOGEST and GROWTH).

Growth factor = eᵇ; the model can also be written y = a·(eᵇ)ˣ. A negative b is exponential decay. r² measures the fit of the straight line to (x, ln y).

Every y must be positive, since ln y is undefined otherwise; results show — when one is not. The fit minimizes errors in ln y, not in y, so it gives relatively more weight to small y values than a nonlinear fit would.

Worked example

Number of points used6 points
x₁0
y₁ (positive)3
x₂1
y₂ (positive)6
x₃2
y₃ (positive)12
x₄3
y₄ (positive)24
x₅4
y₅ (positive)48
x₆5
y₆ (positive)96
x value to predict y for6
Fitted modely = 3 · e^(0.6931x)
Initial value a (y at x = 0)3
Continuous rate b (per unit of x)0.6931
Growth factor eᵇ, so y = a·(eᵇ)ˣ2
Change in y per unit of x (%)100%
r² of the fit of ln y on x1
Predicted y at that x192

Frequently asked questions

How do I get an exponential equation from a table?

Enter the table's x and y pairs. With 3, 6, 12, 24, 48, 96 at x = 0 to 5, the fit is exactly y = 3·e^(0.6931x) = 3·2ˣ.

Why does my result differ slightly from a nonlinear fit?

Fitting ln y by least squares and fitting y directly minimize different errors, so on noisy data the coefficients differ a little. Both are standard; this is the linearized method.

Can I fit decay data?

Yes. Decreasing positive y values give a negative b and a growth factor below 1.

Questions answered

Related calculators