Best Answer

It gets the middle value of a list of values. If you have a list of numbers, it returns the middle value as if they were in numerical order. If there is an odd amount of numbers, then it will give you one of the numbers that is in the list. If there are an even amount of numbers, then it will give the number halfway in value between the two middle numbers.

Study guides

☆

Q: What does MEDIAN mean in Excel?

Write your answer...

Submit

Still have questions?

Continue Learning about Math & Arithmetic

The median can be calculated using the Median function. Assuming the values you wanted the median of were in cells B2 to B20, you could use the function like this: =MEDIAN(B2:B20)

The mean is better than the median when there are outliers.

The median is 9 and the mode is 18 and the mean is 11

the median and mode are but the mean is not

median is the middle number mean is average mode is most median is middle range is high - low

Related questions

Excel has a function called MEDIAN which can be used. Usually you would put the cell range within it as follows: =MEDIAN(A1:A15)

The Average function in Excel totals a range of cells and divides the total by the amount of values in those cells. In mathematics this is known as the Arithmetic Mean.

The mean deviation from the median is equal to the mean minus the median.

The median can be calculated using the Median function. Assuming the values you wanted the median of were in cells B2 to B20, you could use the function like this: =MEDIAN(B2:B20)

The middle value of a set of numbers that are in order is known as the median. If the amount of numbers is odd, there will be a middle number. If the amount is even, then the median is the value halfway between the two middle numbers. Excel has a function called MEDIAN to get the median.The middle value of a set of numbers that are in order is known as the median. If the amount of numbers is odd, there will be a middle number. If the amount is even, then the median is the value halfway between the two middle numbers. Excel has a function called MEDIAN to get the median.The middle value of a set of numbers that are in order is known as the median. If the amount of numbers is odd, there will be a middle number. If the amount is even, then the median is the value halfway between the two middle numbers. Excel has a function called MEDIAN to get the median.The middle value of a set of numbers that are in order is known as the median. If the amount of numbers is odd, there will be a middle number. If the amount is even, then the median is the value halfway between the two middle numbers. Excel has a function called MEDIAN to get the median.The middle value of a set of numbers that are in order is known as the median. If the amount of numbers is odd, there will be a middle number. If the amount is even, then the median is the value halfway between the two middle numbers. Excel has a function called MEDIAN to get the median.The middle value of a set of numbers that are in order is known as the median. If the amount of numbers is odd, there will be a middle number. If the amount is even, then the median is the value halfway between the two middle numbers. Excel has a function called MEDIAN to get the median.The middle value of a set of numbers that are in order is known as the median. If the amount of numbers is odd, there will be a middle number. If the amount is even, then the median is the value halfway between the two middle numbers. Excel has a function called MEDIAN to get the median.The middle value of a set of numbers that are in order is known as the median. If the amount of numbers is odd, there will be a middle number. If the amount is even, then the median is the value halfway between the two middle numbers. Excel has a function called MEDIAN to get the median.The middle value of a set of numbers that are in order is known as the median. If the amount of numbers is odd, there will be a middle number. If the amount is even, then the median is the value halfway between the two middle numbers. Excel has a function called MEDIAN to get the median.The middle value of a set of numbers that are in order is known as the median. If the amount of numbers is odd, there will be a middle number. If the amount is even, then the median is the value halfway between the two middle numbers. Excel has a function called MEDIAN to get the median.The middle value of a set of numbers that are in order is known as the median. If the amount of numbers is odd, there will be a middle number. If the amount is even, then the median is the value halfway between the two middle numbers. Excel has a function called MEDIAN to get the median.

You may mean the 'median' of a series of numbers, instead of the 'average'. Microsoft Excel will crank out those two statistics in no time.

The median of 65 and 90 is the same as their mean: 77.5The median of 65 and 90 is the same as their mean: 77.5The median of 65 and 90 is the same as their mean: 77.5The median of 65 and 90 is the same as their mean: 77.5

who discovered mean median and mode

Mean, Median and Mode. They are three kinds of averages.

Mean is the average, and median is the middle number.

You can estimate the median and the mean.

The mean is better than the median when there are outliers.

People also asked