Results 1 to 5 of 5

Thread: Formula to calculate Frequency

  1. #1

    Formula to calculate Frequency



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Everyone

    I have a table of cash machines and its usage. Grateful if anyone can any help with a formula to calculate the number of visits made by the various types of cards at each of the ATM over the period, with a breakdown of x1 , x2 , x3 , x4 , x5 , >5. Ideally I want to use a formula so that other colleagues could know how it was calculated. Please see the attached sample.


    Many thanks in advance


    Ailene07
    Attached Files Attached Files

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    What determines X1, X2 etc.?

  3. #3
    Quote Originally Posted by Bob Phillips View Post
    What determines X1, X2 etc.?
    How often a card type is used at Atm.

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    Yeah, but what says it is X1? There is nothing obvious in the data.

  5. #5
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,721
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Last edited by Pecoflyer; 2015-03-30 at 01:46 PM.

Posting Permissions

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