Whenever we are given a set of numbers in statistics we need to calculate the values such as mean, median and mode for the data set. We can calculate these values using simple statistical methods. This article will help you in calculating mode of a data set using simple steps. Know how to calculate mode of a set of numbers using the Excel sheet.

Mode is the value in a set of numbers that occur maximum times within a set of numbers. A set of numbers may have more than one values of mode within a data set.

**Calculating mode of a set of numbers:**

You need no calculations for identifying the mode or model value of a given set of numbers. This can be done very easily by arranging the numbers in order.

You can arrange the numbers in ascending order or in descending order. In ascending order numbers are arranged in increasing order while in descending order numbers are arranged in decreasing order. If you know how to arrange the numbers, you can easily compute the mode value of the data set.

It is somewhat difficult to arrange the numbers in case of large data sets. In this case you can take help of the online tools for arranging the data.

- Step 1: Arrange the set of numbers you have been given either in ascending order or in descending order. This will help you in identifying the number which is occurring for maximum number of times easily.
- Step 2: When you have arranged the numbers, look at these numbers and identify the number that occurs for maximum number of times.
- Step 3: If there are more than one numbers that occur for the same number of times then both these numbers are the mode of the given set of values.
- Step 4: This value is the mode of your data set.

**Example:**

Suppose you have been given a set of numbers as

3, 7, 5, 13, 20, 23, 39, 23, 40, 23, 14, 12, 56, 23, 29

Arranging these numbers in order we get,

3, 5, 7, 12, 13, 14, 20, 23, 23, 23, 23, 29, 39, 40, 56

In this case 23 appear 4 times which can be easily located. The purpose of arranging the numbers is to simply make it easier to locate which number appears the maximum number of times.

**Calculating mode using Excel sheet:**

- Enter the range of numbers whose mode is to be found out in the Excel sheet.
- Suppose you want to find out the mode of numbers in the cell as,

A | |

1 | 10 |

2 | 7 |

3 | 8 |

4 | 7 |

5 | 78 |

- Select the range of cells and click on the sort tab to sort the numbers in ascending order or in descending order. Here, we sorted the numbers in ascending order. Place the formula in the cell where you want your mode to be calculated. You can also simply place the formula without sorting the numbers.

A | |

1 | 7 |

2 | 7 |

3 | 8 |

4 | 10 |

5 | 78 |

=Mode (A1: A5) |

You will get the result displayed in the last cell where you have placed the formula.

**Calculating mode online:**

You can also calculate mode of a given set of numbers using online calculators by copying the values in the data set into the online calculators.

Related Content: