Answer

Using weighted averages to calculate ASA and abandonment rate

Your ACD should report ASA and abandonment rate for defined time periods, considering the volume handled. However, if management wants you to combine time periods, using a weighted average provides a more realistic picture of a particular measurement versus a straight average

Published: 30 Jul 2009

Upper management would like me to use weighted averages for determining average speed of answer and abandonment rate. I believe they were referring to call volume, which is (10% - 20%) higher on certain days of the week. However, I do not see a direct correlation between call volume and average speed of answer and abandonment rate (due to staffing levels, types of calls, distribution of calls, etc.). So, I'm not sure if weighted averages would apply in this case and I'm not even sure how I would apply weighted averages. Your thoughts?

Your ACD should report ASA and abandonment rate for defined time periods, considering the volume handled. However, if management wants you to combine time periods, using a weighted average provides a more realistic picture of a particular measurement versus a straight average which skews data and weights all periods equally. The example below shows calculations for straight averages and weighted averages.

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please log in.

You have exceeded the maximum character limit.

Please provide a Corporate Email Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

Example: Calls handled SVL Monday 550 80% Tuesday 300 65% Wednesday 150 90%

Total Straight average Weighted average

The "right" way to do it depends on your definitions and targets, and how your system calculates. For example, if your target is to meet a certain abandon rate each day, then your system should provide the required data. If you need to meet a target each week, you'll need to look at whether your system provides that performance indicator on a weekly basis, and how it calculates it.

1000 (80+65+90)/3 = 78.3% (550x80)+(300x65)+(150x90)/ 1000 = 77%

Cord-cutting driving global broadband usage to surpass 500GB of data per month

UK above average on strategic use of analytics

Heathrow Airport updates clunky loyalty scheme through cloud-based software and services

Refracta 8.0 is an 'average' Linux distro, that's what's great about it