Math for Color Affection

I gathered information from seven knitters of color affection who were kind enough to be very specific about how much yarn they used.  Thanks, ladies!  The trouble is, the yardage varies dramatically.  And it's not even consistent which color you need the most of!  But I've compiled a little table of the results:

Number	MC in yds	CC1 in yds	CC2 in yds
1	217	167	243
2	277	173	217
3	250	211	277
4	256	224	250
5	277	231	300
6	293	254	231
7	277	185	250
Highest	293	254	300
Average	264	206	252

I think number 6 is an outlier in the data.  If I throw those numbers out, my averages are:
MC: 259 yds, CC1: 199 yds,  CC2: 256 yds.  If I spin consistently at 258 yd/50 gm, that would be:
MC: 50.2 gm, CC1: 37.3 gm, CC2: 49.6 gm.

So how much should I spin?  I would love to make all the yardage come out perfect, with no waste, but I know that's setting myself up for trouble.  I think I'll call  my first 50 gm CC2, use the 40 gm bunch for CC1, and add some to the make a 55 gm bunch for the MC.