Forum Discussion
Using Power Trend Line Equations
I am an intermidate EXCEL (version 15.32) user on a mac, and am modeling data to construct a standard curve from which to calculate Y given X. I found these equations on the Internet, and they are what is needed, but when entered into the formula line, and the green arrow is checked, the equation is not recognized by EXCEL. What is needed to make these functional? How is data entered into the y and x variables in order to return c and b in the equation y=cx^b?
c =EXP(INDEX(LINEST(LN(y),LN(x),,),1,2))
b=INDEX(LINEST(LN(y),LN(x),,),1)
Your time and energy in commenting is appreciated.
Jack
Hi Jack
Perhaps the cell is formatted as TEXT.
Detlef,
That is it. You have helped me. Thank you.
