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 - The Fusion of Science and Community**

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?

Loading...

Similar Threads - correct describing change | Date |
---|---|

A Advanced Data Fitting - More than Simple Regressions | Jun 22, 2017 |

A How to do a correct prediction | Apr 18, 2017 |

I Correct way to understand logical implication? | Feb 23, 2017 |

I Understanding Yates' correction | Feb 9, 2017 |

I Why is so much well described by the normal distribution? | May 7, 2016 |

**Physics Forums - The Fusion of Science and Community**