Ambulance Victoria has an official Response Time (RT) targets: Respond to incidents within 15 minutes for 85% of incidents state-wide. Response times are an important measure of the service they provide. The response times are measured from the receipt of the triple zero (000) call until paramedics arrive on scene. Response times are influenced by many factors including traffic, distance required to travel, availability of ambulances and demand for the services. They designate those patients that require urgent paramedic and hospital care as “Code 1,” and these patients receive a “lights and sirens” response. The AmbulanceVictoria file provides information about their Code 1 response time performance by Local Government Area (LGA) in the 3^rd quarter of the financial year 2015-2016.

Managerial Report

Use the data-visualization methods presented in this chapter to explore these data and discover relationships between the variables. Include the following in your report:

• Create a scatter chart to examine the relationship between the average response time and the total number of incidents. Include a trend line for this scatter chart with its formula. What does the scatter chart indicate about the average response time over the total number of incidents for these Victoria’s LGAs? (2 marks)
• Create a scatter chart to examine the relationship between the percentage of less than 15 minutes response times and the average response time. What does this scatter chart indicate about the relationship between the percentage of less than 15 minutes response times and the average response time? (2 marks)
• Create frequency distributions, percent frequency distributions and intervals in a table for the number of incidents using bin size of 250 incidents. Then, draw a histogram for the frequencies. Interpret the results. Do any data points appear to be outliers in this distribution? (3 marks)
• Create a PivotTable for these data. Use the PivotTable to generate a cross tabulation for LGA categories and rating. Determine which combinations of LGA categories and rating are most represented in the Ambulance Victoria data. Now filter the data to consider only area with average response time more than 15 minutes (900 seconds). What combinations of LGA categories and rating are most represented? What does this indicate about how the ranking of the LGAs may be defined for the other quarters of the year? (3 marks)
• Use the PivotTable to display the average incidents happened in each combination of category-rating pair of areas in the data set. Interpret the results. (2 marks)