Forum Discussion

0liver's avatar
0liver
Copper Contributor
Aug 16, 2023

R Squared Values Impacted By Setting intercepts

Does setting the y-intercept on the excel line of best fit has an impact on the r^2 value, other than forcing the line to change? does it consider the intercept (0,0), a point, and so increases the r^2 value by going through it? Beacuse the r^2 value is increasing when I set the intercept to be at (0,0), but it should be decreasing as excel should have already found the best equation for the line if best fit, with the best r^2 value already.

 

(sorry for bad explination)

 

Thanks 

excel

1 Reply

  • 0liver's avatar
    0liver
    Copper Contributor
    Aug 17, 2023

    0liver I got a response from elsewere, the intercept is considered to be a point, and so the R^2 value increases with the addition of a point.

Resources