{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Worksheet","SYSTEM FORMULAE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Worksheet","index":0,"n_rows":20,"n_cols":43,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,2,0,28],[1,0,1,1]]}
[null,null,"Find the median and quartiles of each set of numbers and write a five-figure summary"]
["Variables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lowest","lower quartile (Q1)","median (Q2)","upper quartile (Q3)","highest"]
["SHOW ANSWERS?",{"$f":"AQ9","v":false},"a)",7,0,3,9,5,2,1,5,3,6,7,3,0,6,7,0,11,8,5,""]
["Lists of numbers already in order?",true,null,0,0,0,1,2,3,3,3,5,5,5,6,6,7,7,7,8,9,11,"",null,0,2,5,7,11]
[null,null,"b)",21,13,35,3,35,30,44,15,4,2,17,8,"","","","","","","",""]
[null,null,null,2,3,4,8,13,15,17,21,30,35,35,44,"","","","","","","","",null,2,6,16,32.5,44]
[null,null,"c)",13,15,11,14,17,14,10,9,13,12,14,15,11,13,18,"","","","",""]
[null,null,null,9,10,11,11,12,13,13,13,14,14,14,15,15,17,18,"","","","","",null,9,11,13,15,18]
[null,null,"d)",15,20,14,6,24,20,21,28,14,15,25,15,16,"","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,6,14,14,15,15,15,16,20,20,21,24,25,28,"","","","","","","",null,6,14.5,16,22.5,28]
[null,null,"e)",35,52,34,51,47,56,41,41,26,37,46,43,36,50,"","","","","",""]
[null,null,null,26,34,35,36,37,41,41,43,46,47,50,51,52,56,"","","","","","",null,26,36,42,50,56]
[null,null,"f)",13,13,13,13,13,12,12,13,13,13,13,12,12,13,12,13,"","","",""]
[null,null,null,12,12,12,12,12,13,13,13,13,13,13,13,13,13,13,13,"","","","",null,12,12,13,13,13]
[null,null,"g)",15,17,2,9,17,3,11,12,11,7,20,4,6,21,14,13,1,7,"",""]
[null,null,null,1,2,3,4,6,7,7,9,11,11,12,13,14,15,17,17,20,21,"","",null,1,6,11,15,21]
[null,null,"h)",11,11,24,8,15,2,21,23,20,17,12,4,15,24,10,9,21,"","",""]
[null,null,null,2,4,8,9,10,11,11,12,15,15,17,20,21,21,23,24,24,"","","",null,2,9.5,15,21,24]
[null,null,"i)",7,14,15,9,21,12,21,9,4,28,6,7,8,15,6,"","","","",""]
[null,null,null,4,6,6,7,7,8,9,9,12,14,15,15,21,21,28,"","","","","",null,4,7,9,15,28]

{"sheet":"SYSTEM FORMULAE","index":1,"n_rows":19,"n_cols":34,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lowest","lower quartile","median","upper quartile","highest"]
["a)",{"$f":"ABS(INT(NORMINV(RAND(),$AE2,$AF2)))","v":16},{"$f":"ABS(INT(NORMINV(RAND(),$AE2,$AF2)))","v":17},13,11,14,3,12,34,4,15,{"$f":"IF($AD2<11,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":2},{"$f":"IF($AD2<12,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":20},{"$f":"IF($AD2<13,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":3},{"$f":"IF($AD2<14,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":26},{"$f":"IF($AD2<15,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":17},{"$f":"IF($AD2<16,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":16},{"$f":"IF($AD2<17,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":2},{"$f":"IF($AD2<18,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":17},{"$f":"IF($AD2<19,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":2},{"$f":"IF($AD2<20,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":""},null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(10,20)","v":19},{"$f":"IF(RAND()<0.7,RANDBETWEEN(3,20),RANDBETWEEN(20,100))","v":14},{"$f":"RAND()*20","v":9.4233323303684724}]
[null,{"$f":"IF(ISERROR(LARGE($B2:$U2,$AD2-COLUMN()+2)),\"\",LARGE($B2:$U2,$AD2-COLUMN()+2))","v":2},{"$f":"IF(ISERROR(LARGE($B2:$U2,$AD2-COLUMN()+2)),\"\",LARGE($B2:$U2,$AD2-COLUMN()+2))","v":2},{"$f":"IF(ISERROR(LARGE($B2:$U2,$AD2-COLUMN()+2)),\"\",LARGE($B2:$U2,$AD2-COLUMN()+2))","v":2},{"$f":"IF(ISERROR(LARGE($B2:$U2,$AD2-COLUMN()+2)),\"\",LARGE($B2:$U2,$AD2-COLUMN()+2))","v":3},{"$f":"IF(ISERROR(LARGE($B2:$U2,$AD2-COLUMN()+2)),\"\",LARGE($B2:$U2,$AD2-COLUMN()+2))","v":3},4,11,12,13,14,15,{"$f":"IF(ISERROR(LARGE($B2:$U2,$AD2-COLUMN()+2)),\"\",LARGE($B2:$U2,$AD2-COLUMN()+2))","v":16},16,17,17,17,20,26,34,"",null,{"$f":"QUARTILE($B2:$V2,0)","v":2},{"$f":"IF(MOD($AD2,4)=3,OFFSET(A3,0,($AD2+1)/4),IF(MOD($AD2,4)=2,OFFSET(A3,0,($AD2+2)/4),IF(MOD($AD2,4)=1,AVERAGE(OFFSET(A3,0,($AD2-1)/4),OFFSET(A3,0,(($AD2-1)/4)+1)),AVERAGE(OFFSET(A3,0,($AD2)/4),OFFSET(A3,0,(($AD2)/4)+1)))))","v":3},{"$f":"QUARTILE($B2:$V2,2)","v":14},{"$f":"IF(MOD($AD2,4)=3,OFFSET($A3,0,(3*($AD2+1))/4),IF(MOD($AD2,4)=2,OFFSET($A3,0,(($AD2*0.75)+0.5)),IF(MOD($AD2,4)=1,AVERAGE(OFFSET($A3,0,(($AD2*0.75)+0.25)),OFFSET($A3,0,(($AD2*0.75)+1.25))),AVERAGE(OFFSET($A3,0,($AD2*0.75)),OFFSET($A3,0,(($AD2*0.75)+1))))))","v":17},{"$f":"QUARTILE($B2:$V2,4)","v":34},null,null,null,null,null,null,{"$f":"OFFSET(A3,0,5)","v":3}]
["b)",{"$f":"ABS(INT(NORMINV(RAND(),$AE4,$AF4)))","v":84},84,83,83,84,84,84,83,84,84,{"$f":"IF($AD4<11,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":84},{"$f":"IF($AD4<12,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":83},{"$f":"IF($AD4<13,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":83},{"$f":"IF($AD4<14,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":83},{"$f":"IF($AD4<15,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":83},{"$f":"IF($AD4<16,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":""},{"$f":"IF($AD4<17,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":""},{"$f":"IF($AD4<18,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":""},{"$f":"IF($AD4<19,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":""},{"$f":"IF($AD4<20,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":""},null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(10,20)","v":15},{"$f":"IF(RAND()<0.7,RANDBETWEEN(3,20),RANDBETWEEN(20,100))","v":84},{"$f":"RAND()*20","v":0.29894439207115431}]
[null,{"$f":"IF(ISERROR(LARGE($B4:$U4,$AD4-COLUMN()+2)),\"\",LARGE($B4:$U4,$AD4-COLUMN()+2))","v":83},83,83,83,83,83,83,84,84,84,84,84,84,84,84,"","","","","",null,{"$f":"QUARTILE($B4:$V4,0)","v":83},{"$f":"IF(MOD($AD4,4)=3,OFFSET(A5,0,($AD4+1)/4),IF(MOD($AD4,4)=2,OFFSET(A5,0,($AD4+2)/4),IF(MOD($AD4,4)=1,AVERAGE(OFFSET(A5,0,($AD4-1)/4),OFFSET(A5,0,(($AD4-1)/4)+1)),AVERAGE(OFFSET(A5,0,($AD4)/4),OFFSET(A5,0,(($AD4)/4)+1)))))","v":83},{"$f":"QUARTILE($B4:$V4,2)","v":84},{"$f":"IF(MOD($AD4,4)=3,OFFSET($A5,0,(3*($AD4+1))/4),IF(MOD($AD4,4)=2,OFFSET($A5,0,(($AD4*0.75)+0.5)),IF(MOD($AD4,4)=1,AVERAGE(OFFSET($A5,0,(($AD4*0.75)+0.25)),OFFSET($A5,0,(($AD4*0.75)+1.25))),AVERAGE(OFFSET($A5,0,($AD4*0.75)),OFFSET($A5,0,(($AD4*0.75)+1))))))","v":84},{"$f":"QUARTILE($B4:$V4,4)","v":84}]
["c)",{"$f":"ABS(INT(NORMINV(RAND(),$AE6,$AF6)))","v":56},50,41,80,68,46,56,61,57,70,{"$f":"IF($AD6<11,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":64},{"$f":"IF($AD6<12,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":""},{"$f":"IF($AD6<13,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":""},{"$f":"IF($AD6<14,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":""},{"$f":"IF($AD6<15,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":""},{"$f":"IF($AD6<16,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":""},{"$f":"IF($AD6<17,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":""},{"$f":"IF($AD6<18,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":""},{"$f":"IF($AD6<19,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":""},{"$f":"IF($AD6<20,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":""},null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(10,20)","v":11},{"$f":"IF(RAND()<0.7,RANDBETWEEN(3,20),RANDBETWEEN(20,100))","v":64},{"$f":"RAND()*20","v":14.074676947050349}]
[null,{"$f":"IF(ISERROR(LARGE($B6:$U6,$AD6-COLUMN()+2)),\"\",LARGE($B6:$U6,$AD6-COLUMN()+2))","v":41},46,50,56,56,57,61,64,68,70,80,"","","","","","","","","",null,{"$f":"QUARTILE($B6:$V6,0)","v":41},{"$f":"IF(MOD($AD6,4)=3,OFFSET(A7,0,($AD6+1)/4),IF(MOD($AD6,4)=2,OFFSET(A7,0,($AD6+2)/4),IF(MOD($AD6,4)=1,AVERAGE(OFFSET(A7,0,($AD6-1)/4),OFFSET(A7,0,(($AD6-1)/4)+1)),AVERAGE(OFFSET(A7,0,($AD6)/4),OFFSET(A7,0,(($AD6)/4)+1)))))","v":50},{"$f":"QUARTILE($B6:$V6,2)","v":57},{"$f":"IF(MOD($AD6,4)=3,OFFSET($A7,0,(3*($AD6+1))/4),IF(MOD($AD6,4)=2,OFFSET($A7,0,(($AD6*0.75)+0.5)),IF(MOD($AD6,4)=1,AVERAGE(OFFSET($A7,0,(($AD6*0.75)+0.25)),OFFSET($A7,0,(($AD6*0.75)+1.25))),AVERAGE(OFFSET($A7,0,($AD6*0.75)),OFFSET($A7,0,(($AD6*0.75)+1))))))","v":68},{"$f":"QUARTILE($B6:$V6,4)","v":80}]
["d)",{"$f":"ABS(INT(NORMINV(RAND(),$AE8,$AF8)))","v":20},16,23,16,14,16,11,9,20,26,{"$f":"IF($AD8<11,\"\",ABS(INT(NORMINV(RAND(),$AE8,$AF8))))","v":14},{"$f":"IF($AD8<12,\"\",ABS(INT(NORMINV(RAND(),$AE8,$AF8))))","v":22},{"$f":"IF($AD8<13,\"\",ABS(INT(NORMINV(RAND(),$AE8,$AF8))))","v":""},{"$f":"IF($AD8<14,\"\",ABS(INT(NORMINV(RAND(),$AE8,$AF8))))","v":""},{"$f":"IF($AD8<15,\"\",ABS(INT(NORMINV(RAND(),$AE8,$AF8))))","v":""},{"$f":"IF($AD8<16,\"\",ABS(INT(NORMINV(RAND(),$AE8,$AF8))))","v":""},{"$f":"IF($AD8<17,\"\",ABS(INT(NORMINV(RAND(),$AE8,$AF8))))","v":""},{"$f":"IF($AD8<18,\"\",ABS(INT(NORMINV(RAND(),$AE8,$AF8))))","v":""},{"$f":"IF($AD8<19,\"\",ABS(INT(NORMINV(RAND(),$AE8,$AF8))))","v":""},{"$f":"IF($AD8<20,\"\",ABS(INT(NORMINV(RAND(),$AE8,$AF8))))","v":""},null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(10,20)","v":12},{"$f":"IF(RAND()<0.7,RANDBETWEEN(3,20),RANDBETWEEN(20,100))","v":19},{"$f":"RAND()*20","v":5.994382327029621}]
[null,{"$f":"IF(ISERROR(LARGE($B8:$U8,$AD8-COLUMN()+2)),\"\",LARGE($B8:$U8,$AD8-COLUMN()+2))","v":9},11,14,14,16,16,16,20,20,22,23,26,"","","","","","","","",null,{"$f":"QUARTILE($B8:$V8,0)","v":9},{"$f":"IF(MOD($AD8,4)=3,OFFSET(A9,0,($AD8+1)/4),IF(MOD($AD8,4)=2,OFFSET(A9,0,($AD8+2)/4),IF(MOD($AD8,4)=1,AVERAGE(OFFSET(A9,0,($AD8-1)/4),OFFSET(A9,0,(($AD8-1)/4)+1)),AVERAGE(OFFSET(A9,0,($AD8)/4),OFFSET(A9,0,(($AD8)/4)+1)))))","v":14},{"$f":"QUARTILE($B8:$V8,2)","v":16},{"$f":"IF(MOD($AD8,4)=3,OFFSET($A9,0,(3*($AD8+1))/4),IF(MOD($AD8,4)=2,OFFSET($A9,0,(($AD8*0.75)+0.5)),IF(MOD($AD8,4)=1,AVERAGE(OFFSET($A9,0,(($AD8*0.75)+0.25)),OFFSET($A9,0,(($AD8*0.75)+1.25))),AVERAGE(OFFSET($A9,0,($AD8*0.75)),OFFSET($A9,0,(($AD8*0.75)+1))))))","v":21},{"$f":"QUARTILE($B8:$V8,4)","v":26}]
["e)",{"$f":"ABS(INT(NORMINV(RAND(),$AE10,$AF10)))","v":36},15,22,9,5,21,6,21,8,0,{"$f":"IF($AD10<11,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":17},{"$f":"IF($AD10<12,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":5},{"$f":"IF($AD10<13,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":14},{"$f":"IF($AD10<14,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":11},{"$f":"IF($AD10<15,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":13},{"$f":"IF($AD10<16,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":12},{"$f":"IF($AD10<17,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":0},{"$f":"IF($AD10<18,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":1},{"$f":"IF($AD10<19,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":6},{"$f":"IF($AD10<20,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":""},null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(10,20)","v":19},{"$f":"IF(RAND()<0.7,RANDBETWEEN(3,20),RANDBETWEEN(20,100))","v":5},{"$f":"RAND()*20","v":14.950997904089913}]
[null,{"$f":"IF(ISERROR(LARGE($B10:$U10,$AD10-COLUMN()+2)),\"\",LARGE($B10:$U10,$AD10-COLUMN()+2))","v":0},0,1,5,5,6,6,8,9,11,12,13,14,15,17,21,21,22,36,"",null,{"$f":"QUARTILE($B10:$V10,0)","v":0},{"$f":"IF(MOD($AD10,4)=3,OFFSET(A11,0,($AD10+1)/4),IF(MOD($AD10,4)=2,OFFSET(A11,0,($AD10+2)/4),IF(MOD($AD10,4)=1,AVERAGE(OFFSET(A11,0,($AD10-1)/4),OFFSET(A11,0,(($AD10-1)/4)+1)),AVERAGE(OFFSET(A11,0,($AD10)/4),OFFSET(A11,0,(($AD10)/4)+1)))))","v":5},{"$f":"QUARTILE($B10:$V10,2)","v":11},{"$f":"IF(MOD($AD10,4)=3,OFFSET($A11,0,(3*($AD10+1))/4),IF(MOD($AD10,4)=2,OFFSET($A11,0,(($AD10*0.75)+0.5)),IF(MOD($AD10,4)=1,AVERAGE(OFFSET($A11,0,(($AD10*0.75)+0.25)),OFFSET($A11,0,(($AD10*0.75)+1.25))),AVERAGE(OFFSET($A11,0,($AD10*0.75)),OFFSET($A11,0,(($AD10*0.75)+1))))))","v":17},{"$f":"QUARTILE($B10:$V10,4)","v":36}]
["f)",{"$f":"ABS(INT(NORMINV(RAND(),$AE12,$AF12)))","v":33},29,29,29,33,33,29,25,33,29,{"$f":"IF($AD12<11,\"\",ABS(INT(NORMINV(RAND(),$AE12,$AF12))))","v":35},{"$f":"IF($AD12<12,\"\",ABS(INT(NORMINV(RAND(),$AE12,$AF12))))","v":27},{"$f":"IF($AD12<13,\"\",ABS(INT(NORMINV(RAND(),$AE12,$AF12))))","v":24},{"$f":"IF($AD12<14,\"\",ABS(INT(NORMINV(RAND(),$AE12,$AF12))))","v":28},{"$f":"IF($AD12<15,\"\",ABS(INT(NORMINV(RAND(),$AE12,$AF12))))","v":""},{"$f":"IF($AD12<16,\"\",ABS(INT(NORMINV(RAND(),$AE12,$AF12))))","v":""},{"$f":"IF($AD12<17,\"\",ABS(INT(NORMINV(RAND(),$AE12,$AF12))))","v":""},{"$f":"IF($AD12<18,\"\",ABS(INT(NORMINV(RAND(),$AE12,$AF12))))","v":""},{"$f":"IF($AD12<19,\"\",ABS(INT(NORMINV(RAND(),$AE12,$AF12))))","v":""},{"$f":"IF($AD12<20,\"\",ABS(INT(NORMINV(RAND(),$AE12,$AF12))))","v":""},null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(10,20)","v":14},{"$f":"IF(RAND()<0.7,RANDBETWEEN(3,20),RANDBETWEEN(20,100))","v":31},{"$f":"RAND()*20","v":3.5478719561281213}]
[null,{"$f":"IF(ISERROR(LARGE($B12:$U12,$AD12-COLUMN()+2)),\"\",LARGE($B12:$U12,$AD12-COLUMN()+2))","v":24},25,27,28,29,29,29,29,29,33,33,33,33,35,"","","","","","",null,{"$f":"QUARTILE($B12:$V12,0)","v":24},{"$f":"IF(MOD($AD12,4)=3,OFFSET(A13,0,($AD12+1)/4),IF(MOD($AD12,4)=2,OFFSET(A13,0,($AD12+2)/4),IF(MOD($AD12,4)=1,AVERAGE(OFFSET(A13,0,($AD12-1)/4),OFFSET(A13,0,(($AD12-1)/4)+1)),AVERAGE(OFFSET(A13,0,($AD12)/4),OFFSET(A13,0,(($AD12)/4)+1)))))","v":28},{"$f":"QUARTILE($B12:$V12,2)","v":29},{"$f":"IF(MOD($AD12,4)=3,OFFSET($A13,0,(3*($AD12+1))/4),IF(MOD($AD12,4)=2,OFFSET($A13,0,(($AD12*0.75)+0.5)),IF(MOD($AD12,4)=1,AVERAGE(OFFSET($A13,0,(($AD12*0.75)+0.25)),OFFSET($A13,0,(($AD12*0.75)+1.25))),AVERAGE(OFFSET($A13,0,($AD12*0.75)),OFFSET($A13,0,(($AD12*0.75)+1))))))","v":33},{"$f":"QUARTILE($B12:$V12,4)","v":35}]
["g)",{"$f":"ABS(INT(NORMINV(RAND(),$AE14,$AF14)))","v":5},32,21,11,23,39,8,3,8,4,{"$f":"IF($AD14<11,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":22},{"$f":"IF($AD14<12,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":12},{"$f":"IF($AD14<13,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":16},{"$f":"IF($AD14<14,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":0},{"$f":"IF($AD14<15,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":15},{"$f":"IF($AD14<16,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":2},{"$f":"IF($AD14<17,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":""},{"$f":"IF($AD14<18,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":""},{"$f":"IF($AD14<19,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":""},{"$f":"IF($AD14<20,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":""},null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(10,20)","v":16},{"$f":"IF(RAND()<0.7,RANDBETWEEN(3,20),RANDBETWEEN(20,100))","v":12},{"$f":"RAND()*20","v":18.958415480354446}]
[null,{"$f":"IF(ISERROR(LARGE($B14:$U14,$AD14-COLUMN()+2)),\"\",LARGE($B14:$U14,$AD14-COLUMN()+2))","v":0},2,3,4,5,8,8,11,12,15,16,21,22,23,32,39,"","","","",null,{"$f":"QUARTILE($B14:$V14,0)","v":0},{"$f":"IF(MOD($AD14,4)=3,OFFSET(A15,0,($AD14+1)/4),IF(MOD($AD14,4)=2,OFFSET(A15,0,($AD14+2)/4),IF(MOD($AD14,4)=1,AVERAGE(OFFSET(A15,0,($AD14-1)/4),OFFSET(A15,0,(($AD14-1)/4)+1)),AVERAGE(OFFSET(A15,0,($AD14)/4),OFFSET(A15,0,(($AD14)/4)+1)))))","v":4.5},{"$f":"QUARTILE($B14:$V14,2)","v":11.5},{"$f":"IF(MOD($AD14,4)=3,OFFSET($A15,0,(3*($AD14+1))/4),IF(MOD($AD14,4)=2,OFFSET($A15,0,(($AD14*0.75)+0.5)),IF(MOD($AD14,4)=1,AVERAGE(OFFSET($A15,0,(($AD14*0.75)+0.25)),OFFSET($A15,0,(($AD14*0.75)+1.25))),AVERAGE(OFFSET($A15,0,($AD14*0.75)),OFFSET($A15,0,(($AD14*0.75)+1))))))","v":21.5},{"$f":"QUARTILE($B14:$V14,4)","v":39}]
["h)",{"$f":"ABS(INT(NORMINV(RAND(),$AE16,$AF16)))","v":28},2,19,3,11,26,25,10,12,23,{"$f":"IF($AD16<11,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":21},{"$f":"IF($AD16<12,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":8},{"$f":"IF($AD16<13,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":9},{"$f":"IF($AD16<14,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":11},{"$f":"IF($AD16<15,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":15},{"$f":"IF($AD16<16,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":13},{"$f":"IF($AD16<17,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":7},{"$f":"IF($AD16<18,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":""},{"$f":"IF($AD16<19,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":""},{"$f":"IF($AD16<20,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":""},null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(10,20)","v":17},{"$f":"IF(RAND()<0.7,RANDBETWEEN(3,20),RANDBETWEEN(20,100))","v":14},{"$f":"RAND()*20","v":6.9126465860324444}]
[null,{"$f":"IF(ISERROR(LARGE($B16:$U16,$AD16-COLUMN()+2)),\"\",LARGE($B16:$U16,$AD16-COLUMN()+2))","v":2},3,7,8,9,10,11,11,12,13,15,19,21,23,25,26,28,"","","",null,{"$f":"QUARTILE($B16:$V16,0)","v":2},{"$f":"IF(MOD($AD16,4)=3,OFFSET(A17,0,($AD16+1)/4),IF(MOD($AD16,4)=2,OFFSET(A17,0,($AD16+2)/4),IF(MOD($AD16,4)=1,AVERAGE(OFFSET(A17,0,($AD16-1)/4),OFFSET(A17,0,(($AD16-1)/4)+1)),AVERAGE(OFFSET(A17,0,($AD16)/4),OFFSET(A17,0,(($AD16)/4)+1)))))","v":8.5},{"$f":"QUARTILE($B16:$V16,2)","v":12},{"$f":"IF(MOD($AD16,4)=3,OFFSET($A17,0,(3*($AD16+1))/4),IF(MOD($AD16,4)=2,OFFSET($A17,0,(($AD16*0.75)+0.5)),IF(MOD($AD16,4)=1,AVERAGE(OFFSET($A17,0,(($AD16*0.75)+0.25)),OFFSET($A17,0,(($AD16*0.75)+1.25))),AVERAGE(OFFSET($A17,0,($AD16*0.75)),OFFSET($A17,0,(($AD16*0.75)+1))))))","v":22},{"$f":"QUARTILE($B16:$V16,4)","v":28}]
["i)",{"$f":"ABS(INT(NORMINV(RAND(),$AE18,$AF18)))","v":18},20,27,19,1,9,24,0,1,15,{"$f":"IF($AD18<11,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":18},{"$f":"IF($AD18<12,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":13},{"$f":"IF($AD18<13,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":4},{"$f":"IF($AD18<14,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":5},{"$f":"IF($AD18<15,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":17},{"$f":"IF($AD18<16,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":15},{"$f":"IF($AD18<17,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":6},{"$f":"IF($AD18<18,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":7},{"$f":"IF($AD18<19,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":11},{"$f":"IF($AD18<20,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":6},null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(10,20)","v":20},{"$f":"IF(RAND()<0.7,RANDBETWEEN(3,20),RANDBETWEEN(20,100))","v":14},{"$f":"RAND()*20","v":9.8271625963831575}]
[null,{"$f":"IF(ISERROR(LARGE($B18:$U18,$AD18-COLUMN()+2)),\"\",LARGE($B18:$U18,$AD18-COLUMN()+2))","v":0},1,1,4,5,6,6,7,9,11,13,15,15,17,18,18,19,20,24,27,null,{"$f":"QUARTILE($B18:$V18,0)","v":0},{"$f":"IF(MOD($AD18,4)=3,OFFSET(A19,0,($AD18+1)/4),IF(MOD($AD18,4)=2,OFFSET(A19,0,($AD18+2)/4),IF(MOD($AD18,4)=1,AVERAGE(OFFSET(A19,0,($AD18-1)/4),OFFSET(A19,0,(($AD18-1)/4)+1)),AVERAGE(OFFSET(A19,0,($AD18)/4),OFFSET(A19,0,(($AD18)/4)+1)))))","v":5.5},{"$f":"QUARTILE($B18:$V18,2)","v":12},{"$f":"IF(MOD($AD18,4)=3,OFFSET($A19,0,(3*($AD18+1))/4),IF(MOD($AD18,4)=2,OFFSET($A19,0,(($AD18*0.75)+0.5)),IF(MOD($AD18,4)=1,AVERAGE(OFFSET($A19,0,(($AD18*0.75)+0.25)),OFFSET($A19,0,(($AD18*0.75)+1.25))),AVERAGE(OFFSET($A19,0,($AD18*0.75)),OFFSET($A19,0,(($AD18*0.75)+1))))))","v":18},{"$f":"QUARTILE($B18:$V18,4)","v":27}]