JohnPablo
asked on
r2 Formula for polynomial trendlines.
Hi Experts,
Given a pair of ranges (for rangeA, rangeB), I am able to calculate the r2 number by using
the following formula:
=CORREL(rangeA,rangeB)^2
Now, I need a formula to calculate the r2 for polynomial trendlines.
Thanks!
Given a pair of ranges (for rangeA, rangeB), I am able to calculate the r2 number by using
the following formula:
=CORREL(rangeA,rangeB)^2
Now, I need a formula to calculate the r2 for polynomial trendlines.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER