Table 3 - Illustrative Computation of Competitive Accessibilities and Average Costs

Table 3 - Illustrative Computation of Competitive Accessibilities and Average Costs

Excel | CSV

b = 1.0 Comparison between total of residences and total of jobs, over 35 zones; includes accessibilities and derived average costs.

Accessibilities
Accessibility to employment Accessibility to residents
Simple Ratio Discounted Gravity Simple Ratio Discounted Gravity
0.045 0.515 0.371 0.087 0.088 1.942 1.332 0.657
0.056 0.541 0.448 0.112 0.103 1.847 1.414 0.663
0.057 0.565 0.472 0.131 0.100 1.770 1.309 0.557
0.058 0.653 0.549 0.164 0.088 1.532 1.129 0.419
0.058 0.805 0.672 0.209 0.071 1.242 0.926 0.291
0.055 1.057 0.829 0.262 0.052 0.946 0.719 0.189
0.041 1.232 0.766 0.244 0.033 0.811 0.511 0.115
0.079 0.675 0.567 0.159 0.117 1.481 1.292 0.614
0.092 0.658 0.643 0.192 0.139 1.520 1.449 0.659
0.095 0.683 0.681 0.220 0.138 1.463 1.377 0.575
0.091 0.740 0.738 0.255 0.124 1.351 1.215 0.449
0.091 0.922 0.899 0.317 0.099 1.084 0.999 0.319
0.080 1.147 1.012 0.359 0.069 0.872 0.768 0.209
0.056 1.333 0.903 0.320 0.042 0.750 0.527 0.124
0.135 0.941 0.893 0.287 0.144 1.063 1.160 0.526
0.142 0.817 0.897 0.312 0.173 1.224 1.348 0.586
0.144 0.799 0.914 0.348 0.180 1.251 1.348 0.543
0.139 0.831 0.955 0.389 0.167 1.204 1.242 0.450
0.123 0.931 1.003 0.416 0.132 1.074 1.030 0.329
0.098 1.129 1.028 0.423 0.087 0.886 0.760 0.211
0.065 1.318 0.880 0.357 0.049 0.759 0.502 0.123
0.178 1.107 1.127 0.407 0.161 0.904 1.064 0.458
0.189 1.031 1.146 0.446 0.184 0.970 1.175 0.486
0.200 0.919 1.181 0.510 0.217 1.088 1.308 0.506
0.208 0.978 1.297 0.602 0.213 1.022 1.266 0.445
0.175 1.019 1.251 0.592 0.172 0.981 1.099 0.344
0.120 1.128 1.107 0.518 0.106 0.886 0.795 0.218
0.072 1.258 0.870 0.397 0.057 0.795 0.524 0.125
0.144 1.051 0.944 0.363 0.137 0.951 0.890 0.364
0.169 1.106 1.040 0.434 0.152 0.904 0.910 0.361
0.211 1.020 1.241 0.578 0.207 0.980 1.125 0.419
0.288 1.803 1.809 0.904 0.160 0.555 0.890 0.306
0.193 1.168 1.334 0.678 0.165 0.856 0.957 0.292
0.126 1.394 1.160 0.584 0.091 0.718 0.616 0.169
0.074 1.527 0.940 0.460 0.049 0.655 0.412 0.097

 

Correlations among eight accessibility measures, four in each of two groups
1.000 0.351 0.856 0.823 0.832 -.393 0.224 0.139
0.351 1.000 0.731 0.736 -.192 -.937 -.797 -.789
0.856 0.731 1.000 0.974 0.476 -.769 -.257 -.363
0.823 0.736 0.974 1.000 0.437 -.737 -.287 -.390
0.832 -.192 0.476 0.437 1.000 0.080 0.669 0.576
-.393 -.937 -.769 -.737 0.080 1.000 0.768 0.804
0.224 -.797 -.257 -.287 0.669 0.768 1.000 0.964
0.139 -.789 -.363 -.390 0.576 0.804 0.964 1.000

 

Derived average costs
Accessibility to employment Accessibility to residents
Simple Ratio Discounted Gravity Simple Ratio Discounted Gravity
3.090 0.664 0.992 2.440 2.427 -.664 -.287 0.420
2.886 0.613 0.803 2.187 2.272 -.613 -.347 0.411
2.870 0.571 0.751 2.031 2.299 -.571 -.269 0.585
2.852 0.427 0.599 1.810 2.426 -.427 -.122 0.869
2.856 0.217 0.398 1.564 2.639 -.217 0.077 1.234
2.897 -.056 0.188 1.341 2.952 0.056 0.329 1.664
3.205 -.209 0.267 1.412 3.414 0.209 0.671 2.165
2.539 0.392 0.567 1.842 2.146 -.392 -.256 0.487
2.390 0.419 0.442 1.652 1.971 -.419 -.371 0.418
2.358 0.381 0.384 1.513 1.978 -.381 -.320 0.554
2.392 0.301 0.303 1.366 2.091 -.301 -.195 0.800
2.397 0.081 0.107 1.149 2.316 -.081 0.001 1.143
2.530 -.137 -.012 1.025 2.667 0.137 0.264 1.566
2.885 -.287 0.102 1.139 3.172 0.287 0.641 2.087
2.000 0.061 0.113 1.249 1.939 -.061 -.149 0.642
1.955 0.203 0.109 1.165 1.753 -.203 -.299 0.534
1.937 0.224 0.090 1.056 1.712 -.224 -.299 0.610
1.973 0.185 0.046 0.945 1.787 -.185 -.216 0.798
2.099 0.071 -.003 0.876 2.027 -.071 -.029 1.113
2.326 -.121 -.027 0.860 2.447 0.121 0.275 1.555
2.737 -.276 0.128 1.031 3.013 0.276 0.689 2.100
1.725 -.101 -.120 0.900 1.826 0.101 -.062 0.781
1.664 -.031 -.136 0.808 1.694 0.031 -.161 0.722
1.610 0.084 -.167 0.673 1.526 -.084 -.269 0.682
1.570 0.022 -.260 0.507 1.548 -.022 -.236 0.809
1.742 -.019 -.224 0.524 1.760 0.019 -.094 1.068
2.121 -.120 -.102 0.658 2.242 0.120 0.230 1.524
2.634 -.230 0.139 0.923 2.864 0.230 0.647 2.079
1.937 -.050 0.058 1.014 1.987 0.050 0.116 1.011
1.780 -.101 -.040 0.834 1.881 0.101 0.094 1.020
1.556 -.020 -.216 0.549 1.576 0.020 -.117 0.869
1.244 -.589 -.593 0.101 1.833 0.589 0.116 1.184
1.645 -.155 -.288 0.389 1.800 0.155 0.043 1.232
2.069 -.332 -.149 0.538 2.401 0.332 0.484 1.780
2.602 -.424 0.062 0.776 3.025 0.424 0.887 2.330