Fahsid1230
Active Member
- Joined
- Dec 26, 2006
- Messages
- 282
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
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