How to plot data from excel
조회 수: 3 (최근 30일)
이전 댓글 표시
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
답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!