Stats help!!!

[aarivera]

I have been given a set of stats by a fellow employee with no description of how she arrived at her conclusion. The stats are final results on how well one of our catalog did in sales. Total Rev for the catalog was $465,084 and there were 1,011 products in the catalog. The top 50% of products made $368,850 of the total rev. According to her spreadsheet, the that top half, 505.5 products, individually made $442 or more. Where did she get the 442?

 

[Dr.Peterson]

I have been given a set of stats by a fellow employee with no description of how she arrived at her conclusion. The stats are final results on how well one of our catalog did in sales. Total Rev for the catalog was $465,084 and there were 1,011 products in the catalog. The top 50% of products made $368,850 of the total rev. According to her spreadsheet, the that top half, 505.5 products, individually made $442 or more. Where did she get the 442?

That would have to come from the actual data, not from the summary you've given. As I interpret what you say, $442 is the revenue from the 505th product down the list, so that everything above it made at least $442. That makes sense, since if 505 products all made $442, the total would be $223,210, which, appropriately, is less than what their total actually is.