I've a data:
| name | team | score | score_diff |
|---|---|---|---|
| a | x | 10 | 10 |
| a | y | 20 | 10 |
| b | x | 400 | 10 |
| b | y | 390 | 10 |
| c | x | 400 | 390 |
| c | y | 10 | 390 |
How to know for each value in name, whether the score difference, i.e. values in score_diff column is significantly large or not, on the basis of values present in score column
E.g. For a & b:
| name | team | score | score_diff |
|---|---|---|---|
| a | x | 10 | 10 |
| a | y | 20 | 10 |
and
| name | team | score | score_diff |
|---|---|---|---|
| b | x | 400 | 10 |
| b | y | 390 | 10 |
Both a & b has score_diff of 10, but a difference of 10 for b in scales of 390 & 400 is not as big as a difference for a which is in 10 & 20 scale
Similarly, in scale of 10 & 400, score_diff of 390 is huge.
Is there any way to determine when is the score_diff a significant value, on the basis of values in score column?