Percentile Logic

P

PAL

I have two formulas, one to identify 75th percentile, the other 95th
percentile. They return the same value which makes no sense. They are both
arrays. Please advise.

=PERCENTILE(IF('1 Worksheet'!$H$2:$H$1309="",'1
Worksheet'!$I$2:$I$1309,""),0.75)


=PERCENTILE(IF('1 Worksheet'!$H$2:$H$1309="",'1
Worksheet'!$I$2:$I$1309,""),0.95)
 
B

barry houdini

I take it you have "array entered" the formula so that they are enclose
in curly braces?

Are either of the results correct? 75th Percentile is the same as 3r
Quartile so you could compare with tha
 
M

Mike H

I see my formula in response to your previous thread worked, you never
mentioned that!!

On what data do you get the same answer with these 2 formula?

Mike
 
K

Kassie

You are not using PERCENTILE correctly. Loose the <=""> from the first range
and the <""> from the second range.

--
HTH

Kassie

Replace xxx with hotmail
 
Top