Using the Fire Data for Analysis spreadsheet,  Download Fire Data for Analysis spreadsheet,answer the questions in Tab 4–Emergency Unit Responses and Tab 5–Shift Call Log.

Tab 4–Emergency Unit Responses:

1. What was the Average number of Engine Responses?
2. What was the Median number of Aerial Responses?
3. Develop a BAR CHART that depicts the Total Responses from 2001 to 2005.
4. Develop a BAR CHART that depicts the Total Engine Responses 2006 to 2015.
5. Develop a PIE CHART that depicts the Total Engine Responses from 2001 to 2005.

Tab 5–Shift Call Log:

1. How many Rescue Calls were run during the shift?
2. What was the AVERAGE 9-1-1 Processing Time for Rescue Calls?
3. What was the AVERAGE Response Time (On Scene) for Rescue Calls?
4. Develop a BAR CHART depicting the 9-1-1 Processing Time during the shift.
5. Develop a PIE CHART depicting the 9-1-1 Processing Time during the shift.

Be sure to upload your Excel Worksheet!!!