Hi,(adsbygoogle = window.adsbygoogle || []).push({});

Please see the attached Excel file.

The list shows the old and new values of a set of variables. I am trying to understand what is the best way – average or median - to describe the change the values of the set. I want to describe the true central tendency of the change.

1. I think there are the following four ways I can describe the change in the values of the set . Which one is the most accurate?

a) the average value changed by 0.15% (the mean of the change values shown in Cell E63)2. I am ignoring the change values of variables X12 and X39, as these variables did not change. Is that correct?

b) the average value changed by 0.10% (the median of the change values shown in Cell E64)

c) the average value changed by 0.14% (the difference of Cell D63 and C63)

d) the average value changed by 0.25% (the difference of Cell D64 and C64)

Thanks.

**Physics Forums | Science Articles, Homework Help, Discussion**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# What is the correct way of describing this change - mean or median?

**Physics Forums | Science Articles, Homework Help, Discussion**