percentile calculation

  1. T

    Median & Percentile for the range of various lengths

    Hi, I am trying to calculate the Median & 75th Percentile for the range in array where the range differs in the length. For example, my data looks like the one given below (my data-set is almost 100,000 rows). Now I am trying to find the median and 75th percentile values of a combined set of 3...
  2. A

    How to calculate Percentile for a large data set?

    I want to know how to calculate percentile for a large data set. I have to calculate percentiles of 5th,10th,20th,30th,40th,50th,60th,70th,75th,80th,90th and 95th for a known value of data lets say. 1.456 1.234 1.457 1.453 1.789 1.670 1.543 1.234 1.342 1.568 I can do...
  3. U

    VBA: Dynamic Range in Percentile Formula

    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 =...
  4. B

    percentile if and statement

    Hello, I have data with multiple columns. In one column I have months designated 1 - 12 (column C). In another column I have values such as temperature (column P). I am trying to calculate the 85th percentile of only the months may - October (5 - 10). I have tried a nested percentile if and...
  5. B

    Percentile_Inc function with an internal VBA array

    Dear experts, with EXCEL 2010 there is this nice percentile_inc function that gives the k-percentile value of a part of this worksheet. This works fine - also for a 2-dimensional table, and even the values must not be sorted. Now, I want to use this function within a VBA program. A maximum of...
  6. P

    How to get Percentiles from Value Ranges

    Hello, I have data in the following format: <tbody> Range Min 26 31 36 41 46 Range Max 30 35 40 45 50 Number of Occurences 211 134 652 121 89 </tbody> How I can use Excel to get the value of a given percentile. So for example, the 15th percentile is 32, the 85th percentile is...
  7. M

    Dynamically calculate range within PERCENTILE.INC() formula

    I have a large data set where the data is delineated by a field called "Category." For each Category, I'd like to calculate the PERCENTILE.INC for each row within that Category. For example, here is some sample data with the (manual) formula. I'd like a way to automatically calculate the range...
  8. B

    Macro/Script to calculate percentile on daily basis.

    Hi, I am trying to automate percentile report generation. Any help would be greatly appreciated. Requirement: 1. I get 40 csv files with data everyday under a shared LAN folder. Folder name is current date and 40 csv files names remain same. 2. I need to calculate a percentile report everyday...
  9. S

    Multi Conditional Percentile in multiple columns

    OK so here is my not working formula, which in fact needs to be extended to include references G3 and H3: =PERCENTILE(IF(OR(E:E=E3,E:E=F3),L:L),Ref!$B$2) The problem is the source data with formatting which means that there is not always a value in column E, sometimes it is in F or G or H, and...
  10. G

    Automated Percentile VBA Code

    So basically I have a column of numbers. I need to calculate the 25th, 50th, 75th, and 90th percentiles automatically. There is one blank row between the bottom of the column and my 25th percentile calculation. The VBA code below would work if the column was a fixed number of rows but there...

Some videos you may like

This Week's Hot Topics

Top