Calculates the middle value of a given set of numbers Show
What is the MEDIAN Function?The MEDIAN Function[1] is categorized under Excel Statistical functions. The function will calculate the middle value of a given set of numbers. Median can be defined as the middle number of a group of numbers. That is, half the numbers return values that are greater than the median, and half the numbers return values that are less than the median. For example, the median of 2, 3, 3, 5, 7, and 10 is 4. In financial analysis, the function can be useful in calculating the median of certain numbers, e.g., median sales or median expenses. Formula=MEDIAN(number1, [number2], …) The function uses the following arguments:
For the MEDIAN function, remember that:
How to use the MEDIAN Function in Excel?As a worksheet function, MEDIAN can be entered as part of a formula in a cell of a worksheet. To understand the uses of the function, let us consider a few examples: Example 1Let’s understand how this function would calculate the median using the set of values below: Here we provided an odd set of values. The formula used was: We get the results below: Suppose we now provide an even set of numbers and use the formula below: As it is an even set of numbers, the average of the two middle values is returned. Example 2For the data below: We used the following formula: While calculating the median for the above range, the function ignored the logical values and gave the result below: Click here to download the sample Excel file Additional ResourcesThanks for reading CFI’s guide to important Excel functions! CFI is the official provider of the Financial Modeling & Valuation Analyst certification. By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional CFI resources:
Article Sources
What does median A1 A4 return?What does MEDIAN(A1:A4) return? 6. Cells B1:B25 contain salaries. Write a formula to return the rank of cell B8, with the values ranked in ascending order. RANK(B8, B1:B25, 1)
What is the formula that will add the contents of the cells A1 and A2?For example, clicking in a cell and typing =A1+A2 means that the value of the cell you selected will equal the value of cell A1 plus the value of cell A2.
What is the formula for adding the values found in cell range A1 A3 C1 C2 and e1?For example, the function =SUM(A1:A3, C1:C2, E2) will add the values of all cells in the three arguments.
What is the correct function to show the formula in cell A2?For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data. The formula in C2 returns the formula it finds in cell A2 as a text string so that you can easily inspect its structure.
|