Map showing changes in substantiated child abuse cases from 2011 to 2015 in PA Counties. From CNHI News and the PA DHS Child Abuse Report (The map was wrinkled in my folder) |
Corr w Philly
|
Uninsured: %
|
% in poverty
|
% increase in Child Abuse
|
Bachelors
|
Some college
|
HS Grad
|
HS Only
|
LT High School
|
HS comp
|
Trump %
|
Uninsured: %
|
1
|
|||||||||
% in poverty
|
0.34
|
1
|
||||||||
% increase in Child Abuse
|
-0.03
|
0.10
|
1
|
|||||||
Bachelors
|
-0.41
|
-0.45
|
-0.16
|
1
|
||||||
Some college
|
-0.49
|
-0.47
|
-0.13
|
0.86
|
1
|
|||||
HS Grad
|
-0.73
|
-0.45
|
0.03
|
0.63
|
0.78
|
1
|
||||
HS Only
|
0.35
|
0.42
|
0.18
|
-0.85
|
-0.97
|
-0.61
|
1
|
|||
LT High School
|
0.73
|
0.45
|
-0.03
|
-0.63
|
-0.78
|
-1.00
|
0.61
|
1
|
||
HS comp
|
0.03
|
0.03
|
-0.04
|
-0.06
|
-0.13
|
0.00
|
0.17
|
0.00
|
1
|
|
Trump %
|
0.14
|
0.03
|
0.19
|
-0.77
|
-0.66
|
-0.31
|
0.71
|
0.31
|
0.28
|
1
|
The variables that are most strongly associated with Trump's % of the vote in each county are the educational attainment variables. The strongest negative correlation with Trump's vote is the % of the county with a bachelor's degree or higher with a coefficient of -0.77. The scatter plot shows that as the % with a bachelor's or higher increases, Trump's % of the vote decreases accounting for 58.4% of the variability in this relationship (if 100% of variability were accounted for, all of the counties would form a perfect straight line). The one county that the model does not fit very well is Philadelphia which had 15% of the vote for Trump but had 25% with a bachelor's degree or higher which is close to the state rate. To look at the effect that Philadelphia County has I recreated the table and scatterplot with it excluded. 27 pairwise correlations are significant above.
The correlation table below shows more significant relationships for Trump's % of the vote with the uninsured and poverty rates having a a weakly positive relationship of 0.33 and 0.30 respectively. Looking at the % with a high school (HS) degree or higher there is a weak negative relationship (-0.52) but looking at the high school completion rate (those who enter HS in the 9th grade who finish) there is a positive relationship. Doing some subtraction to find the % in each county who have a HS degree only and those with less than a HS degree the % in the county with a HS degree only has a strong positive relationship with a coefficient of 0.74 accounting for 55% of the variability. Adding Philadelphia to the data had little effect on the correlation as can be seen in the scatterplot below.
Corr wo Philly
|
Uninsured:
%
|
% in
poverty
|
% increase in
Child Abuse
|
Bachelors
|
Some
college
|
HS
Grad
|
HS
Only
|
LT High
School
|
HS
comp
|
Trump %
|
Uninsured: %
|
1
|
|||||||||
% in poverty
|
0.24
|
1
|
||||||||
% increase in Child Abuse
|
0.00
|
0.15
|
1
|
|||||||
Bachelors
|
-0.44
|
-0.52
|
-0.15
|
1
|
||||||
Some coll
|
-0.52
|
-0.54
|
-0.13
|
0.86
|
1
|
|||||
HS Grad
|
-0.70
|
-0.39
|
0.01
|
0.67
|
0.82
|
1
|
||||
HS Only
|
0.41
|
0.54
|
0.17
|
-0.86
|
-0.98
|
-0.68
|
1
|
|||
LT High School
|
0.70
|
0.39
|
-0.01
|
-0.67
|
-0.82
|
-1.00
|
0.68
|
1
|
||
HS comp
|
0.04
|
0.04
|
-0.04
|
-0.05
|
-0.13
|
0.00
|
0.16
|
0.00
|
1
|
|
Trump %
|
0.33
|
0.30
|
0.17
|
-0.84
|
-0.73
|
-0.52
|
0.74
|
0.52
|
0.31
|
1
|
Philadelphia is an outlier for PA counties in much the same way as DC is for the rest of the states. Child abuse case increases were not correlated with any other variables. In the next post I will look at these variables in a multiple regression model. Below is the raw data for the analysis.
Name
|
Uninsured
%
|
% in
poverty
|
% increase in
Child Abuse
|
Bachelors
Or higher
|
Some
college
|
HS
Grad
|
HS
Only
|
LT High
School
|
HS
comp
|
Trump
%
|
Pennsylvania
|
7.6
|
13.1
|
23.30%
|
28.6
|
63
|
89
|
26.2
|
10.8
|
85
|
48.58
|
Adams County, PA
|
7.9
|
8.5
|
-40.3
|
21.7
|
53
|
87.3
|
34.8
|
12.7
|
92
|
66.17
|
Allegheny County, PA
|
6
|
12.2
|
14.8
|
37.8
|
77
|
93.5
|
16.3
|
6.5
|
89
|
39.91
|
Armstrong County, PA
|
7.2
|
12.6
|
16
|
15
|
54
|
88.9
|
34.6
|
11.1
|
89
|
74.27
|
Beaver County, PA
|
5.5
|
13.1
|
37.5
|
22.8
|
66
|
91.7
|
25.6
|
8.3
|
74
|
57.64
|
Bedford County, PA
|
8.5
|
13.9
|
275
|
13.5
|
47
|
86.0
|
38.7
|
14.0
|
92
|
82.72
|
Berks County, PA
|
8.6
|
12.6
|
17.7
|
23.2
|
57
|
85.1
|
28.4
|
14.9
|
84
|
52.78
|
Blair County, PA
|
6.4
|
15.3
|
12.5
|
19.6
|
54
|
90.5
|
36.2
|
9.5
|
88
|
71.27
|
Bradford County, PA
|
8.1
|
13
|
-4.3
|
17.6
|
46
|
88.5
|
42.7
|
11.5
|
89
|
70.57
|
Bucks County, PA
|
5.8
|
6.3
|
-31.7
|
37.4
|
72
|
93.5
|
21.7
|
6.5
|
92
|
47.74
|
Butler County, PA
|
4.9
|
9.5
|
-19.2
|
32.3
|
72
|
93.0
|
20.8
|
7.0
|
95
|
66.37
|
Cambria County, PA
|
6.6
|
14.9
|
65.2
|
19.1
|
58
|
89.6
|
31.6
|
10.4
|
90
|
67
|
Cameron County, PA
|
7.4
|
13.3
|
100
|
15.7
|
59
|
89.5
|
30.5
|
10.5
|
72.69
|
|
Carbon County, PA
|
7.1
|
11.5
|
9.5
|
15.5
|
52
|
88.7
|
36.9
|
11.3
|
81
|
65.13
|
Centre County, PA
|
7.9
|
16.1
|
110
|
41.4
|
72
|
93.2
|
21.3
|
6.8
|
92
|
46.32
|
Chester County, PA
|
6.4
|
6
|
-20.3
|
49.1
|
75
|
92.7
|
17.5
|
7.3
|
89
|
43.2
|
Clarion County, PA
|
8.1
|
17.4
|
322.2
|
20.1
|
56
|
88.7
|
33.1
|
11.3
|
94
|
71.72
|
Clearfield County, PA
|
7.3
|
16.6
|
41.9
|
13.2
|
45
|
87.1
|
41.7
|
12.9
|
89
|
72.75
|
Clinton County, PA
|
7.6
|
16
|
66.7
|
16.9
|
52
|
87.1
|
35.5
|
12.9
|
93
|
65.1
|
Columbia County, PA
|
6.7
|
15
|
18.8
|
21.1
|
54
|
88.5
|
34.0
|
11.5
|
88
|
63.78
|
Crawford County, PA
|
9.8
|
15.3
|
-21.2
|
19.8
|
52
|
87.7
|
35.4
|
12.3
|
90
|
66.65
|
Cumberland County, PA
|
6.8
|
7.3
|
102
|
32.7
|
66
|
91.5
|
26.0
|
8.5
|
90
|
56.8
|
Dauphin County, PA
|
7.4
|
13.6
|
146
|
28.4
|
63
|
88.8
|
25.8
|
11.2
|
84
|
46.51
|
Delaware County, PA
|
6.8
|
10.4
|
27
|
36
|
69
|
92.2
|
23.0
|
7.8
|
76
|
37.18
|
Elk County, PA
|
6
|
9.3
|
220
|
16.8
|
53
|
91.1
|
38.1
|
8.9
|
91
|
69.49
|
Erie County, PA
|
6.9
|
17.1
|
-18.3
|
26.1
|
59
|
90.8
|
31.3
|
9.2
|
87
|
48.57
|
Fayette County, PA
|
7.5
|
20.1
|
67.5
|
14.2
|
48
|
86.8
|
38.7
|
13.2
|
79
|
64.33
|
Forest County, PA
|
8.3
|
24.3
|
66.7
|
8.5
|
16
|
80.5
|
64.7
|
19.5
|
70.1
|
|
Franklin County, PA
|
9.4
|
9.4
|
23.4
|
19
|
50
|
86.0
|
35.8
|
14.0
|
86
|
71.37
|
Fulton County, PA
|
7.8
|
11.6
|
42.9
|
13.1
|
46
|
85.1
|
39.5
|
14.9
|
86
|
84.09
|
Greene County, PA
|
6.5
|
15.1
|
300
|
17.7
|
45
|
86.9
|
42.0
|
13.1
|
85
|
68.82
|
Huntingdon County, PA
|
7
|
14.3
|
80
|
14.3
|
44
|
88.8
|
45.1
|
11.2
|
89
|
73.55
|
Indiana County, PA
|
8.7
|
18.2
|
-4.3
|
22.6
|
58
|
88.5
|
30.4
|
11.5
|
94
|
65.89
|
Jefferson County, PA
|
8.8
|
14.6
|
58.3
|
14.6
|
49
|
88.6
|
39.3
|
11.4
|
92
|
78
|
Juniata County, PA
|
9.9
|
12.8
|
-81.3
|
13.1
|
37
|
81.7
|
44.8
|
18.3
|
94
|
79.14
|
Lackawanna County, PA
|
7.8
|
15.3
|
46.6
|
25.9
|
63
|
89.9
|
27.2
|
10.1
|
83
|
46.77
|
Lancaster County, PA
|
11.1
|
10.6
|
0
|
25.2
|
53
|
84.5
|
31.0
|
15.5
|
90
|
57.2
|
Lawrence County, PA
|
7.1
|
17.5
|
-16.7
|
19.7
|
60
|
89.2
|
29.5
|
10.8
|
93
|
62.4
|
Lebanon County, PA
|
8.7
|
11.6
|
89.7
|
19.6
|
52
|
85.7
|
33.5
|
14.3
|
86
|
65.53
|
Lehigh County, PA
|
8.6
|
12.1
|
18.8
|
28.5
|
62
|
87.4
|
25.0
|
12.6
|
84
|
45.77
|
Luzerne County, PA
|
7.8
|
15.1
|
52.1
|
21.4
|
59
|
88.9
|
29.8
|
11.1
|
87
|
58.29
|
Lycoming County, PA
|
7.2
|
14.8
|
46.6
|
20.4
|
57
|
88.0
|
31.3
|
12.0
|
87
|
70.46
|
Mc Kean County, PA
|
7.2
|
16.9
|
-20.7
|
16.7
|
48
|
89.7
|
41.7
|
10.3
|
90
|
71.4
|
Mercer County, PA
|
7.9
|
14.2
|
76.2
|
21.5
|
56
|
89.1
|
33.2
|
10.9
|
93
|
60.3
|
Mifflin County, PA
|
10.7
|
15.4
|
57.9
|
11.6
|
43
|
82.2
|
39.2
|
17.8
|
89
|
75.77
|
Monroe County, PA
|
8.5
|
12.7
|
12.7
|
23
|
64
|
89.7
|
26.2
|
10.3
|
89
|
47.86
|
Montgomery County, PA
|
5.3
|
6.6
|
8.6
|
46.9
|
78
|
93.8
|
15.8
|
6.2
|
94
|
37.44
|
Montour County, PA
|
5
|
9
|
50
|
28.8
|
61
|
89.4
|
28.3
|
10.6
|
88
|
61.8
|
Northampton County, PA
|
6.9
|
8.8
|
-10.7
|
27.2
|
66
|
89.8
|
23.6
|
10.2
|
73
|
49.98
|
Northumberland County, PA
|
7.3
|
13.1
|
23.8
|
14.6
|
45
|
85.6
|
40.6
|
14.4
|
87
|
69.43
|
Perry County, PA
|
9.3
|
9.6
|
0
|
16
|
55
|
88.5
|
33.4
|
11.5
|
91
|
73.81
|
Philadelphia County, PA
|
11
|
25.4
|
-9.2
|
25.4
|
58
|
82.0
|
23.7
|
18.0
|
88
|
15.37
|
Pike County, PA
|
8.6
|
10.9
|
200
|
23.7
|
63
|
91.0
|
28.3
|
9.0
|
70
|
61.51
|
Potter County, PA
|
7.8
|
14.3
|
0
|
15.7
|
51
|
87.8
|
37.2
|
12.2
|
92
|
80.31
|
Schuylkill County, PA
|
7.9
|
13
|
15.8
|
15.4
|
51
|
87.5
|
36.1
|
12.5
|
69.99
|
|
Snyder County, PA
|
10.5
|
11.7
|
38.9
|
16.5
|
45
|
82.4
|
37.7
|
17.6
|
89
|
71.66
|
Somerset County, PA
|
8.7
|
14.4
|
-36
|
15.3
|
47
|
86.5
|
39.8
|
13.5
|
87
|
76.54
|
Sullivan County, PA
|
8.9
|
13.5
|
300
|
16.1
|
47
|
89.6
|
42.7
|
10.4
|
93
|
73.05
|
Susquehanna County, PA
|
9.3
|
12.6
|
-17.2
|
17.1
|
49
|
89.1
|
40.5
|
10.9
|
68.34
|
|
Tioga County, PA
|
8.6
|
13.1
|
72.2
|
19.6
|
55
|
88.4
|
33.0
|
11.6
|
95
|
74.29
|
Union County, PA
|
8.9
|
12.4
|
45.5
|
20.5
|
46
|
83.9
|
37.5
|
16.1
|
88
|
60.81
|
Venango County, PA
|
7.3
|
13.5
|
22.2
|
15.8
|
50
|
89.0
|
39.0
|
11.0
|
95
|
68.62
|
Warren County, PA
|
7.1
|
12.2
|
-30.8
|
18.1
|
55
|
90.5
|
35.4
|
9.5
|
90
|
67.68
|
Washington County, PA
|
5.7
|
10.1
|
29.2
|
27.4
|
67
|
91.3
|
24.5
|
8.7
|
89
|
60.51
|
Wayne County, PA
|
8.1
|
13.3
|
-13.6
|
19.7
|
50
|
89.3
|
39.7
|
10.7
|
90
|
67.63
|
Westmoreland County, PA
|
5.9
|
11.3
|
-1.5
|
26.4
|
68
|
92.7
|
25.0
|
7.3
|
94
|
64.01
|
Wyoming County, PA
|
6.9
|
11.1
|
200
|
18.2
|
50
|
91.2
|
40.9
|
8.8
|
91
|
67.23
|
York County, PA
|
7.1
|
10.4
|
21.9
|
22.8
|
57
|
88.3
|
31.8
|
11.7
|
94
|
62.4
|
**Related Posts**