percentile

I have a table of about 435 rows (and growing a bit). I have values in the column AJ and some are "0" which affect the percentile (even as nested...with the {}) This is my best guess, but as said, the percentile is still not correct, because of the "zeros"...

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...

Hello, I am trying to pull data from another large spreadsheet (thousands of rows) which is currently sorted to look something like this; A === B === C === D Item === Quantity === Price === Running Total Qty. Apple === 50 === $2.00 === 50 Apple === 100 === $2.25 === 150 Apple === 75 ===...

Hello, I am trying to pull data from another large spreadsheet (thousands of rows) which is currently sorted to look something like this; A === B === C === D Item === Quantity === Price === Running Total Qty. Apple === 50 === $2.00 === 50 Apple === 100 === $2.25 === 150 Apple === 75 === $2.75...

I have a large table with many columns. I would like to filter the table first using VBA and then calculate the percentile of a single column using VBA to store the data in a different workbook. I have cobbled together how I think it should work using other sections of my code, I just need help...

Hey all Can we do something like percentileifs the way we do it with averageifs? Like do the percentile to only cells which a certain condition is met in another column. Thank you

Hi Guys, I'm running a formula to determine what the 90th Percentile is relative to a each team, in a table How do I then show how many records are actually in the 90th Percentile ? Formula for the percentile is =PERCENTILE.INC(IF(Team=Comp,Values),0.9) Thanks D

I have a percentile data set bmiage from the CDC that includes the L,M, and S data---is there a formula in Excel that will calculate the Z-score and the percentile that corresponds to that Z score for a given parameter? I need to be able to determine the child's percentile on a given day based...

Hi all, I have a question about conditional formatting and using a formula to highlight the correct percentile that a rate falls into. Additionally, my rates are in percentages while the percentiles are in number format. A data example is below. Can someone help me develop a formula that would...

Hi, I am working on a spreadsheet which has values attached to customers. I would like to know which values contribute to the top percentages of the cumulative value of the total. For example if the total value is 300, I would like to know that Customer D and C both have values of 15...

Hello all, I have two series of value I need to the proportion to figure out which is the value I should put based on my old valuations. I am going to explain better. Based on past series I have the below distribution: <colgroup><col style="width: 100px"><col width="100"><col...

Hi, I am trying to create a macro which will calculate percentile for a set of range in a row but the numbrs of cells change and hence the range needs to be dynamic. I have record the macro: Sub mrexcel() Range("A117").Select ActiveCell.FormulaR1C1 =...

Good afternoon, I'm trying to build an equation that will assign a particular value to a data set depending on if that value is <, between, or > than a certain value. Disregard flows for now, that will be coming from a separate spreadsheet. The remaining five categories are all on one...

Hi, Summary: I need help calculating the 50th percentile of a given array where the array is determined by using a reference to a primary key. Table 1 contains base salary values based on various positions associated with various companies. This table is structured so that the table header is...

Hi Team, Here's my objective: I have a range of student scores on assessments. I need the average score of the bottom 25% of performers (So if there are 20 students, I need the average of the lowest 5 scores). I have a formula to make this work, but I have a filter running, and I need the...

Hello, I have a large set of data. I am trying to calculate the median (and other percentiles) of a range of data conditional upon a number of factors. So, i have: A range of salaries - this is what i want the median of but only when certain conditions are met. Conditions: - Location -...

Hi, First post here. I found the board by googling various problems and this board came up a lot. I'm using Excel 2010. Here's my problem: I have two sets of data. Column B is the price per ton paid for grapes in a year. Column C is the number of tons for each price paid. For example: B...

How can I exclude cells having value less than 29 from array(column) which have values between 0 to 100. I have to calculate percentile from renaming values. <tbody> Total 38 51 72 59 45 77 40 76 82 71 68 29 50 0 53 54 52 20 65 </tbody> <tbody>...

Hello I'm struggling to write the correct formula to get the 90th percentile of a dynamic range. I don't want to do it in VBA as it seems to be possible with an Excel formula. I've found this post but I don't manage to amend the formula properly...

Hi there, I've done a bit of searching on the forum first so I dont duplicate but couldnt find an answer to the following: I needed quartiles for a larger dataset of salaries and used the percentile function for that. In the process I also the 50th percentiel just for fun and found that it was...