How do I calculate a combined median of two groups

[ablackburn]

I have two groups of data that I want to calculate the combined median for.One group has 4,094 sales with a median of $573,139 and the 2nd group is 1,259 sales with a median of $2,023,814.How do I calculate the median of the combined groups?Thanks

 

[Eric W]

You need to calculate the median from the combined group, you can't do it from the medians and sizes of the groups.

	A	B	C

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]10[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"]10[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"]10[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"]11[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"]12[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"]12[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"]12[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"]11[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"]8.5[/TD]
[TD="align: right"][/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A9[/TH]
[TD="align: left"]=MEDIAN(A1:A7)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C9[/TH]
[TD="align: left"]=MEDIAN(C1:C7)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B10[/TH]
[TD="align: left"]=MEDIAN(A1:A7,C1:C7)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

I have two groups of data that I want to calculate the combined median for.One group has 4,094 sales with a median of $573,139 and the 2nd group is 1,259 sales with a median of $2,023,814.How do I calculate the median of the combined groups?Thanks

Eric has told you how to do what you asked for; but, if the values you posted are representative in any way, I have to wonder of what use such a number would be. The median is the value in the middle of the set. Given the large difference in sales between the two groups, the median of the combined groups will always come from the group with the larger number of sales... the only thing the smaller sales group will do is pull the median from a different location within that larger sales group. Since the medians between the two groups is so widely different, I cannot see what value there would be in obtaining the median for the combined groups. Are you sure you mean the median and not the mean (average)?

 

[ablackburn]

Unfortunately, the groups are summed, so I don't have the sale prices of the individual sales. I just have the numbers above, so I don't think the formula from Eric will work.

 

[Eric W]

If the numbers you gave are the means (NOT medians) of the groups, you can calculate the mean of both combined groups like this:

=(573139*4094+2023814*1259)/(4094+1259)

However, if those are medians, then this will generate some meaningless number you should not use for anything. Depending on what you're trying to achieve, you may not have enough information to make a good decision. The answer would be to get more information, not try to torture the information you have into giving you something that doesn't work.

What are you trying to achieve?