[dba-Tech] finding the most consistent combination of 3 columns

[Stuart McLachlan]

Guess it depends on how you define "consistemt?  

Absolute difference or relative difference

I woould say that the numbers in row 37 were much "closer" to each other than row 22.

In the first, the outlier is only 20% larger tha the other two.
In the second it is the 100% larger

With your method,  0,0,1  has the same "spread" as 50,50,51 and 98.98.99  which I find hard 
to accept when dealing with percentages. :)


On 9 Mar 2021 at 2:36, John Bartow wrote:

> 37	5.00	6.00	5.00	2.00
> 22	2.00	1.00	1.00	2.00