1. Traffic Engineers need estimates of the number of vehicles on roads in a local community. These estimates are used to set the timing of traffic lights and for the design of roadways. The table contains a set of data for a median sized city that is separated into 46 zones. The variable of interest (Y) is the number of daily work trips made in a zone. This variable is some function of the zone population, the number of dwellings in the zone and the number of vehicles in the zone. Using the data in the table, find the minimum and maximum values of Y. Then generate 25 values of Y using the rand function. Transform each of the 25 random values (ui) to values of Y using the following transformation model: Yimin +ui(max-min) X3 X2 Variable Y X1 Definition Units Number of daily work trips made in a zone Zone population Count (103) Count (10) Number of dwellings in a zone Count (10) Number of vehicles in a zone Count (103) X1 X2 X3 Y X1 X2 X3 Y 20.009 6.33 10.223 1.776 23.235 4.17 7.156 1.616 21.739 2.327 5.661 1.479 14.258 7.398 12.071 1.5 24.471 2.17 7.509 0.858 18.487 2.936, 6.098 0.788 17.589 1.851 6.237 0.542 10.716 4.131 6.923 0.912 24.285 5.109 7.806 1.627 13.84 2.186, 4.882 0.783 21.27 5.476 8.034 1.289 17.776 6.699, 8.775 1.469 15.582 6.016, 9.108 1.384 17.875 4.31 6.234 1.281 19.987 3.575 6.452 1.103 17.254 4.445 9.435 1.171 14.97 6.717 12.142 1.256 21.493 4.356, 7.367 0.987 18.327 4.375 7.073 1.081 19.874 4.069 6.643 1.282 20.342 3.391 6.071 1.44 19.225 1.425 3.873 0.571 21.068 4.16 7.764 1.175 14.848 4.227 6.173 1.135 21.192 2.976, 5.792 1.556 19.547 3.478 5.234 0.956 26.998 3.671 9.176 1.455 24.242 2.931 7.135 1.173 19.925 3.566 11.634 1.432 22.188 3.929 6.513 1.175 17.219 4.905 7.845 1.489 19.78 8.15 11.272 1.743 20.172 3.41 8.665 1.233 22.949 2.85 4.857 1.458 20.465 3.715 7.291 1.217 26.663, 2.809 8.262 1.167 20.599 3.115 9.182 1.094 13.01 5.57 8.999 1.086 24.416 1.209 5.719 0.721 23.88 6.388 8.616 1.887 19.724 3.643 6.821 0.797 11.243 4.672 5.357 1.011 24.505 4.954 7.716 1.64 15.016 2.526 6.983 0.919 9.726 4.313 7.45 0.975 19.528 4.797 7.932 1.176