Learning Goal: I’m working on a management writing question and need the explanation and answer to help me learn.
Are EMS Response Times Normally Distributed?
The Texas Department of Health Services tracks EMS response times for 911 Runs by Ground Ambulance as reported to the Texas EMS Registry (link).Response Time is defined as the minutes elapsed from the time a unit was notified by dispatch to the time the unit arrived on the scene.The Excel file contains a representative data set.Render the distributions described below.
1.Create a histogram of EMS Response Times using the bin categories provided.·
- Correct chart ·
- Chart title
- Axis labels (Cut-and-paste your chart below) 2.Create a pivot chart of EMS Response Times.·
- Correct chart
- Response times are counted, notsummed
- X-axis of response times inminutes is grouped by five from 1 to 45·
- Zero is includedin the x-axis, (Cut-and-paste your chart below): 3.Explain why a stem-and-leaf diagram was not appropriate for this data set. 4. Are the collected EMS Response Times normally distributed? 5.Justify your conclusion.
Submit both your HW 5 Word and Excel files.