"Bruce" wrote in message
...
Hi PHilippe: Thanks for responding. My data currently looks like this:

A B C D E
3 5 6 3 2

where (A, B, C, D, E) correspond to the number of responses I get for
ratings of (1, 2, 3, 4, 5), respectively. For example, a "6" in column C
indicates that I have 6 responses of a rating "3".

The median for this "grouped" data is 3 as there are 8 responses below the
3
rating and 8 above. But doing an "=MEDIAN(A1:E1) would give me the median
value of the group (2,3,3,5,6), when what I actually want is the that of
the
groups(1,1,2,2,2,3,3,3,4,4,4,4,4,5,5,5,5,5,5). Does this make sense? But
how to do it???

-Bruce
--
Bruce


"Philippe L. Balmanno" wrote:

"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

Because each column corresponds to a value, what you want then is the max
value in the row
A B C D E
1 3 5 6 3 2
=MAX(A1:E1) would return 6 where Column C corresponds to the rating of 3 and
there are 6