Interpolate between specific values in a data set
7 views (last 30 days)
I am having trouble trying to figure out how to interpolate between specific y values for 2 given x values from excel.
For example in excel:
then given an X value of 3.5 from a matlab output I would like to find the corresponding Y value, in this case it would be 0.45. Then store that and use that in the future. I am not sure how to search for where 3.5 would sit within the X column and then find the surrounding values to do the interpolation.