Excel: why is the average of divisions different from division of sums?

Viewed 3333

So lets say I have two variables x and y. I calculate the total sum of each variable.

I calculate y/x for each row and also calculate y/x for the sum of both x and y columns (280/10=28).

I would expect this value (28) to be equal to the average of y/x (230/4=32.5), but it is different.

This might have a simple explanation, but I can't seem to find it.

An example here

Thanks in advance

1 Answers
Related