Results 1 to 5 of 5

Thread: Another Average ?

  1. #1

    Thread Starter
    Member
    Join Date
    Mar 2001
    Location
    Delaware
    Posts
    50

    Arrow Another Average ?

    I need to find the mathmatical equation
    to compute an average number of time a users have gone to a certin form.

    This is the data I have

    7 = 182
    6 = 200
    5 = 299
    4 = 366
    3 = 338
    2 = 201
    1 = 43

    I want to produce something that says
    this form is accessed on average 4 times.
    or whatever the average amount is ... what is the equation to figure this out ?

    Thanks
    OddPrime
    MCP

    The wild world of geeks
    coming soon at:

    www.renegadegeeks.com

  2. #2
    DerFarm
    Guest
    Are you sure you want the average and not the mode or the
    median? The mode is the most often seen value. In this case, it
    would 4.

    I think you are really looking for is the median. If you sort the
    table by number of times and find the mid-point in the set, that is
    the median. It is often used in datasets where the actual
    average would be seriously skewed:

    1
    2
    3
    3
    3
    4
    5
    6
    7
    8
    1000

    Average: 95.1
    Mode: 3
    Median 4

  3. #3

    Thread Starter
    Member
    Join Date
    Mar 2001
    Location
    Delaware
    Posts
    50
    Well what about like this

    1 use 1
    2 uses 1
    3 uses 3
    4 uses 1
    5 uses 1
    6 uses 3
    7 uses 1000

    What would the median be? would it still be 4 or
    would it now be 7 ??
    Last edited by oddprime; Jan 24th, 2002 at 10:37 AM.
    OddPrime
    MCP

    The wild world of geeks
    coming soon at:

    www.renegadegeeks.com

  4. #4

    Thread Starter
    Member
    Join Date
    Mar 2001
    Location
    Delaware
    Posts
    50

    Found it

    Its pretty much just like my other
    problem i had.

    7 * 182 = 1274
    6 * 200 = 1200
    5 * 299 = 1495
    4 * 366 = 1464
    3 * 338 = 1014
    2 * 201 = 402
    1 * 43 = 43
    ----------------------
    1629 / 6892 = 4.23

    so on my answer would be 4.23 times..

    what is this median ? mean ? average ? something else ?

    Thanks
    OddPrime
    MCP

    The wild world of geeks
    coming soon at:

    www.renegadegeeks.com

  5. #5
    DerFarm
    Guest
    In the for what it's worth category

    1 use 1
    2 uses 1
    3 uses 3
    4 uses 1
    5 uses 1
    6 uses 3
    7 uses 1000

    the median would be 1000.

    Assume that each time a form is used a record is appended to a
    table where the record keeps track of the name of the form. At
    the end of the time period, you would have

    1 record for 1
    1 record for 2
    3 records for 3
    1 record for 4
    1 reocrd for 5
    3 records for 6
    1000 records for 7 for a total of 1010 records



    sort the records by name of the form, and pick the 505th record.
    That is the median.

    The mode is 7. the mode is defined as the most often seen value.

Posting Permissions

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



Click Here to Expand Forum to Full Width