This worksheet help you to understand how to calculate Linear Interpolation. The unknown value which lies between the two known rates/ points can be calculated by linear interpolation.
The below formula is used to
(y-y0)/(x-x0)=(y1-y0)/(x1-x0)
Lets consider (x1,y1), (x3, y3) are two points to find the value of the point x2 or y2
Linear Interpolation Formulas to find unknown:
To find y2,
y2=(x2-x1)*(y3-y1)/(x3-x1)+y1
To find x2,
x2=(y2-y1)*(x3-x1)/(y3-y1)+x1
To findout the value of X2 we must know the value of y2; to find y2 we must know the value of x2
Linear Interpolation Example:
x1 =1 x2 =2 x3 = 3
y1 = 4 y2 = ? y3 = 6
The formula to find y2 is,
y2=(x2-x1)*(y3-y1)/(x3-x1)+y1
y2=(2 - 1)*(6 - 4)/(3 - 1) + 4
y2 = 2/2 + 4
y2 = 5
Hence the unknown point Value is 5
When you try such calculations on your own, this linear interpolation calculator can be used to verify your results.