Man, you're a life saver. I'm working with people from JP Morgan and they used this Interpolation to determine interest rates. I tried to do this what you explained and I got the same values as they did. Thanks again!
Hello, I am a naval architecture and marine engineering student and this video has saved me such a big time and energy i cant show you how greatfull i am. Thank you :)
This may be a silly question, but is it possible to linearly interpolate negative values as well? I'm just beginning to learn this now on my own for a research project and so am not super familiar with this process
Good day sir. I follow your formula and its work. But how about if i have a(11.798,15.055) , b(18.326,22.639), c(24.848,30.229). I have also known d(18.666,16.059). Now i want to know the foot perpindicular to the line w/c AB using your formula but the outcome is not match..can you help me sir.thanks
I was with you until 8:13, How did you move the formula without manually changing the rows? I thought you might be cutting and pasting but I got lost here.
Jason, at 8:13, I copied the formula for the Yupper and then manually dragged the cell references from the Y to the X column (twice) and to the Xlower cell rather than the Ylower (D16 to B16). I hope that answers your question.
F4 is one of the function keys (www.rd.com/article/computer-f-keys/). Maybe not all keyboards have function keys though (particularly outside the USA)?
There are some errors. It should be as shown below: For Xupper:=INDEX($A$5:$A$25,MATCH(K5,A$5:$A$25)+1) For Yupper: =INDEX($B$5:$B$25,MATCH(M5,$B$5:$B$25,-1)+1) For your information.
People who are watching this video, know the meaning of interpolation. They just came here to know the excel trick. So, don't elongate the video unnecessary by talking about the details of interpolation. Just stick to the point and come directly to the excel function that is required. 10 minutes for this simple trick is useless.
Man, you're a life saver.
I'm working with people from JP Morgan and they used this Interpolation to determine interest rates.
I tried to do this what you explained and I got the same values as they did.
Thanks again!
Saved my time and energy. Far better videos than others for linear interpolation.
Hello, I am a naval architecture and marine engineering student and this video has saved me such a big time and energy i cant show you how greatfull i am. Thank you :)
Thank you. Thank you. Thank you! Concise, clear, and so so so helpful!
Thank you so much. It's works very well.
Bundle of thanks sir. It was really helpful.
great video! Saved me lots of time!!!!!!
so clear and direct ,
Thank you
This is the most wonderful video i have ever watched on youtube. You just made my modeling so easy
Thank you so much sir. that was very easy to do interpolation.
I don't know why i didnt get the same result in match function, but i tried xmatch then it works. Thanks!
thank you, this was very useful
Well done, thanks!
Thank you sooooooooooo much
Great job. Thanks
valuable information. Thank you appreciated
thank you so much
This may be a silly question, but is it possible to linearly interpolate negative values as well? I'm just beginning to learn this now on my own for a research project and so am not super familiar with this process
Good video sir, Thank you
Thank's man!
Thanks
I need to know how to deal with double interpretation
Love it.
Thank you!
Hello, As my 1st Y value is zero, I am not able to get Yupper value with the formula used
What's wrong with Forecast.Linear?
Good day sir. I follow your formula and its work. But how about if i have a(11.798,15.055) , b(18.326,22.639), c(24.848,30.229). I have also known d(18.666,16.059). Now i want to know the foot perpindicular to the line w/c AB using your formula but the outcome is not match..can you help me sir.thanks
I was with you until 8:13, How did you move the formula without manually changing the rows? I thought you might be cutting and pasting but I got lost here.
Jason, at 8:13, I copied the formula for the Yupper and then manually dragged the cell references from the Y to the X column (twice) and to the Xlower cell rather than the Ylower (D16 to B16). I hope that answers your question.
@@davidlampert5804 i cannot do it
Probably F4 button is under function mode like volume or brightness of a screen. Try to push fn+F4 and see how it works
❤
I wanna know what the f4 button is
F4 is one of the function keys (www.rd.com/article/computer-f-keys/). Maybe not all keyboards have function keys though (particularly outside the USA)?
There are some errors. It should be as shown below:
For Xupper:=INDEX($A$5:$A$25,MATCH(K5,A$5:$A$25)+1)
For Yupper: =INDEX($B$5:$B$25,MATCH(M5,$B$5:$B$25,-1)+1)
For your information.
OMG i'll just calculate it by hand
excel function: FORECAST.LINEAR
Ninjago
People who are watching this video, know the meaning of interpolation. They just came here to know the excel trick. So, don't elongate the video unnecessary by talking about the details of interpolation. Just stick to the point and come directly to the excel function that is required. 10 minutes for this simple trick is useless.