[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

BGonline.org Forums

*** Off Topic *** Excel base 10 exponential trendline

Posted By: leobueno
Date: Wednesday, 1 May 2024, at 10:36 p.m.

In Response To: *** Off Topic *** Excel base 10 exponential trendline (Timothy Chow)

I should have been wise enough to realize that 10^i = e^b so can disregard the constants a and c.

Now that I see the answer to my question I realize I asked the wrong question. Changing the base does not address my problem.

To reiterate, if I have a series that grows at a 5% periodic rate, Excel's b will be ~0.0488; if at 10%, b will be ~0.0953. Excel's trendline gives the continuous growth rate, thus b will always be less than i.

I want to calculate i given Excel's b.

Messages In This Thread

 

Post Response
Your Name:
Your E-Mail Address:
Subject:
Message:

If necessary, enter your password below:

Password:
 

 

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

BGonline.org Forums is maintained by Stick with WebBBS 5.12.