Median calculation of grouped data.
=MEDIAN(A1:E6)
"Bruce" skrev:
Greetings all: All I want to do is calculate the median of grouped data. I
have five cols. of data corresponding to a 1:5 Likert scale. For example: 3
ones, 5 twos, 3 threes, 6 fours, 2 fives. I have 19 values, so the 10th
ranked value would be the median. The 10th value resides in the "threes"
column, so that's my median value. But how to do this via a function?
Do I expand these cells like this?:
=MEDIAN(1,1,1,2,2,2,2,2,3,3,3,4,4,4,4,4,4,5,5), which I don't know how to do,
by the way, or is there a simpler way?
Many thanks in advance...
--
Bruce
|