I have a multiple matrice with x,y values with z as dependent variable. How can I average the matrice to make a surface plot?

Question

Anonyms 2021-9-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1453914-i-have-a-multiple-matrice-with-x-y-values-with-z-as-dependent-variable-how-can-i-average-the-matri

编辑： Kevin Holly 2021-9-15

Data needs to be extracted from an excel sheet to matlab and each matrix is a different sheet. Here is the example of one such matrix. All the x and y values of these matrix would be almost similar

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Kevin Holly 2021-9-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1453914-i-have-a-multiple-matrice-with-x-y-values-with-z-as-dependent-variable-how-can-i-average-the-matri#answer_788209

编辑：Kevin Holly 2021-9-15

在 MATLAB Online 中打开

Anonyms ,

I would try the following below. Let me know if this is what you wanted.

%Select Excel File to Load
[filename folder] = uigetfile('*.xls*');
%Read sheet 1
sheet = 1;
Data1 = readtable([folder,filename],'Sheet',sheet);
Data1 = table2array(Data1);
%Read sheet 2
sheet = 2;
Data2 = readtable([folder,filename],'Sheet',sheet);
Data2 = table2array(Data2);
%Read x, y, and z
x = Data1(2:end,1);
y = Data1(1,2:end);
z1 = Data1(2:end,2:end);
z2 = Data2(2:end,2:end);
%Calculate Average
zavg = (z1+z2)/2;
%Generate Surf Plot
[xg, yg] = meshgrid(x,y);
surf(xg',yg',zavg)