BGonline.org Forums

OT: Converting y = Ae^bx to base 10

Posted By: leobueno
Date: Sunday, 29 January 2012, at 3:12 p.m.

I am a little rusty on my algebra so need your help.

The Microsoft Excel trendline function readily fits a data series to several functions (linear, polynomial, exponential, etc.)

The Excel exponential function uses e as the base, so it produces a function thus: y=Ae^bx.

How does one convert y=Ae^bx to base 10, i.e., y=A10^cx?

That way if I have an annual data series, c will be the % growth rate.

Thanks in advance for you help.

Messages In This Thread

• OT: Converting y = Ae^bx to base 10
  leobueno -- Sunday, 29 January 2012, at 3:12 p.m.
  • OT: Converting y = Ae^bx to base 10
    Casper van der Tak -- Sunday, 29 January 2012, at 3:22 p.m.
    • OT: Converting y = Ae^bx to base 10
      Jason Lee -- Sunday, 29 January 2012, at 3:48 p.m.
      • OT: Converting y = Ae^bx to base 10 - How does Excel calculate b ???
        leobueno -- Sunday, 29 January 2012, at 7:20 p.m.
        • OT: Converting y = Ae^bx to base 10 - How does Excel calculate b ???
          Sam Pottle -- Sunday, 29 January 2012, at 9:14 p.m.
          • OT: Converting y = Ae^bx to base 10 - How does Excel calculate b ???
            Jake Jacobs -- Monday, 30 January 2012, at 2:38 a.m.
            • OT: Converting y = Ae^bx to base 10 - How does Excel calculate b ???
              Michael Petch -- Monday, 30 January 2012, at 3:56 a.m.
          • OT: Converting y = Ae^bx to base 10 - How does Excel calculate b ???
            leobueno -- Monday, 30 January 2012, at 1:44 p.m.
            • OT: Converting y = Ae^bx to base 10 - How does Excel calculate b ???
              Sam Pottle -- Monday, 30 January 2012, at 3:43 p.m.