Between mar, 1, 1994 and aug 31, 1994, all calls that involved both ambulance and fire department personnel were monitored. The times for each service to arrive at the scene were recorded using the following format:
Column 1: call number for Cambridge calls
Column 2: time in minutes for fire truck to arrive
Column 3: time in minutes for the fire truck to arrive
Column 4: call number for Kitchener calls
Column 5: time in minutes for the the ambulance to arrive
Column 6: time in minutes for fire truck to arrive
Column 7: call number for Waterloo calls:
Column 8: time in minutes for the ambulance
Column 9: time in minutes for fire truck to arrive
It has been decided that the training of fire department personnel is warranted only if it can be shown that a fire truck arrives at the scene on average more than 1 minute sooner than an ambulance and that the frequency of arrival within 8 minutes is greater for the fire department.
What conclusions can be drawn from the data?
It is a relatively simple to solve in Excel. You can use Excel's AVERAGE formula to calculate the average time of arrival for fire trucks and ambulances. However, I used Excel's statistical tool to solve the problem to show you other descriptive statistics. This is how you do it in Excel:
The solution examines drawing conclusion for ambulance departments.