bsp_4_1_2b.m

% Beispiel für Kap 4.1.2b
% Beispiel Klausuren, Kennzahlen

% Daten einlesen
file = '../daten/klausuren.xlsx';
kl15 = xlsread(file, '2015');
kl14 = xlsread(file, '2014');
kl13 = xlsread(file, '2013');
X13 = kl13(1:end-2,5);
X14 = kl14(1:end-2,5);
X15 = kl15(1:end-2,5);
X = [X13; X14; X15];
n = size(X,1); 
fprintf('%d Datensätze gelesen\n', n);

edges = 0:10:100;
subplot(2,2,1)
histogram(X13, edges)
xlabel('2013')

subplot(2,2,2)
histogram(X14, edges)
xlabel('2014')

subplot(2,2,3)
histogram(X15, edges)
xlabel('2015')

subplot(2,2,4)
histogram(X, edges)
xlabel('gesamt')

xq = zeros(1,4);
xq(1) = mean(X13);
xq(2) = mean(X14);
xq(3) = mean(X15);
xq(4) = mean(X);

xm = zeros(1,4);
xm(1) = median(X13);
xm(2) = median(X14);
xm(3) = median(X15);
xm(4) = median(X);

xq1 = zeros(1,4);
xq1(1) = quantile(X13, 1/4);
xq1(2) = quantile(X14, 1/4);
xq1(3) = quantile(X15, 1/4);
xq1(4) = quantile(X, 1/4);

xq3 = zeros(1,4);
xq3(1) = quantile(X13, 3/4);
xq3(2) = quantile(X14, 3/4);
xq3(3) = quantile(X15, 3/4);
xq3(4) = quantile(X, 3/4);

xs = zeros(1,4);
xs(1) = std(X13);
xs(2) = std(X14);
xs(3) = std(X15);
xs(4) = std(X);

fprintf('Kennzahl 2013    2014    2015    gesamt\n');
fprintf('mean     %5.2f   %5.2f   %5.2f   %5.2f\n', xq);
fprintf('Q1       %5.2f   %5.2f   %5.2f   %5.2f\n', xq1);
fprintf('median   %5.2f   %5.2f   %5.2f   %5.2f\n', xm);
fprintf('Q3       %5.2f   %5.2f   %5.2f   %5.2f\n', xq3);
fprintf('s        %5.2f   %5.2f   %5.2f   %5.2f\n', xs);