Results 1 to 5 of 5

The average peak usage time and day for customer's calls

Threaded View

  1. #1
    Registered User
    Join Date
    05-07-2015
    Location
    London
    MS-Off Ver
    MS Ofice 2010
    Posts
    3

    Exclamation The average peak usage time and day for customer's calls

    Hello,

    I hope that someone will help me.

    I have a data set as per below:

    Date Hour Number Calls
    01/01/2014 0 30
    02/01/2014 1 23
    03/01/2014 2 56
    04/01/2014 3 78
    05/01/2014 4 90

    What will be the best array formula to be use to find the average peak usage time and day for customer's calls?

    The data is for the whole year, 365 days, 24 hours but the hours are in the data as 0,1,2,3,4,5,6....23

    So I expect the result to be that the average peak usage e.g. 230 calls is 11oclock and the average peak day is Thursday

    Many Thanks
    Last edited by OliverM23; 05-07-2015 at 05:42 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 05-01-2015, 12:02 PM
  2. Replies: 5
    Last Post: 05-18-2013, 11:59 AM
  3. Replies: 5
    Last Post: 05-16-2012, 11:52 AM
  4. Finding peak usage times
    By afitzwater in forum Excel General
    Replies: 2
    Last Post: 01-04-2012, 05:19 PM
  5. Excel 2007 : Calculate Peak Usage of Vehicle
    By ttriola1 in forum Excel General
    Replies: 1
    Last Post: 02-04-2010, 08:57 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1