Ambulance Victoria has requested data on the performance of their Response Time (RT) target. The RT target is to respond to incidents within 15 minutes for 85% of incidents state-wide. Response time is an important measure of the quality of service that they provide. The response time is measured from the time that a triple zero (000) call was received until paramedics arrive on the scene. Response times are influenced by many factors including traffic, the distance required to travel, availability of ambulances, and demand for the services.

The paramedics designate patients who require urgent paramedic and/or hospital care as "Code 1", and these patients receive a "lights and sirens" response. The AmbulanceVictoria dataset (available from the assessment page in Canvas) provides information regarding the ?Code 1? response times for various Local Government Area (LGA) categories during the 3rd quarter of the financial year 2015-2016.

Create a managerial report for Ambulance Victoria Apply the appropriate?descriptive statistical methods to analyse?the provided datasets for Ambulance Victoria.

You must include your interpretation of the data in your report. Include the following in your report:

Data-visualization methods including 5 plot?s/tables that give insights on the Ambulance Victoria dataset.

Your interpretation of each table or plot in one paragraph.

? Each paragraph is limited to 150 words.

Kindly see the below data sets to solve this?problem.?Need to explain in charts like Histogram, Scatter plot, line chart, bar chart, Boxplot, stacked area etc.?

Transcribed Image Text:

Financial Year Quarter LGA Code 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 2015-2016 Qtr 3 Jan-Mar 2016 5655116,516651151255115155111511151515111 [_]]]]/-]}-}}]-[-]-\-]]--]-]]>------}-]*]}}} LGA Category The percentage of less than 15 minutes. response times 62.72% 71.45% 61.26% 65.95% 26.11% 48.05% 70.19% 73.71% 58.56% 17.45% 72.18% 71.91% 53.44% 31.61% 49.69% 67.33% 35.81% 50.64% 69.70% 72.03% 52.81% 42.56% 67.81% 49.57% 74.03% 69.43% 63.56% 49.00% 53.25% 68.23% 52.04% 47.08% 27.47% 73.24% 48.70% 71.02% 36.94% 71.89% 60.78% 19.94% 78.81% Average response time - Seconds. 704 590 449 632 1013 908 615 773 564 1126 591 589 748 1082 786 649 1140 863 623 595 752 902 654 882 589 628 469 799 745 463 796 940 1104 593 882 593 1042 601 709 1051 439 Number of incidents 1950 481 1181 557 2354 1329 2032 562 1238 1359 227 566 244 1746 1019 1934 542 592 142 1687 755 384 1409 1589 281 2903 2633 2774 2454 876 2589 794 1630 2475 1193 593 2226 642 946 159 1512 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 5551|11551561111101155|55||||||||0||||| ]]]]]22]]2]}}-}2}}--} · !}}}}} 73.59% 71.94% 75.46% 62.30% 68.58% 51.21% 49.19% 71.41% 70.19% 45.69% 71.42% 73.61% 25.30% 39.23% 59.42% 30.47% 60.59% 75.00% 43.42% 29.34% 76.55% 59.19% 70.29% 63.14% 74.78% 52.23% 21.19% 59.83% 41.17% 29.40% 28.63% 42.69% 49.14% 73.03% 36.12% 23.24% 34.42% 60.31% 571 573 517 672 603 794 818 602 631 816 599 588 1144 910 714 1170 744 556 918 1101 546 705 603 683 557 783 1138 680 923 996 1083 861 879 569 1004 945 1008 713 760 993 837 235 1705 796 1815 1156 2381 682 484 1585 639 1229 2373 2384 625 2745 2066 1142 1864 624 1245 2255 2481 2562 2620 ▬▬▬▬▬▬▬▬ 969 973 756 430 2049 956 2578 2739 1034 530 1963 Financial Year Quarter LGA Code 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 2015-2016 Qtr 3 Jan-Mar 2016 5655116,516651151255115155111511151515111 [_]]]]/-]}-}}]-[-]-\-]]--]-]]>------}-]*]}}} LGA Category The percentage of less than 15 minutes. response times 62.72% 71.45% 61.26% 65.95% 26.11% 48.05% 70.19% 73.71% 58.56% 17.45% 72.18% 71.91% 53.44% 31.61% 49.69% 67.33% 35.81% 50.64% 69.70% 72.03% 52.81% 42.56% 67.81% 49.57% 74.03% 69.43% 63.56% 49.00% 53.25% 68.23% 52.04% 47.08% 27.47% 73.24% 48.70% 71.02% 36.94% 71.89% 60.78% 19.94% 78.81% Average response time - Seconds. 704 590 449 632 1013 908 615 773 564 1126 591 589 748 1082 786 649 1140 863 623 595 752 902 654 882 589 628 469 799 745 463 796 940 1104 593 882 593 1042 601 709 1051 439 Number of incidents 1950 481 1181 557 2354 1329 2032 562 1238 1359 227 566 244 1746 1019 1934 542 592 142 1687 755 384 1409 1589 281 2903 2633 2774 2454 876 2589 794 1630 2475 1193 593 2226 642 946 159 1512 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 5551|11551561111101155|55||||||||0||||| ]]]]]22]]2]}}-}2}}--} · !}}}}} 73.59% 71.94% 75.46% 62.30% 68.58% 51.21% 49.19% 71.41% 70.19% 45.69% 71.42% 73.61% 25.30% 39.23% 59.42% 30.47% 60.59% 75.00% 43.42% 29.34% 76.55% 59.19% 70.29% 63.14% 74.78% 52.23% 21.19% 59.83% 41.17% 29.40% 28.63% 42.69% 49.14% 73.03% 36.12% 23.24% 34.42% 60.31% 571 573 517 672 603 794 818 602 631 816 599 588 1144 910 714 1170 744 556 918 1101 546 705 603 683 557 783 1138 680 923 996 1083 861 879 569 1004 945 1008 713 760 993 837 235 1705 796 1815 1156 2381 682 484 1585 639 1229 2373 2384 625 2745 2066 1142 1864 624 1245 2255 2481 2562 2620 ▬▬▬▬▬▬▬▬ 969 973 756 430 2049 956 2578 2739 1034 530 1963