Originally Posted by
MrShorty
Solving the linear interpolation equation is a common application of solving proportions or rational equations that you would have learned back in early secondary algebra. I believe there is value in reviewing those math principles you should already know:
(y-0)/(-0.113-(-2))=(1-0)/(2-(-2)) multiply by (-0.113-(-2)) to get y alone
y=1*(-0.113-(-2))/(2-(-2)) -- and there you go. If you have 1 in A1, -0.113 in say A2, -2 in A3, and 2 in A4, then your linear interpolation formula become =A1*(A2-A3)/(A4-A3)
Bookmarks