Forum Discussion
R2 values differ by graph type
I have a question about analyzing graphs in excel. 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?
Thank you!!
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.
2 Replies
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.
- Thank you for your help, I appreciate it!
