How to plot data from excel

4 次查看（过去 30 天）

Julie Kathrine Treu Andersen 2019-4-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/456869-how-to-plot-data-from-excel

Hi,

I'm trying to replicate a specific study (not that familiar with Matlab) and I am having some troubles understanding the matlab code.

I want to compare the model with my data, but the output only shows the simulated model in the graph and not the data from excel (dependency ratio).

Hope someone can help me out on this :)

years             = 1990:5:2100;
% Years to consider (110 years simulation horizon)
start_yr    = 1990;
end_yr      = 110/5;
% Dependency ratio
dep_ratio_data    = xlsread('EER-D-16-00235_data','dep_ratio');
for i = 1:end_yr+1
    dep_ratio_mod(i) = psi_base(5*i-3);
end
figure(3)
plot(years,100*dep_ratio_mod,years,dep_ratio_data(:,2),'r--')
ylim([0 80])
xlim([1990 2100]); 
title('Dependency Ratio')
ylabel('per cent');
tickx = [1990:10:2100];
set(gca,'XTick',tickx);
set(gca,'XTickLabel',[1990:10:2100])
legend('Model','Data','Location','SouthEast')
set(gcf,'Units','inches');
screenposition = get(gcf,'Position');
set(gcf,...
    'PaperPosition',[0 0 screenposition(3:4)],...
    'PaperSize',screenposition(3:4));
    print -dpdf -painters dep_ratio_model_data