WallStreetMojo

WallStreetMojo

WallStreetMojo

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

Interpolation

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

What is Interpolation?

Interpolation can be described as the mathematical procedure applied in order to derive value in between two points having a prescribed value. In simple words, we can describe it as a process of approximating the value of a given function at a given set of discrete points. It can be applied in estimating varied concepts of cost, mathematics, statistics, etc.

Interpolation can be said as the method of determining the unknown value for any given set of functions with known values. The unknown value is found out. If the given sets of values work on a linear trend, then we can apply linear Interpolation in excel to determine the unknown value from the two known points.

Interpolation Formula

The formula is as follows: –

Interpolation Formula

As we have learned in the definition stated above, it helps to ascertain a value based on other sets of value, in the above formula: –

  • X and Y are unknown figures which will be ascertained on the basis of other values given.
  • Y1, Y2, X1, and X2 are given sets of variables that will help in determining unknown value.

For example, A farmer engaged in farming of mango trees observes and collects the following data regarding the height of the tree on particular days shown as follows: –

Interpolation Explanation

Based on the given set of data, farmers can estimate the height of trees for any number of days until the tree reaches its normal height. Based on the above data, the farmer wants to know the height of the tree on the 7th day.

He can find it out by interpolating the above values. The height of the tree on the 7th day will 70 MM.

Popular Course in this category
Sale
Financial Modeling Course (with 15+ Projects)
4.9 (927 ratings)
16 Courses | 15+ Projects | 90+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Interpolation-Formula

Examples of Interpolation

Now, let us understand the concept with the help of some simple and practical examples.

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

Example #1

Calculate the unknown value using the interpolation formula from the given set of data. Calculate the value of Y when X value is 60.

Interpolation Formula - Example 1.1

Solution:

The value of Y can be derived when X is 60 with the help of Interpolation as follows: –

Here X is 60, Y needs to be determined. Also,

Interpolation Formula - Example 1.2

So, the Calculation of Interpolation will be –

Interpolation Formula - Example 1.3

  • Y= Y1 + (Y2-Y1)/(X2-X1) * (X-X1)
  • =80 + (120-80)/(70-50) * (60-50)
  • =80 + 40/20 *10
  • = 80+ 2*10
  • =80+20

Interpolation Formula - Example 1.4

  • Y = 100

Example #2

Mr. Harry shares details of Sales and profits. He is eager to know the profits of his business when the sales figure reaches $75,00,000. You are required to calculate profits based on the given data:

Interpolation Formula - Example 2.1

Solution:

Based on the above data, we can estimate the profits of Mr. Harry using the interpolation formula as follows:

Here

Interpolation Formula - Example 2.2

So, the Calculation of Interpolation will be –

2.3 - Calculation of Y

  • Y= Y1 + (Y2-Y1)/(X2-X1) * (X-X1)
  • = $ 5,00,000 + ($6,00,000 – $5,00,000)/($50,00,000 – $40,00,000) * ($75,00,000 – $40,00,000)
  • = $ 5,00,000 + $1,00,000 / $10,00,000 * $ 35,00,000
  • = $5,00,000 + $ 3,50,000

2.4 - Value of Y

  • Y = $8,50,000

Example #3

Mr. Lark shares details of production and costs. In this era of global recession fears, Mr. Lark is also having a fear of decreasing the demands of his product and eager to know the optimum production level to cover the total cost of his business. You are required to calculate the optimum quantity level of production based on the given data. Lark wants to determine the quantity of production required to cover the estimated cost of $90,00,000.

3.1 - Sample Data

Solution:

Based on the above data, we can estimate the quantity required to cover the cost of $90,00,00 using interpolation formula as follows:

Here,

Example 3.2

Y= Y1 + (Y2-Y1)/(X2-X1) * (X-X1)

To get the quantity of production required we have modified the above formula as follows

X = (Y – Y1) /[(Y2-Y1)/(X2-X1)] + X1

Quantity of Production (X)

  • X =(9,000,000 – 5,500,000) /[(6,000,000 – 5,500,000) / (500,000 – 400,000)] + 400,000
  • = 3,500,000 /(5,00,000/1,00,000) + 400,000
  • = 3,500,000 /5 + 400,000
  • = 7,00,000 + 400,000
  • = 11,00,000 Units

Interpolation Calculator

You can use the following calculator.

X
X1
X2
Y1
Y2
Interpolation Formula
 

Interpolation Formula = Y1 + (Y2 - Y1)/(X2 - X1) * (X - X1)
0 + (0 - 0)/(0 - 0) * (0 - 0) = 0

Relevance And Use

In the era where data analysis plays an important role in each and every business, an organization can make varied use of interpolation to estimate different values from the known set of values. Mentioned below are some of the relevance and uses of interpolation.

  • Interpolation can be used by data scientists to analyze and derive meaningful results from a given set of raw values.
  • It can be applied by an organization to determine any financial information which is based on a given set of function like the cost of goods sold; profits earned, etc.
  • Interpolation is being used in numerous statistical operations to derive meaningful information.
  • This is being used by scientists to determine possible results out of numerous estimates.
  • This concept can also be used by a photographer to determine useful information out of raw collected data.

Recommended Articles

This has been a guide Interpolation and its definition. Here we discuss the formula for the calculation of Interpolation along with examples and downloadable excel sheets. You may also have a look at the following articles –

  • How to do Interpolation in Excel?
  • Formula of Extrapolation
  • How to do Forecast in Excel
  • Non-Linear Excel Regression
0 Shares
Share
Tweet
Share
Financial Modeling Course (with 15+ Projects)
  • 16 Courses
  • 15+ Projects
  • 90+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
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 Interpolation Formula Excel Template

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