How To Find Mean

Finding the mean is a basic statistical method that is used to calculate the average of a given set of data. It is a commonly used method in various fields such as mathematics, science, finance, and many more. In this article, we will discuss how to find mean in a simple and easy way.

What is Mean?

Mean is a mathematical measure of central tendency, which refers to the average of a set of numbers. It is calculated by adding all the values in a dataset and dividing the sum by the total number of values. The mean is used to determine the typical value or average value of the data, which can be helpful in making comparisons or drawing conclusions.

How to Calculate Mean?

To calculate the mean, first, you need to add up all the values in the dataset. Then divide the sum by the number of values in the dataset. The formula for finding the mean is as follows:

Mean = (Sum of all values) / (Number of values)

Example of Finding Mean

Let’s take an example to understand the concept of finding the mean better. Suppose we have a dataset of the following numbers: 4, 8, 12, 16, 20. To find the mean, we first add up all the values, which gives us a sum of 60. Then, we divide 60 by the total number of values, which is 5. The resulting value is 12. Therefore, the mean of the given dataset is 12.

Finding Mean in Excel

Microsoft Excel provides a built-in function to calculate the mean of a given set of data. To find the mean in Excel, you can use the AVERAGE function. The AVERAGE function takes a range of cells as input and calculates the average value of those cells.

To find the mean using the AVERAGE function in Excel, follow these steps:

  1. Select the cells containing the data that you want to find the mean of.
  2. Click on the “Formulas” tab in the Excel ribbon.
  3. In the “Function Library” group, click on “Statistical” and select “AVERAGE” from the list.
  4. The AVERAGE function will appear in the formula bar. Press enter to calculate the mean.

When to Use Mean?

Mean is used to represent the typical value of a dataset when the data is normally distributed. In other words, when the data is distributed evenly around the mean, the mean can be used to represent the average value of the data.

Mean is also useful when comparing two or more sets of data. By comparing the means of different datasets, you can determine which one is higher or lower and draw conclusions based on that.


In conclusion, finding the mean is a simple statistical method that can be helpful in various fields. By knowing how to find the mean, you can calculate the average value of a given set of data and use it to draw conclusions or make comparisons. Whether you are a student, a researcher, or a professional, understanding how to find the mean can be beneficial in many ways.

Leave a Comment