Hi,

I assume you are *not* answering my question but the OP's? My question referred to the specific data set of A1:E5 discussed earlier and the median function =median(A1:E5). I know we need CSE (array) when we use MEDIAN(IF( etc. I was interested in why Philippe said we must have CSE for =median(A1:E5).

The following link says CSE not necessary.

"Referencing more than a single row or column will also give the correct median value. Entering these formulas using (Ctrl + Shift + Enter) is not necessary......"

Source: http://www.bettersolutions.com/excel...I647548581.htm

On to your formula ......

A1:E1: 3 5 6 3 2 as OP stated.

If I am not mistaken your formula (with CSE) returns 15 which is not the median. Am I missing something?

Please explain. My purpose is to learn. Thank you.

Epinn

"excelent" wrote in message ...
{=SUM((A1:E1)*{1;2;3;4;5})/SUM(A1:E1)}



"Epinn" skrev:

Hi Philippe,

...... but =MEDIAN(A1:E6) wouldn't make sense unless you had an array ...... <<

Can you elaborate this statement, please? Can you give me an example that using CSE (Ctrl+Shift+Enter) will give the correct result whereas not using it will give the wrong result?

Using the data set suggested by you

A B C D E

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

and many other data sets that I created, I always came up with the same correct result without using CSE. I even used data sets that had values not in a sorted (ascending) sequence; no problem whatsoever.

I really want to know what you meant by way of an example. Thanks.

Epinn

"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.