B
Bruce
Hi,
I wish to return the logarithm stats based on the log line of best fit.
I can do this for linear and poly entered as an array formula as follows;
For linear
=LINEST(C58:C69,B58:B69,,1)
For 2nd order poly (quadratic)
=LINEST(C58:C69,B58:B69^{1,2},,1)
How do i modify this for a logarithm?
Bruce
I wish to return the logarithm stats based on the log line of best fit.
I can do this for linear and poly entered as an array formula as follows;
For linear
=LINEST(C58:C69,B58:B69,,1)
For 2nd order poly (quadratic)
=LINEST(C58:C69,B58:B69^{1,2},,1)
How do i modify this for a logarithm?
Bruce