How to calculate the mode, mean and median in Excel

The mode, mean and median They are useful mathematical concepts because they allow you to analyze and summarize data sets effectively. Calculating these values ​​helps you better understand the characteristics and trends of the data.

They can be calculated manually, which can be tedious and susceptible to errors. However, in this article you will learn how to do these calculations in Excel simply and quickly.

How to calculate the mode in Excel

The mode is the value that occurs most frequently in a data set. In other words, the number or element that is most repeated within that set.

To calculate the mode in Excel, you just have to follow these simple steps:

-Open an Excel document.

-Create your list of numbers or values ​​that you are going to work with.

-In another cell, write the formula “=MODE(all data)”, selecting all that data within the parentheses.

fashion photo in excel

-To select the data, you can drag it with the mouse to take the entire range or you type the first cell of the range, followed by the colon sign “:” and the last cell.

-Next, the program will perform the calculation automatically.

Another way to do this is by using the formula icon.

-You just have to click on the formula icon, write “Fashion”, press where it says “Go”, then click on “Fashion” and “Accept”.

photo of the fashion function in excel

-You choose the data list and Excel will do the corresponding calculation.

How to calculate the mean in Excel

The mean is the average of a set of numbers. This is calculated by adding all the values ​​and then dividing that sum by the number of values.

If you need to do this calculation in Excel, follow this step by step:

-Open an Excel document.

-Create your list of values ​​from which you will average.

-In another cell, type “=AVERAGE(the data to be used for the calculation)” and press “ENTER”. Within the parentheses, you must add all the data that will be taken into account to perform the calculation.

photo of how to calculate average

-And that’s it, you’ll have the stocking.

Another method of doing this is by using the formula icon in the program as the first example. To do this, click on the formula icon, type “Average” to find the function.

-Then click “Go”, choose “Average” and then “OK”.

average photo in excel book

-You will see another screen to select the data with the mouse, you accept and, in this way, you will obtain the calculation without having to write the formula.

How to calculate the median in Excel

The median is the value found in the middle of a set of ordered numbers. If the set has an odd number of values, the median is the middle number. On the other hand, if it has an even number of values, the median would be the average of the two central numbers.

To calculate it in Excel quickly and easily, do the following:

-Open an Excel document.

-Create your list of values ​​that you need to calculate.

-In another cell, write the formula «=MEDIAN(all data)» and press «ENTER». Inside the parentheses, you have to select all the values ​​with which you are going to work.

photo of the median in excel

-Later, you will have the result.

In this case, you also have the option to search for the function directly in the formulas icon.

-You must click on the formulas icon, write “Median”, then click on “Go”.

photo of the median in formula

Next you choose “Median”, press “Accept” and select the data so that the system does the mathematical calculation in a matter of seconds.

Click to rate this entry!
(Votes: 0 Average: 0)

Leave a Comment