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

**Quartile Deviation (Table of Contents)**

## What is Quartile Deviation?

When one takes half of the difference or variance between the 3^{rd} quartile and the 1^{st} quartile of a simple distribution or frequency distribution is the quartile deviation.

### Quartile Deviation Formula

A Quartile Deviation (Q.D.) formula is used in statistics to measure spread or in other words to measure dispersion. This can also be called a Semi Inter-Quartile Range.

**Q.D. = Q3 – Q1 / 2**

- The formula includes Q3 and Q1 in the calculation which is top 25% and lowers 25% data respectively and when the difference is taken between these two and when this number is halved then it gives measures of spread or dispersion.
- So, to calculate Quartile deviation, you need to first find out Q1 then the second step is to find Q3 and then take a difference of both and the final step is to divide by 2.
- This is one of the best methods of dispersion for open-ended data.

### Examples of Quartile Deviation (with Excel Template)

#### Example #1

**Consider a data set of following numbers: 22, 12, 14, 7, 18, 16, 11, 15, 12. You are required to calculate the Quartile Deviation.**

**Solution:**

First, we need to arrange data in ascending order to find Q3 and Q1 and avoid any duplicates.

7, 11, 12, 13, 14, 15, 16, 18, 22

Calculation of Q1 can be done as follows,

Q1 = ¼ (9 + 1)

=¼ (10)

**Q1**=**2.5 Term**

Calculation of Q3 can be done as follows,

Q3=¾ (9 + 1)

=¾ (10)

** Q3**= **7.5 Term**

Calculation of quartile deviation can be done as follows,

- Q1 is average of 2
^{nd}which is11 and add the product of the difference between 3^{rd}& 4^{th}and 0.5 which is (12-11)*0.5 = 11.50. - Q3 is 7
^{th}term and product of 0.5 and the difference between 8^{th}and 7^{th}term which is (18-16)*0.5 and result is 16 + 1 = 17.

**Q.D. = Q3 – Q1 / 2**

Using quartile deviation formula , we have (17-11.50) / 2

=5.5/2

**Q.D.**=**2.75.**

#### Example #2

**Harry ltd. is a textile manufacturer and is working upon a reward structure. The management is in discussion to start a new initiative, but they first want to know how much their production spread is.**

**The management has collected their average daily production data for last 10 days per (average) employee.**

**155, 169, 188, 150, 177, 145, 140, 190, 175, 156.**

4.9 (927 ratings)

**Use the Quartile Deviation formula to help management find dispersion.**

**Solution:**

The number of observations here is 10 and our first step would be to arrange data n ascending order.

140, 145, 150, 155, 156, 169, 175, 177, 188, 190

Calculation of Q1 can be done as follows,

Q1= ¼ (n+1)th term

=¼ (10+1)

=¼ (11)

**Q1**= **2.75 ^{th} Term**

Calculation of Q3 can be done as follows,

Q3= ¾ (n+1)th term

=¾ (11)

** Q3**= **8.25 Term**

Calculation of quartile deviation can be done as follows,

- 2
^{nd}term is 145 and now adding to this 0.75 * (150 – 145) which is 3.75 and the result is 148.75 - 8
^{th}term is 177 and now adding to this 0.25 * (188 – 177) which is 2.75 and the result is 179.75

**Q.D. = Q3 – Q1 / 2**

Using the quartile deviation formula, we have (179.75-148.75) / 2

=31/2

**Q.D.**=**15.50.**

#### Example #3

**Ryan international academy wants to analyze how much percentage scores marks of their students are spread out.**

**The data is for the 25 students.**

**Use the Quartile Deviation formula find out the dispersion in % marks.**

**Solution:**

The number of observations here is 25 and our first step would be arranging data in ascending order.

Calculation of Q1 can be done as follows,

Q1= ¼ (n+1)th term

=¼ (25+1)

=¼ (26)

**Q1**= **6.5 ^{th} Term**

Calculation of Q3 can be done as follows,

Q3=¾ (n+1)th term

=¾ (26)

** Q3** = **19.50 Term**

Calculation of quartile deviation or semi inter-quartile range can be done as follows,

- 6
^{th}term is 154 and now adding to this 0.50 * (156 – 154) which is 1 and the result is 155.00 - 19
^{th}term is 177 and now adding to this 0.50 * (177 – 177) which is 0 and the result is 177

**Q.D. = Q3 – Q1 / 2**

Using the quartile deviation formula, we have (177-155) / 2

=22/2

**Q.D.**= **11.**

#### Example #4

**Let us now determine the value through an excel template for Practical example I.**

**Solution:**

Use the following data for the calculation of quartile deviation.

Calculation of Q1 can be done as follows,

**Q1**=**148.75**

Calculation of Q3 can be done as follows,

**Q3**= **179.75**

Calculation of quartile deviation can be done as follows,

Using the quartile deviation formula, we have (179.75-148.75 )/ 2

Q.D. will be –

**QD** = **15.50**

### Relevance and Uses

Quartile deviation which is also renowned as a semi inter-quartile range. Again, the difference or the variance between the 3^{rd} and 1^{st} quartiles is termed as the interquartile range. The interquartile range depicts the extent to which the observations or the values of the given dataset are spread out from the mean or their average. The Quartile deviation or semi inter-quartile range is majority used in a case where one wants to learn or say study about the dispersion of the observations or the samples of the given data sets that lie in the main or middle body of the given series. This case would usually happen in a distribution where the data or the observations tends to lie intensely in the main body or middle of the given set of data or the series and the distribution or the values do not lie towards the extremes and if they lie then they are not of much significance for the calculation.

You can download this Quartile Deviation Formula Excel Template from here – Quartile Deviation Formula Excel Template

### Recommended Articles

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

- Quartile Formula
- Calculate Portfolio Standard Deviation
- Calculate Standard Deviation in Excel
- Calculate Relative Standard Deviation

- 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