How to Calculate a Median in Excel 2013

Learning how to calculate a median in Excel 2013 is similar to learning how to perform most other mathematical functions within the program, such as subtracting in Excel. If you are new to using formulas in Excel, then this article can be helpful. Excel uses a formula that takes the values in a range of cells, then automatically determines the median from those values.

If you are not sure what a median value is, then you can find out more about it on Wikipedia. A median can be a good alternative to an average if you find that your data values are highly skewed, and an average is not representative of the data that you are evaluating. Your median value can be determined with just a few short steps in Excel, which can be a real time saver when you are dealing with a lot of data values.

Calculate a Median in Excel 2013

This article will show you how to find the median value for a range of cells that you select. The median will be displayed in the cell that you choose in the second step of our tutorial.

Step 1: Open the spreadsheet containing the values for which you want to calculate a median value.

Step 2: Click inside the cell where you want the median to be displayed.

select the cell where you will display the median

Step 3: Type =MEDIAN(AA:BB) into the cell, where AA is the cell location of the first cell of your range, and BB is the cell location of the last cell. In my example image below, the formula would be =MEDIAN(A1:A7). You can then press Enter on your keyboard to calculate the formula.

type the formula into the cell

Note that the median will be displayed in the cell, but that you can still view the formula by clicking on the cell, then looking at the Formula Bar above the spreadsheet.

view the median formula

If the median value of your data is not helpful, then you can also calculate an average in a similar manner.

solveyourtech.com newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.