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

**Range Formula – Table of Contents**

## What is the Range Formula?

The range can be calculated as the difference or variance between the maximum value and the minimum value of a given sample or the given data set, and which serves as 1 of 2 important features of a given sample or given data set. Mathematically, Range Formula is represented as,

**Range Formula = the maximum value – the minimum value**

Of the given dataset, which provides statisticians and the mathematician with a better understanding of the data set how varied it is. It is the simplest approach to calculate variance in statistics.

### Explanation of the Range Formula

The formula for Range is quite simple and easy to use as the formula states its Maximum value less minimum value of the given sample. Therefore, the variance between Maximum value and the minimum value is the Range and even though that is simple to use and understand it requires to interpret properly.

For example, if there is outliner in the data the range would get influenced by same and would get the result will lead to misrepresentation. Take a practical example for given data 2, 4, 7, 7, 100 then the range would be 100 – 2 which is 98 but as one can see that the data range lies below 10 but considering and interpreting that data is within 98 will lead to misrepresentation. Hence interpretation of Range should be conducted with due consideration.

**Examples of Range Formula (with Excel Template)**

Let’s see some simple to advanced examples of range formula in excel to understand it better.

#### Example#1

**Consider following given dataset 2,2,4,4, 4, 6,7,7,8, 8, 8, 9 ,9, 9, 9, 9. Using the range formula as discussed above, you are required to calculate the Range for this sample.**

4.9 (927 ratings)

**Solution:**

The formula for range = maximum value – minimum value

- Maximum value = 9
- Minimum value = 2

Range = 9 – 2

Range = **7**

#### Example#2

**Mr. Stark, a scientist who is working for 10 years with a company called Dream moon. Mr. Arora his supervisor is conducting an experiment on human health and has collected few sample data of male height which are 162, 158, 189, 144, 151, 150, 151, 178, 155, 160, he is perplexed now and wants to know how much data is varied. Mr. Stark who is an experienced statistician has been approached by his supervisor Mr. Arora to remove his confusion as to about variation of the formula. Mr. Arora uses Range formula and is required to provide an answer to his supervisor, you are required to calculate how much is the data varied?**

**Solution:**

The formula for range = maximum value – minimum value

- Maximum value = 189
- Minimum value = 144

Range = 189 – 144

Range = **45**

The data or the sample collected has a variation of 45.

#### Example#3

**Mr. Buffet a well-known and an esteemed investor around the world are now considering US market stock and is in the process of analyzing a few of them where he wants to invest in. The list includes major blue-chip companies of the US.**** Below are the given shortlisted stock or securities along with their latest stock market price which is denoted in US$, where he is considering for investing in.**

You are required to calculate Range and come up the variation the list has.

**Solution:**

Below is given data for calculation of the range formula in excel.

Using the above information, the calculation of Max Value in excel will be as follows,

Max Value = 204.66

Calculation of Min Value in excel as follows,

Min Value = 45.93

Therefore, calculation of range is as follows,

Range = 204.66 – 45.93

**Range will be –**

Range = 158.73

### Relevance and Uses

The range in its own way is a very easy and very basic to understand of how the numbers in the given data set or given sample are spread out because as stated earlier it is relatively easy to do calculation as there is the only required of a very basic arithmetic operation which is just subtracting the minimum from the maximum value, but the range formula it has few more applications for a given data set or a given sample in statistics. The range is also useful in estimating another measure of spread which is called variance or the standard deviation.

The range as mentioned earlier can only inform about the basic details i.e. where the spread of a given sample or given set of data will lie. By giving the difference or say the variance between the highest and the lowest values of a given sample or given dataset it gives one an information or a rough idea about the major extreme observations as to how widely spread-out those are, but again it gives no hint or any information as about the other data points that where they would lie, which is the main weakness of using the range formula.

The range as discussed above is useful for depicting the spread within a given sample or a given dataset and further is also used for comparing the resultant spread between the same given sample or same given datasets.

### Recommended Articles

This has been a guide to Range Formula. Here we discuss how to calculate the range using its formula along with excel examples and downloadable excel template. You can learn more about financing from the following articles –

- Standard Deviation Formula | Explanation
- Examples of Standard Deviation Formula in Excel
- Sample Standard Deviation Formula | Examples | Explanation
- Relative Standard Deviation Formula | Examples | Explanation
- Using Max IF in Excel
- Use VBA Range
- How to use Dynamic Named Range in Excel
- Use Mode in Excel

- 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