If you are interested in the trend line statistics you can find them below.
- Trend Line Statistics
Trend Lines Model
A linear trend model is computed for Percentage without Internet given Percentage in Poverty. The model may be significant at p <= 0.05.
Model formula: ( Percentage in Poverty + intercept ) Number of modeled observations: 819 Number of filtered observations: 0 Model degrees of freedom: 2 Residual degrees of freedom (DF): 817 SSE (sum squared error): 2.56574 MSE (mean squared error): 0.0031404 R-Squared: 0.452575 Standard error: 0.0560396 p-value (significance): < 0.0001
Individual trend lines:
Panes Line Coefficients Row Column p-value DF Term Value StdErr t-value p-value Percentage without Internet Percentage in Poverty < 0.0001 817 Percentage in Poverty 0.922455 0.0354937 25.9893 < 0.0001 intercept 0.0961313 0.0055128 17.4378 < 0.0001
The data for this visualization comes from the United States Census Bureau. It is gathered during the American Community Survey. I used 2015, 1 Year Estimates for each county with a population of more than 65,000 people. This can be found at American Fact Finder under Table S2801 and S1701. Once I had the data from the table, I cleaned it in Excel and used Tableau to create this visualization.
There are a couple of things worth noting when viewing this graphic. First, this is only the counties in the U.S. with a population of more than 65,000 people. Counties with less people than that are not available as a selectable geography in the ACS 1 year data files. Second, the percentage of poverty is only for people that the ACS could determine the poverty level. Finally, the percentage of people in poverty is a person level statistic and internet connection is a household level statistic. In some counties this could have an effect on the data, especially ones with above or below average household size. If you have any questions about these limitations or the data visualization be sure to leave a comment below or reach out to us on Twitter.
If you want to keep up with our surveys and data analysis, be sure to follow us on Twitter and Facebook.
— Overflow Data (@overflow_data) March 21, 2017