The trip distribution table below has 5 zones. The interzonal travel times (tij) in minutes, trip generations (Oi), and trip attractions (Dj) are shown in the table. a. Calculate the number of interzonal trips between the five zones using Microsoft Excel and the Gravity Model. Assume the travel time calibration constant, x=0.5. You may stop at Iteration 4. b. Track the error (change in Tij ) between iterations using the following equation: Ek=i=15j=15TijkTijk1 where k is the iteration number. Then, plot a graph of Ek versus k for k=1,2,3, and 4 . Hint: find the difference between each Tij from one iteration to the next. Then, sum all Tij and take the absolute value. You will have one Ek value for each iteration (iterations 14) Note: you must upload your Excel file (.xlsx) to Canvas to receive credit for this problem. The trip distribution table below has 5 zones. The interzonal travel times (tij) in minutes, trip generations (Oi), and trip attractions (Dj) are shown in the table. a. Calculate the number of interzonal trips between the five zones using Microsoft Excel and the Gravity Model. Assume the travel time calibration constant, x=0.5. You may stop at Iteration 4. b. Track the error (change in Tij ) between iterations using the following equation: Ek=i=15j=15TijkTijk1 where k is the iteration number. Then, plot a graph of Ek versus k for k=1,2,3, and 4 . Hint: find the difference between each Tij from one iteration to the next. Then, sum all Tij and take the absolute value. You will have one Ek value for each iteration (iterations 14) Note: you must upload your Excel file (.xlsx) to Canvas to receive credit for this