'Why does the trend line in excel show me a wrong r^2?

I need to analyze some dispersion data (x,y) with a graph and its respective trend line. When using the help of the trend line, it generates the equation and the r^2. But when calculating the r^2 with the excel formulas, it shows me different values.

These are the values that i need to analyze

x=9.3905
9.4055
9.409
9.433
9.448
9.49
9.5055
9.5205
9.578
9.5935
9.637
9.649
9.6635
9.678
9.7065
9.7195 

y=0.338413743
0.051130936
0.116011672
0.121103582
0.084803205
0.06854196
0.040290114
0.032241627
0.035526723
0.047681584
0.030270569
0.03404843
0.027642492
0.03946884
0.038976075
0.028628021

To perform the exponential regresion, the values of y are changed to LN(y)

y'=-1.083486041
-2.973365555
-2.15406447
-2.111109048
-2.467421945
-2.680309171
-3.211649145
-3.434496906
-3.337470092
-3.043210043
-3.497579366
-3.379971359
-3.588401137
-3.232243782
-3.244807274
-3.5533693

The value of r is given by the Pearson formula

When you use the r^2 formula of excel (=RSQ(y';x)) the value is 0.588584751

Incorrect r2

Incorrect r2

With the trending line i get the value 0.4597

In other pc, it shows the correct value

Correct r2 Correct r2



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source