Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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,......] which are in another column. I need to calculate percentiles (25%,50% and 75%) of these numbers for different indexes. In another word, I need to calculate percentiles for those numbers with index of 1, 2, ... respectively, not the percentiles of all the numbers. Thanks a lot! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |