Financial Modeling Tutorials
- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- 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
- Internal Rate of Return (IRR)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- 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
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Mortgage APR vs Interest Rate
- Regression Formula
- Correlation Coefficient Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- Regression vs ANOVA
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,
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.
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.
The formula for range = maximum value – minimum value
- Maximum value = 9
- Minimum value = 2
Range = 9 – 2
Range = 7
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?
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.
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.
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.
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 –