Plotting xlsx file data using a for loop

Question

Petch Anuwutthinawin 2021-6-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/866625-plotting-xlsx-file-data-using-a-for-loop

评论： Petch Anuwutthinawin 2021-6-28

pops.xlsx

I need to plot a raw data in a xlsx file using the fit command. I need to use a for loop in order to plot the data in the file. I have written code for it but it does not work. The data file is linked as well, as I cannot describe it properly.

Allpops=xlsread('pops.xlsx');
T=[1960,2020];
%I need a for loop to create exp1 fits for all of them and plot these fits
%on the same graph.
for k=1:length(Allpops(1,:));
    ft=fittype('exp1');
    [Fit,gof]=fit(T,k,ft);
    plot(T,Fit);
    hold on;
    drawnow;
end

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

请先登录，再进行评论。

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

Answer 1

KSSV 2021-6-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/866625-plotting-xlsx-file-data-using-a-for-loop#answer_734865

在 MATLAB Online 中打开

Allpops=xlsread('pops.xlsx');
T = (1961:2020)' ;
%I need a for loop to create exp1 fits for all of them and plot these fits
%on the same graph.
for k=1:length(Allpops(1,:))
    y = Allpops(k,:)' ; 
    Fit=fit(T,y,'poly2');
    plot(Fit,T,y);
    drawnow;
end

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

Petch Anuwutthinawin 2021-6-28

The code works but it makes a new graph every time the loop runs, it does not save all the data into just one graph. How do I make it save all the data onto just one graph?

Also how do I make it stop plotting the raw data, I dont see a line of code that should plot raw data.

请先登录，再进行评论。