I have a data set that looks like this:
|Name||Top Speed||Number Sprints||Cumulative Sprint distance|
Top Speed is in km/h. Cumulated Sprint distance is in km. Number of sprints is a counted number.
I need a way to rank the data in a smart way by rating. each entry should have a rating, which is calculated from the 3 columns. Based on this rating I would like to rank the data. So someone with a high maximum speed, most sprints run and the total distance sprinted should have a better rating than someone who has a worse value overall. I don't care about the range. I just want it to be "logical" and smart. Overall, it's about giving each entry a value as a "skill" based on the 3 variables. Overall, I am thinking of a formula that I can apply to new data. It would also be useful to be able to weight variables here in the formula. So the influence in the target variable. Or do you see a ML model hier which I fit with the 3 columns and let him rate it? Which model would work here?