Interpolation of 3 dimensional values from a excel file

1 次查看（过去 30 天）
Shubham Mohan Tatpalliwar
评论： Adam 2018-9-24
i got 10 values of x for each value of x i have 10 values of y and the values of z for each x depends on y
how should i interpolate them so that i can give any value of x and y in between the range to get ultimate value of z.
i have attached a file of values for more clarity.

请先登录，再回答此问题。

采纳的回答

KSSV
KSSV 2018-9-24
[num,txt,raw] = xlsread('Mappe1.xlsx') ;
x = num(:,1) ; x(isnan(x))= [ ];
A = num(:,2:end) ;
A(isnan(A(:,1)),:)= [] ;
Y = A(1:2:end,:) ;
Z = A(2:2:end,:) ;
X = repmat(x,1,size(Y,1)) ;
idx = ~isnan(Z) ;
F = scatteredInterpolant([X(idx) Y(idx)],Z(idx),'linear','none');
iwant = F(250,0.7)
  5 个评论
显示 3更早的评论
Adam
Adam 2018-9-24
Please don't use flags for things that should just be a comment, or in this case, just accepting the answer is enough to say it worked.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Interpolation 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by