 #1
 251
 6
Main Question or Discussion Point
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.
Attachments

20.9 KB Views: 103