Import grid data and surface fit

Question

Michael Cody 2018-9-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/417188-import-grid-data-and-surface-fit

评论： Michael Cody 2018-9-5

采纳的回答： Walter Roberson

Hi,

Looking for help on what is probably an easy problem. I can't even get data into Matlab correctly to start!

I have MS Excel grid - temperature (orange), %alcohol (blue), density (green). This is excerpt:

I would like to create a function/formula: input density and temperature, output %alcohol. This function should interpolate/extrapolate, so for example could enter temperatures like 34.6, 40.7

So guess I would like to fit a surface and get function equation, and then reorganize so %alcohol is on LHS.

Questions:

1. First problem how to import data into grid format I can use? I have tried to bring in as table, but treats every column as different variable.

2. How to best fit a function to this data and "solve" for %alcohol.

Any suggestions, similar examples, outline workflows appreciated.

Thanks, Michael

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2018-9-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/417188-import-grid-data-and-surface-fit#answer_335454

在 MATLAB Online 中打开

data = xlsread('YourFile.xlsx');
alch = data(2:end,1);
temperature = data(1,2:end);
density = data(2:end,2:end);
surf(temperature, alch, density, 'edgecolor','none')
xlabel('temperature'); ylabel('% alcohol')

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Michael Cody 2018-9-5

Hi Walter, This is nice succinct answer to my question on how to order data for 3D surface. Obvious of course, when someone shows you!

I think will close this question now and split my second question into a new thread after I do some more research.

Thanks a lot. Michael

请先登录，再进行评论。

Answer 2

ahmed nebli 2018-9-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/417188-import-grid-data-and-surface-fit#answer_335099

1- u need to use the function xlsread , see this link : https://www.mathworks.com/help/matlab/ref/xlsread.html

3 个评论
显示 1更早的评论隐藏 1更早的评论

ahmed nebli 2018-9-3

i think once you imported the xls sheet, u need to store it in a .mat file , then you can treat the double sttored in the .mat like you want

Michael Cody 2018-9-4

在 MATLAB Online 中打开

Loaded data, each set into own variable matrix. My main problem was how to organize data for 3D plot and curve fitting.

I eventually found meshgrid which seemed to help me.

[abv_x,temperature_y] = meshgrid(abv,temperature)
surf (abv_x,temperature_y,density)

Thanks for tip on xlsread.

On question 2, if I fit with interpolation curve then seems cannot evaluate for points outside original data range e.g my max temperature is 40, if try feval on fit function get NaN. Is this limitation of interpolation do you know?

Thanks, Michael

请先登录，再进行评论。