Results 1 to 3 of 3

drop top and bottom values before computing average

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    drop top and bottom values before computing average

    Attached is a sample spreadsheet which is used to computer team averages in a dart tournament. There are two different games played, and each has it's own stats at the end of a match. After teams have played 2 matches we look at their stats to determine if they're shooting above their stated ability. If they are, we re-rate the team.
    In the past we used all their stats for the games played. at our next tournament I'm being asked to exclude the top 10% and the bottom 20%. I have not been able to figure out how to do this. To make things more difficult, the stats for the two different games are totally different from each other, but the scores to be excluded could come from either set.
    In my sample F7 computes the average for their "01 games" (data is in row 7 starting with P), and H7 computes the average for their "cricket" games (data is located in row 8 starting with P).

    Any suggestions?

    Let me know if I need to explain anything (or everything) better.
    Attached Files Attached Files
    "Laugh? I thought I'd die!"

    Jimbo?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] "Drop the lowest" in computing average
    By Matthew Leingang in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-06-2005, 07:05 AM
  2. "Drop the lowest" in computing average
    By Matthew Leingang in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 06:05 AM
  3. "Drop the lowest" in computing average
    By Matthew Leingang in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 03:05 AM
  4. "Drop the lowest" in computing average
    By Matthew Leingang in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 02:05 AM
  5. [SOLVED] "Drop the lowest" in computing average
    By Matthew Leingang in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-05-2005, 10:05 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