Finding the Median (Slightly more complicated)

**paul86** · 07-31-2012, 02:35 PM

Hi,

I'm trying to find the median number from a group where there is more than one instance of each number. The easiest way to describe it would be to look at this picture:

\1

For July 2010, there were 8 sales at $240k each. August 2010 there were 7 sales at $185k each. September 2010 there were 12 sales at $214k each.

So basically if you were to manually write it out and find the median it would look like this:

185,185,185,185,185,185,185, 214,214,214,214,214,214,214,214,214,214,214,214,240,240,240,240,240,240,240,240. And the median would be 214.

How do you operate this function (or another) so that it can find the median when there's more than one instance of each number like in this example? This is an actual screenshot of what i'm working with, so any help would be much appreciated. Thank you very much.

**shg** · 07-31-2012, 02:37 PM

=median(185,185,185,185,185,185,185, 214,214,214,214,214,214,214,214,214,214,214,214, 240,240,240,240,240,240,240,240)

I just realized that's not what you want.

There's no way to calculate the median price, average price, or weighted average price from the information in your picture.

**paul86** · 07-31-2012, 02:42 PM

Right, but hardcoding that in every single time is crazy. Sometimes there's hundreds of instances of one number.

**shg** · 07-31-2012, 02:45 PM

See the edit to my last post. The result of that formula is meaningless -- it doesn't calculate anything when the arguments are themselves median values.