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.
just for fun here are those numbers on a bar chart in a spreadsheet - looks like the graphic is decently honest in its depiction
Wonder how thay scales verse popularion growth
Either way, nice to see it take a fat dump on the racist halftime show
pulling annual US population data from: https://www.macrotrends.net/global-metrics/countries/usa/united-states/population
(take this with a grain of salt, the last US census was in 2020, I don’t know how they calculate these numbers)
this is what I put together:
Looks like the growth of half-time show audience is faster than population growth.
EDIT: this is the third time I have recreated this damn spreadsheet, lol
you da bomb
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.