Hi,
I'm using the "Power" trendline in an XY scatter chart and want to use the formula and the rsquared result in a worksheet.
The formula is: y = 644.691x^-0.895
I've looked at LINEST but that seems to only give a straight line trend?
LOGEST gives me the exponential result?
Basically I'm worried about using the rsquared value from the chart if I don't have it through a function as well.
Anyone able to help?
Thanks!
I'm using the "Power" trendline in an XY scatter chart and want to use the formula and the rsquared result in a worksheet.
The formula is: y = 644.691x^-0.895
I've looked at LINEST but that seems to only give a straight line trend?
LOGEST gives me the exponential result?
Basically I'm worried about using the rsquared value from the chart if I don't have it through a function as well.
Anyone able to help?
Thanks!