Friday, August 23, 2013

How to Calculate Median in Excel


1. Enter a list of numbers down a column that you would like to calculate the median for. Make sure the numbers are in ascending order.
2. Click on a cell where you would like the median to appear. This can be the cell after the last number or any other area in the spreadsheet where you want the median to appear.
3. Type =MEDIAN(range) in the cell, with the range specified as the range of cells containing the data. For example, if you have data in cells A1 through A6, the range would be A1:A6. Alternatively, in Microsoft Excel 2007, you can click on the 'Formulas' tab in the toolbar. Click on 'Insert Function,' type 'Median' and press 'OK.'

Blogger news