I collect coin sets from the Australian mint, using ebay's "completed listing" feature, I can find out what the coin sets have been selling for over the 15 days or so and it is easy enough to use Excel to find out the mean price over the last fortnight.

My main problem is the outliers, a few auctions go unnoticed by the public and the sets sell very cheaply with no competition, a few people haven't done their homework and use the "buy it now" option and pay well above the mean.

These all skew the data, I can easily manually remove any obvious inconsistencies and I have used the TRIMMEAN function in excel to cut out the top and bottom values once they have been sorted.

All these methods work and with the small number of listings it probably won't effect the final figure much but I would like to know the most accurate way of automatically cutting out the most obvious outliers to produce a more accurate mean price for a fair auction (one that everyone has an equal opportunity to pay their maximum price in the auction).

I though some way of chosing a middle value, finding out how most of the values differ from that value and from each other and ignoring all values that differ by a larger margin and finaly working out the mean from all the remaining values.

Not sure how to tell that to Excel though, any ideas?

Cheers

MArk