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