% xlsE2.m - Read and Compute for final score
%
Data=xlsread('grade618.xlsx','D1:I101');
N=101;
J=zeros(N,1);
for k=1:N
  Y=(Data(k,1)+Data(k,2)+Data(k,3)+Data(k,4))*0.25+...
    0.3*Data(k,5)+0.4*Data(k,6);
  J(k,1)=ceil(Y);
  Data(k,8)=k;
end
Data(:,7)=J(:,1);
success=xlswrite('gradetemp.xlsx',Data,'A1:H101')
T=Data(:,6);
S=sort(T,'ascend');
[S(5),S(29),S(53),S(77),S(101)];
S'
F=sort(J(:,1),'ascend');
F'
boxplot(S,'orientation','horizontal');
text(10,0.7,'[min, q_1, median, q_3, max] = [6, 42, 64, 81, 100]')
title('Summary of Statistics for Final Exam of CS3332(01),2015')