Sensor Data for look up table

Hi, i have some data, in excell in 3 columns the first two columns being independant and the third the dependant, or the result.

Im trying to get the data into a look up table to aproxamate the result for any input. im not having much sucess.

Thanks for any help

[Rik]

The first step is to load the content of the excel file as a variable. Did you do that already?

What do you think the next step is? What did you try?

[stephen collier]

yes i can load the data, inported as vectors and into a 2D lookup,

[stephen collier]

I also ran it through a surface fit and got the 1*1sfit ans . but i dont know how to use the data

Answer 1

[KSSV]

T = readtable('look21 (1).xlsx')
x = T.x ;
y = T.y ;
z = T.z ; 

xi = linspace(min(x),max(x)) ;
yi = linspace(min(y),max(y)) ;
[X,Y] = meshgrid(xi,yi) ;
F = scatteredInterpolant(x,y,z,'nearest','none') ;

Z = F(X,Y) ; 
surf(X,Y,Z)

[stephen collier]

Thanks KKSV,

I ran that ang got a Fit, how do i use that in a look up table?

[KSSV]

If you have a point (x,y); Jut use:

z = F(x,y)

[stephen collier]

I have a 2d lookup table working using the below data, my issue now is when the x or y value is not in it data set the model returns nan, show do you get an interpolated answer? i sorted that by changing the scatterplot as below for any one in the same boat. Thank you KSSV