Question

How can you calculate median by using Excel ? Illustrate.​

Answer 1

Explanation:

MEDIAN is one of the most straightforward and easy-to-use functions in Excel. However, there are still some tricks, not obvious to beginners. Say, how do you calculate a median based on a condition? The answer is in one of the following examples.

Excel Median formula

For starters, let's see how to use the classic Median formula in Excel to find the middle value in a set of numbers. In a sample sales report , supposing you want to find the median of numbers in cells C2:C8. The formula would be as simple as this:

hope it help