Step by step demonstration of calculation

When entering data, press Enter or Space or Tab or , after each value, non-numeric cells won't be counted

vmes

Sort the list of numbers in running order. The middle number is the median.

When having even number of results, there are two middle numbers, the median is the average of the two results.

Accumulate the sum of all the values, and then divide the result by the total count of values.

Count the total number of time each value appears in the list. The value appears most times is a mode.

You may get more than one mode, as several values may have the same frequency.

For a sample from a continuous distribution, you may need to group the values into equal intervals, the mode will be the interval with the highest frequency.

Since no single value repeats, you may find the mode in the group level histogram