你好同学:
T = readtable('2020-10-12.xls', 'PreserveVariableNames',true);
xuehao = T{:, '学号'};
xingming = T{:,'姓名'};
chengji = T{:,'成绩'};
% (1)
figure(1); clf
plot(chengji); hold on
yline(mean(cheng))
% (2)
figure(2); clf;
Q = histogram(randi([0,100],10000,1), [0,60:10:100]);
figure(3);clf
p = h.Values;
x=({'0-60','60-69','70-79','80-89','90-100'});
for i = 1:size(x,2)
x{1,i} = [x{1,i},' (',num2str((p(i)/sum(p))*100,'%.1f'),'%)'];
end
explode=ones(1,numel(p));
pie(p,explode,x)
colormap(jet)
% (3)
q = chengji<60;
bujige = table(xingming(q), xuehao(q), chengji(q))
q = chengji>=90;
bujige = table(xingming(q), xuehao(q), chengji(q))
有帮助望采纳