Extrapolation Formula

Formula of Extrapolation (Table of Contents)

• Formula
• Examples

What is Extrapolation Formula?

Extrapolation can be defined as a function that shall be used to forecast the dependent variable’s value for an independent variable which shall lie outside the range of the given set of data.

The Extrapolation Formula is represented as per below:

Explanation of the Linear Extrapolation Formula

The Extrapolation Formula in excel can be divided into the following steps:

• The data first needs to be analyzed whether the data is following the trend and whether the same can be forecasted.
• There should be two variables where one has to be a dependent variable and second has to be an independent variable.
• The numerator of the formula starts with the previous value of a dependent variable and then one needs to add back the fraction of independent variable as one does while computing for mean for class intervals.
• Finally, multiply the value arrived in step 3 by a difference of immediate given dependent values.
•  After adding step 4 to the value of the dependent variable will yield us the extrapolated value.

Examples of Extrapolation Formula (with Excel Template)

Let’s understand some simple to advanced examples of the extrapolation formula in a better manner.

Example #1

Suppose that the value of the certain variables is given below in the form of (X, Y):

• (4, 5)
• (5, 6)

Based on the above information, you are required to find the value of Y(6) using the extrapolation method.

Solution

Use the below-given data for calculation.

Calculation of Y(6) using extrapolation formula is as follows,

Extrapolation Formula Y(x) =  Y(1) + (x) – (x1) / (x2) – (x1) x {Y(2) – Y(1)}

Y(6) = 5 + 6 – 4 / 5 – 4 x (6 – 5)

Answer will be –

• Y3 =  7

Hence, the value for Y when the value of X is 6 will be 7.

Example #2

Mr. M and Mr. N are students of 5^th standard and they are currently analyzing the data given to them by their math teacher. The teacher has asked them to compute the weight of students whose height will be 5.90 and has informed that the below set of data follows linear extrapolation.

Assuming that this data follows a linear series, you are required to calculate the weight which would be dependent variable Y in this example when the independent variable x (height) is 5.90.

Solution

In this example, we now need to find out the value or in other words, we need to forecast the value of students whose height is 5.90 based on the trend given in the example. We can use below extrapolation formula in excel to calculate the weight which is a dependent variable for given height which is an independent variable

Calculation of Y(5.90) using extrapolation formula is as follows,

• Extrapolation Formula  Y(5.90) = Y(8) + (x) – (x8) /(x9) – (x8)   x [Y(9) – Y(8)]
• Y(5.90) = 59 + 5.90 – 5.70 / 5.80 – 5.70 x (62 – 59)

Answer will be –

• = 65

Hence, the value for Y when the value of X is 5.90 will be 65.

Example #3

Mr. W is executive director of the company ABC. He was concerned with the sales of the company being following a downward trend. He has asked his research department to produce a new product which shall follow increasing demand as and when the production increases. After a period of 2 years, they develop a product which faced increasing demand.

Below are the details of the last few months:

They observed that since this was a new product and cheap product and hence initially this would follow linear demand until a certain point.

Hence moving forward, they would first forecast the demand and then compare them with actual and produce accordingly as this has demanded huge cost for them.

The marketing manager wants to know what the units would be demanded if they produce 100 units. Based on the above information, you are required to compute the demand in units when they produce 100 units.

Solution

We can use below formula to calculate the demands in units which is the dependent variable for given units produce which is an independent variable.

Calculation of Y(100) using extrapolation formula is as follows,

• Extrapolation Formula Y(100) = Y(8) + (x)- (x8) / (x9) – (x8) x [ Y(9) – Y(8)]
• Y(100)   =  90 + 100 – 80 / 90 – 80 x (100 – 90)

Answer will be –

• = 110

 Hence, the value for Y when the value of X is 100 will be 110.

Relevance and Uses

Extrapolation is nothing but midway to make rough guesses or try to forecast the value that will be in the future or about certain situations which could be hypothetical and further that could be based on data that one would know already.

This is mostly used to forecast the data which is out of the current range of the data. In this case, one is assuming that the trend shall continue for given data and even outside that range which shall not be the case always and hence extrapolation should be used very cautiously and instead there is the better method to do the same is the use of interpolation method.

Recommended Articles

This has been a guide to the Extrapolation Formula. Here we discuss the formula to calculate the dependent variable’s value for an independent variable along with practical examples and downloadable excel template. You can learn more about economics from the following articles –

• Rolling Forecast | Merits
• Velocity of Money Formula
• Excel Trend Line
• TREND Excel Function 
• How to do Linear Regression in Excel?
• Formula of Multiple Regression