Assuming that your counts are in A1:A5, that the corresponding values are
1,...,5, and that no count exceeds 6, the array formula
=MEDIAN(IF(ROW(A1:E6)<=A1:E1,COLUMN(A1:E1)))
should give what you want.

Note that array formulas must be array entered (Ctrl-Shift-Enter)

Jerry

"Bruce" wrote:

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