That said, it is true that the trendline 'R^2' is calculated differently in various versions of Excel, due to recent corrections.ġ. The Line chart always uses x = 1, 2, 3 etc, which might not be the actual x-values. That is, the number of decimal places that you enter into the calculator vs Excel.Īnother possible explanation is: you are using a Line chart instead of an X-Y Scatter chart. One possible explanation might be the precision of the data.
Re: ``the R^2 value for a trendline in excel it always ends up different The equation of the trendline will usually end up different too`` (Note: That might not be the same as 15 decimal places.) Show the values and coefficients with the precision of 15 significant digits. Ideally, attach an Excel file that demonstrates the problem.īut at the very least, post the data, the type of chart that you use, the trendline equation and R^2 that Excel displays, and the trendline equation and R^2 that you expect.
For a quicker useful explanations, post some details.
