Question: Your manager has requested your help to find out how well ( or not ) your call center is functioning. You are provided with a

Your manager has requested your help to find out how well (or not) your call center is functioning.
You are provided with a file with some data for each month the call-center has been in business. (The Month column contains dates but they are showing up as numberscan you please fix that? ) Please use the Recommendations sheet to convey what you feel are the four most important insights your analysis of the data provides. In your written insights, please reference at least one of the charts you have created that supports your insights.
Please deliver one insight for each of the metrics defined below.
Inbound Calls how many calls has the call center received in that month?
Average Speed of Answer in Seconds how many seconds does it take for a caller to be connected with a person?
Abandoned Calls how many callers hang up before the end of the conversation?
Call Abandonment Rate (you need to calculate this using the data above) it should show the percent of inbound calls where callers hang up before the end of the conversation.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!