The median is the middle number in a range of numbers. If you have data in an Excel 2013 workbook, you can use a simple formula to calculate the median. This may be easier and more accurate than trying to work it out manually, especially if you are dealing with a large set of numbers.
Video of the Day
Open a new worksheet in Excel. Click on the first cell in the first column and type the number "1" (without the quotation marks) into the cell.
Click on the cell below or press "Enter" on your keyboard to go to it automatically. Type "2" (without the quotation marks) in this cell. Repeat the process until you have numbers 1 through 5 in cells A1 through A5 in the column.
Click on an empty cell where you want the median calculation to appear. This cell can be directly under your list of numbers or anywhere else on the sheet.
Type "=MEDIAN(A1:A5)" (without the quotation marks) into the cell. This tells Excel to calculate the median across your range of cell numbers. Press the "Enter" key and you should see the median number appear in the cell designated in Step Three.