Say I have these values :
| Value 1 | Value 2 | Absolute difference (Value 1 - Value 2) | Relative difference (Value 1 / Value 2 - 1) |
|---|---|---|---|
| 0.80 | 0.30 | 0.50 | 167% |
| 0.75 | 0.20 | 0.55 | 275% |
I'm interested in calculating the overall relative difference. I see two options :
Option 1: Average of relative differences
$$(167\% + 275\%)/2 = 221\%$$
Option 2: Relative difference of averages
$$Average\ Value\ 1 = (0.80+0.75)/2 = 0.78$$ $$Average\ Value\ 2 = (0.30+0.20)/2 = 0.25$$ $$Average\ relative\ difference = (0.78/0.25-1) = 210\%$$
I've done the algebra and know that the two options will give different numbers, but I can't see why they are different. Is one better that the other? Is there some weighing happening that I don't see? I wish to have equal weighing across the observations.
Thank you.