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
| 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
| 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 |
|