I don’t know, I deleted the spreadsheet - I don’t know if it helps but it said the trend line was “linear” (unfortunately I don’t know enough about this kind of stuff, I don’t really understand r-squared or what it means)
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.
What’s the r squared on that trend line?
I don’t know, I deleted the spreadsheet - I don’t know if it helps but it said the trend line was “linear” (unfortunately I don’t know enough about this kind of stuff, I don’t really understand r-squared or what it means)
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.