How to Calculate the Midrange in Excel?
MS Excel is a spreadsheet developed by the company Microsoft. Excel provides various kinds of functions and we can insert the data in form of rows and columns and perform operations on the data and yield the results we desired.
The Midrange of the dataset in other terms can be specified as average or mean. the Midrange is also known as the measure of center in statistics.
Attention reader! Don’t stop learning now. If you are an Excel beginner (or an intermediate) and want to learn Excel, Geeksforgeeks brings the perfect course for you to start, Diving Into Excel
Midrange of any dataset can be calculated as follows: (largest value + smallest value) / 2
In order to calculate using formulas of excel we follow 3 steps:
- Calculate Min value
- Calculate Max value
- Apply midrange formula
Consider the following data i.e. marks obtained by students of a class
To find the midrange of the given data we will follow the 3 steps
Step 1:Calculate the min value of the data by using the min function
Step 2:Calculate the max value of the data by using the max function
Step 3:Now apply the midrange formula
Finally, we get the midrange of the data as 70.
- The midrange deviates hugely when there are outliers in our data
- We need to find first the maximum and minimum value to the data in order to find the midrange
- The midrange sometimes differs from mean and median hugely.
For example in our data, consider another field with the value of 1000 then the midrange will be 520.5 which is far away from the original midrange of 70. So this shows how large the midrange deviates from the outliers.
Instead of finding the midrange, we can directly calculate the mean, median of the data which points to the average or the midpoint of the data
Mean: It is the average value of the data set. It is calculated by the formula
Mean = Sum of all the observations/Total number of Observations
In excel we can directly compute the mean by using the average function.
Median: It is the middle value of the dataset. We need to first arrange the dataset in either non-increasing or non-decreasing order and select the middlemost element. In case there are two middlemost elements we compute the average of two.
In excel we can compute it by using the median function
This image gives the mean, median and midrange of the dataset.