Excel: determine median - how it works

If you want to determine the median from a data set in Excel, you can do this with a simple formula. We show you how to do this.

Determine median with Excel

• Double-click in the cell in which you want to insert the median.
• Now enter "= median (A1: A99)". In this case you determine the median of all values ​​entered in cells A1 to A99.
• Alternatively, you can click individual cells or select entire rows.

Various exercises on Excel can be found here.