Forum Discussion

Todd Benedict's avatar
Todd Benedict
Copper Contributor
Nov 03, 2018

Find the closest 3 averages in a range of 21 values

I'm trying to determine the fairest 3 man teams for next season's league by averaging the performance numbers of 21 players and seeing which 3 numbers are most equal, creating the fairest teams. The ...
excel
Todd Benedict's avatar
Todd Benedict
Copper Contributor
Nov 04, 2018

Thanks for the response. The average for the below scores per player is 86.2, or for a 3 man team the average is 258.6. What I'd like to do is find the 3 matches that come closest to this average to determine the fairest teams for next year. For example, the best player would have to be paired with the two worst players with the scores

 

355.87

15.34

8.9

 

I would like to find all other 3 player score combinations that come closest to the average to find the fairest teams

 

Here are the scores without decimals in descending order. Does this make sense?

 

356
236
212
170
142
109
103
94
57
40
40
34
33
33
32
30
26
23
16
15
9
Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Nov 04, 2018

if your criteria would be pairing the highest with the two lowest,

pls see attached file.

hope that this is what your're looking for.

thanks..

  • Todd Benedict's avatar
    Todd Benedict
    Copper Contributor
    Nov 05, 2018

    Thanks, Lorenzo. That seems about right. Can you advise what formula is used to show these numbers? So I know for the future. Thanks again for your help!

    • Lorenzo Kim's avatar
      Lorenzo Kim
      Bronze Contributor
      Nov 05, 2018

      I don't use any formula.. just pairing of a top to 2 bottoms.
      glad that it helped..

       

      actually, it is like the semi matchup of NBA

      number 1 against number 8

      2 vs 7

      3 vs 6

      4 vs 5

Resources