"Philippe L. Balmanno" wrote in message
...
"Bruce" wrote in message
...
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

Well if you have your values in a row columns A1:S1 then
if this was placed in T1: =MEDIAN(A1:S1) It would bring up your Median.
If your numbers were in a column like in A1:A19 then =MEDIAN(A1:A19) but
=MEDIAN(A1:E6) wouldn't make sense unless you had an array.

5 columns (6) 4's
so your data would look like this {=MEDIAN(A1:E4)}
A B C D E

1 1 1 2 2
2 2 2 3 3
3 4 4 4 4
4 4 5 5