%歸一化 

data=xlsread('1.xls','血常規(guī)','i2:n994');
save data;
%min-max normalization
data_min_max=zeros(993,6);
for i=1:6
    minA=min(data(:,i));
    maxA=max(data(:,i));
    for j=1:993
        data_min_max(j,i)=(data(j,i)-minA)/(maxA-minA);
    end
end
save data_min_max;
%z-score normalization
data_z_score=zeros(993,6);
for i=i:6
    meanA=mean(data(:,i));
    sum=0;
    for j=1:993
        sum=sum+(data(j,i)-meanA)^2;
        meanB=sum/(993-1);
        xigmad=sqrt(meanB);
        data_z_score(j,i)=(data(j,i)-meanA)/xigmad;
    end
end

%narmalization by decimal scaling 
data_decimal=zeros(993,6);
for i=1:6
    maxA=max(data(:,i));
    if maxA/10<1
        for j=1:993
            data_decimal(j,i)=data(j,i)/10;
        end
    else if maxA/100<1
            for j=1:993
               data_decimal(j,i)=data(j,i)/100;
            end
        else
            for j=1:993
                data_decimal(j,i)=data(j,i)/1000;
            end
        end
    end
end