Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate the median of a distribution?
I need to calculate the median value of a distribution of numbers. The data I
have are the percentage (pct below, or, I have the total number of contracts if that is easier to work with) of contracts that settled at given rates (rate). The data show that 2.9% of contracts settled at 0, 3.4% of contracts settled at 1, etc. I need to know the median rate of settlement for this set of contracts. There are many contracts, so it is not feasible to create a separate row for each contract and to take the median of those values. Can anybody help? Many thanks in advance Rate Pct 0 2.9 1 3.4 2.5 37.0 3.5 41.8 4.5 9.1 5.5 2.9 6.5 1.9 7.5 0.0 8 1.0 9 0.0 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate MEDIAN of Last x Rows in a Column | Excel Worksheet Functions | |||
How do I calculate the cumulative distribution function | Excel Worksheet Functions | |||
calculate a MEDIAN using multiple criteria? | Excel Worksheet Functions | |||
Calculate median for different groups | Excel Discussion (Misc queries) | |||
Will not calculate average/median formulas;acts like no data in c. | Excel Worksheet Functions |