+ Reply to Thread
Results 1 to 3 of 3

Average excluding percentiles (top/bottom nth percent)

  1. 01-13-2014, 03:44 PM #1
    ker9
    ker9 is offline
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    Average excluding percentiles (top/bottom nth percent)

    Hi, We are showing 10th, 25th, 50th, 75th, 90th percentiles and we also want to show the average, but we want the average to only average those numbers that appear in the 10th-90th percentiles.

    Edit: includes If statement: 

    Please Login or Register  to view this content.
    Any suggestions?

    Thank you!
    Last edited by ker9; 01-14-2014 at 09:51 AM. Reason: clarity on heading for searching
    Reply With QuoteRegister To Reply
  2. 01-13-2014, 03:57 PM #2
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Average excluding top/bottom percentiles

    have a look at the TRIMMEAN function
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  3. 01-13-2014, 04:34 PM #3
    ker9
    ker9 is offline
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    Re: Average excluding top/bottom percentiles

    Perfect - thanks!

    Please Login or Register  to view this content.
    (using Ctrl-Shift-Enter to get curly brackets)

    This site gives a good explanation of TRIMMEAN:

    http://office-watch.com/t/n.aspx?a=1269
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for Conditional Formatting Bottom 5 excluding 0's
    By FlyinIron406 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-10-2013, 02:23 AM
  2. The rank of average ranks excluding empty cells but including their average.
    By Terminal45 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-21-2012, 03:44 AM
  3. [SOLVED] 1 Cell to Formulate Cumulative Total Excluding Top & Bottom 10%
    By benishiryo in forum Excel General
    Replies: 6
    Last Post: 10-05-2012, 09:18 PM
  4. formulate tests scores then average them as percentiles in excel
    By David Pruden in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-17-2006, 02:10 PM
  5. [SOLVED] percentiles?-How does excel calculates the percentiles worksheet function?
    By Agnes Goris in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2005, 11:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1