- #1

- 280

- 10

Hi,

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?

Thanks.

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)

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)

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.