USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

U.S. Department of Transportation U.S. Department of Transportation Icon United States Department of Transportation United States Department of Transportation

Table 3 - Illustrative Computation of Competitive Accessibilities and Average Costs

Wednesday, November 30, 2011

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