graphing question

[msingle]

For this series of data:

4,5,7,3,4,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0

How would I graph the percentile range...that is, this range of numbers fall the lowest 25%, then 50%, then 75%.

I tried
quatrile(array,x,1)
quatrile(array,x,2)
but the results don't make alot of sense.

 

[SkipVought]

Hi,

I pasted you list in column A from A3 to A22.

Then I put .25, .5, .75 and 1 in row B1 - E1

In B2...

=PERCENTILE($A$3:$A$22,B1)

and copy to E2

In B3...

=IF($A3<=B$2,$A3,&quot;&quot;)

and copy DOWN

in C3...

=IF(AND($A3<=C$2,$A3>B$2),$A3,&quot;&quot;)

and copy across and down.

and...

VOLA! I think that's what you want???

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com