Import grid data and surface fit

2 次查看（过去 30 天）
Michael Cody
Michael Cody 2018-9-2
评论： Michael Cody 2018-9-5
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

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

采纳的回答

Walter Roberson
Walter Roberson 2018-9-4
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 个评论
Michael Cody
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

请先登录，再进行评论。

更多回答（1 个）

ahmed nebli
ahmed nebli 2018-9-2
1- u need to use the function xlsread , see this link : https://www.mathworks.com/help/matlab/ref/xlsread.html
  3 个评论
显示 1更早的评论
ahmed nebli
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
Michael Cody 2018-9-4
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

请先登录，再进行评论。

类别

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

标签

产品


版本

R2014a

Community Treasure Hunt

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

Start Hunting!

Translated by