Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Quartile Function
I would like to use a formula to return which quartile the given data array
falls into- that is I would like to return 0,1,2,3,4. 0= min, 1=25%, 2=50%, etc. The quartile function only returns the value of the various quartiles, while I need to know within which quartile the value falls. Any help is appreciated. |
#2
|
|||
|
|||
On Tue, 15 Mar 2005 01:01:02 -0800, "tika528"
wrote: I would like to use a formula to return which quartile the given data array falls into- that is I would like to return 0,1,2,3,4. 0= min, 1=25%, 2=50%, etc. The quartile function only returns the value of the various quartiles, while I need to know within which quartile the value falls. Any help is appreciated. Perhaps: =FLOOR(A1,0.25)*4 will do what you describe? --ron |
#3
|
|||
|
|||
For a given observation in the data set,
=SUMPRODUCT(--(obsQUARTILE(allData,{1,2,3,4})))+1 should do it. Jerry tika528 wrote: I would like to use a formula to return which quartile the given data array falls into- that is I would like to return 0,1,2,3,4. 0= min, 1=25%, 2=50%, etc. The quartile function only returns the value of the various quartiles, while I need to know within which quartile the value falls. Any help is appreciated. |
#4
|
|||
|
|||
Hi Jerry, I tried this, but get a #name error- it seems to not recognize the
"obs" funciton. Actually, I don't get this one either. Is it a special function from an add-in? Thanks for your help. "Jerry W. Lewis" wrote: For a given observation in the data set, =SUMPRODUCT(--(obsQUARTILE(allData,{1,2,3,4})))+1 should do it. Jerry tika528 wrote: I would like to use a formula to return which quartile the given data array falls into- that is I would like to return 0,1,2,3,4. 0= min, 1=25%, 2=50%, etc. The quartile function only returns the value of the various quartiles, while I need to know within which quartile the value falls. Any help is appreciated. |
#5
|
|||
|
|||
"obs" is not a function, it is a place holder for your observation, just
as "allData" is a place holder for the endire data set. Replace the place holders with appropriate cell references, range names, or constants. Jerry tika528 wrote: Hi Jerry, I tried this, but get a #name error- it seems to not recognize the "obs" funciton. Actually, I don't get this one either. Is it a special function from an add-in? Thanks for your help. "Jerry W. Lewis" wrote: For a given observation in the data set, =SUMPRODUCT(--(obsQUARTILE(allData,{1,2,3,4})))+1 should do it. Jerry tika528 wrote: I would like to use a formula to return which quartile the given data array falls into- that is I would like to return 0,1,2,3,4. 0= min, 1=25%, 2=50%, etc. The quartile function only returns the value of the various quartiles, while I need to know within which quartile the value falls. Any help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |