This time, we're going to calculate the Weighted Harmonic Average.
The formula I found on Wikipedia looks like this:
The table we're starting with, again, looks like this:
Our Average is 165.8, the median is 165.05 and the Weighted average is 163. Lets see what the Harmonic Weighted average gives us.
Lets add up our Unit Prices.
Now, we divide each quantity sold by the unit price and we add them up. Sounds weird to me, but, why not.
(Sum([Quantity sold]/[Sold at (unit price)])
I think I'm starting to like this particular average :)
Last step, we divide.
=Sum([Quantity sold]) / (Sum([Quantity sold]/[Sold at (unit price)]))
Tada, our Weighted Harmonic Average : 161.52
More averages to come :)