Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculate percentile for indexed numbers. Thanks
Hi, I have a large series of numbers saved in one column
[34,5,21,98,34,3,432,55,27,90,1125,......]. These data are indexed, e.g. by [1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,......N] which are in another column. Basically I am calculating the 25% percentiles for numbers indexed "1", "2", "3",...., "N" respectivelly. There are a lot of numbers with a big uplimit of index "N" so that selecting numbers of each index manually is not easy. In another word, if N = 9999, then I need to calculate N 25% percentiles with one for each indexed number class. That is it. Thansk for any input! Thanks a lot! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculate percentile for indexed numbers. Thanks
Dan --
Don't quite understand exactly what you're trying to do, but two Excel 2003 functions should work nicely: =PERCENTILE, and =PERCENTILERANK. An example: =PERCENTILE(A1:A9999,0.25) It sounds like you have different classes of results, classed by your index number. If that's correct and the data is fairly static, you might sort them first. If not, then we can play with a better formula that takes those classes into account. HTH "Dan" wrote: Hi, I have a large series of numbers saved in one column [34,5,21,98,34,3,432,55,27,90,1125,......]. These data are indexed, e.g. by [1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,......N] which are in another column. Basically I am calculating the 25% percentiles for numbers indexed "1", "2", "3",...., "N" respectivelly. There are a lot of numbers with a big uplimit of index "N" so that selecting numbers of each index manually is not easy. In another word, if N = 9999, then I need to calculate N 25% percentiles with one for each indexed number class. That is it. Thansk for any input! Thanks a lot! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Calculate numbers between 2 dates | Excel Discussion (Misc queries) | |||
Calculate Minimum numbers | Excel Worksheet Functions | |||
Formula to calculate only the negative numbers | Excel Worksheet Functions |