+ Reply to Thread
Results 1 to 5 of 5

90TH Percentile

  1. #1
    Registered User
    Join Date
    02-23-2018
    Location
    London, Canada
    MS-Off Ver
    Office 2016
    Posts
    2

    90TH Percentile

    Hi,
    I need to find out the 90th percentile of a set of times but with conditions. I have rows with data that need to be considered in the percentile. The first column has the incident numbers (there are duplicate values because there are different staff showing up at different times for the same incident). The second column has the times the staff showed up and the third column has the amount of staff that showed up each time. I only want to consider the times in the percentile that incorporate the first 12 staff, this may just be the first 3 times if 4 staff show up each time. However I am not sure how to create the formula that will find the times of the first 12 staff members and ignore the other times of any staff over 12. I need a formula that will copy down because I have data for about 300 different incidents to look at. Hopefully there is a way to do this.

    Incident Response times # of staff
    HF16-2 0:11:36 4
    HF16-2 0:05:48 4
    HF16-2 0:06:56 2
    HF16-2 0:03:20 4
    HF16-2 0:02:19 4
    HF16-2 0:08:40 1
    HF16-3 0:12:05 4
    HF16-3 0:02:03 4
    HF16-3 0:08:45 1
    HF16-3 0:03:54 4
    HF16-3 0:07:40 2
    HF16-3 0:05:11 4
    HF16-4 0:58:26 0
    HF16-4 0:05:40 0
    HF16-4 0:06:04 0
    HF16-5 0:06:17 2
    HF16-5 0:04:50 2

    Thank you.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: 90TH Percentile

    Cross-posted at https://www.mrexcel.com/forum/excel-...onditions.html
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: 90TH Percentile

    Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

    • Use concise, accurate thread titles.
    • Your post title should describe your problem, not your anticipated solution.
    • Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
    • Responding to a request to change your thread title by doing so is mandatory.

    To change a title go to your first post, click EDIT then Go Advanced and change your title.

    No help to be offered, please, until the OP complies with this request.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Registered User
    Join Date
    02-23-2018
    Location
    London, Canada
    MS-Off Ver
    Office 2016
    Posts
    2

    Angry Re: 90TH Percentile

    "No help to be offered, please, until the OP complies with this request. "

    Goodness gracious, I apologize if my title was non compliant.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: 90TH Percentile

    It still isn't, so please change it. You also cross-posted. Please take a moment to read our forum rules, to which you agreed upon joining, before posting again. Here is a direct link to them for your convenience: https://www.excelforum.com/forum-rul...rum-rules.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Display 90th percentile values for multiple categories
    By mgblair in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-24-2015, 12:34 AM
  2. [SOLVED] Conditional percentile: Bug in percentíle function?
    By Duronka in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-13-2013, 08:08 AM
  3. [SOLVED] PERCENTILE.INC and PERCENTILE.EXC - difference
    By Saturn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-19-2012, 11:34 AM
  4. Excel 2007 : 90th Percentile
    By SDHAKE in forum Excel General
    Replies: 3
    Last Post: 02-20-2012, 06:07 PM
  5. [SOLVED] Percentile --> how to?
    By BHARATH RAJAMANI in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2006, 06:10 AM
  6. Percentile --> how to?
    By BHARATH RAJAMANI in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2006, 09:55 AM
  7. percentile
    By Blessingspoint in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2005, 03:08 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1