Q
Problem solve Get help with specific problems with your technologies, process and projects.

# 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

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.

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

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

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.

This was last published in July 2009

#### Have a question for an expert?

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

#### Start the conversation

Send me notifications when other members comment.

• ### Cambridge Analytica-Facebook case shows need for ethical data mining

Ethical data collection practices are becoming even more important, as cases like Cambridge Analytica's misuse of Facebook data ...

• ### Rethinking analytics processes spurs enterprise innovation

By taking a fresh look at the makeup of their analytics organizations, enterprises can innovate their business models and take ...

• ### Diversified data sets for analytics deliver top results

Analytics teams should focus on data diversity to ensure that their projects deliver the most meaningful insights -- but they ...

## SearchDataManagement

• ### GDPR data protection edicts make good data governance a must

The European Union's new GDPR law puts the onus on companies to ensure that their data governance and management practices enable...

• ### GDPR rules can spur broader steps to protect sensitive data

Companies need to make compliance with GDPR's requirements on managing personal data a priority, but they should also work to ...

• ### Data integrity protection spurs greater security spending

As hacking, ransomware and malware attacks mount, companies place big data protection and integrity among the primary reasons for...

## SearchSAP

• ### SAP indirect access debate tackled in new licensing model

SAP wants to resolve the indirect-access issue with a new, document-based licensing model. Analysts think customers will be happy...

• ### Pros and cons of SAP Cloud Platform integration tools

While SAP offerings are often best for cloud-to-cloud and cloud-to-ground integration, sometimes, it's better to look elsewhere. ...

• ### Supply chain risk assessment a major focus of SAP Ariba

SAP Ariba's Supplier Risk helps companies assess their suppliers in a number of risk categories, but building a responsible ...

## SearchOracle

• ### Collaborate 18 to track progress of Oracle cloud database, apps

The Collaborate 18 conference will shine a light on Oracle cloud adoption and migration issues, and on the impact that such moves...

• ### Oracle Autonomous Database debut heralds new cloud hopes

It wasn't the first in the cloud computing space, but Oracle is all in now. Key to the effort is a new Autonomous Database ...

• ### Oracle cloud services aim to pull users out of IT comfort zone

Oracle has gone all-in on cloud computing and expanded its line of cloud services in the hopes users will make the jump. But ...

## SearchAWS

• ### Amazon FreeRTOS aims to simplify, secure IoT deployment

Operational technology teams have been slow to update microcontroller software due to safety and logistics concerns, but Amazon ...

• ### Test your knowledge of GDPR rights and AWS data protection

Is your enterprise GDPR-compliant? Take this quick quiz to test your knowledge of the EU regulation, as well as relevant AWS data...

• ### Support for Node.js in AWS Lambda slowly, but surely, evolves

Developers who need the latest version of Node.js for a serverless platform might turn to Lambda rivals to meet that need. But ...

## SearchContentManagement

• ### How a digital transformation process helped curb reliance on paper

By moving on from paper, the North Carolina Court System and the Texas Animal Health Commission were able to accommodate ...

• ### Intelligent information management is ready for AI, blockchain

A panel discussion at AIIM 2018 looked at how AI, cloud and blockchain will disrupt the intelligent information management space.

• ### SharePoint 2019 on premises the talk of SharePoint Fest D.C.

This episode of the Pipeline podcast breaks down SharePoint users' concerns about data migration, on-premises version support, ...

## SearchSalesforce

• ### Salesforce Field Service Lightning gets appointment, scheduling upgrades

While the new Field Service Lightning features will help Salesforce users connect customers to their service needs, it lacks any ...

• ### Salesforce World Tour Boston talks Integration Cloud, Social Studio

Salesforce World Tour sessions included dives into Philanthropy Cloud, integrated surveys and Salesforce's new Integration Cloud.

• ### Salesforce Boston World Tour show highlights customers, philanthropy

From the dais and halls at Salesforce World Tour's Boston stop, talk focused on automating employee volunteerism, marketing best ...

Close