There's a channel on YouTube called Statquest that teaches statistics in a pretty accessible way if you're interested in analyzing this sort of data.
There's a channel on YouTube called Statquest that teaches statistics in a pretty accessible way if you're interested in analyzing this sort of data.
To make my point in the original post, I held the group scores fixed and extrapolated combined scores based on changing population sizes. This is straightforward. Simple even.
\(\widehat S=\sum_g p_gS_g,\)
Why did I call this "linear"? (Not a "linear model", your term, because it is not). The model function actually tracks the population function. Over the 25-year period, however, this trend is in fact linear because the White-to-Hispanic population trend is linear on that timescale. Over a longer timescale it would not be.
I don't mean to disparage amateur statistics since often there are interesting things that experts miss that amateurs have insight into but this sort of data with few data points (the data you have doesn't sound independent) and a lot of confounding factors is not trivial to accurately model. Not that everyone needs to learn statistics but this sort of data (and also this topic) probably deserves a bit more of a rigorous approach.
As a very simple example, picking a time range for the model because the model doesn't work when you go farther back adds a lot of potential bias into the model and that along with the non-independence issue (and without looking at the data myself I don't know if there are other issues) are going to lead to overconfidence in conclusions.