r-squared is the measure of how well a set of data can be represented by a linear trend line. The values range from 0 to 1, and the closer to 1, the more likely that the data is linear. It’s not perfect, and often there’s more to look at to decide on linearity, but it’s a pretty cool metric.
r-squared is the measure of how well a set of data can be represented by a linear trend line. The values range from 0 to 1, and the closer to 1, the more likely that the data is linear. It’s not perfect, and often there’s more to look at to decide on linearity, but it’s a pretty cool metric.
wow, thanks for that explanation!
Just for you, I recreated the spreadsheet and added the r2, which turns out to be 0.896:
Y’all are both awesome. One of my regrets in life is I didn’t spend more time studying statistics.