Apologies if this is a simple query, I have struggled to find an obvious solution on the wider web, though.
I am trying to calculate the median sale price across a total number of sales. Total 2046 sales at 17 different prices.
The data is in two columns. The first column contains the unit price. The second column contains the number of sales of that unit at that price.
Data in the attachement.
Any assistance appreciated.
Last edited by captainjazz; 06-21-2011 at 08:35 AM.
by inspection median is 9 (in c3 put = b3,in c4 put =b4+c3 drag down
median is the middle number (or mean of the middle 2 numbers if range even)
your median lies at sum(b3:b19)/2 which is 1023
you can see it lies between 985 and 1189 which corresponds to £9
the average price would be
=SUMPRODUCT(A3:A19,B3:B19)/SUM(B3:B19) which =£8.67
Last edited by martindwilson; 06-21-2011 at 09:34 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks martindwilson. That makes sense.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks