Explore BrainMass

Explore BrainMass

    Drawing Conclusions for Ambulance Departments

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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?

    © BrainMass Inc. brainmass.com June 3, 2020, 10:46 pm ad1c9bdddf


    Solution Preview

    Dear Student,

    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:

    Tools ...

    Solution Summary

    The solution examines drawing conclusion for ambulance departments.