Is it possible to create a formula to rank subject on a scale of 1-10 (decimals acceptable) given the data?

Question

Trying to create a formula to that ranks a subjects on a scale of 1-10

Data I have includes, in no particular order

1. The number of trials completed over the number of trials attempted. For example one subject completed 99 trials out of 152 attempted trials. 99/152 (Higher Number of Trials completed = rank closer to 10)
2. Average Completion of trials. On average Example Subject completed 86.07% of a trial before failure. (Higher percentage = rank closer to 10)
3. Overall Completion of all tasks within trials. Subject in example completed 85.22% of all tasks across trials (higher percentage = rank closer to 10)
4. Completion of tasks compared to other other subjects (commonality of completion?). 46.65% of other subjects were able to complete same tasks in trials as example subject. (lower percentage = rank closer to 10)

Is it possible to create a formula to rank subject on a scale of 1-10 (decimals acceptable) given the data?

Answer 1

Hi Nicholas K.,

Not possible. Sets 1 and 2 appear to deal with a single task across multiple trials. If the total attempted set size is equal over these two datasets, then there are ways of relating set 2 performance to set 1 performance. But, to be useful data, there must be many trials in the set: successful completion of 1/1 trials doesn't make one infinitely competent, for example.

In sets 3 and 4, there appear to be multiple tasks within each trial. This is a different granularity of data, if you will.

In set 4, there is again no apparent standardization of data sets for tasks. So if I can complete a task that noone else can, does that make me superior, if that is the only task that I do accomplish? Obviously not! So you are trying to compare apples scores to oranges scores, never useful.

So -- you could, with difficulty, combine sets 1 and 2, (perhaps), only.

-- Cheers, -- Mr. d.