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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top