How can i find a value?
1 view (last 30 days)
Show older comments
I have a x-y table that i insert from excel file The x has values that goes like 5m 10m.... 3000m And u want to find the y of a x value that it is not in the excel for example i want to find the y value of x=6m I have to make a line throught the closest point with 6( 5 and 10) then find the y=ax +b and then find the y value of 6 The program must does this procedure for any x value ( ps: the line y=ax+b between the closest points) Thankyou very much
0 Comments
Answers (1)
Ameer Hamza
on 30 Oct 2020
x; % x-values from excel file
y; % y-values from excel file
xq = 6; % point at which you want to find y
yq = interp1(x, y, xq); % value of y
2 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!