percentile

Hi... I have this function in a Pivot Table =PERCENTIL(SI('RAW C TIME'!$D$2:$D$51816=$J9,SI('RAW C TIME'!$J$2:$J$51816=$K$4,SI($K$3="(All)",'RAW C TIME'!$I$2:$I$51816,SI('RAW C TIME'!$G$2:$G$51816=$K$3,'RAW C TIME'!$I$2:$I$51816)))),N$6) I need to create a custom function in VBA that will...

Hi, I am working on a project and have not figured out one aspect: I have daily data that lists the number of rooms occupied through the morning. I wanted to make a dynamic calculation (calculate the Median or percentile, etc) over a specified time period. I.E. I would input a “date range”...

I'm trying to create a formula which calculates an average for array 2 if another the values from array 1 are within a percentile range, the values are based on the same year, and the state matches parameter #2. I've tried several different versions of the percentrank to identify the percentile...

I apologize if this is obvious or has been answered elsewhere (I've searched high and low and haven't come across it, even my manuals/books I am using to learn this stuff). I'm new to VBAs and macros. I'm trying to create a macro that will return the 50th percentile (median) of a column. I can...

Im doing up massive amount of data which will be continuously updated in near future, therefore im trying to create formulas that can aid me with my data keying and update accordingly. Now im stuck with the percentile formula, which im trying to get MIC50 and MIC90 from my raw data. However I...

I am using a range in a vlookup formula. The problem is that when excel interprets the formula, the range name acts as if it's a string. Here's the code: Dim pdq As Range Set pdq = ActiveWorkbook.Sheets("Parameters").Range("$A:$P") Cells(2, FinalCol).FormulaR1C1 =...

I am using the percentile function within an array. If I use it in conjunction with with an "IF" statement, I get the wrong result. For example, this formula returns the correct calculation (it's using a much smaller data set than actual). {=PERCENTILE(L2:L8,0.02)} However, if I embed this...

So here is the background to the problem - I have spreadsheet of 19000+ rows of data, multiple calculations including 4 percentile calculations, and obviously excel can't cope. So I have replaced the percentile formulas with SMALL: =SMALL(M:M,CEILING(Q1*COUNTA(Sheet1!M:M),1)) Cell Q1 has the...

I have an excel sheet, and I am trying to bring some sort of automation in to that sheet (since I use it quite often) with the help of macros. The fact is that I am really new to macros and VBA programming language, so I need a little help in writing the code to find the 10th percentile (the...

Hello everyone I hope that you all are fine. I have an excel sheet, and I am trying to bring some sort of automation in to that sheet (since I use it quite often) with the help of macros. The fact is that I am really new to macros and VBA programming language, so I need a little help in...

Hi All, I need a formula for an excel sheet of dimension 63rX740c. All columns have variable data. Some columns have first 10 rows filled, some have 33, 29, 52, 63 rows filled. I need a formula which averages the values of the first 20% cells of that column. I am using this but it produces...

Hi, I've got a spreadsheet containing my data pulled from various sources and appears to be working fine. Column C contains data about the region (sometimes a name, sometimes a number - thank you to the person who decided this was acceptable). Column E contains a KPI value. What I've been...

In Excel we can specify the percentile e.g (= percentile(array, .45) to get what number would the percentile be in a range. Is there a method to find the percentile of a value within the range. if i have numbers 1 to 10 and i want to find what percentile 9.5 would be. thanks

Hello, I have a PT with 2 Row Fields ("Product" & "Customer") and 1 Column Field (" Net Sales") I would to calculate the "Percentile (Netsales; 75%)" for each "Product" ... Anyone an idea on what the calculated field should be? Or another solution ..? Best Regards, Sige

Hi I have the following Pivot table: In RowFields: -Productnumber - Customer In DataField: -Quantity - NS/Unit IS there a way that I can calculate (Insert> Calculated Field) the Sum of "Percentile" based on the Quantity WITHIN the Pivot table? --- I can/would calculate the Sum of Percentile...

I have a plot with set phi grain size values on the X-axis, and percent on the Y axis. The plot is made by calculated cumulative values. What I need is a way to determine what the grain size value (X) is at any point (n'th percentile) on the "cumulative curve" (see picture). I should add that...