Question: what is the difference between the average and median functions in excel?
Answer: Median is the middle value in a group of numbers, which are arranged in ascending or descending order, i.e. half the numbers are greater than the median and half the numbers are less than the median. ... In this case, the median is the arithmetic mean (average) of the two middle values.