Import grid data and surface fit
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Michael Cody
el 2 de Sept. de 2018
Comentada: Michael Cody
el 5 de Sept. de 2018
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:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/194966/image.png)
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 comentarios
Respuesta aceptada
Walter Roberson
el 4 de Sept. de 2018
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')
Más respuestas (1)
ahmed nebli
el 2 de Sept. de 2018
1- u need to use the function xlsread , see this link : https://www.mathworks.com/help/matlab/ref/xlsread.html
3 comentarios
ahmed nebli
el 3 de Sept. de 2018
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
Ver también
Categorías
Más información sobre Get Started with Curve Fitting Toolbox en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!