Financial Modeling Tutorials

- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Profitability Index
- Cash Burn Rate
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- F-Test Formula
- Quantitative Research

Related Courses

**Formula for Midrange (Table of Contents)**

## What is Midrange Formula?

Midrange can be defined as the middle point of a range of number. 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.

The formula to calculate the midrange is

**Midrange Formula = (Highest Value+ Lowest Value)/2**

### Examples of Midrange Formula (with Excel Template)

Let’s see some simple to advanced examples of midrange formula to understand it better.

#### 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

The highest value of the observed heights will be-

Highest Value = 145

The lowest value of the observed heights will be-

Lowest Value=110

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

4.9 (927 ratings)

= (145+110)/2

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

#### 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 midrange.

The highest value of the observed weights will be-

Highest Value =65

The lowest value of the observed weights will be-

Lowest Value = 42

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

= (65+42)/2

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 midrange.

The highest value of the observed prices will be-

Highest Value =195

The lowest value of the observed prices will be-

Lowest Value =115

So, the calculation can be done as follows-

= (195+115)/2

### Relevance and Use

The midrange formula is relevant in practical life. Like the mobile example, we discussed above, a company has a range of phones with varies 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 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.

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

### Recommended Articles

This has been a guide to Midrange Formula. Here we discuss how to calculate midrange in excel with practical examples and downloadable excel template. You can learn more about excel modeling from the following articles –

- Harmonic Mean Calculation & Formula
- Weighted Mean Calculation & Formula
- Percentile Rank Calculation & Formula
- P Value Formula & Calculation

- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion

- Basic Microsoft Excel Training
- MS Excel 2010 Training Course: Advanced
- Microsoft Excel Basic Training
- Microsoft Excel 2013 – Advanced
- Microsoft Excel 2016 – Beginners
- Microsoft Excel 2016 – Advanced

## Leave a Reply