percentile

[Fahsid1230]

Hi Folks,
I have a list like:
Lafayette 0.0%
Natchez 0.0%
Branson 0.0%
Mtn Grove 0.0%
Jefferson City 0.0%
Joplin 0.0%
Pittsburg 0.0%
Galesburg 0.0%
Peoria 0.0%
Sedona 0.0%
Baytown 0.0%
League City 0.0%
Houston 0.0%
West Plains 0.1%
White Mountain 0.3%
Springfield 0.5%
Columbia 0.6%
Cedar Rapids 0.8%
Monroe 0.9%
Bluefield, WV 1.0%
Slidell 1.2%
Birmingham 1.7%
Casa Grande 1.7%
Payson 1.8%
Alexandria 2.3%
Monett 2.3%
New Orleans 2.9%
Columbia, TN 3.0%
Meridian 3.1%
McComb 3.9%
Shreveport/Minden 5.5%
Osage Beach 5.8%
Flagstaff 7.5%
Tullahoma 8.6%
Baton Rouge 9.0%
Yuma 11.0%

In column A, I have the programs and in column B the % associated with it. Now the task is to find out the 25th percentile based from lowest to highest. The criteria is that lowest is good. Do I make any sense??? Any solution to this ???
I have used the percentile from the formula box but the result is coming as #nNUM.
Any help will be appreciated.
thx

 

[Kelbo]

Hi,

I think you may be using 25 in the function instead of 0.25.

The K value in the function must be between 0 and 1.

=PERCENTILE(E1:E36,0.25)

However this will give a value of 0.

If you try =PERCENTILE(E1:E36,0.85) then the result will be 0.051.

Hope this helps to solve your problem!

Kelbo

 

[Fahsid1230]

Thanks for the response. You are correct. I was using 25 but upon reading the rule, I than used .25 and the result was zero. What 0.85 signifies?? Is this constitute 25% percentile???

 

[Kelbo]

Hi! Fahsid1230

I used the value 0.85 to show that the function actually works. The 25th percentile is too small and hence shows zero.

Hope you follow this logic, if results give error messages or a value of zero I like to prove that the function is working and that the zero is a valid answer.

Regards,
Kelbo

 

[Fahsid1230]

thanks so much.