I am not very well educated in math and I have a math puzzle that I'm trying to solve. I have the following list and each object has 3 numbers. The first 2 numbers are better when they are as high as possible and the last number is bad when it is a high number.
DWTI 90.07, 28.57, 14.29
DGAZ 75.84, 42.86, 14.29
JNUG 44.9, 28.57, 14.29
SQQQ 18.2, 14.29, 14.29
TLL 89.5, 14.29, 28.57
ENRJ 23.41, 42.86, 14.29
ASPS 7.46, 14.29, 14.29
TKMR 39.88, 42.86, 0
GENE 239.09, 71.43, 0
ZIOP 82.71, 42.86, 0
How can I create a math formula/what math formula could I use to order them with the following names at the top of the list (in any order): ENRJ, GENE, ZIOP, DWTI
I'm looking to create a math formula like this (I know this one doesn't work but this is just an example) ((1st number + 2nd number) - 3rd number) / 3
Data in copyable form:
data ={{DWTI, 90.07`, 28.57`, 14.29`}, {DGAZ, 75.84`, 42.86`, 14.29`},
{JNUG, 44.9`, 28.57`, 14.29`}, {SQQQ, 18.2`, 14.29`, 14.29`},
{TLL, 89.5`, 14.29`, 28.57`}, {ENRJ, 23.41`, 42.86`, 14.29`},
{ASPS, 7.46`, 14.29`, 14.29`}, {TKMR, 39.88`, 42.86`, 0},
{GENE, 239.09`, 71.43`, 0}, {ZIOP, 82.71`, 42.86`, 0}}
