Julian Flowers
14th April 2016
'data.frame': 7750 obs. of 11 variables:
$ practice: chr "A81007" "A81008" "A81009" "A81011" ...
$ ccg : chr "NHS Hartlepool And Stockton-On-Tees CCG" "NHS South Tees CCG" "NHS South Tees CCG" "NHS Hartlepool And Stockton-On-Tees CCG" ...
$ 0-4 : num 5.28 5.99 6.66 5.53 7.32 ...
$ 5-14 : num 12.5 11 12.1 10.6 12 ...
$ <18 : num 21.5 20.5 22.6 19.7 22.9 ...
$ 65+ : num 18.6 16.6 14.7 18.6 14.3 ...
$ 75+ : num 9.26 7.73 6.72 8.51 7.34 ...
$ 85+ : num 2.71 2.06 1.82 1.92 1.79 ...
$ imd : num 31.7 51.9 35.5 34.8 49.7 ...
$ pop : int 9525 4088 9265 11285 4756 6077 3786 3021 9505 21147 ...
$ eth : num 0.974 0.956 0.87 0.977 0.91 ...
These charts show the relationship between the demographic variables. We can see that there are strong correlations between 65+, 75+, and 85+ populations, and <18 and 5-14.
For the sake of parsimony, we will use 75+ and 5-14.
Number_clusters Value_Index
15.0000 0.2028
clust | 0-4 | 5-14 | 65+ | 75+ | 85+ | imd | pop | eth | size |
---|---|---|---|---|---|---|---|---|---|
10 | 5.06 | 11.20 | 20.38 | 8.98 | 2.59 | 12.75 | 5512.78 | 0.94 | 1054 |
12 | 4.76 | 10.39 | 23.83 | 11.09 | 3.31 | 14.01 | 10943.64 | 0.96 | 741 |
4 | 5.32 | 10.17 | 19.12 | 8.62 | 2.41 | 28.75 | 4145.22 | 0.92 | 728 |
1 | 7.01 | 12.69 | 13.61 | 5.86 | 1.69 | 17.19 | 5540.70 | 0.87 | 719 |
15 | 6.00 | 11.22 | 18.13 | 8.22 | 2.33 | 27.92 | 10082.02 | 0.92 | 705 |
7 | 6.01 | 11.57 | 17.44 | 7.88 | 2.34 | 14.12 | 13979.04 | 0.91 | 631 |
2 | 3.93 | 9.08 | 28.24 | 13.37 | 4.04 | 16.50 | 4923.83 | 0.96 | 604 |
8 | 6.84 | 12.51 | 14.21 | 6.28 | 1.67 | 42.92 | 4903.61 | 0.87 | 587 |
11 | 7.27 | 13.62 | 9.42 | 4.33 | 1.10 | 32.08 | 5319.93 | 0.42 | 500 |
3 | 5.72 | 9.74 | 10.43 | 4.72 | 1.24 | 28.38 | 5257.22 | 0.54 | 469 |
5 | 9.70 | 15.12 | 8.34 | 3.48 | 0.95 | 36.96 | 4450.73 | 0.82 | 283 |
6 | 7.63 | 13.16 | 10.96 | 5.02 | 1.42 | 28.26 | 12837.59 | 0.65 | 269 |
14 | 9.48 | 18.47 | 6.60 | 3.13 | 0.77 | 43.68 | 5303.04 | 0.37 | 245 |
13 | 3.02 | 4.57 | 6.90 | 2.98 | 0.86 | 23.84 | 9058.90 | 0.73 | 159 |
9 | 5.19 | 9.91 | 16.29 | 7.41 | 2.16 | 19.53 | 28190.84 | 0.89 | 56 |