...
It A Perl script covid-us.pl was developed to gather the above information and cast it in a suitable form for the www.charte.ca motion charts and correlation data. See here for an example. The script also ranks the age, income, and education demographics for each state or county into low, medium, or high based on their their tertiles. This is so these demographics can be used with the chare charte.ca's grouping feature.A Perl script covid-us.pl was developed to gather the above information and cast it in a suitable form for the www.charte.ca motion charts and correlation data. See here for an example.
...
Results
US
Motion chart of deaths vs Covid-19 Confirmed cases with bubbles sized by population for US states and colored by political leaning
...
We investigated the correlations between the demographics and the confirmed Covid-19 case cases for CA. We used the R squared coefficient of determination to characterize the degree of correlation between the various demographics using a linear fit.
| Demographic | Income | Education | Cases | Politics | Age | Population density | Population | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Per capita income | * | 0.81 | 0.0032 | .28 | 0.008 | 0.12 | 0.19 | ||||||
% of people completing college education for CA | 0.81 | * | 0.016 | 0.43 | 0.009 | 0.20 | 0.043 | ||||||
| Covid-19 confirmed cases | 0.0032 | 0.016 | * | 0.34 | 0.012 | 0.14 | 0.77 | ||||||
| % of Registered voters who are registered as Democratic | 0.28 | 0.43 | 0.034 | * | 0.089 | 0.15 | 0.081 | ||||||
| Median age | 0.008 | 0.008 | 0.012 | 0.0089 | * | 0.0029 | 0.084 | ||||||
| Population density (people/sq mile) | 0.12 | 0.20 | 0.14 | 0.25 | 0.0029 | * | |||||||
| Population | 0.19 | 0.043 | 0.77 | 0.081 | 0.084 | * |
It is seen that there is strong correlation between the per capita income and education and between confirmed cases and population, a medium correlation between registered voter political leaning and education. Otherwise here is little correlation between other metrics. The excel spreadsheet of the analysis of the above demographics can be found here.
Ungrouped
Deaths vs Confirmed:
...