Thanks:  0
Likes:  0

# Thread: Power and exponential trendlines in formulas

1. Hi

I regularly produce response graphs for forecasting and use power and exponential trendlines to help plot future responses.

To speed up the process I really need to have my forecast equation linked to a cell.

I know it is possible to plot Linear x and y interception using the LINEST and INTERCEPT functions. Is there a function to plot power and exponential equations?

thanks

2. On 2002-03-18 09:27, Mr B wrote:
Hi

I regularly produce response graphs for forecasting and use power and exponential trendlines to help plot future responses.

To speed up the process I really need to have my forecast equation linked to a cell.

I know it is possible to plot Linear x and y interception using the LINEST and INTERCEPT functions. Is there a function to plot power and exponential equations?

thanks
Youcan use the LOGEST function instead of
LINEST to use a logarythmic model. GROWTH
uses an exponential model. You can also
use the TREND function to use either a linear
or polynomial model.

Good luck!

3. Thanks Tim, the GROWTH function helps.

Do you know how I can recreate a POWER trendline through a function? Or plot the interception point?

Thanks again for the earlier help.

4. On 2002-03-19 09:03, Mr B wrote:
Thanks Tim, the GROWTH function helps.

Do you know how I can recreate a POWER trendline through a function? Or plot the interception point?

Thanks again for the earlier help.
There is no direct function to do this.
You can always use the standard transform
on the data and fall back on the LINEST function:

model
LOG(y)=LOG(B) + M LOG(X) linearly.

Someone clever on the web has probably got a free add-in with a POWER function that will
do exactly what you want.

Not that I know where. Good luck!

5. ## Re: Power and exponential trendlines in formulas

I think I’m asking the same thing here, and wonder if there hav been any new discoveries in this area.

I’m using the power trend line formula to adjust data. I’d like to capture the “c” value and “b” value to plug into other formula’s, but don’t know how to extract it from the “add trend line, options, display formula on chart” series of selections so that it appears on the chart.

Is this even possible?

Thanks a gazillion.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•