Hello,

I was just wondering how I can create a logarithmic trendline equatio
function out of three points. I don’t want to have to manually copy i
from a chart as there are over fifty different log equations. I woul
like it to just calculate a result automatically in a cell.

Example:

Three data points:

X
15.00 23.00 35.00

Y
25.34 24.38 22.72


Trendline equation created from three point in chart:
y = -3.0925Ln(x) + 33.836

Let x = 25

y = 23.88

I sure hope you can help me this.

Thanks,

Mitchel

mparke
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message399665.htm