To determine the **median** of a dataset, you may use one of the following options:

1) Select the whole dataset (A1:A100) and sort it from the smallest to the largest value using the `Sort Smallest to Largest`

functionality which you will find by clicking on the `Sort & Filter`

icon, in the `Editing`

section of the ribbon under the `Home`

tab. Once the dataset sorted, you just need to find the value in the middle position of the sorted set of entries. If the dataset contains an **odd number n of entries**, then the median is the value of the ((

*n*+1)/2)

^{th}entry in the dataset. If the dataset contains an

**even number**, then the median is the

*n*of entries**average of the values of the (**. In our practical example, the dataset contains an even number of entries (100), the median is therefore the average of the (100/2)

*n*/2)^{th}and ((*n*/2)+1)^{th}entries^{th}and the ((100/2)+1)

^{th }entries, i.e. the average of the 50

^{th}and 51

^{th}entries.

2) Simply use the function

to directly obtain the value of the median. In our case, type **=**MEDIAN(...)`=MEDIAN(A1:A100)`

to get the median of our dataset.