'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
With the trending line i get the value 0.4597
In other pc, it shows the correct value
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|


