Use Excel's Moving Average add-in to predict customer service call load

Monitor and predict call center volume using Excel's Moving Average add-in, which can help you spot trends that may warrant further attention, saving you headaches down the line.

UPDATE: You can download an Excel example of this tip here.

Your call center manager notices that the center has received an increased number of calls over the past five days; the majority of calls are about your company's newly released product. Before alerting the quality control department, you ask the manager to provide you with the total number of calls received each day for the past 10 days. The manager sends you an Excel spreadsheet with the calls for each day listed in fields A2:B11. To perform a Moving Average analysis of the data to see if this reflects a trend that will result in increased calls over the next week, follow these steps:

  1. Go to Tools | Options.
  2. Under the Error Checking tab, clear Formula Omits Cells in the Region check box.
  3. If this is the first time you have used an Excel add-in, go to Tools | Add-ins. Otherwise, click OK and skip to step 6.
  4. Click the Analysis ToolPak-VBA check box and click OK.
  5. Go to Tools | Data Analysis.
  6. Click Moving Average and click OK.
  7. Click in the Input Range text box, and then select the A2:A11.
  8. Click in the Interval box and enter 3.
  9. Click in the Output Range, select B2, and click OK.

If the number of calls listed in column B shows an increase, then you should alert engineering to correct the problem before it becomes worse.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox