We’ll use the same range of ten numbers (2, 3, 5, 5, 7, 7, 7, 9, 16, and 19) as we used in the method for finding the mean value. Enter them in the cells from A1 to A10, if you haven’t already done so.
 You do this by using the MEDIAN function. As with the AVERAGE function, you can enter it one of three ways:


Click on an empty cell, such as A13, then type “=MEDIAN(A1:10)” (again, without the quotation marks) directly in the cell.
Click on an empty cell, then click on the “fx” symbol in the function bar above the worksheet. Select “MEDIAN” from the “Select a function:” list in the Insert Function dialog and click OK. Enter the range “A1:A10” in the Number 1 field of the Function Arguments dialog and click OK.
Enter an equals sign (=) in the function bar to the right of the function symbol. Select the MEDIAN function from the Name box dropdown list to the left of the function symbol. Enter the range “A1:A10” in the Number 1 field of the Function Arguments dialog and click OK.
 The median is the point where half the numbers in the sample have values higher than the median value and the other half have values lower than the median value. (In the case of our sample range, the median value is 7.) The median may be the same as one of the values in the sample range, or it may not.
Enter the numbers you want to find the median for.
Find the median value of the numbers you entered.
Observe the result in the cell you entered the function in.
{"src": "wikihow-all_validation", "title": "How to Calculate Averages in Excel2"}