EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Finance Finance Resources Finance Formula Midrange Formula
 

Midrange Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated July 29, 2023

Midrange Formula

 

 

Midrange Formula (Table of Contents)
  • Midrange Formula
  • Examples of Midrange Formula (With Excel Template)
  • Midrange Formula Calculator

Midrange Formula

Midrange in layman terms is the middle of any data set or the simply the average, mean of the data. A midrange is a statistical tool which is also known as the measure of center in statistics.

Along with the existence of the midrange formula means, medium, average, mode, and range are also known as the measure of central tendency. The midrange of the data set is simply the value between the biggest value and the lowest value. In order to find the midrange of the data set the value is then divided by 2 after summing the lowest value present in the data set with the highest value present in the data set.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Today, In this article we will try and understand the working and the logic behind the working of the Midrange formula. And the relevance and the use of it. However, it is recommended by some statistician that in order to find the midrange of the data set we need to present the data in ascending and descending order. Since we are finding the midrange of the data set and we are picking the lowest and the highest value of the data so it is not necessary to arrange the present data in ascending and the descending order.

A formula for Midrange is given by:

Midrange = (Maximum Value + Minimum Value) / 2

Examples of Midrange Formula (With Excel Template)

Let’s take an example to understand the calculation of Midrange formula in a better manner.

You can download this Midrange Template here – Midrange Template

Midrange Formula – Example #1

The daily temperature recorded in the city of Colombia Bogata is 55, 65, 67, 69, 70, 80, 81, 87, 90. We need to calculate the mid-temperature in Bogata during this period.

daily temperature recorded in the city

Solution:

Now we need to find the Midrange of the given function and how spread the data set is.

A Midrange of a given function can be calculated with the help of the following steps:-

Step 1: First, we need to find what is the maximum value in the data set. Maximum Value in the data set is calculated as

maximum value in the data set Example 1

Step 2: Then we need to find what is the minimum value in the data set. Minimum Value in the data set is calculated as

minimum value in the data set Example 1

Step 3: Midrange is calculated using the formula given below

Midrange = (Maximum Value + Minimum Value) / 2

Calculation of Midrange for example 1

  • Midrange = (90 + 55) / 2
  • Midrange = 145 / 2
  • Midrange = 72.5

Midrange Formula – Example #2

The test scores of Mr. Nadal recorded in the state government entrance exam of Uttar Pradesh are 28, 33, 34, 35, 42, 40, 41, 44, 45. We need to calculate the midrange value.

Entrance exam of Uttar Pradesh

Solution:

Now we need to find the Midrange of the given function and how spread the data set is.

A Midrange of a given function can be calculated with the help of the following steps:-

Step 1: First, we need to find what is the maximum value in the data set. Maximum Value in the data set is calculated as

maximum value in the data set for example 2

Step 2: Then we need to find what is the minimum value in the data set. Minimum Value in the data set is calculated as

minimum value in the data set for example 2

Step 3: Midrange is calculated using the formula given below

Midrange = (Maximum Value + Minimum Value) / 2

Calculation of Midrange for example 2

  • Midrange = (45 + 27.5) / 2
  • Midrange = 72.5
  • Midrange = 36.25

Midrange Formula – Example #3

Here is the data set with numbers 33, 39, 40, 41, 42, 48, 49, 52, 54. We need to calculate the midrange.

Data set Value

Solution:

Now we need to find the Midrange of the given function and how spread the data set is.

A Midrange of a given function can be calculated with the help of the following steps:-

Step 1: First, we need to find what is the maximum value in the data set. Maximum Value in the data set is calculated as

maximum value in the data set for example 3

Step 2: Then we need to find what is the minimum value in the data set. Minimum Value in the data set is calculated as

minimum value in the data set for example 3

Step 3: Midrange is calculated using the formula given below

Midrange = (Maximum Value + Minimum Value) / 2

calculation of Midrange for example 3

  • Midrange = (54 + 33) / 2
  • Midrange = 87 / 2
  • Midrange = 43.5

Explanation

The formula for Midrange basically the average of the data set. The Midrange is being computed as the average of the maximum and the minimum values present in the data sample corresponds to the measure of central tendency.

The midrange Formula can be computed as –

Midrange = (Maximum Value + Minimum Value) / 2

Relevance and Uses of Midrange Formula

  • The midrange formula of statistics is of great help when the user needs to find the midpoint of a large data set and it also provides as an alternative calculation for the measure of central tendency.
  • It also tells us about the maximum and the minimum range of the data set and where most of the data lie in a particular array. It is also useful it finding averages of various data sets. However, Mean is the most popular statistical formula which is used most in the industry.
  • The mid-range also lacks robustness, as outliers change it significantly. Indeed, it is one of the least efficient and least robust statistics.

Midrange Formula Calculator

You can use the following Midrange Calculator

Maximum Value
Minimum Value
Midrange Formula =
 

Midrange Formula =
Maximum Value + Minimum Value
=
2
0 + 0
= 0
2

Recommended Articles

This has been a guide to Midrange Formula. Here we discuss how to calculate Midrange along with practical examples. We also provide Midrange calculator with downloadable excel template. You may also look at the following articles to learn more –

  1. Formula for Debtor Days
  2. How to Calculate Equity Value?
  3. Guide to Solvency Ratio Formula
  4. Calculation of Interest Expense Formula

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Midrange Template

EDUCBA Login

Forgot Password?

EDUCBA

डाउनलोड Midrange Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW