Q

# 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 first published in July 2009

## Content

Find more PRO+ content and other member only offers, here.

#### 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.

Oldest

• ### SQL engines boost Hadoop query processing for big data users

Organizations with big data environments are turning to SQL-on-Hadoop software to speed up analytical queries and data ...

• ### Reality check needed to assess AI applications

When assessing the reality behind today's AI technology, businesses need to think about how it can perform in specific tasks ...

• ### Experts advise on data science for business teambuilding

When it comes to building a data science team, businesses should expect to find workers from a variety of backgrounds rather than...

## SearchDataManagement

• ### Big data challenges traditional data modeling techniques

Surging big data is changing data modeling techniques, including schema creation. The word from Enterprise Data World 2016: Data...

• ### EBay helps drive new style of data engineering

Open source data engineering has become a way of life at e-commerce leader eBay, says the company's Debashis Saha. Kylin is one ...

Cloudera distribution including Apache Hadoop provides an analytics platform and the latest open source technologies to store, ...

## SearchSAP

• ### Integrate cloud to on-premises with HANA Cloud Integration

SAP offers a raft of prebuilt integrations that handle many of the key business processes between major cloud and on-premises ...

• ### Courtroom lessons from a failed SAP ERP implementation

A consulting firm's expert witness explains what SAP and a global manufacturer did -- and didn't do -- that led to a major SAP ...

• ### Building data visualization with SAP Fiori tools

Some BI developers will get by fine with features such as the Fiori Launchpad and Overview pages. Here's what's built into Fiori ...

## SearchOracle

• ### ECCU shares ups, downs of Oracle Fusion Financials migration

Moving to Oracle Fusion Financials has been a mixed blessing for the Evangelical Christian Credit Union. It saved money, but had ...

• ### Oracle Enterprise Manager 13c gives DBAs new cloud tools

The latest version of Oracle Enterprise Manager is designed to make life easier for DBAs working in the cloud. Oracle Enterprise ...

• ### Oracle Collaborate conference generates buzz in Las Vegas

The Oracle database and applications forum, presented by three independent user groups, combines hands-on experiences, networking...

## SearchAWS

• ### AWS, partners' balancing act weighs on users, too

AWS partners are a critical part of the growing ecosystem, but the choice between third-party services and the waiting game for ...

• ### Words to go: AWS data storage

If you're confused about which data storage option is ideal for your enterprise, refer to our reference sheet on AWS tools and ...

• ### Using AWS CloudFormation templates to deploy IAC

CloudFormation templates help IT teams quickly and safely update AWS-based applications. The time saved on the back end could ...

## SearchContentManagement

• ### The state of three legal document management tools

Microsoft and other document management providers have updated their software to meet the needs of the legal industry. Here's how.

• ### SharePoint Online Public Website drops off, pricing doesn't

Microsoft is killing off support for SharePoint public websites, and companies will now have to go to third parties for support. ...

• ### How close is too close in context-aware computing?

Context-aware technology is hyped to the max, enabling companies to gather precious data about customers. But it has to be mature...

Close