How to plot data from excel

조회 수: 3 (최근 30일)
Julie Kathrine Treu Andersen
Julie Kathrine Treu Andersen 2019년 4월 17일
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

답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by