I have two rows of numbers ...
1) 2 2 1 0 0 1
2) 1.5 1 0 .5 1 2
Each column is compared to each other. Lower values are better. For example Column 1, row 2's value (1.5) is more accurate than row 1 (2)
In normal comparison I would take to the sum of each row and compare to the other row to find the lowest sum (most accurate). In this case both would be equal.
I want to create two other comparison methods When values ascend from column 1 they should be weighted more (col 2 should hold more weight than 1, 3 than 2 and so on)
Also the opposite
Originally I thought it would be best to divide the value by its position but that doesn't work correctly.
What would be the best way to do this for a row?
Thanks!