MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Polynomial Trendlines


Posted by JimmyD on January 03, 2002 11:21 AM

Is there a way to force the exponent on a 'Power'
trendline in a graph.

e.g. The power trendline equation will be:
y = mx^b where 'm' and 'b' are constants

I want to force 'b' to be a particular number,
and I want Excel to calculate what the best constant
would be to fit my data.

Jimmy


Posted by Bariloche on January 03, 2002 5:48 PM

Jimmy,

You may find this thread from the Excel Programming NewsGroup on DejaNews of interest:


http://groups.google.com/groups?threadm=Pine.GSO.3.96.990326153954.27610B-100000%40equinox&rnum=5&prev=/groups%3Fq%3Dplot%2Blog%2Blog%26meta%3Dgroup%253Dmicrosoft.public.excel.programming

If that link doesn't work, its the result of doing a search for "plot log log" here:
http://groups.google.com/groups?group=microsoft.public.excel.programming

good luck

Posted by Bariloche on January 03, 2002 11:34 PM

another possibility

Jimmy,

Here's a post from that same NewsGroup that has a VBA procedure that might be of use to you:

http://groups.google.com/groups?threadm=37982F47.203F6BAA%40fiastl.net&rnum=15&prev=/groups%3Fq%3Dpolynomial%2Btrendline%26group%3Dmicrosoft.public.excel.programming%26start%3D10%26sa%3DN

That thread was obtained by searching for "polynomial trendline".


enjoy

,

: Is there a way to force the exponent on a 'Power' : trendline in a graph. : e.g. The power trendline equation will be