On my machine the formula in column A returns everything but the Median. As I uploaded it, the formula in Column A returns a value of 87. Last night, when I sorted the data from smallest to largest, the value changed (which shouldn't happen with a Median function). Today, I cannot reproduce that particular error, but the Median for column A should be 21, not 87. Now I'm noticing that if I change the last value in column C to 10, the Median formula result changes to 6. My understanding of Median is that, if you have an odd number of numbers, Median is just the number in the middle when you sort them by highest to lowest. Changing the largest number to a larger number, shouldn't affect Median, by my understanding.
Thanks for looking at it. I'm hoping the hive mind can help.
|