Idntifying Quartile's
Apr 23, 2007
The goal is to return the proper quartile based upon the results of the below parameters. Too many If, Then’s for me…
******** ******************** ************************************************************************>Microsoft Excel - Book3___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutC1=
CDEF1Current*Base*Salary***2Max*Salary***3Min*Salary***4****5****6Criteria*for*Quartile***7****81st*Quartile*-*If(current*base*salary<(max*salary*-*min*salary)/4+min*salary,*then*First*Quartile,*otherwise*"-"))***92nd*Quartile*-*If*greater*than*1st*Quartile*but*less*than*2nd,*then*2nd*quartile,*otherwise*1st*Quartile***103rd*Quartile*-*If*greater*than*2nd*Quartile*but*less*than*3rd*quartile,*then*3rd*quartile,*otherwise*2nd*Quartile***114th*Quartile*-*If*greater*than*3rd*Quartile*but*less*than*4th*quartile,*then*4th*quartile,*otherwise*3rd*Quartile***Sheet1*
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
View 9 Replies
Dec 1, 2008
I need to find third quartile for a set of data. Eg:
Client Time Taken
ABC 00:25:27
XYZ 01:11:21
ABC 07:03:33
ABC 02:44:13
DEF 00:22:12
XYZ 00:33:23
ABC 00:22:18
ABC 00:27:12
DEF 00:18:23
............................. etc.
There are around 50 Clients, and the third quartile (of Time Taken) for each of these clients needs to be calculated.
Currently what I am doing is, I sort the entire data by Clint Name, and then write 50 formula (Each for each client).
View 13 Replies
View Related
Dec 10, 2008
Excel formula for 3rd Quartile = Quartile(Range, 3)
In my
Cells(LastRow + 1, 12).Formula =
My range is between Selection and Selectioin.End(xlUp)
So the resultant formula will be somewhat like
"=Quartile("Selection" : "Selection.End(XlUp)",3)"
View 12 Replies
View Related
Jun 18, 2008
I have a collection of data where the lower the value, the better. When I use Quartile/Percentile, it shows higher values as having a higher rank. Any way to reverse the order, without changing the underlying data (ie. multiply all values by -1)?
Also, I have a graph of the data showing the 1st, 2nd (median) and 3rd quartile and then a particular data set (in this case, company results) over a number of years. Any way to automatically add the Percentrank as a data label for the specific company results? For example, the value 200 puts this company at the 65th percentile. I want the data label to show 65, not 200.
View 9 Replies
View Related
Dec 12, 2011
I have a bunch of raw sales data, by individual, which I would like to quartile to determine who is performing at which level.
Not all of this data should factor into the Quartile - a T/F "Exclude?" column flags the individuals who should not count in the quartile for any given month.
I then built a pivot like this with the Row Labels nest like such:
Exclude
Year
Month
Agent
What I would like to do is define a formula that will quartile all of the agents where Exlude is False, Year is 2011, and the Month is January. And I would like this work going forward, so manually defining the range each month would not be a fix.
What do you all think? Is there a way to do this? To tell it to only quartile the individuals for each month?
FALSE
..2011
.....January
.........Roseus.........5
.........Mr. Excel......6
........................3
.....February
View 3 Replies
View Related
Oct 8, 2013
Just curious to know of any other formulas similar to the "quartile" function that allow you to calculate results in thirds (plus any other if known)
View 2 Replies
View Related
Aug 1, 2008
Im looking to use vba to determin upper and lower quartiles, i know how to do this through excel "QUARTILE(B9:B59990,1)", but was wondering if anyone would of any code to do this in visual basic?
View 2 Replies
View Related
Apr 15, 2014
Having trouble changing this formula from its current Median to a Quartile or Percentile. The median formula looks like this:
(MEDIAN(IF(DATA!$B$15:$DZ$15=1000,DATA!$B26:$DZ26))) and works perfect.
However I can't figure out how to manipulate it into a percentile keeping the condition of
IF(DATA!$B$15:$DZ$15=1000)
View 2 Replies
View Related
