We know we can fit a series of data points to a trendline, which can be linear, exponential, polynomial or a couple of others.
Excel's exponential trendline takes the form y=ae^bx, where e is the natural log function base. Excel calculates the best-fit values for the constants a and b.
Instead of fitting to an exponential trendline using base e, I would like to fit the data to base 10. In other words, y=p10^ix.
Note that when i is relatively small, it will be roughly close to b in value. So, for example, if I have a series that grows at a 5% annual rate, Excel's b will be 0.0488; if at 10%, b will be 0.0953.
Thus I prefer to fit the data to a base 10 trendline so I get the percent rate, i.
My Algebra 2 is rusty, so I have not figured out a way to convert from one to the other. The goal is to let Excel calculate b and then convert b to the corresponding i.
I will appreciate your help in figuring out the conversion. Thanks in advance for your assistance.
Excel's exponential trendline takes the form y=ae^bx, where e is the natural log function base. Excel calculates the best-fit values for the constants a and b.
Instead of fitting to an exponential trendline using base e, I would like to fit the data to base 10. In other words, y=p10^ix.
Note that when i is relatively small, it will be roughly close to b in value. So, for example, if I have a series that grows at a 5% annual rate, Excel's b will be 0.0488; if at 10%, b will be 0.0953.
Thus I prefer to fit the data to a base 10 trendline so I get the percent rate, i.
My Algebra 2 is rusty, so I have not figured out a way to convert from one to the other. The goal is to let Excel calculate b and then convert b to the corresponding i.
I will appreciate your help in figuring out the conversion. Thanks in advance for your assistance.
