I'm not sure I follow. Do you really mean that you drop the scores that
achieve the most improvement? That seems counterintuitive to me.

To simplify, take an example where there are four scores, and you drop
one.

A B C D
1) 9 7 37 9
2) 10 10 50 10

So before dropping a score, the average is SUM(A1:D1)/SUM(A2:D2) = 77.5%

Dropping the lowest score, in column B (7/10 = 70%) results in (55)/(70)
= 78.57%

Dropping the score in column C (37/50 = 74%) results in (25)/(30) =
83.33%

So you really want to drop a higher % score (74% vs 70%) on a more
important assignment (50 vs 10)???

That seems bizarre!


In article ,
Matthew Leingang wrote:

First, let me say that I have a solution to this problem but I am looking
for a better one. Second, I apologize if this gets a little long.