{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Urliste","Säulendiagramm","Klassen 1","Klassen 2","arithm. Mittel","Modalwert","Median","Spann- u. Halbweite","Boxplot(30)","Streuung"],"not_rendered":{"charts":8,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Urliste","index":0,"n_rows":24,"n_cols":33,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,1,5,2],[6,1,6,2],[18,9,18,11],[22,11,22,13]]}
[]
[null,"Beispiel: Korrektur Matheklausur in der Oberstufe"]
[]
[null,"Hier kann das Ergebnis der Korrekur von 30 Matheklausuren eingegeben bzw. zufällig generiert werden."]
[]
[null,"Nummer der Klausur",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Notenpunkte ",null,12,13,8,7,8,10,2,13,7,13,8,13,14,5,10,14,9,13,14,7,13,11,10,13,11,12,8,12,15,15]
[]
[]
[null,null,null,{"$f":"IF($J$19=TRUE,D11,RANDBETWEEN($J$14,$J$16))","v":9},{"$f":"IF($J$19=TRUE,E11,RANDBETWEEN($J$14,$J$16))","v":14},12,11,9,13,6,12,12,11,8,10,11,11,8,11,8,8,6,8,15,8,8,9,8,7,7,12,9,12]
[null,null,null,{"$f":"ROUND(MAX(MIN(_xlfn.NORM.INV(RAND(),$K$21,$K$20),$J$16),$J$14),0)","v":9},14,12,11,9,13,6,12,12,11,8,10,11,11,8,11,8,8,6,8,15,8,8,9,8,7,7,12,9,12]
[]
[]
[null,null,null,"kleinster Zufallswert:",null,null,null,null,null,0]
[]
[null,null,null,"größter Zufallswert:",null,null,null,null,null,15]
[]
[]
[null,null,null,null,"Normalverteilung:",null,null,null,null,true]
[null,null,null,null,"Standardabweichung:",null,null,null,null,null,2.6]
[null,null,null,null,"Mittelwert:",null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,"Schritte 1. - 5. können per Makro durchgeführt werden mit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tastenkombination:",null,null,null,null,"Strg + N"]
[]
[" ","Anzahl der Klausuren, die auf den anderen Tabellenblättern verwendet werden (0-30):",null,null,null,null,null,null,null,null,null,null,null,null,null,8]

{"sheet":"Säulendiagramm","index":1,"n_rows":17,"n_cols":45,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,17,16,18],[16,19,16,20],[16,21,16,22],[16,23,16,24],[16,25,16,26],[16,27,16,28],[16,29,16,30],[16,31,16,32],[16,33,16,34],[10,27,10,28],[10,29,10,30],[10,31,10,32],[10,33,10,34],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,12],[10,15,10,16],[10,17,10,18],[10,19,10,20],[10,21,10,22],[10,23,10,24],[10,25,10,26],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[10,13,10,14],[11,38,11,41],[11,42,11,43],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[12,15,12,16],[11,25,11,26],[11,27,11,28],[11,29,11,30],[11,31,11,32],[11,33,11,34],[11,36,11,37],[11,13,11,14],[11,15,11,16],[11,17,11,18],[11,19,11,20],[11,21,11,22],[11,23,11,24],[12,36,12,37],[12,38,12,41],[12,42,12,43],[12,17,12,18],[12,19,12,20],[12,21,12,22],[12,23,12,24],[12,25,12,26],[12,27,12,28],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[12,29,12,30],[12,31,12,32],[12,33,12,34],[13,38,13,41],[13,42,13,43],[13,27,13,28],[13,29,13,30],[13,31,13,32],[13,33,13,34],[13,36,13,37],[14,15,14,16],[14,17,14,18],[13,25,13,26],[13,13,13,14],[13,15,13,16],[13,17,13,18],[13,19,13,20],[13,21,13,22],[13,23,13,24],[14,31,14,32],[14,33,14,34],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[14,19,14,20],[14,21,14,22],[14,23,14,24],[14,25,14,26],[14,27,14,28],[14,29,14,30],[15,33,15,34],[15,29,15,30],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[14,13,14,14],[26,3,26,4],[27,3,27,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[15,31,15,32],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[15,19,15,20],[15,21,15,22],[15,23,15,24],[15,25,15,26],[15,27,15,28],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[16,13,16,14],[16,15,16,16]]}
[]
[null,"Beispiel: Korrektur Matheklausur in der Oberstufe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(","Anzahl der Klausuren:",null,null,null,null,null,{"$f":"Urliste!P24","v":8},")",null,null,null,null,null,null,null,null,null,false]
[]
[null,"Urliste:"]
[]
[null,"Nummer der Klausur",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Notenpunkte ",null,{"$f":"IF(D6<=$AH$2,Urliste!D7,\"\")","v":12},{"$f":"IF(E6<=$AH$2,Urliste!E7,\"\")","v":13},{"$f":"IF(F6<=$AH$2,Urliste!F7,\"\")","v":8},{"$f":"IF(G6<=$AH$2,Urliste!G7,\"\")","v":7},{"$f":"IF(H6<=$AH$2,Urliste!H7,\"\")","v":8},{"$f":"IF(I6<=$AH$2,Urliste!I7,\"\")","v":10},{"$f":"IF(J6<=$AH$2,Urliste!J7,\"\")","v":2},{"$f":"IF(K6<=$AH$2,Urliste!K7,\"\")","v":13},{"$f":"IF(L6<=$AH$2,Urliste!L7,\"\")","v":""},{"$f":"IF(M6<=$AH$2,Urliste!M7,\"\")","v":""},{"$f":"IF(N6<=$AH$2,Urliste!N7,\"\")","v":""},{"$f":"IF(O6<=$AH$2,Urliste!O7,\"\")","v":""},{"$f":"IF(P6<=$AH$2,Urliste!P7,\"\")","v":""},{"$f":"IF(Q6<=$AH$2,Urliste!Q7,\"\")","v":""},{"$f":"IF(R6<=$AH$2,Urliste!R7,\"\")","v":""},{"$f":"IF(S6<=$AH$2,Urliste!S7,\"\")","v":""},{"$f":"IF(T6<=$AH$2,Urliste!T7,\"\")","v":""},{"$f":"IF(U6<=$AH$2,Urliste!U7,\"\")","v":""},{"$f":"IF(V6<=$AH$2,Urliste!V7,\"\")","v":""},{"$f":"IF(W6<=$AH$2,Urliste!W7,\"\")","v":""},{"$f":"IF(X6<=$AH$2,Urliste!X7,\"\")","v":""},{"$f":"IF(Y6<=$AH$2,Urliste!Y7,\"\")","v":""},{"$f":"IF(Z6<=$AH$2,Urliste!Z7,\"\")","v":""},{"$f":"IF(AA6<=$AH$2,Urliste!AA7,\"\")","v":""},{"$f":"IF(AB6<=$AH$2,Urliste!AB7,\"\")","v":""},{"$f":"IF(AC6<=$AH$2,Urliste!AC7,\"\")","v":""},{"$f":"IF(AD6<=$AH$2,Urliste!AD7,\"\")","v":""},{"$f":"IF(AE6<=$AH$2,Urliste!AE7,\"\")","v":""},{"$f":"IF(AF6<=$AH$2,Urliste!AF7,\"\")","v":""},{"$f":"IF(AG6<=$AH$2,Urliste!AG7,\"\")","v":""}]
[]
[]
[null,"Häufigkeitstabelle:"]
[null,null,null,{"$f":"D13*D12","v":0},null,{"$f":"F13*F12","v":0},null,{"$f":"H13*H12","v":26},null,{"$f":"J13*J12","v":12},null,{"$f":"L13*L12","v":0},null,{"$f":"N13*N12","v":10},null,{"$f":"P13*P12","v":0},null,{"$f":"R13*R12","v":16},null,{"$f":"T13*T12","v":7},null,{"$f":"V13*V12","v":0},null,{"$f":"X13*X12","v":0},null,{"$f":"Z13*Z12","v":0},null,{"$f":"AB13*AB12","v":0},null,{"$f":"AD13*AD12","v":2},null,{"$f":"AF13*AF12","v":0},null,{"$f":"AH13*AH12","v":0}]
[null,"Notenpunkte",null,15,null,14,null,13,null,12,null,11,null,10,null,9,null,8,null,7,null,6,null,5,null,4,null,3,null,2,null,1,null,0,null,null,"Summe"]
[null,"absolute Häufigkeit",null,{"$f":"COUNTIF($D$7:$AG$7,D12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,F12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,H12)","v":2},null,{"$f":"COUNTIF($D$7:$AG$7,J12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,L12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,N12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,P12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,R12)","v":2},null,{"$f":"COUNTIF($D$7:$AG$7,T12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,V12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,X12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,Z12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,AB12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,AD12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,AF12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,AH12)","v":0},null,null,{"$f":"SUM(D13:AI13)","v":8}]
[null,"relative Häufigkeit",null,{"$f":"ROUND(D13/$AH$2,3)","v":0},null,{"$f":"ROUND(F13/$AH$2,3)","v":0},null,{"$f":"ROUND(H13/$AH$2,3)","v":0.25},null,{"$f":"ROUND(J13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(L13/$AH$2,3)","v":0},null,{"$f":"ROUND(N13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(P13/$AH$2,3)","v":0},null,{"$f":"ROUND(R13/$AH$2,3)","v":0.25},null,{"$f":"ROUND(T13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(V13/$AH$2,3)","v":0},null,{"$f":"ROUND(X13/$AH$2,3)","v":0},null,{"$f":"ROUND(Z13/$AH$2,3)","v":0},null,{"$f":"ROUND(AB13/$AH$2,3)","v":0},null,{"$f":"ROUND(AD13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(AF13/$AH$2,3)","v":0},null,{"$f":"ROUND(AH13/$AH$2,3)","v":0},null,null,{"$f":"SUM(D14:AI14)","v":1}]
[null,null,null,{"$f":"ROUND(D14,3)","v":0},null,{"$f":"ROUND(F14,3)","v":0},null,{"$f":"ROUND(H14,3)","v":0.25},null,{"$f":"ROUND(J14,3)","v":0.125},null,{"$f":"ROUND(L14,3)","v":0},null,{"$f":"ROUND(N14,3)","v":0.125},null,{"$f":"ROUND(P14,3)","v":0},null,{"$f":"ROUND(R14,3)","v":0.25},null,{"$f":"ROUND(T14,3)","v":0.125},null,{"$f":"ROUND(V14,3)","v":0},null,{"$f":"ROUND(X14,3)","v":0},null,{"$f":"ROUND(Z14,3)","v":0},null,{"$f":"ROUND(AB14,3)","v":0},null,{"$f":"ROUND(AD14,3)","v":0.125},null,{"$f":"ROUND(AF14,3)","v":0},null,{"$f":"ROUND(AH14,3)","v":0}]
[null,null,null,{"$f":"D14*D12","v":0},null,{"$f":"F14*F12","v":0},null,{"$f":"H14*H12","v":3.25},null,{"$f":"J14*J12","v":1.5},null,{"$f":"L14*L12","v":0},null,{"$f":"N14*N12","v":1.25},null,{"$f":"P14*P12","v":0},null,{"$f":"R14*R12","v":2},null,{"$f":"T14*T12","v":0.875},null,{"$f":"V14*V12","v":0},null,{"$f":"X14*X12","v":0},null,{"$f":"Z14*Z12","v":0},null,{"$f":"AB14*AB12","v":0},null,{"$f":"AD14*AD12","v":0.25},null,{"$f":"AF14*AF12","v":0},null,{"$f":"AH14*AH12","v":0}]
[null,"Säulendiagramm:",null,{"$f":"IF($AS$2=FALSE,D13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,F13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,H13,\"\")","v":2},null,{"$f":"IF($AS$2=FALSE,J13,\"\")","v":1},null,{"$f":"IF($AS$2=FALSE,L13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,N13,\"\")","v":1},null,{"$f":"IF($AS$2=FALSE,P13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,R13,\"\")","v":2},null,{"$f":"IF($AS$2=FALSE,T13,\"\")","v":1},null,{"$f":"IF($AS$2=FALSE,V13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,X13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,Z13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,AB13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,AD13,\"\")","v":1},null,{"$f":"IF($AS$2=FALSE,AF13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,AH13,\"\")","v":0}]

{"sheet":"Klassen 1","index":2,"n_rows":23,"n_cols":44,"rows_kept":23,"cut":false,"hidden":false,"merged":[[21,3,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,14],[10,27,10,28],[10,29,10,30],[10,31,10,32],[14,31,14,32],[19,16,19,17],[20,3,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,12],[20,13,20,14],[20,16,20,17],[19,3,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[10,33,10,34],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,12],[10,15,10,16],[10,17,10,18],[10,19,10,20],[10,21,10,22],[10,23,10,24],[10,25,10,26],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[10,13,10,14],[11,38,11,41],[11,42,11,43],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[12,15,12,16],[11,25,11,26],[11,27,11,28],[11,29,11,30],[11,31,11,32],[11,33,11,34],[11,36,11,37],[11,13,11,14],[11,15,11,16],[11,17,11,18],[11,19,11,20],[11,21,11,22],[11,23,11,24],[12,36,12,37],[12,38,12,41],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[12,29,12,30],[12,31,12,32],[12,33,12,34],[13,27,13,28],[13,29,13,30],[13,31,13,32],[13,33,13,34],[13,25,13,26],[13,13,13,14],[13,15,13,16],[13,17,13,18],[13,19,13,20],[13,21,13,22],[13,23,13,24],[12,42,12,43],[12,17,12,18],[12,19,12,20],[12,21,12,22],[12,23,12,24],[12,25,12,26],[12,27,12,28],[13,38,13,41],[13,42,13,43],[13,36,13,37],[14,33,14,34],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[14,19,14,20],[14,21,14,22],[14,23,14,24],[14,25,14,26],[14,27,14,28],[14,29,14,30],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[14,13,14,14],[14,15,14,16],[14,17,14,18],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,7,18,8],[15,31,15,32],[15,33,15,34],[15,19,15,20],[15,21,15,22],[15,23,15,24],[15,25,15,26],[15,27,15,28],[15,29,15,30],[18,9,18,10],[18,11,18,12],[18,13,18,14],[18,16,18,17]]}
[]
[null,"Beispiel: Korrektur Matheklausur in der Oberstufe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(","Anzahl der Klausuren:",null,null,null,null,null,{"$f":"Urliste!P24","v":8},")",null,null,null,null,null,null,null,null,false]
[]
[null,"Urliste:"]
[]
[null,"Nummer der Klausur",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Notenpunkte ",null,{"$f":"IF(D6<=$AH$2,Urliste!D7,\"\")","v":12},{"$f":"IF(E6<=$AH$2,Urliste!E7,\"\")","v":13},{"$f":"IF(F6<=$AH$2,Urliste!F7,\"\")","v":8},{"$f":"IF(G6<=$AH$2,Urliste!G7,\"\")","v":7},{"$f":"IF(H6<=$AH$2,Urliste!H7,\"\")","v":8},{"$f":"IF(I6<=$AH$2,Urliste!I7,\"\")","v":10},{"$f":"IF(J6<=$AH$2,Urliste!J7,\"\")","v":2},{"$f":"IF(K6<=$AH$2,Urliste!K7,\"\")","v":13},{"$f":"IF(L6<=$AH$2,Urliste!L7,\"\")","v":""},{"$f":"IF(M6<=$AH$2,Urliste!M7,\"\")","v":""},{"$f":"IF(N6<=$AH$2,Urliste!N7,\"\")","v":""},{"$f":"IF(O6<=$AH$2,Urliste!O7,\"\")","v":""},{"$f":"IF(P6<=$AH$2,Urliste!P7,\"\")","v":""},{"$f":"IF(Q6<=$AH$2,Urliste!Q7,\"\")","v":""},{"$f":"IF(R6<=$AH$2,Urliste!R7,\"\")","v":""},{"$f":"IF(S6<=$AH$2,Urliste!S7,\"\")","v":""},{"$f":"IF(T6<=$AH$2,Urliste!T7,\"\")","v":""},{"$f":"IF(U6<=$AH$2,Urliste!U7,\"\")","v":""},{"$f":"IF(V6<=$AH$2,Urliste!V7,\"\")","v":""},{"$f":"IF(W6<=$AH$2,Urliste!W7,\"\")","v":""},{"$f":"IF(X6<=$AH$2,Urliste!X7,\"\")","v":""},{"$f":"IF(Y6<=$AH$2,Urliste!Y7,\"\")","v":""},{"$f":"IF(Z6<=$AH$2,Urliste!Z7,\"\")","v":""},{"$f":"IF(AA6<=$AH$2,Urliste!AA7,\"\")","v":""},{"$f":"IF(AB6<=$AH$2,Urliste!AB7,\"\")","v":""},{"$f":"IF(AC6<=$AH$2,Urliste!AC7,\"\")","v":""},{"$f":"IF(AD6<=$AH$2,Urliste!AD7,\"\")","v":""},{"$f":"IF(AE6<=$AH$2,Urliste!AE7,\"\")","v":""},{"$f":"IF(AF6<=$AH$2,Urliste!AF7,\"\")","v":""},{"$f":"IF(AG6<=$AH$2,Urliste!AG7,\"\")","v":""}]
[]
[]
[null,"Häufigkeitstabelle:"]
[null,null,null,{"$f":"D13*D12","v":0},null,{"$f":"F13*F12","v":0},null,{"$f":"H13*H12","v":26},null,{"$f":"J13*J12","v":12},null,{"$f":"L13*L12","v":0},null,{"$f":"N13*N12","v":10},null,{"$f":"P13*P12","v":0},null,{"$f":"R13*R12","v":16},null,{"$f":"T13*T12","v":7},null,{"$f":"V13*V12","v":0},null,{"$f":"X13*X12","v":0},null,{"$f":"Z13*Z12","v":0},null,{"$f":"AB13*AB12","v":0},null,{"$f":"AD13*AD12","v":2},null,{"$f":"AF13*AF12","v":0},null,{"$f":"AH13*AH12","v":0}]
[null,"Notenpunkte",null,15,null,14,null,13,null,12,null,11,null,10,null,9,null,8,null,7,null,6,null,5,null,4,null,3,null,2,null,1,null,0,null,null,"Summe"]
[null,"absolute Häufigkeit",null,{"$f":"COUNTIF($D$7:$AG$7,D12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,F12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,H12)","v":2},null,{"$f":"COUNTIF($D$7:$AG$7,J12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,L12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,N12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,P12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,R12)","v":2},null,{"$f":"COUNTIF($D$7:$AG$7,T12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,V12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,X12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,Z12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,AB12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,AD12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,AF12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,AH12)","v":0},null,null,{"$f":"SUM(D13:AI13)","v":8}]
[null,"relative Häufigkeit",null,{"$f":"ROUND(D13/$AH$2,3)","v":0},null,{"$f":"ROUND(F13/$AH$2,3)","v":0},null,{"$f":"ROUND(H13/$AH$2,3)","v":0.25},null,{"$f":"ROUND(J13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(L13/$AH$2,3)","v":0},null,{"$f":"ROUND(N13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(P13/$AH$2,3)","v":0},null,{"$f":"ROUND(R13/$AH$2,3)","v":0.25},null,{"$f":"ROUND(T13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(V13/$AH$2,3)","v":0},null,{"$f":"ROUND(X13/$AH$2,3)","v":0},null,{"$f":"ROUND(Z13/$AH$2,3)","v":0},null,{"$f":"ROUND(AB13/$AH$2,3)","v":0},null,{"$f":"ROUND(AD13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(AF13/$AH$2,3)","v":0},null,{"$f":"ROUND(AH13/$AH$2,3)","v":0},null,null,{"$f":"SUM(D14:AI14)","v":1}]
[null,null,null,{"$f":"ROUND(D14,3)","v":0},null,{"$f":"ROUND(F14,3)","v":0},null,{"$f":"ROUND(H14,3)","v":0.25},null,{"$f":"ROUND(J14,3)","v":0.125},null,{"$f":"ROUND(L14,3)","v":0},null,{"$f":"ROUND(N14,3)","v":0.125},null,{"$f":"ROUND(P14,3)","v":0},null,{"$f":"ROUND(R14,3)","v":0.25},null,{"$f":"ROUND(T14,3)","v":0.125},null,{"$f":"ROUND(V14,3)","v":0},null,{"$f":"ROUND(X14,3)","v":0},null,{"$f":"ROUND(Z14,3)","v":0},null,{"$f":"ROUND(AB14,3)","v":0},null,{"$f":"ROUND(AD14,3)","v":0.125},null,{"$f":"ROUND(AF14,3)","v":0},null,{"$f":"ROUND(AH14,3)","v":0}]
[null,null,null,{"$f":"D14*D12","v":0},null,{"$f":"F14*F12","v":0},null,{"$f":"H14*H12","v":3.25},null,{"$f":"J14*J12","v":1.5},null,{"$f":"L14*L12","v":0},null,{"$f":"N14*N12","v":1.25},null,{"$f":"P14*P12","v":0},null,{"$f":"R14*R12","v":2},null,{"$f":"T14*T12","v":0.875},null,{"$f":"V14*V12","v":0},null,{"$f":"X14*X12","v":0},null,{"$f":"Z14*Z12","v":0},null,{"$f":"AB14*AB12","v":0},null,{"$f":"AD14*AD12","v":0.25},null,{"$f":"AF14*AF12","v":0},null,{"$f":"AH14*AH12","v":0}]
[null,"Klasseneinteilung (Zensuren):",null,null,null,null,null,null,null,null,true]
[]
[null,"Zensuren",null,1,null,2,null,3,null,4,null,5,null,6,null,null,"Summe"]
[null,"absolute Häufigkeit",null,{"$f":"IF($AR$2=FALSE,SUM(D13:I13),\"\")","v":2},null,{"$f":"IF($AR$2=FALSE,SUM(J13:O13),\"\")","v":2},null,{"$f":"IF($AR$2=FALSE,SUM(P13:U13),\"\")","v":3},null,{"$f":"IF($AR$2=FALSE,SUM(V13:AA13),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,SUM(AB13:AG13),\"\")","v":1},null,{"$f":"IF($AR$2=FALSE,SUM(AH13),\"\")","v":0},null,null,{"$f":"SUM(D20:O20)","v":8}]
[null,"relative Häufigkeit",null,{"$f":"ROUND(D20/$AH$2,3)","v":0.25},null,{"$f":"ROUND(F20/$AH$2,3)","v":0.25},null,{"$f":"ROUND(H20/$AH$2,3)","v":0.375},null,{"$f":"ROUND(J20/$AH$2,3)","v":0},null,{"$f":"ROUND(L20/$AH$2,3)","v":0.125},null,{"$f":"ROUND(N20/$AH$2,3)","v":0},null,null,{"$f":"SUM(D21:O21)","v":1}]
[]
[null,"Säulendiagramm:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kreisdiagramm:"]

{"sheet":"Klassen 2","index":3,"n_rows":23,"n_cols":43,"rows_kept":23,"cut":false,"hidden":false,"merged":[[10,27,10,28],[10,29,10,30],[10,31,10,32],[10,33,10,34],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,12],[10,15,10,16],[10,17,10,18],[10,19,10,20],[10,21,10,22],[10,23,10,24],[10,25,10,26],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[10,13,10,14],[11,38,11,41],[11,42,11,43],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[12,15,12,16],[11,25,11,26],[11,27,11,28],[11,29,11,30],[11,31,11,32],[11,33,11,34],[11,36,11,37],[11,13,11,14],[11,15,11,16],[11,17,11,18],[11,19,11,20],[11,21,11,22],[11,23,11,24],[12,36,12,37],[12,38,12,41],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[12,29,12,30],[12,31,12,32],[12,33,12,34],[13,27,13,28],[13,29,13,30],[13,31,13,32],[13,33,13,34],[13,25,13,26],[13,13,13,14],[13,15,13,16],[13,17,13,18],[13,19,13,20],[13,21,13,22],[13,23,13,24],[12,42,12,43],[12,17,12,18],[12,19,12,20],[12,21,12,22],[12,23,12,24],[12,25,12,26],[12,27,12,28],[13,38,13,41],[13,42,13,43],[13,36,13,37],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[14,19,14,20],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[14,13,14,14],[14,15,14,16],[14,17,14,18],[15,31,15,32],[15,33,15,34],[15,19,15,20],[15,21,15,22],[15,23,15,24],[15,25,15,26],[15,27,15,28],[15,29,15,30],[14,31,14,32],[14,33,14,34],[14,21,14,22],[14,23,14,24],[14,25,14,26],[14,27,14,28],[14,29,14,30],[20,1,20,2],[20,3,20,9],[20,10,20,16],[20,17,20,23],[20,25,20,26],[18,1,18,2],[18,3,18,9],[18,10,18,16],[18,17,18,23],[18,25,18,26],[19,1,19,2],[19,3,19,9],[19,10,19,16],[19,17,19,23],[19,25,19,26]]}
[]
[null,"Beispiel: Korrektur Matheklausur in der Oberstufe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(","Anzahl der Klausuren:",null,null,null,null,null,{"$f":"Urliste!P24","v":8},")",null,null,null,null,null,null,null,false]
[]
[null,"Urliste:"]
[]
[null,"Nummer der Klausur",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Notenpunkte ",null,{"$f":"IF(D6<=$AH$2,Urliste!D7,\"\")","v":12},{"$f":"IF(E6<=$AH$2,Urliste!E7,\"\")","v":13},{"$f":"IF(F6<=$AH$2,Urliste!F7,\"\")","v":8},{"$f":"IF(G6<=$AH$2,Urliste!G7,\"\")","v":7},{"$f":"IF(H6<=$AH$2,Urliste!H7,\"\")","v":8},{"$f":"IF(I6<=$AH$2,Urliste!I7,\"\")","v":10},{"$f":"IF(J6<=$AH$2,Urliste!J7,\"\")","v":2},{"$f":"IF(K6<=$AH$2,Urliste!K7,\"\")","v":13},{"$f":"IF(L6<=$AH$2,Urliste!L7,\"\")","v":""},{"$f":"IF(M6<=$AH$2,Urliste!M7,\"\")","v":""},{"$f":"IF(N6<=$AH$2,Urliste!N7,\"\")","v":""},{"$f":"IF(O6<=$AH$2,Urliste!O7,\"\")","v":""},{"$f":"IF(P6<=$AH$2,Urliste!P7,\"\")","v":""},{"$f":"IF(Q6<=$AH$2,Urliste!Q7,\"\")","v":""},{"$f":"IF(R6<=$AH$2,Urliste!R7,\"\")","v":""},{"$f":"IF(S6<=$AH$2,Urliste!S7,\"\")","v":""},{"$f":"IF(T6<=$AH$2,Urliste!T7,\"\")","v":""},{"$f":"IF(U6<=$AH$2,Urliste!U7,\"\")","v":""},{"$f":"IF(V6<=$AH$2,Urliste!V7,\"\")","v":""},{"$f":"IF(W6<=$AH$2,Urliste!W7,\"\")","v":""},{"$f":"IF(X6<=$AH$2,Urliste!X7,\"\")","v":""},{"$f":"IF(Y6<=$AH$2,Urliste!Y7,\"\")","v":""},{"$f":"IF(Z6<=$AH$2,Urliste!Z7,\"\")","v":""},{"$f":"IF(AA6<=$AH$2,Urliste!AA7,\"\")","v":""},{"$f":"IF(AB6<=$AH$2,Urliste!AB7,\"\")","v":""},{"$f":"IF(AC6<=$AH$2,Urliste!AC7,\"\")","v":""},{"$f":"IF(AD6<=$AH$2,Urliste!AD7,\"\")","v":""},{"$f":"IF(AE6<=$AH$2,Urliste!AE7,\"\")","v":""},{"$f":"IF(AF6<=$AH$2,Urliste!AF7,\"\")","v":""},{"$f":"IF(AG6<=$AH$2,Urliste!AG7,\"\")","v":""}]
[]
[]
[null,"Häufigkeitstabelle:"]
[null,null,null,{"$f":"D13*D12","v":0},null,{"$f":"F13*F12","v":0},null,{"$f":"H13*H12","v":26},null,{"$f":"J13*J12","v":12},null,{"$f":"L13*L12","v":0},null,{"$f":"N13*N12","v":10},null,{"$f":"P13*P12","v":0},null,{"$f":"R13*R12","v":16},null,{"$f":"T13*T12","v":7},null,{"$f":"V13*V12","v":0},null,{"$f":"X13*X12","v":0},null,{"$f":"Z13*Z12","v":0},null,{"$f":"AB13*AB12","v":0},null,{"$f":"AD13*AD12","v":2},null,{"$f":"AF13*AF12","v":0},null,{"$f":"AH13*AH12","v":0}]
[null,"Notenpunkte",null,15,null,14,null,13,null,12,null,11,null,10,null,9,null,8,null,7,null,6,null,5,null,4,null,3,null,2,null,1,null,0,null,null,"Summe"]
[null,"absolute Häufigkeit",null,{"$f":"COUNTIF($D$7:$AG$7,D12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,F12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,H12)","v":2},null,{"$f":"COUNTIF($D$7:$AG$7,J12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,L12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,N12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,P12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,R12)","v":2},null,{"$f":"COUNTIF($D$7:$AG$7,T12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,V12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,X12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,Z12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,AB12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,AD12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,AF12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,AH12)","v":0},null,null,{"$f":"SUM(D13:AI13)","v":8}]
[null,"relative Häufigkeit",null,{"$f":"ROUND(D13/$AH$2,3)","v":0},null,{"$f":"ROUND(F13/$AH$2,3)","v":0},null,{"$f":"ROUND(H13/$AH$2,3)","v":0.25},null,{"$f":"ROUND(J13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(L13/$AH$2,3)","v":0},null,{"$f":"ROUND(N13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(P13/$AH$2,3)","v":0},null,{"$f":"ROUND(R13/$AH$2,3)","v":0.25},null,{"$f":"ROUND(T13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(V13/$AH$2,3)","v":0},null,{"$f":"ROUND(X13/$AH$2,3)","v":0},null,{"$f":"ROUND(Z13/$AH$2,3)","v":0},null,{"$f":"ROUND(AB13/$AH$2,3)","v":0},null,{"$f":"ROUND(AD13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(AF13/$AH$2,3)","v":0},null,{"$f":"ROUND(AH13/$AH$2,3)","v":0},null,null,{"$f":"SUM(D14:AI14)","v":1}]
[null,null,null,{"$f":"ROUND(D14,3)","v":0},null,{"$f":"ROUND(F14,3)","v":0},null,{"$f":"ROUND(H14,3)","v":0.25},null,{"$f":"ROUND(J14,3)","v":0.125},null,{"$f":"ROUND(L14,3)","v":0},null,{"$f":"ROUND(N14,3)","v":0.125},null,{"$f":"ROUND(P14,3)","v":0},null,{"$f":"ROUND(R14,3)","v":0.25},null,{"$f":"ROUND(T14,3)","v":0.125},null,{"$f":"ROUND(V14,3)","v":0},null,{"$f":"ROUND(X14,3)","v":0},null,{"$f":"ROUND(Z14,3)","v":0},null,{"$f":"ROUND(AB14,3)","v":0},null,{"$f":"ROUND(AD14,3)","v":0.125},null,{"$f":"ROUND(AF14,3)","v":0},null,{"$f":"ROUND(AH14,3)","v":0}]
[null,null,null,{"$f":"D14*D12","v":0},null,{"$f":"F14*F12","v":0},null,{"$f":"H14*H12","v":3.25},null,{"$f":"J14*J12","v":1.5},null,{"$f":"L14*L12","v":0},null,{"$f":"N14*N12","v":1.25},null,{"$f":"P14*P12","v":0},null,{"$f":"R14*R12","v":2},null,{"$f":"T14*T12","v":0.875},null,{"$f":"V14*V12","v":0},null,{"$f":"X14*X12","v":0},null,{"$f":"Z14*Z12","v":0},null,{"$f":"AB14*AB12","v":0},null,{"$f":"AD14*AD12","v":0.25},null,{"$f":"AF14*AF12","v":0},null,{"$f":"AH14*AH12","v":0}]
[null,"Klasseneinteilung (3 Klassen):",null,null,null,null,null,null,null,null,true]
[]
[null,"Klasse",null,"10-15 Punkte",null,null,null,null,null,null,"5-9 Punkte",null,null,null,null,null,null,"0-4 Punkte",null,null,null,null,null,null,null,"Summe"]
[null,"absolute Häufigkeit",null,{"$f":"IF($AQ$2=FALSE,SUM(D13:O13),\"\")","v":4},null,null,null,null,null,null,{"$f":"IF($AQ$2=FALSE,SUM(P13:Y13),\"\")","v":3},null,null,null,null,null,null,{"$f":"IF($AQ$2=FALSE,SUM(Z13:AI13),\"\")","v":1},null,null,null,null,null,null,null,{"$f":"SUM(D20:X20)","v":8}]
[null,"relative Häufigkeit",null,{"$f":"ROUND(D20/$AH$2,3)","v":0.5},null,null,null,null,null,null,{"$f":"ROUND(K20/$AH$2,3)","v":0.375},null,null,null,null,null,null,{"$f":"ROUND(R20/$AH$2,3)","v":0.125},null,null,null,null,null,null,null,{"$f":"SUM(D21:X21)","v":1}]
[]
[null,"Säulendiagramm:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kreisdiagramm:"]

{"sheet":"arithm. Mittel","index":4,"n_rows":29,"n_cols":44,"rows_kept":29,"cut":false,"hidden":false,"merged":[[10,27,10,28],[10,29,10,30],[10,31,10,32],[10,33,10,34],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,12],[10,15,10,16],[10,17,10,18],[10,19,10,20],[10,21,10,22],[10,23,10,24],[10,25,10,26],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[10,13,10,14],[11,38,11,41],[11,42,11,43],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[12,15,12,16],[11,25,11,26],[11,27,11,28],[11,29,11,30],[11,31,11,32],[11,33,11,34],[11,36,11,37],[11,13,11,14],[11,15,11,16],[11,17,11,18],[11,19,11,20],[11,21,11,22],[11,23,11,24],[12,36,12,37],[12,38,12,41],[12,42,12,43],[12,17,12,18],[12,19,12,20],[12,21,12,22],[12,23,12,24],[12,25,12,26],[12,27,12,28],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[12,29,12,30],[12,31,12,32],[12,33,12,34],[15,29,15,30],[14,38,14,41],[14,42,14,43],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[14,25,14,26],[14,27,14,28],[14,29,14,30],[14,31,14,32],[14,33,14,34],[14,36,14,37],[14,13,14,14],[14,15,14,16],[14,17,14,18],[14,19,14,20],[14,21,14,22],[14,23,14,24],[28,2,28,44],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[20,2,20,34],[16,31,16,32],[16,33,16,34],[16,19,16,20],[16,21,16,22],[16,23,16,24],[16,25,16,26],[16,27,16,28],[16,29,16,30],[15,31,15,32],[15,33,15,34],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[16,13,16,14],[23,35,24,35],[23,36,24,38],[13,27,13,28],[13,29,13,30],[13,31,13,32],[13,33,13,34],[23,2,23,34],[24,2,24,34],[13,15,13,16],[13,17,13,18],[13,19,13,20],[13,21,13,22],[13,23,13,24],[13,25,13,26],[20,35,21,35],[20,36,21,38],[21,2,21,34],[16,15,16,16],[16,17,16,18],[15,19,15,20],[15,21,15,22],[15,23,15,24],[15,25,15,26],[15,27,15,28]]}
[]
[null,"Beispiel: Korrektur Matheklausur in der Oberstufe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(","Anzahl der Klausuren:",null,null,null,null,null,{"$f":"Urliste!P24","v":8},")",null,null,null,null,null,null,null,null,false]
[]
[null,"Urliste:"]
[]
[null,"Nummer der Klausur",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Notenpunkte ",null,{"$f":"IF(D6<=$AH$2,Urliste!D7,\"\")","v":12},{"$f":"IF(E6<=$AH$2,Urliste!E7,\"\")","v":13},{"$f":"IF(F6<=$AH$2,Urliste!F7,\"\")","v":8},{"$f":"IF(G6<=$AH$2,Urliste!G7,\"\")","v":7},{"$f":"IF(H6<=$AH$2,Urliste!H7,\"\")","v":8},{"$f":"IF(I6<=$AH$2,Urliste!I7,\"\")","v":10},{"$f":"IF(J6<=$AH$2,Urliste!J7,\"\")","v":2},{"$f":"IF(K6<=$AH$2,Urliste!K7,\"\")","v":13},{"$f":"IF(L6<=$AH$2,Urliste!L7,\"\")","v":""},{"$f":"IF(M6<=$AH$2,Urliste!M7,\"\")","v":""},{"$f":"IF(N6<=$AH$2,Urliste!N7,\"\")","v":""},{"$f":"IF(O6<=$AH$2,Urliste!O7,\"\")","v":""},{"$f":"IF(P6<=$AH$2,Urliste!P7,\"\")","v":""},{"$f":"IF(Q6<=$AH$2,Urliste!Q7,\"\")","v":""},{"$f":"IF(R6<=$AH$2,Urliste!R7,\"\")","v":""},{"$f":"IF(S6<=$AH$2,Urliste!S7,\"\")","v":""},{"$f":"IF(T6<=$AH$2,Urliste!T7,\"\")","v":""},{"$f":"IF(U6<=$AH$2,Urliste!U7,\"\")","v":""},{"$f":"IF(V6<=$AH$2,Urliste!V7,\"\")","v":""},{"$f":"IF(W6<=$AH$2,Urliste!W7,\"\")","v":""},{"$f":"IF(X6<=$AH$2,Urliste!X7,\"\")","v":""},{"$f":"IF(Y6<=$AH$2,Urliste!Y7,\"\")","v":""},{"$f":"IF(Z6<=$AH$2,Urliste!Z7,\"\")","v":""},{"$f":"IF(AA6<=$AH$2,Urliste!AA7,\"\")","v":""},{"$f":"IF(AB6<=$AH$2,Urliste!AB7,\"\")","v":""},{"$f":"IF(AC6<=$AH$2,Urliste!AC7,\"\")","v":""},{"$f":"IF(AD6<=$AH$2,Urliste!AD7,\"\")","v":""},{"$f":"IF(AE6<=$AH$2,Urliste!AE7,\"\")","v":""},{"$f":"IF(AF6<=$AH$2,Urliste!AF7,\"\")","v":""},{"$f":"IF(AG6<=$AH$2,Urliste!AG7,\"\")","v":""}]
[]
[]
[null,"Häufigkeitstabelle:"]
[null,null,null,{"$f":"D13*D12","v":0},null,{"$f":"F13*F12","v":0},null,{"$f":"H13*H12","v":26},null,{"$f":"J13*J12","v":12},null,{"$f":"L13*L12","v":0},null,{"$f":"N13*N12","v":10},null,{"$f":"P13*P12","v":0},null,{"$f":"R13*R12","v":16},null,{"$f":"T13*T12","v":7},null,{"$f":"V13*V12","v":0},null,{"$f":"X13*X12","v":0},null,{"$f":"Z13*Z12","v":0},null,{"$f":"AB13*AB12","v":0},null,{"$f":"AD13*AD12","v":2},null,{"$f":"AF13*AF12","v":0},null,{"$f":"AH13*AH12","v":0}]
[null,"Notenpunkte",null,15,null,14,null,13,null,12,null,11,null,10,null,9,null,8,null,7,null,6,null,5,null,4,null,3,null,2,null,1,null,0,null,null,"Summe"]
[null,"absolute Häufigkeit",null,{"$f":"COUNTIF($D$7:$AG$7,D12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,F12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,H12)","v":2},null,{"$f":"COUNTIF($D$7:$AG$7,J12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,L12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,N12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,P12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,R12)","v":2},null,{"$f":"COUNTIF($D$7:$AG$7,T12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,V12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,X12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,Z12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,AB12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,AD12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,AF12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,AH12)","v":0},null,null,{"$f":"SUM(D13:AI13)","v":8}]
[null,null,null,{"$f":"IF(D13>0,CONCATENATE(\" + \",D13,\" ∙ \",D12),\"\")","v":""},null,{"$f":"IF(F13>0,CONCATENATE(\" + \",F13,\" ∙ \",F12),\"\")","v":""},null,{"$f":"IF(H13>0,CONCATENATE(\" + \",H13,\" ∙ \",H12),\"\")","v":" + 2 ∙ 13"},null,{"$f":"IF(J13>0,CONCATENATE(\" + \",J13,\" ∙ \",J12),\"\")","v":" + 1 ∙ 12"},null,{"$f":"IF(L13>0,CONCATENATE(\" + \",L13,\" ∙ \",L12),\"\")","v":""},null,{"$f":"IF(N13>0,CONCATENATE(\" + \",N13,\" ∙ \",N12),\"\")","v":" + 1 ∙ 10"},null,{"$f":"IF(P13>0,CONCATENATE(\" + \",P13,\" ∙ \",P12),\"\")","v":""},null,{"$f":"IF(R13>0,CONCATENATE(\" + \",R13,\" ∙ \",R12),\"\")","v":" + 2 ∙ 8"},null,{"$f":"IF(T13>0,CONCATENATE(\" + \",T13,\" ∙ \",T12),\"\")","v":" + 1 ∙ 7"},null,{"$f":"IF(V13>0,CONCATENATE(\" + \",V13,\" ∙ \",V12),\"\")","v":""},null,{"$f":"IF(X13>0,CONCATENATE(\" + \",X13,\" ∙ \",X12),\"\")","v":""},null,{"$f":"IF(Z13>0,CONCATENATE(\" + \",Z13,\" ∙ \",Z12),\"\")","v":""},null,{"$f":"IF(AB13>0,CONCATENATE(\" + \",AB13,\" ∙ \",AB12),\"\")","v":""},null,{"$f":"IF(AD13>0,CONCATENATE(\" + \",AD13,\" ∙ \",AD12),\"\")","v":" + 1 ∙ 2"},null,{"$f":"IF(AF13>0,CONCATENATE(\" + \",AF13,\" ∙ \",AF12),\"\")","v":""},null,{"$f":"IF(AH13>0,CONCATENATE(\" + \",AH13,\" ∙ \",AH12),\"\")","v":""}]
[null,"relative Häufigkeit",null,{"$f":"ROUND(D13/$AH$2,3)","v":0},null,{"$f":"ROUND(F13/$AH$2,3)","v":0},null,{"$f":"ROUND(H13/$AH$2,3)","v":0.25},null,{"$f":"ROUND(J13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(L13/$AH$2,3)","v":0},null,{"$f":"ROUND(N13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(P13/$AH$2,3)","v":0},null,{"$f":"ROUND(R13/$AH$2,3)","v":0.25},null,{"$f":"ROUND(T13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(V13/$AH$2,3)","v":0},null,{"$f":"ROUND(X13/$AH$2,3)","v":0},null,{"$f":"ROUND(Z13/$AH$2,3)","v":0},null,{"$f":"ROUND(AB13/$AH$2,3)","v":0},null,{"$f":"ROUND(AD13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(AF13/$AH$2,3)","v":0},null,{"$f":"ROUND(AH13/$AH$2,3)","v":0},null,null,{"$f":"SUM(D15:AI15)","v":1}]
[null,null,null,{"$f":"ROUND(D15,3)","v":0},null,{"$f":"ROUND(F15,3)","v":0},null,{"$f":"ROUND(H15,3)","v":0.25},null,{"$f":"ROUND(J15,3)","v":0.125},null,{"$f":"ROUND(L15,3)","v":0},null,{"$f":"ROUND(N15,3)","v":0.125},null,{"$f":"ROUND(P15,3)","v":0},null,{"$f":"ROUND(R15,3)","v":0.25},null,{"$f":"ROUND(T15,3)","v":0.125},null,{"$f":"ROUND(V15,3)","v":0},null,{"$f":"ROUND(X15,3)","v":0},null,{"$f":"ROUND(Z15,3)","v":0},null,{"$f":"ROUND(AB15,3)","v":0},null,{"$f":"ROUND(AD15,3)","v":0.125},null,{"$f":"ROUND(AF15,3)","v":0},null,{"$f":"ROUND(AH15,3)","v":0}]
[null,null,null,{"$f":"D15*D12","v":0},null,{"$f":"F15*F12","v":0},null,{"$f":"H15*H12","v":3.25},null,{"$f":"J15*J12","v":1.5},null,{"$f":"L15*L12","v":0},null,{"$f":"N15*N12","v":1.25},null,{"$f":"P15*P12","v":0},null,{"$f":"R15*R12","v":2},null,{"$f":"T15*T12","v":0.875},null,{"$f":"V15*V12","v":0},null,{"$f":"X15*X12","v":0},null,{"$f":"Z15*Z12","v":0},null,{"$f":"AB15*AB12","v":0},null,{"$f":"AD15*AD12","v":0.25},null,{"$f":"AF15*AF12","v":0},null,{"$f":"AH15*AH12","v":0}]
[]
[]
[]
[null,null,{"$f":"CONCATENATE(D13,\" ∙ \",D12,\" + \",F13,\" ∙ \",F12,\" + \",H13,\" ∙ \",H12,\" + \",J13,\" ∙ \",J12,\" + \",L13,\" ∙ \",L12,\" + \",N13,\" ∙ \",N12,\" + \",P13,\" ∙ \",P12,\" + \",R13,\" ∙ \",R12,\" + \",T13,\" ∙ \",T12,\" + \",V13,\" ∙ \",V12,\" + \",X13,\" ∙ \",X12,\" + \",Z13,\" ∙ \",Z12,\" + \",AB13,\" ∙ \",AB12,\" + \",AD13,\" ∙ \",AD12,\" + \",AF13,\" ∙ \",AF12,\" + \",AH13,\" ∙ \",AH12)","v":"0 ∙ 15 + 0 ∙ 14 + 2 ∙ 13 + 1 ∙ 12 + 0 ∙ 11 + 1 ∙ 10 + 0 ∙ 9 + 2 ∙ 8 + 1 ∙ 7 + 0 ∙ 6 + 0 ∙ 5 + 0 ∙ 4 + 0 ∙ 3 + 1 ∙ 2 + 0 ∙ 1 + 0 ∙ 0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≅",{"$f":"ROUND(SUM(D11:AI11)/$AH$2,3)","v":9.125}]
[null,null,{"$f":"$AH$2","v":8}]
[]
[null,null,{"$f":"CONCATENATE(D14,F14,H14,J14,L14,N14,P14,R14,T14,V14,X14,Z14,AB14,AD14,AF14,AH14)","v":" + 2 ∙ 13 + 1 ∙ 12 + 1 ∙ 10 + 2 ∙ 8 + 1 ∙ 7 + 1 ∙ 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≅",{"$f":"ROUND(SUM(D11:AI11)/$AH$2,3)","v":9.125}]
[null,null,{"$f":"C22","v":8}]
[]
[]
[]
[null,null,{"$f":"CONCATENATE(D16,\" ∙ \",D12,\" + \",F16,\" ∙ \",F12,\" + \",H16,\" ∙ \",H12,\" + \",J16,\" ∙ \",J12,\" + \",L16,\" ∙ \",L12,\" + \",N16,\" ∙ \",N12,\" + \",P16,\" ∙ \",P12,\" + \",R16,\" ∙ \",R12,\" + \",T16,\" ∙ \",T12,\" + \",V16,\" ∙ \",V12,\" + \",X16,\" ∙ \",X12,\" + \",Z16,\" ∙ \",Z12,\" + \",AB16,\" ∙ \",AB12,\" + \",AD16,\" ∙ \",AD12,\" + \",AF16,\" ∙ \",AF12,\" + \",AH16,\" ∙ \",AH12,\" ≅ \",AK24)","v":"0 ∙ 15 + 0 ∙ 14 + 0,25 ∙ 13 + 0,125 ∙ 12 + 0 ∙ 11 + 0,125 ∙ 10 + 0 ∙ 9 + 0,25 ∙ 8 + 0,125 ∙ 7 + 0 ∙ 6 + 0 ∙ 5 + 0 ∙ 4 + 0 ∙ 3 + 0,125 ∙ 2 + 0 ∙ 1 + 0 ∙ 0 ≅ 9,125"}]

{"sheet":"Modalwert","index":5,"n_rows":55,"n_cols":44,"rows_kept":55,"cut":false,"hidden":false,"merged":[[9,27,9,28],[9,29,9,30],[9,31,9,32],[9,33,9,34],[10,1,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[9,15,9,16],[9,17,9,18],[9,19,9,20],[9,21,9,22],[9,23,9,24],[9,25,9,26],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,12],[9,13,9,14],[10,38,10,41],[10,42,10,43],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,12],[11,13,11,14],[11,15,11,16],[10,25,10,26],[10,27,10,28],[10,29,10,30],[10,31,10,32],[10,33,10,34],[10,36,10,37],[10,13,10,14],[10,15,10,16],[10,17,10,18],[10,19,10,20],[10,21,10,22],[10,23,10,24],[11,36,11,37],[11,38,11,41],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[11,29,11,30],[11,31,11,32],[11,33,11,34],[12,27,12,28],[12,29,12,30],[12,31,12,32],[12,33,12,34],[12,25,12,26],[12,13,12,14],[12,15,12,16],[12,17,12,18],[12,19,12,20],[12,21,12,22],[12,23,12,24],[11,42,11,43],[11,17,11,18],[11,19,11,20],[11,21,11,22],[11,23,11,24],[11,25,11,26],[11,27,11,28],[12,38,12,41],[12,42,12,43],[12,36,12,37],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[14,13,14,14],[14,15,14,16],[14,17,14,18],[13,19,13,20],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[13,15,13,16],[13,17,13,18],[14,31,14,32],[14,33,14,34],[14,19,14,20],[14,21,14,22],[14,23,14,24],[14,25,14,26],[14,27,14,28],[14,29,14,30],[13,31,13,32],[13,33,13,34],[13,21,13,22],[13,23,13,24],[13,25,13,26],[13,27,13,28],[13,29,13,30]]}
[]
[null,"Beispiel: Korrektur Matheklausur in der Oberstufe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(","Anzahl der Klausuren:",null,null,null,null,null,{"$f":"Urliste!P24","v":8},")",null,null,null,null,null,null,null,null,false]
[]
[null,"Urliste:"]
[]
[null,"Nummer der Klausur",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Notenpunkte ",null,{"$f":"IF(D6<=$AH$2,Urliste!D7,\"\")","v":12},{"$f":"IF(E6<=$AH$2,Urliste!E7,\"\")","v":13},{"$f":"IF(F6<=$AH$2,Urliste!F7,\"\")","v":8},{"$f":"IF(G6<=$AH$2,Urliste!G7,\"\")","v":7},{"$f":"IF(H6<=$AH$2,Urliste!H7,\"\")","v":8},{"$f":"IF(I6<=$AH$2,Urliste!I7,\"\")","v":10},{"$f":"IF(J6<=$AH$2,Urliste!J7,\"\")","v":2},{"$f":"IF(K6<=$AH$2,Urliste!K7,\"\")","v":13},{"$f":"IF(L6<=$AH$2,Urliste!L7,\"\")","v":""},{"$f":"IF(M6<=$AH$2,Urliste!M7,\"\")","v":""},{"$f":"IF(N6<=$AH$2,Urliste!N7,\"\")","v":""},{"$f":"IF(O6<=$AH$2,Urliste!O7,\"\")","v":""},{"$f":"IF(P6<=$AH$2,Urliste!P7,\"\")","v":""},{"$f":"IF(Q6<=$AH$2,Urliste!Q7,\"\")","v":""},{"$f":"IF(R6<=$AH$2,Urliste!R7,\"\")","v":""},{"$f":"IF(S6<=$AH$2,Urliste!S7,\"\")","v":""},{"$f":"IF(T6<=$AH$2,Urliste!T7,\"\")","v":""},{"$f":"IF(U6<=$AH$2,Urliste!U7,\"\")","v":""},{"$f":"IF(V6<=$AH$2,Urliste!V7,\"\")","v":""},{"$f":"IF(W6<=$AH$2,Urliste!W7,\"\")","v":""},{"$f":"IF(X6<=$AH$2,Urliste!X7,\"\")","v":""},{"$f":"IF(Y6<=$AH$2,Urliste!Y7,\"\")","v":""},{"$f":"IF(Z6<=$AH$2,Urliste!Z7,\"\")","v":""},{"$f":"IF(AA6<=$AH$2,Urliste!AA7,\"\")","v":""},{"$f":"IF(AB6<=$AH$2,Urliste!AB7,\"\")","v":""},{"$f":"IF(AC6<=$AH$2,Urliste!AC7,\"\")","v":""},{"$f":"IF(AD6<=$AH$2,Urliste!AD7,\"\")","v":""},{"$f":"IF(AE6<=$AH$2,Urliste!AE7,\"\")","v":""},{"$f":"IF(AF6<=$AH$2,Urliste!AF7,\"\")","v":""},{"$f":"IF(AG6<=$AH$2,Urliste!AG7,\"\")","v":""}]
[]
[null,"Häufigkeitstabelle:"]
[null,null,null,{"$f":"D12*D11","v":0},null,{"$f":"F12*F11","v":0},null,{"$f":"H12*H11","v":26},null,{"$f":"J12*J11","v":12},null,{"$f":"L12*L11","v":0},null,{"$f":"N12*N11","v":10},null,{"$f":"P12*P11","v":0},null,{"$f":"R12*R11","v":16},null,{"$f":"T12*T11","v":7},null,{"$f":"V12*V11","v":0},null,{"$f":"X12*X11","v":0},null,{"$f":"Z12*Z11","v":0},null,{"$f":"AB12*AB11","v":0},null,{"$f":"AD12*AD11","v":2},null,{"$f":"AF12*AF11","v":0},null,{"$f":"AH12*AH11","v":0}]
[null,"Notenpunkte",null,15,null,14,null,13,null,12,null,11,null,10,null,9,null,8,null,7,null,6,null,5,null,4,null,3,null,2,null,1,null,0,null,null,"Summe"]
[null,"absolute Häufigkeit",null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,D11),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,F11),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,H11),\"\")","v":2},null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,J11),\"\")","v":1},null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,L11),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,N11),\"\")","v":1},null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,P11),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,R11),\"\")","v":2},null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,T11),\"\")","v":1},null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,V11),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,X11),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,Z11),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,AB11),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,AD11),\"\")","v":1},null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,AF11),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,COUNTIF($D$7:$AG$7,AH11),\"\")","v":0},null,null,{"$f":"SUM(D12:AI12)","v":8}]
[null,"relative Häufigkeit",null,{"$f":"IF($AR$2=FALSE,ROUND(D12/$AH$2,3),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,ROUND(F12/$AH$2,3),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,ROUND(H12/$AH$2,3),\"\")","v":0.25},null,{"$f":"IF($AR$2=FALSE,ROUND(J12/$AH$2,3),\"\")","v":0.125},null,{"$f":"IF($AR$2=FALSE,ROUND(L12/$AH$2,3),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,ROUND(N12/$AH$2,3),\"\")","v":0.125},null,{"$f":"IF($AR$2=FALSE,ROUND(P12/$AH$2,3),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,ROUND(R12/$AH$2,3),\"\")","v":0.25},null,{"$f":"IF($AR$2=FALSE,ROUND(T12/$AH$2,3),\"\")","v":0.125},null,{"$f":"IF($AR$2=FALSE,ROUND(V12/$AH$2,3),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,ROUND(X12/$AH$2,3),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,ROUND(Z12/$AH$2,3),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,ROUND(AB12/$AH$2,3),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,ROUND(AD12/$AH$2,3),\"\")","v":0.125},null,{"$f":"IF($AR$2=FALSE,ROUND(AF12/$AH$2,3),\"\")","v":0},null,{"$f":"IF($AR$2=FALSE,ROUND(AH12/$AH$2,3),\"\")","v":0},null,null,{"$f":"SUM(D13:AI13)","v":1}]
[null,null,null,{"$f":"ROUND(D13,3)","v":0},null,{"$f":"ROUND(F13,3)","v":0},null,{"$f":"ROUND(H13,3)","v":0.25},null,{"$f":"ROUND(J13,3)","v":0.125},null,{"$f":"ROUND(L13,3)","v":0},null,{"$f":"ROUND(N13,3)","v":0.125},null,{"$f":"ROUND(P13,3)","v":0},null,{"$f":"ROUND(R13,3)","v":0.25},null,{"$f":"ROUND(T13,3)","v":0.125},null,{"$f":"ROUND(V13,3)","v":0},null,{"$f":"ROUND(X13,3)","v":0},null,{"$f":"ROUND(Z13,3)","v":0},null,{"$f":"ROUND(AB13,3)","v":0},null,{"$f":"ROUND(AD13,3)","v":0.125},null,{"$f":"ROUND(AF13,3)","v":0},null,{"$f":"ROUND(AH13,3)","v":0}]
[null,null,null,{"$f":"D13*D11","v":0},null,{"$f":"F13*F11","v":0},null,{"$f":"H13*H11","v":3.25},null,{"$f":"J13*J11","v":1.5},null,{"$f":"L13*L11","v":0},null,{"$f":"N13*N11","v":1.25},null,{"$f":"P13*P11","v":0},null,{"$f":"R13*R11","v":2},null,{"$f":"T13*T11","v":0.875},null,{"$f":"V13*V11","v":0},null,{"$f":"X13*X11","v":0},null,{"$f":"Z13*Z11","v":0},null,{"$f":"AB13*AB11","v":0},null,{"$f":"AD13*AD11","v":0.25},null,{"$f":"AF13*AF11","v":0},null,{"$f":"AH13*AH11","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Modalwert(e):",null,{"$f":"_xlfn.MODE.MULT(D7:AG7)","v":13},{"$f":"_xlfn.IFNA(D28,40)","v":13},null,null,"(Werte mit der größten relativen Häufigkeit)"]
[null,null,null,8,{"$f":"_xlfn.IFNA(D29,40)","v":8},{"$f":"IF(OR(E29=40,E29=$D$28),1,0)","v":0}]
[null,null,null,{"$error":"#N/A"},40,{"$f":"IF(OR(E30=40,E30=$D$28),1,0)","v":1}]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]
[null,null,null,{"$error":"#N/A"},40,1]

{"sheet":"Median","index":6,"n_rows":39,"n_cols":42,"rows_kept":39,"cut":false,"hidden":false,"merged":[[36,3,36,4],[37,3,37,4],[38,3,38,4],[37,21,37,23],[38,21,38,23],[51,5,51,6],[19,7,19,8],[21,7,21,8],[23,7,23,8],[24,7,24,8],[20,7,20,8],[22,7,22,8],[43,5,43,6],[47,5,47,6]]}
[]
[null,"Beispiel: Korrektur Matheklausur in der Oberstufe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(","Anzahl der Klausuren:",null,null,null,null,null,{"$f":"Urliste!P24","v":8},")",null,null,null,null,null,null,false]
[]
[null,"Urliste:"]
[]
[null,"Nummer der Klausur",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Notenpunkte ",null,{"$f":"IF(D6<=$AH$2,Urliste!D7,\"\")","v":12},{"$f":"IF(E6<=$AH$2,Urliste!E7,\"\")","v":13},{"$f":"IF(F6<=$AH$2,Urliste!F7,\"\")","v":8},{"$f":"IF(G6<=$AH$2,Urliste!G7,\"\")","v":7},{"$f":"IF(H6<=$AH$2,Urliste!H7,\"\")","v":8},{"$f":"IF(I6<=$AH$2,Urliste!I7,\"\")","v":10},{"$f":"IF(J6<=$AH$2,Urliste!J7,\"\")","v":2},{"$f":"IF(K6<=$AH$2,Urliste!K7,\"\")","v":13},{"$f":"IF(L6<=$AH$2,Urliste!L7,\"\")","v":""},{"$f":"IF(M6<=$AH$2,Urliste!M7,\"\")","v":""},{"$f":"IF(N6<=$AH$2,Urliste!N7,\"\")","v":""},{"$f":"IF(O6<=$AH$2,Urliste!O7,\"\")","v":""},{"$f":"IF(P6<=$AH$2,Urliste!P7,\"\")","v":""},{"$f":"IF(Q6<=$AH$2,Urliste!Q7,\"\")","v":""},{"$f":"IF(R6<=$AH$2,Urliste!R7,\"\")","v":""},{"$f":"IF(S6<=$AH$2,Urliste!S7,\"\")","v":""},{"$f":"IF(T6<=$AH$2,Urliste!T7,\"\")","v":""},{"$f":"IF(U6<=$AH$2,Urliste!U7,\"\")","v":""},{"$f":"IF(V6<=$AH$2,Urliste!V7,\"\")","v":""},{"$f":"IF(W6<=$AH$2,Urliste!W7,\"\")","v":""},{"$f":"IF(X6<=$AH$2,Urliste!X7,\"\")","v":""},{"$f":"IF(Y6<=$AH$2,Urliste!Y7,\"\")","v":""},{"$f":"IF(Z6<=$AH$2,Urliste!Z7,\"\")","v":""},{"$f":"IF(AA6<=$AH$2,Urliste!AA7,\"\")","v":""},{"$f":"IF(AB6<=$AH$2,Urliste!AB7,\"\")","v":""},{"$f":"IF(AC6<=$AH$2,Urliste!AC7,\"\")","v":""},{"$f":"IF(AD6<=$AH$2,Urliste!AD7,\"\")","v":""},{"$f":"IF(AE6<=$AH$2,Urliste!AE7,\"\")","v":""},{"$f":"IF(AF6<=$AH$2,Urliste!AF7,\"\")","v":""},{"$f":"IF(AG6<=$AH$2,Urliste!AG7,\"\")","v":""}]
[]
[null,"Der Große nach geordnet:"]
[]
[null,"Nummer der Klausur",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Notenpunkte ",null,{"$f":"IF(D11<=$AH$2,SMALL($D$7:$AG$7,D11),\"\")","v":2},{"$f":"IF(E11<=$AH$2,SMALL($D$7:$AG$7,E11),\"\")","v":7},8,8,10,12,13,13,"","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"Median (Lage):",null,{"$f":"IF(D11=$H$22,\"x\",\"\")","v":""},{"$f":"IF(E11=$H$22,\"x\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Untermedian (Lage):",null,{"$f":"IF(D11=$H$24,\"x\",\"\")","v":""},{"$f":"IF(E11=$H$24,\"x\",\"\")","v":""},"","x","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Obermedian (Lage):",null,{"$f":"IF(D11=$H$25,\"x\",\"\")","v":""},{"$f":"IF(E11=$H$25,\"x\",\"\")","v":""},"","","x","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"untere Hälfte:",null,{"$f":"IF(AND($H$21=FALSE,D11<$H$22),\"x\",IF(AND($H$23=FALSE,D11<=$H$24),\"x\",\"\"))","v":"x"},{"$f":"IF(AND($H$21=FALSE,E11<$H$22),\"x\",IF(AND($H$23=FALSE,E11<=$H$24),\"x\",\"\"))","v":"x"},"x","x","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"obere Hälfte:",null,{"$f":"IF(D11<=$H$20,IF(AND($H$21=FALSE,D11>$H$22),\"x\",IF(AND($H$23=FALSE,D11>$H$24),\"x\",\"\")),\"\")","v":""},{"$f":"IF(E11<=$H$20,IF(AND($H$21=FALSE,E11>$H$22),\"x\",IF(AND($H$23=FALSE,E11>$H$24),\"x\",\"\")),\"\")","v":""},"","","x","x","x","x","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"Anzahl:",null,null,null,null,null,{"$f":"AH2","v":8}]
[null,"gerade:",null,null,null,null,null,{"$f":"ISEVEN(H20)","v":true}]
[null,null,"Nummer Median:",null,null,null,null,{"$f":"IF(H21=FALSE,ROUNDUP(H20/2,0),\"\")","v":""}]
[null,"ungerade:",null,null,null,null,null,{"$f":"ISODD(H20)","v":false}]
[null,null,"Nummer Untermedian:",null,null,null,null,{"$f":"IF(H23=FALSE,ROUNDDOWN(H20/2,0),\"\")","v":4}]
[null,null,"Nummer Obermedian:",null,null,null,null,{"$f":"IF(H23=FALSE,H20/2+1,\"\")","v":5}]
[]
[null,"untere Hälfte:"]
[]
[null,"Nummer der Klausur",null,{"$f":"IF(D30=\"\",\"\",D6)","v":1},2,3,4,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Notenpunkte ",null,{"$f":"IF(D17=\"x\",IF(D6<=$AH$2,SMALL($D$7:$AG$7,D6),\"\"),\"\")","v":2},7,8,8,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"obere Hälfte:"]
[]
[null,"Nummer der Klausur",null,{"$f":"IF(D35=\"\",\"\",D6)","v":""},"","","",5,6,7,8,"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Notenpunkte ",null,{"$f":"IF(D18=\"x\",IF(D6<=$AH$2,SMALL($D$7:$AG$7,D6),\"\"),\"\")","v":""},"","","",10,12,13,13,"","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"Median x1/2 :",null,{"$f":"QUARTILE($D$12:$AG$12,2)","v":9},null,"(Wert, der die der Größe nach geordnete Reihe der Daten halbiert.)"]
[null,"Viertelwert x1/4 :",null,{"$f":"QUARTILE($D$30:$AG$30,2)","v":7.5},null,"(Median der unteren Hälfte)",null,null,null,null,null,null,null,null,null,null,null,"25%-Quartil:",null,null,null,{"$f":"QUARTILE($D$12:$AG$12,1)","v":7.75}]
[null,"Viertelwert x3/4 :",null,{"$f":"QUARTILE($D$35:$AG$35,2)","v":12.5},null,"(Median der oberen Hälfte)",null,null,null,null,null,null,null,null,null,null,null,"75%-Quartil:",null,null,null,{"$f":"QUARTILE($D$12:$AG$12,3)","v":12.25}]

{"sheet":"Spann- u. Halbweite","index":7,"n_rows":46,"n_cols":42,"rows_kept":46,"cut":false,"hidden":false,"merged":[[36,3,36,4],[37,3,37,4],[38,3,38,4],[40,3,40,4],[41,3,41,4],[37,21,37,22],[38,21,38,22],[47,5,47,6],[51,5,51,6],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[43,8,43,9],[45,8,45,9]]}
[]
[null,"Beispiel: Korrektur Matheklausur in der Oberstufe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(","Anzahl der Klausuren:",null,null,null,null,null,{"$f":"Urliste!P24","v":8},")",null,null,null,null,null,null,false]
[]
[null,"Urliste:"]
[]
[null,"Nummer der Klausur",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Notenpunkte ",null,{"$f":"IF(D6<=$AH$2,Urliste!D7,\"\")","v":12},{"$f":"IF(E6<=$AH$2,Urliste!E7,\"\")","v":13},{"$f":"IF(F6<=$AH$2,Urliste!F7,\"\")","v":8},{"$f":"IF(G6<=$AH$2,Urliste!G7,\"\")","v":7},{"$f":"IF(H6<=$AH$2,Urliste!H7,\"\")","v":8},{"$f":"IF(I6<=$AH$2,Urliste!I7,\"\")","v":10},{"$f":"IF(J6<=$AH$2,Urliste!J7,\"\")","v":2},{"$f":"IF(K6<=$AH$2,Urliste!K7,\"\")","v":13},{"$f":"IF(L6<=$AH$2,Urliste!L7,\"\")","v":""},{"$f":"IF(M6<=$AH$2,Urliste!M7,\"\")","v":""},{"$f":"IF(N6<=$AH$2,Urliste!N7,\"\")","v":""},{"$f":"IF(O6<=$AH$2,Urliste!O7,\"\")","v":""},{"$f":"IF(P6<=$AH$2,Urliste!P7,\"\")","v":""},{"$f":"IF(Q6<=$AH$2,Urliste!Q7,\"\")","v":""},{"$f":"IF(R6<=$AH$2,Urliste!R7,\"\")","v":""},{"$f":"IF(S6<=$AH$2,Urliste!S7,\"\")","v":""},{"$f":"IF(T6<=$AH$2,Urliste!T7,\"\")","v":""},{"$f":"IF(U6<=$AH$2,Urliste!U7,\"\")","v":""},{"$f":"IF(V6<=$AH$2,Urliste!V7,\"\")","v":""},{"$f":"IF(W6<=$AH$2,Urliste!W7,\"\")","v":""},{"$f":"IF(X6<=$AH$2,Urliste!X7,\"\")","v":""},{"$f":"IF(Y6<=$AH$2,Urliste!Y7,\"\")","v":""},{"$f":"IF(Z6<=$AH$2,Urliste!Z7,\"\")","v":""},{"$f":"IF(AA6<=$AH$2,Urliste!AA7,\"\")","v":""},{"$f":"IF(AB6<=$AH$2,Urliste!AB7,\"\")","v":""},{"$f":"IF(AC6<=$AH$2,Urliste!AC7,\"\")","v":""},{"$f":"IF(AD6<=$AH$2,Urliste!AD7,\"\")","v":""},{"$f":"IF(AE6<=$AH$2,Urliste!AE7,\"\")","v":""},{"$f":"IF(AF6<=$AH$2,Urliste!AF7,\"\")","v":""},{"$f":"IF(AG6<=$AH$2,Urliste!AG7,\"\")","v":""}]
[]
[null,"Der Große nach geordnet:"]
[]
[null,"Nummer der Klausur",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Notenpunkte ",null,{"$f":"IF(D11<=$AH$2,SMALL($D$7:$AG$7,D11),\"\")","v":2},{"$f":"IF(E11<=$AH$2,SMALL($D$7:$AG$7,E11),\"\")","v":7},8,8,10,12,13,13,"","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"Median (Lage):",null,{"$f":"IF(D11=$H$22,\"x\",\"\")","v":""},{"$f":"IF(E11=$H$22,\"x\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Untermedian (Lage):",null,{"$f":"IF(D11=$H$24,\"x\",\"\")","v":""},{"$f":"IF(E11=$H$24,\"x\",\"\")","v":""},"","x","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Obermedian (Lage):",null,{"$f":"IF(D11=$H$25,\"x\",\"\")","v":""},{"$f":"IF(E11=$H$25,\"x\",\"\")","v":""},"","","x","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"untere Hälfte:",null,{"$f":"IF(AND($H$21=FALSE,D11<$H$22),\"x\",IF(AND($H$23=FALSE,D11<=$H$24),\"x\",\"\"))","v":"x"},{"$f":"IF(AND($H$21=FALSE,E11<$H$22),\"x\",IF(AND($H$23=FALSE,E11<=$H$24),\"x\",\"\"))","v":"x"},"x","x","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"obere Hälfte:",null,{"$f":"IF(D11<=$H$20,IF(AND($H$21=FALSE,D11>$H$22),\"x\",IF(AND($H$23=FALSE,D11>$H$24),\"x\",\"\")),\"\")","v":""},{"$f":"IF(E11<=$H$20,IF(AND($H$21=FALSE,E11>$H$22),\"x\",IF(AND($H$23=FALSE,E11>$H$24),\"x\",\"\")),\"\")","v":""},"","","x","x","x","x","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"Anzahl:",null,null,null,null,null,{"$f":"AH2","v":8}]
[null,"gerade:",null,null,null,null,null,{"$f":"ISEVEN(H20)","v":true}]
[null,null,"Nummer Median:",null,null,null,null,{"$f":"IF(H21=FALSE,ROUNDUP(H20/2,0),\"\")","v":""}]
[null,"ungerade:",null,null,null,null,null,{"$f":"ISODD(H20)","v":false}]
[null,null,"Nummer Untermedian:",null,null,null,null,{"$f":"IF(H23=FALSE,ROUNDDOWN(H20/2,0),\"\")","v":4}]
[null,null,"Nummer Obermedian:",null,null,null,null,{"$f":"IF(H23=FALSE,H20/2+1,\"\")","v":5}]
[]
[null,"untere Hälfte:"]
[]
[null,"Nummer der Klausur",null,{"$f":"IF(D30=\"\",\"\",D6)","v":1},2,3,4,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Notenpunkte ",null,{"$f":"IF(D17=\"x\",IF(D6<=$AH$2,SMALL($D$7:$AG$7,D6),\"\"),\"\")","v":2},7,8,8,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"obere Hälfte:"]
[]
[null,"Nummer der Klausur",null,{"$f":"IF(D35=\"\",\"\",D6)","v":""},"","","",5,6,7,8,"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Notenpunkte ",null,{"$f":"IF(D18=\"x\",IF(D6<=$AH$2,SMALL($D$7:$AG$7,D6),\"\"),\"\")","v":""},"","","",10,12,13,13,"","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"Median x1/2 :",null,{"$f":"QUARTILE($D$12:$AG$12,2)","v":9},null,"(Wert, der die der Größe nach geordnete Reihe der Daten halbiert.)"]
[null,"Viertelwert x1/4 :",null,{"$f":"QUARTILE($D$30:$AG$30,2)","v":7.5},null,"(Median der unteren Hälfte)"]
[null,"Viertelwert x3/4 :",null,{"$f":"QUARTILE($D$35:$AG$35,2)","v":12.5},null,"(Median der oberen Hälfte)"]
[]
[null,"Minimalwert xmin :",null,{"$f":"MIN(D12:AG12)","v":2}]
[null,"Maximalwert xmax :",null,{"$f":"MAX(D12:AG12)","v":13}]
[]
[null,"Spannweite d:  ",null,"d  =  xmax  -  xmin  =",null,null,null,null,{"$f":"D42-D41","v":11}]
[]
[null,"Halbweite H:",null,"H  =  x3/4  -  x1/4 =",null,null,null,null,{"$f":"D39-D38","v":5}]

{"sheet":"Boxplot(30)","index":8,"n_rows":46,"n_cols":42,"rows_kept":46,"cut":false,"hidden":false,"merged":[[36,3,36,4],[37,3,37,4],[38,3,38,4],[40,3,40,4],[41,3,41,4],[37,21,37,22],[38,21,38,22],[47,5,47,6],[51,5,51,6],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[43,8,43,9],[45,8,45,9]]}
[]
[null,"Beispiel: Korrektur Matheklausur in der Oberstufe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(","Anzahl der Klausuren:",null,null,null,null,null,30,")",null,null,null,null,null,null,false]
[]
[null,"Urliste:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boxplot"]
[]
[null,"Nummer der Klausur",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Notenpunkte ",null,{"$f":"IF(D6<=$AH$2,Urliste!D7,\"\")","v":12},{"$f":"IF(E6<=$AH$2,Urliste!E7,\"\")","v":13},{"$f":"IF(F6<=$AH$2,Urliste!F7,\"\")","v":8},{"$f":"IF(G6<=$AH$2,Urliste!G7,\"\")","v":7},{"$f":"IF(H6<=$AH$2,Urliste!H7,\"\")","v":8},{"$f":"IF(I6<=$AH$2,Urliste!I7,\"\")","v":10},{"$f":"IF(J6<=$AH$2,Urliste!J7,\"\")","v":2},{"$f":"IF(K6<=$AH$2,Urliste!K7,\"\")","v":13},{"$f":"IF(L6<=$AH$2,Urliste!L7,\"\")","v":7},{"$f":"IF(M6<=$AH$2,Urliste!M7,\"\")","v":13},{"$f":"IF(N6<=$AH$2,Urliste!N7,\"\")","v":8},{"$f":"IF(O6<=$AH$2,Urliste!O7,\"\")","v":13},{"$f":"IF(P6<=$AH$2,Urliste!P7,\"\")","v":14},{"$f":"IF(Q6<=$AH$2,Urliste!Q7,\"\")","v":5},{"$f":"IF(R6<=$AH$2,Urliste!R7,\"\")","v":10},{"$f":"IF(S6<=$AH$2,Urliste!S7,\"\")","v":14},{"$f":"IF(T6<=$AH$2,Urliste!T7,\"\")","v":9},{"$f":"IF(U6<=$AH$2,Urliste!U7,\"\")","v":13},{"$f":"IF(V6<=$AH$2,Urliste!V7,\"\")","v":14},{"$f":"IF(W6<=$AH$2,Urliste!W7,\"\")","v":7},{"$f":"IF(X6<=$AH$2,Urliste!X7,\"\")","v":13},{"$f":"IF(Y6<=$AH$2,Urliste!Y7,\"\")","v":11},{"$f":"IF(Z6<=$AH$2,Urliste!Z7,\"\")","v":10},{"$f":"IF(AA6<=$AH$2,Urliste!AA7,\"\")","v":13},{"$f":"IF(AB6<=$AH$2,Urliste!AB7,\"\")","v":11},{"$f":"IF(AC6<=$AH$2,Urliste!AC7,\"\")","v":12},{"$f":"IF(AD6<=$AH$2,Urliste!AD7,\"\")","v":8},{"$f":"IF(AE6<=$AH$2,Urliste!AE7,\"\")","v":12},{"$f":"IF(AF6<=$AH$2,Urliste!AF7,\"\")","v":15},{"$f":"IF(AG6<=$AH$2,Urliste!AG7,\"\")","v":15}]
[null,null,null,{"$f":"IF($AP$2=FALSE,D7,\"\")","v":12},{"$f":"IF($AP$2=FALSE,E7,\"\")","v":13},8,7,8,10,2,13,7,13,8,13,14,5,10,14,9,13,14,7,13,11,10,13,11,12,8,12,15,15]
[null,"Der Große nach geordnet:"]
[]
[null,"Nummer der Klausur",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Notenpunkte ",null,{"$f":"IF(D11<=$AH$2,SMALL($D$7:$AG$7,D11),\"\")","v":2},{"$f":"IF(E11<=$AH$2,SMALL($D$7:$AG$7,E11),\"\")","v":5},7,7,7,8,8,8,8,9,10,10,10,11,11,12,12,12,13,13,13,13,13,13,13,14,14,14,15,15]
[]
[null,"Median (Lage):",null,{"$f":"IF(D11=$H$22,\"x\",\"\")","v":""},{"$f":"IF(E11=$H$22,\"x\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Untermedian (Lage):",null,{"$f":"IF(D11=$H$24,\"x\",\"\")","v":""},{"$f":"IF(E11=$H$24,\"x\",\"\")","v":""},"","","","","","","","","","","","","x","","","","","","","","","","","","","","",""]
[null,"Obermedian (Lage):",null,{"$f":"IF(D11=$H$25,\"x\",\"\")","v":""},{"$f":"IF(E11=$H$25,\"x\",\"\")","v":""},"","","","","","","","","","","","","","x","","","","","","","","","","","","","",""]
[null,"untere Hälfte:",null,{"$f":"IF(AND($H$21=FALSE,D11<$H$22),\"x\",IF(AND($H$23=FALSE,D11<=$H$24),\"x\",\"\"))","v":"x"},{"$f":"IF(AND($H$21=FALSE,E11<$H$22),\"x\",IF(AND($H$23=FALSE,E11<=$H$24),\"x\",\"\"))","v":"x"},"x","x","x","x","x","x","x","x","x","x","x","x","x","","","","","","","","","","","","","","",""]
[null,"obere Hälfte:",null,{"$f":"IF(D11<=$H$20,IF(AND($H$21=FALSE,D11>$H$22),\"x\",IF(AND($H$23=FALSE,D11>$H$24),\"x\",\"\")),\"\")","v":""},{"$f":"IF(E11<=$H$20,IF(AND($H$21=FALSE,E11>$H$22),\"x\",IF(AND($H$23=FALSE,E11>$H$24),\"x\",\"\")),\"\")","v":""},"","","","","","","","","","","","","","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[]
[null,"Anzahl:",null,null,null,null,null,{"$f":"AH2","v":30}]
[null,"gerade:",null,null,null,null,null,{"$f":"ISEVEN(H20)","v":true}]
[null,null,"Nummer Median:",null,null,null,null,{"$f":"IF(H21=FALSE,ROUNDUP(H20/2,0),\"\")","v":""}]
[null,"ungerade:",null,null,null,null,null,{"$f":"ISODD(H20)","v":false}]
[null,null,"Nummer Untermedian:",null,null,null,null,{"$f":"IF(H23=FALSE,ROUNDDOWN(H20/2,0),\"\")","v":15}]
[null,null,"Nummer Obermedian:",null,null,null,null,{"$f":"IF(H23=FALSE,H20/2+1,\"\")","v":16}]
[]
[null,"untere Hälfte:"]
[]
[null,"Nummer der Klausur",null,{"$f":"IF(D30=\"\",\"\",D6)","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,"","","","","","","","","","","","","","",""]
[null,"Notenpunkte ",null,{"$f":"IF(D17=\"x\",IF(D6<=$AH$2,SMALL($D$7:$AG$7,D6),\"\"),\"\")","v":2},5,7,7,7,8,8,8,8,9,10,10,10,11,11,"","","","","","","","","","","","","","",""]
[]
[null,"obere Hälfte:"]
[]
[null,"Nummer der Klausur",null,{"$f":"IF(D35=\"\",\"\",D6)","v":""},"","","","","","","","","","","","","","",16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Notenpunkte ",null,{"$f":"IF(D18=\"x\",IF(D6<=$AH$2,SMALL($D$7:$AG$7,D6),\"\"),\"\")","v":""},"","","","","","","","","","","","","","",12,12,12,13,13,13,13,13,13,13,14,14,14,15,15]
[]
[null,"Median x1/2 :",null,{"$f":"QUARTILE($D$12:$AG$12,2)","v":11.5},null,"(Wert, der die der Größe nach geordnete Reihe der Daten halbiert.)"]
[null,"Viertelwert x1/4 :",null,{"$f":"QUARTILE($D$30:$AG$30,2)","v":8},null,"(Median der unteren Hälfte)"]
[null,"Viertelwert x3/4 :",null,{"$f":"QUARTILE($D$35:$AG$35,2)","v":13},null,"(Median der oberen Hälfte)"]
[]
[null,"Minimalwert xmin :",null,{"$f":"MIN(D12:AG12)","v":2}]
[null,"Maximalwert xmax :",null,{"$f":"MAX(D12:AG12)","v":15}]
[]
[null,"Spannweite d:  ",null,"d  =  xmax  -  xmin  =",null,null,null,null,{"$f":"D42-D41","v":13}]
[]
[null,"Halbweite H:",null,"H  =  x3/4  -  x1/4 =",null,null,null,null,{"$f":"D39-D38","v":5}]

{"sheet":"Streuung","index":9,"n_rows":39,"n_cols":45,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,3,38,5],[38,7,38,10],[17,33,17,34],[24,2,24,34],[23,36,24,38],[23,35,24,35],[23,2,23,34],[19,27,19,28],[19,29,19,30],[19,31,19,32],[19,33,19,34],[34,2,34,34],[33,35,34,35],[30,35,31,35],[19,15,19,16],[19,17,19,18],[19,19,19,20],[19,21,19,22],[19,23,19,24],[19,25,19,26],[18,29,18,30],[18,31,18,32],[18,5,18,6],[18,7,18,8],[30,36,31,38],[33,40,34,42],[17,31,17,32],[17,11,17,12],[17,13,17,14],[17,15,17,16],[17,17,17,18],[17,19,17,20],[17,21,17,22],[18,33,18,34],[33,2,33,34],[19,3,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[18,17,18,18],[18,19,18,20],[18,21,18,22],[18,23,18,24],[18,25,18,26],[18,27,18,28],[30,2,30,34],[31,2,31,34],[18,3,18,4],[15,21,15,22],[15,23,15,24],[15,25,15,26],[15,27,15,28],[15,29,15,30],[16,13,16,14],[16,15,16,16],[16,17,16,18],[15,19,15,20],[18,9,18,10],[18,11,18,12],[18,13,18,14],[18,15,18,16],[26,2,26,34],[26,35,27,35],[26,36,27,38],[27,2,27,34],[16,31,16,32],[16,33,16,34],[17,3,17,4],[17,5,17,6],[17,7,17,8],[17,9,17,10],[16,19,16,20],[16,21,16,22],[16,23,16,24],[16,25,16,26],[16,27,16,28],[16,29,16,30],[17,23,17,24],[17,25,17,26],[17,27,17,28],[17,29,17,30],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[14,38,14,41],[14,42,14,43],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[15,17,15,18],[14,25,14,26],[14,27,14,28],[14,29,14,30],[14,31,14,32],[14,33,14,34],[14,36,14,37],[14,13,14,14],[14,15,14,16],[14,17,14,18],[14,19,14,20],[14,21,14,22],[14,23,14,24],[15,31,15,32],[15,33,15,34],[13,27,13,28],[13,29,13,30],[13,31,13,32],[13,33,13,34],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[13,15,13,16],[13,17,13,18],[13,19,13,20],[13,21,13,22],[13,23,13,24],[13,25,13,26],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[12,33,12,34],[12,36,12,37],[12,38,12,41],[12,42,12,43],[12,17,12,18],[12,19,12,20],[12,21,12,22],[12,23,12,24],[12,25,12,26],[12,27,12,28],[11,38,11,41],[11,42,11,43],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[12,15,12,16],[11,25,11,26],[11,27,11,28],[11,29,11,30],[11,31,11,32],[11,33,11,34],[11,36,11,37],[11,13,11,14],[11,15,11,16],[11,17,11,18],[11,19,11,20],[11,21,11,22],[11,23,11,24],[12,29,12,30],[12,31,12,32],[10,27,10,28],[10,29,10,30],[10,31,10,32],[10,33,10,34],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,12],[10,15,10,16],[10,17,10,18],[10,19,10,20],[10,21,10,22],[10,23,10,24],[10,25,10,26],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[10,13,10,14]]}
[]
[null,"Beispiel: Korrektur Matheklausur in der Oberstufe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(","Anzahl der Klausuren:",null,null,null,null,null,{"$f":"Urliste!P24","v":8},")",null,null,null,null,null,null,null,null,null,false]
[]
[null,"Urliste:"]
[]
[null,"Nummer der Klausur",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Notenpunkte ",null,{"$f":"IF(D6<=$AH$2,Urliste!D7,\"\")","v":12},{"$f":"IF(E6<=$AH$2,Urliste!E7,\"\")","v":13},{"$f":"IF(F6<=$AH$2,Urliste!F7,\"\")","v":8},{"$f":"IF(G6<=$AH$2,Urliste!G7,\"\")","v":7},{"$f":"IF(H6<=$AH$2,Urliste!H7,\"\")","v":8},{"$f":"IF(I6<=$AH$2,Urliste!I7,\"\")","v":10},{"$f":"IF(J6<=$AH$2,Urliste!J7,\"\")","v":2},{"$f":"IF(K6<=$AH$2,Urliste!K7,\"\")","v":13},{"$f":"IF(L6<=$AH$2,Urliste!L7,\"\")","v":""},{"$f":"IF(M6<=$AH$2,Urliste!M7,\"\")","v":""},{"$f":"IF(N6<=$AH$2,Urliste!N7,\"\")","v":""},{"$f":"IF(O6<=$AH$2,Urliste!O7,\"\")","v":""},{"$f":"IF(P6<=$AH$2,Urliste!P7,\"\")","v":""},{"$f":"IF(Q6<=$AH$2,Urliste!Q7,\"\")","v":""},{"$f":"IF(R6<=$AH$2,Urliste!R7,\"\")","v":""},{"$f":"IF(S6<=$AH$2,Urliste!S7,\"\")","v":""},{"$f":"IF(T6<=$AH$2,Urliste!T7,\"\")","v":""},{"$f":"IF(U6<=$AH$2,Urliste!U7,\"\")","v":""},{"$f":"IF(V6<=$AH$2,Urliste!V7,\"\")","v":""},{"$f":"IF(W6<=$AH$2,Urliste!W7,\"\")","v":""},{"$f":"IF(X6<=$AH$2,Urliste!X7,\"\")","v":""},{"$f":"IF(Y6<=$AH$2,Urliste!Y7,\"\")","v":""},{"$f":"IF(Z6<=$AH$2,Urliste!Z7,\"\")","v":""},{"$f":"IF(AA6<=$AH$2,Urliste!AA7,\"\")","v":""},{"$f":"IF(AB6<=$AH$2,Urliste!AB7,\"\")","v":""},{"$f":"IF(AC6<=$AH$2,Urliste!AC7,\"\")","v":""},{"$f":"IF(AD6<=$AH$2,Urliste!AD7,\"\")","v":""},{"$f":"IF(AE6<=$AH$2,Urliste!AE7,\"\")","v":""},{"$f":"IF(AF6<=$AH$2,Urliste!AF7,\"\")","v":""},{"$f":"IF(AG6<=$AH$2,Urliste!AG7,\"\")","v":""}]
[]
[]
[null,"Häufigkeitstabelle:"]
[null,null,null,{"$f":"D13*D12","v":0},null,{"$f":"F13*F12","v":0},null,{"$f":"H13*H12","v":26},null,{"$f":"J13*J12","v":12},null,{"$f":"L13*L12","v":0},null,{"$f":"N13*N12","v":10},null,{"$f":"P13*P12","v":0},null,{"$f":"R13*R12","v":16},null,{"$f":"T13*T12","v":7},null,{"$f":"V13*V12","v":0},null,{"$f":"X13*X12","v":0},null,{"$f":"Z13*Z12","v":0},null,{"$f":"AB13*AB12","v":0},null,{"$f":"AD13*AD12","v":2},null,{"$f":"AF13*AF12","v":0},null,{"$f":"AH13*AH12","v":0}]
[null,"Notenpunkte",null,15,null,14,null,13,null,12,null,11,null,10,null,9,null,8,null,7,null,6,null,5,null,4,null,3,null,2,null,1,null,0,null,null,"Summe"]
[null,"absolute Häufigkeit",null,{"$f":"COUNTIF($D$7:$AG$7,D12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,F12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,H12)","v":2},null,{"$f":"COUNTIF($D$7:$AG$7,J12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,L12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,N12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,P12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,R12)","v":2},null,{"$f":"COUNTIF($D$7:$AG$7,T12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,V12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,X12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,Z12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,AB12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,AD12)","v":1},null,{"$f":"COUNTIF($D$7:$AG$7,AF12)","v":0},null,{"$f":"COUNTIF($D$7:$AG$7,AH12)","v":0},null,null,{"$f":"SUM(D13:AI13)","v":8}]
[null,null,null,{"$f":"IF(D13>0,CONCATENATE(\" + \",D13,\" ∙ \",D12),\"\")","v":""},null,{"$f":"IF(F13>0,CONCATENATE(\" + \",F13,\" ∙ \",F12),\"\")","v":""},null,{"$f":"IF(H13>0,CONCATENATE(\" + \",H13,\" ∙ \",H12),\"\")","v":" + 2 ∙ 13"},null,{"$f":"IF(J13>0,CONCATENATE(\" + \",J13,\" ∙ \",J12),\"\")","v":" + 1 ∙ 12"},null,{"$f":"IF(L13>0,CONCATENATE(\" + \",L13,\" ∙ \",L12),\"\")","v":""},null,{"$f":"IF(N13>0,CONCATENATE(\" + \",N13,\" ∙ \",N12),\"\")","v":" + 1 ∙ 10"},null,{"$f":"IF(P13>0,CONCATENATE(\" + \",P13,\" ∙ \",P12),\"\")","v":""},null,{"$f":"IF(R13>0,CONCATENATE(\" + \",R13,\" ∙ \",R12),\"\")","v":" + 2 ∙ 8"},null,{"$f":"IF(T13>0,CONCATENATE(\" + \",T13,\" ∙ \",T12),\"\")","v":" + 1 ∙ 7"},null,{"$f":"IF(V13>0,CONCATENATE(\" + \",V13,\" ∙ \",V12),\"\")","v":""},null,{"$f":"IF(X13>0,CONCATENATE(\" + \",X13,\" ∙ \",X12),\"\")","v":""},null,{"$f":"IF(Z13>0,CONCATENATE(\" + \",Z13,\" ∙ \",Z12),\"\")","v":""},null,{"$f":"IF(AB13>0,CONCATENATE(\" + \",AB13,\" ∙ \",AB12),\"\")","v":""},null,{"$f":"IF(AD13>0,CONCATENATE(\" + \",AD13,\" ∙ \",AD12),\"\")","v":" + 1 ∙ 2"},null,{"$f":"IF(AF13>0,CONCATENATE(\" + \",AF13,\" ∙ \",AF12),\"\")","v":""},null,{"$f":"IF(AH13>0,CONCATENATE(\" + \",AH13,\" ∙ \",AH12),\"\")","v":""}]
[null,"relative Häufigkeit",null,{"$f":"ROUND(D13/$AH$2,3)","v":0},null,{"$f":"ROUND(F13/$AH$2,3)","v":0},null,{"$f":"ROUND(H13/$AH$2,3)","v":0.25},null,{"$f":"ROUND(J13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(L13/$AH$2,3)","v":0},null,{"$f":"ROUND(N13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(P13/$AH$2,3)","v":0},null,{"$f":"ROUND(R13/$AH$2,3)","v":0.25},null,{"$f":"ROUND(T13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(V13/$AH$2,3)","v":0},null,{"$f":"ROUND(X13/$AH$2,3)","v":0},null,{"$f":"ROUND(Z13/$AH$2,3)","v":0},null,{"$f":"ROUND(AB13/$AH$2,3)","v":0},null,{"$f":"ROUND(AD13/$AH$2,3)","v":0.125},null,{"$f":"ROUND(AF13/$AH$2,3)","v":0},null,{"$f":"ROUND(AH13/$AH$2,3)","v":0},null,null,{"$f":"SUM(D15:AI15)","v":1}]
[null,null,null,{"$f":"ROUND(D15,3)","v":0},null,{"$f":"ROUND(F15,3)","v":0},null,{"$f":"ROUND(H15,3)","v":0.25},null,{"$f":"ROUND(J15,3)","v":0.125},null,{"$f":"ROUND(L15,3)","v":0},null,{"$f":"ROUND(N15,3)","v":0.125},null,{"$f":"ROUND(P15,3)","v":0},null,{"$f":"ROUND(R15,3)","v":0.25},null,{"$f":"ROUND(T15,3)","v":0.125},null,{"$f":"ROUND(V15,3)","v":0},null,{"$f":"ROUND(X15,3)","v":0},null,{"$f":"ROUND(Z15,3)","v":0},null,{"$f":"ROUND(AB15,3)","v":0},null,{"$f":"ROUND(AD15,3)","v":0.125},null,{"$f":"ROUND(AF15,3)","v":0},null,{"$f":"ROUND(AH15,3)","v":0}]
[null,null,null,{"$f":"IF($AS$2=FALSE,D13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,F13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,H13,\"\")","v":2},null,{"$f":"IF($AS$2=FALSE,J13,\"\")","v":1},null,{"$f":"IF($AS$2=FALSE,L13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,N13,\"\")","v":1},null,{"$f":"IF($AS$2=FALSE,P13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,R13,\"\")","v":2},null,{"$f":"IF($AS$2=FALSE,T13,\"\")","v":1},null,{"$f":"IF($AS$2=FALSE,V13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,X13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,Z13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,AB13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,AD13,\"\")","v":1},null,{"$f":"IF($AS$2=FALSE,AF13,\"\")","v":0},null,{"$f":"IF($AS$2=FALSE,AH13,\"\")","v":0}]
[null,null,null,{"$f":"IF(D13>0,CONCATENATE(\" + (\",D12,\" - \",$AK$24,\")² ∙ \",D13),\"\")","v":""},null,{"$f":"IF(F13>0,CONCATENATE(\" + (\",F12,\" - \",$AK$24,\")² ∙ \",F13),\"\")","v":""},null,{"$f":"IF(H13>0,CONCATENATE(\" + (\",H12,\" - \",$AK$24,\")² ∙ \",H13),\"\")","v":" + (13 - 9,125)² ∙ 2"},null,{"$f":"IF(J13>0,CONCATENATE(\" + (\",J12,\" - \",$AK$24,\")² ∙ \",J13),\"\")","v":" + (12 - 9,125)² ∙ 1"},null,{"$f":"IF(L13>0,CONCATENATE(\" + (\",L12,\" - \",$AK$24,\")² ∙ \",L13),\"\")","v":""},null,{"$f":"IF(N13>0,CONCATENATE(\" + (\",N12,\" - \",$AK$24,\")² ∙ \",N13),\"\")","v":" + (10 - 9,125)² ∙ 1"},null,{"$f":"IF(P13>0,CONCATENATE(\" + (\",P12,\" - \",$AK$24,\")² ∙ \",P13),\"\")","v":""},null,{"$f":"IF(R13>0,CONCATENATE(\" + (\",R12,\" - \",$AK$24,\")² ∙ \",R13),\"\")","v":" + (8 - 9,125)² ∙ 2"},null,{"$f":"IF(T13>0,CONCATENATE(\" + (\",T12,\" - \",$AK$24,\")² ∙ \",T13),\"\")","v":" + (7 - 9,125)² ∙ 1"},null,{"$f":"IF(V13>0,CONCATENATE(\" + (\",V12,\" - \",$AK$24,\")² ∙ \",V13),\"\")","v":""},null,{"$f":"IF(X13>0,CONCATENATE(\" + (\",X12,\" - \",$AK$24,\")² ∙ \",X13),\"\")","v":""},null,{"$f":"IF(Z13>0,CONCATENATE(\" + (\",Z12,\" - \",$AK$24,\")² ∙ \",Z13),\"\")","v":""},null,{"$f":"IF(AB13>0,CONCATENATE(\" + (\",AB12,\" - \",$AK$24,\")² ∙ \",AB13),\"\")","v":""},null,{"$f":"IF(AD13>0,CONCATENATE(\" + (\",AD12,\" - \",$AK$24,\")² ∙ \",AD13),\"\")","v":" + (2 - 9,125)² ∙ 1"},null,{"$f":"IF(AF13>0,CONCATENATE(\" + (\",AF12,\" - \",$AK$24,\")² ∙ \",AF13),\"\")","v":""},null,{"$f":"IF(AH13>0,CONCATENATE(\" + (\",AH12,\" - \",$AK$24,\")² ∙ \",AH13),\"\")","v":""}]
[null,null,null,{"$f":"IF(D13>0,ROUND((D12-$AK$24)^2*D13,3),\"\")","v":""},null,{"$f":"IF(F13>0,ROUND((F12-$AK$24)^2*F13,3),\"\")","v":""},null,{"$f":"IF(H13>0,ROUND((H12-$AK$24)^2*H13,3),\"\")","v":30.030999999999999},null,{"$f":"IF(J13>0,ROUND((J12-$AK$24)^2*J13,3),\"\")","v":8.266},null,{"$f":"IF(L13>0,ROUND((L12-$AK$24)^2*L13,3),\"\")","v":""},null,{"$f":"IF(N13>0,ROUND((N12-$AK$24)^2*N13,3),\"\")","v":0.76600000000000001},null,{"$f":"IF(P13>0,ROUND((P12-$AK$24)^2*P13,3),\"\")","v":""},null,{"$f":"IF(R13>0,ROUND((R12-$AK$24)^2*R13,3),\"\")","v":2.5310000000000001},null,{"$f":"IF(T13>0,ROUND((T12-$AK$24)^2*T13,3),\"\")","v":4.516},null,{"$f":"IF(V13>0,ROUND((V12-$AK$24)^2*V13,3),\"\")","v":""},null,{"$f":"IF(X13>0,ROUND((X12-$AK$24)^2*X13,3),\"\")","v":""},null,{"$f":"IF(Z13>0,ROUND((Z12-$AK$24)^2*Z13,3),\"\")","v":""},null,{"$f":"IF(AB13>0,ROUND((AB12-$AK$24)^2*AB13,3),\"\")","v":""},null,{"$f":"IF(AD13>0,ROUND((AD12-$AK$24)^2*AD13,3),\"\")","v":50.765999999999998},null,{"$f":"IF(AF13>0,ROUND((AF12-$AK$24)^2*AF13,3),\"\")","v":""},null,{"$f":"IF(AH13>0,ROUND((AH12-$AK$24)^2*AH13,3),\"\")","v":""}]
[null,null,null,{"$f":"IF(D13>0,CONCATENATE(\" + \",D19),\"\")","v":""},null,{"$f":"IF(F13>0,CONCATENATE(\" + \",F19),\"\")","v":""},null,{"$f":"IF(H13>0,CONCATENATE(\" + \",H19),\"\")","v":" + 30,031"},null,{"$f":"IF(J13>0,CONCATENATE(\" + \",J19),\"\")","v":" + 8,266"},null,{"$f":"IF(L13>0,CONCATENATE(\" + \",L19),\"\")","v":""},null,{"$f":"IF(N13>0,CONCATENATE(\" + \",N19),\"\")","v":" + 0,766"},null,{"$f":"IF(P13>0,CONCATENATE(\" + \",P19),\"\")","v":""},null,{"$f":"IF(R13>0,CONCATENATE(\" + \",R19),\"\")","v":" + 2,531"},null,{"$f":"IF(T13>0,CONCATENATE(\" + \",T19),\"\")","v":" + 4,516"},null,{"$f":"IF(V13>0,CONCATENATE(\" + \",V19),\"\")","v":""},null,{"$f":"IF(X13>0,CONCATENATE(\" + \",X19),\"\")","v":""},null,{"$f":"IF(Z13>0,CONCATENATE(\" + \",Z19),\"\")","v":""},null,{"$f":"IF(AB13>0,CONCATENATE(\" + \",AB19),\"\")","v":""},null,{"$f":"IF(AD13>0,CONCATENATE(\" + \",AD19),\"\")","v":" + 50,766"},null,{"$f":"IF(AF13>0,CONCATENATE(\" + \",AF19),\"\")","v":""},null,{"$f":"IF(AH13>0,CONCATENATE(\" + \",AH19),\"\")","v":""}]
[]
[]
[]
[null,null,{"$f":"CONCATENATE(D13,\" ∙ \",D12,\" + \",F13,\" ∙ \",F12,\" + \",H13,\" ∙ \",H12,\" + \",J13,\" ∙ \",J12,\" + \",L13,\" ∙ \",L12,\" + \",N13,\" ∙ \",N12,\" + \",P13,\" ∙ \",P12,\" + \",R13,\" ∙ \",R12,\" + \",T13,\" ∙ \",T12,\" + \",V13,\" ∙ \",V12,\" + \",X13,\" ∙ \",X12,\" + \",Z13,\" ∙ \",Z12,\" + \",AB13,\" ∙ \",AB12,\" + \",AD13,\" ∙ \",AD12,\" + \",AF13,\" ∙ \",AF12,\" + \",AH13,\" ∙ \",AH12)","v":"0 ∙ 15 + 0 ∙ 14 + 2 ∙ 13 + 1 ∙ 12 + 0 ∙ 11 + 1 ∙ 10 + 0 ∙ 9 + 2 ∙ 8 + 1 ∙ 7 + 0 ∙ 6 + 0 ∙ 5 + 0 ∙ 4 + 0 ∙ 3 + 1 ∙ 2 + 0 ∙ 1 + 0 ∙ 0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≅",{"$f":"ROUND(SUM(D11:AI11)/$AH$2,3)","v":9.125}]
[null,null,{"$f":"$AH$2","v":8}]
[]
[null,null,{"$f":"CONCATENATE(D14,F14,H14,J14,L14,N14,P14,R14,T14,V14,X14,Z14,AB14,AD14,AF14,AH14)","v":" + 2 ∙ 13 + 1 ∙ 12 + 1 ∙ 10 + 2 ∙ 8 + 1 ∙ 7 + 1 ∙ 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≅",{"$f":"ROUND(SUM(D11:AI11)/$AH$2,3)","v":9.125}]
[null,null,{"$f":"C25","v":8}]
[]
[]
[null,null,{"$f":"CONCATENATE(D18,F18,H18,J18,L18,N18,P18,R18,T18,V18,X18,Z18,AB18,AD18,AF18,AH18,)","v":" + (13 - 9,125)² ∙ 2 + (12 - 9,125)² ∙ 1 + (10 - 9,125)² ∙ 1 + (8 - 9,125)² ∙ 2 + (7 - 9,125)² ∙ 1 + (2 - 9,125)² ∙ 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≅",{"$f":"ROUND(SUM(D19:AI19)/$AH$2,3)","v":12.11}]
[null,null,{"$f":"$AH$2","v":8}]
[]
[null,null,{"$f":"CONCATENATE(D20,F20,H20,J20,L20,N20,P20,R20,T20,V20,X20,Z20,AB20,AD20,AF20,AH20)","v":" + 30,031 + 8,266 + 0,766 + 2,531 + 4,516 + 50,766"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≅"]
[null,null,{"$f":"$AH$2","v":8}]
[]
[]
[]
[null,null,null,{"$f":"ROUND(SQRT(AK31),3)","v":3.48}]