M
mparker
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
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