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);