WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Midrange Formula

Midrange Formula

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

By Madhuri Thakur

Formula to Calculate Midrange of a Number

Midrange formula is used in order to calculate the middle value of the two number given and according to the formula the given two number are added and the resultant is divided by the 2 in order to get the midpoint value of the two.

The midrange can be defined as the middle point of a range of numbers. The mid-range of a series of the number will be the average of the highest number and the lowest number of that series. If a series of number has 10 observations and the highest point of that observation is 250, and the lowest point is 50. Then the range for that observation will be from 50 to 250.

Midrange = (Highest Value+ Lowest Value)/2

Midrange Formula

Examples

You can download this Midrange Formula Excel Template here – Midrange Formula Excel Template

Example #1

Let us try to find out how to calculate the midrange with the help of an example. Let us try to analyze the height of a class of 8 students in centimeters. Suppose the heights of each student in the class are 124, 130, 115, 118, 110, 135, 145, and 117. In order to calculate this for the whole population, we need to find out the highest value and the lowest value of the observed values.

Solution:

Use the following data for the calculation

Midrange Formula Example 1

The highest value of the observed heights will be-

Midrange Formula Example 1.2

Highest Value = 145

The lowest value of the observed heights will be-

Example 1.3

Lowest Value=110

So, the calculation of midrange can be done as follows-

Example 1.4

= (145+110)/2

Midrange Formula Example 1.5

The example shows that the midrange for the observed value is 127.5 centimeters.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example #2

Let us try to find out how to calculate the midrange with the help of another example. Let us try to analyze the weight of a class of 8 students in kilograms. Suppose the weights of each student in the class are 45, 49, 54, 60, 42, 65, 56, and 59. In order to calculate this for the whole population, we need to find out the highest value and the lowest value of the observed values.

Solution:

Use the following data for the calculation of the midrange.

Midrange Formula Example 2

The highest value of the observed weights will be-

Midrange Formula Example 2.1

Highest Value =65

The lowest value of the observed weights will be-

Example 2.2

Lowest Value = 42

So, the calculation of midrange can be done as follows-

Example 2.3

= (65+42)/2

Midrange Formula Example 2.4

The example shows that the midrange for the observed value is 53.5 kilograms.

Example #3

Let us try to find out how to calculate the midrange with the help of another example. Let us try to analyze the price of a series of Samsung phones sold in a store. Suppose the price of a range of Samsung phones are $160, $168, $185, $195, $115, $186, $125 and $150. In order to calculate this for the whole population, we need to find out the highest value and the lowest value of the observed values.

Solution:

Use the following data for the calculation of the midrange.

Midrange Formula Example 3

The highest value of the observed prices will be-

Midrange Formula Example 3.1

Highest Value =195

The lowest value of the observed prices will be-

Example 3.2

Lowest Value =115

So, the calculation can be done as follows-

Example 3.3

= (195+115)/2

Midrange Formula Example 3.4

Relevance and Use of Midrange Formula

The midrange formula is relevant in practical life. Like the mobile example we discussed above, a company has a range of phones with various price points at any given point of time. So with the help of finding out the mid-range of the series of phones, one can make out whether the particular model of the phone he is looking for is above the average price or below the average price. If we find out midrange of the weights of a class of students, then by having that, we can make a guess whether a particular student is overweight or underweight in that class.

Recommended Articles

This has been a guide to Midrange Formula. Here we learn how to calculate the middle value of two given numbers along with practical examples and a downloadable excel template. You can learn more about excel modeling from the following articles –

  • What is Harmonic Mean?
  • Formula of Weighted Mean 
  • Percentile Rank Calculation 
  • P Value Formula Calculation
  • Annualized Rate of Return Formula
7 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Category iconExcel Modeling,  Financial Modeling Tutorials

Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

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

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

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

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Midrange Formula Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More