A supervisor suggests that the old computer program for estimating delivery times (used in

problems 1-3) be abandoned. Instead, schedulers could use an alternative such as MapQuest to

estimate driving times. As a pilot study, 500 recent deliveries were randomly selected. The Excel

file named SP20_Midterm_Data.xls contains the following variables:

Actual Times: actual time required to make delivery

Old Model Deviations: difference in actual delivery time and predicted delivery time

using old computer prediction model

MapQuest: predicted delivery times for the randomly selected routes using MapQuest

Use the data to calculate the deviations for the MapQuest estimates

(DMapQuest = actual delivery time - MapQuest predicted delivery time), then construct an

appropriate graph for comparing the deviations for the Old Computer model and the MapQuest

model. Interpret the results and indicate which prediction model should be used in the future.

(Do NOT include the calculated deviations here. Do include the graph and interpretation.)