Forum Discussion
R2 values differ by graph type
CastineBernardy wrote: ``When I select the same data, the R2 value is different when I plot it on a bar graph versus a scatter plot. Does anyone know why that is?``
The x-axis values in charts other than XY Scatter charts are always 1, 2, 3 etc -- not the x-values in your data.
Unless your actual x-values are 1, 2, 3 etc, the trendline formula and R^2 are not valid unless you use an XY Scatter chart.
This is explained in a support.microsoft webpage. But, sigh, my search engines cannot find it.
CastineBernardy wrote: ``When I select the same data, the R2 value is different when I plot it on a bar graph versus a scatter plot. Does anyone know why that is?``
The x-axis values in charts other than XY Scatter charts are always 1, 2, 3 etc -- not the x-values in your data.
Unless your actual x-values are 1, 2, 3 etc, the trendline formula and R^2 are not valid unless you use an XY Scatter chart.
This is explained in a support.microsoft webpage. But, sigh, my search engines cannot find it.
