dversloot1
Board Regular
- Joined
- Apr 3, 2013
- Messages
- 113
Hello,
I've noticed some significant differences between the R^2 value on a 3 order polynomial trendline on a chart and that of a RSQ function. From my understanding, the RSQ function doesn't provide an accurate 3 order polynomial R^2 value.
Does anyone know how to calculate this either via VBA or an Excel function?
Known X's: Top row
Known Y's: Bottom Row
<tbody>
</tbody>
R^2 on Chart: 0.6948
RSQ Function: 0.02248
I hope someone can provide an excel function to arrive at the 0.6948.
Thanks,
Dan
I've noticed some significant differences between the R^2 value on a 3 order polynomial trendline on a chart and that of a RSQ function. From my understanding, the RSQ function doesn't provide an accurate 3 order polynomial R^2 value.
Does anyone know how to calculate this either via VBA or an Excel function?
Known X's: Top row
Known Y's: Bottom Row
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
17.52% | 6.54% | 5.23% | 6.11% | 5.48% | 7.84% | 7.81% | 10.32% | 8.16% | 8.51% | 7.98% | 8.51% |
<tbody>
</tbody>
R^2 on Chart: 0.6948
RSQ Function: 0.02248
I hope someone can provide an excel function to arrive at the 0.6948.
Thanks,
Dan