Problem $2$

By using a spread sheet program $($refer to the attached example Excel file$),$ calibrate a trip distribution model for the base year data. Categorize travel times into four groups $(0-5,5-10,1015,$ and $15-20)$ and find four friction factors. Show ALL calculations for three iterations $($or until convergence$).$ Use destination balancing.

$\backslash$table$[[$BASE$,$Travel Times,BASE,Trip interchanqes,$],[$Fromito$,1,2,3,4,$FramlTo,$1,2,3,4],[1,5,16,13,18,1,250,125,375,75],[2,16,7,20,12,2,100,400,50,225],[3,13,20,2,9,3,205,60,225,420],[4,18,12,9,3,4,156,215,320,175]]$