{"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":42,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,2,0,27],[1,0,1,1]]}
[null,null,{"$f":"CONCATENATE(\"For each list, work out the median, quartiles and \",IF(B5=2,\"semi-\",\"\"),\"interquartile range\")","v":"For each list, work out the median, quartiles and interquartile range"}]
["Variables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"median","lower quartile","upper quartile",{"$f":"CONCATENATE(IF(B5=2,\"semi-\",\"\"),\"interquartile range\")","v":"interquartile range"}]
["SHOW ANSWERS?",{"$f":"AP9","v":false},"a)",45,50,44,57,49,48,44,52,48,50,42,"","","","","","","","",""]
["Lists of numbers already in order?",false,null,42,44,44,45,48,48,49,50,50,52,57,"","","","","","","","","",null,48,44,50,6]
["InterQuartile Range                  ",1,"b)",52,54,50,52,52,51,52,52,51,49,51,52,53,52,52,53,53,51,51,""]
["Semi InterQuartile Range                  ",false,null,49,50,51,51,51,51,51,52,52,52,52,52,52,52,52,53,53,53,54,"",null,52,51,52,1]
[null,null,"c)",25,31,22,1,35,19,12,22,33,32,18,37,27,21,38,8,9,14,"",""]
[null,null,null,1,8,9,12,14,18,19,21,22,22,25,27,31,32,33,35,37,38,"","",null,22,14,32,18]
[null,null,"d)",16,25,23,15,19,21,14,12,13,21,15,20,17,22,12,16,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,12,12,13,14,15,15,16,16,17,19,20,21,21,22,23,25,"","","","",null,16.5,14.5,21,6.5]
[null,null,"e)",25,20,16,15,7,23,25,6,18,16,9,"","","","","","","","",""]
[null,null,null,6,7,9,15,16,16,18,20,23,25,25,"","","","","","","","","",null,16,9,23,14]
[null,null,"f)",29,35,26,9,21,21,12,11,14,1,6,"","","","","","","","",""]
[null,null,null,1,6,9,11,12,14,21,21,26,29,35,"","","","","","","","","",null,14,9,26,17]
[null,null,"g)",96,79,86,66,102,97,81,70,90,65,90,55,62,81,84,88,106,91,79,93]
[null,null,null,55,62,65,66,70,79,79,81,81,84,86,88,90,90,91,93,96,97,102,106,null,85,74.5,92,17.5]
[null,null,"h)",4,6,6,9,14,10,1,12,18,1,6,13,17,15,12,5,"","","",""]
[null,null,null,1,1,4,5,6,6,6,9,10,12,12,13,14,15,17,18,"","","","",null,9.5,5.5,13.5,8]
[null,null,"i)",102,96,100,98,94,94,102,95,99,95,84,88,"","","","","","","",""]
[null,null,null,84,88,94,94,95,95,96,98,99,100,102,102,"","","","","","","","",null,95.5,94,99.5,5.5]

{"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,"median","lower quartile","upper quartile","SIQR"]
["a)",{"$f":"ABS(INT(NORMINV(RAND(),$AE2,$AF2)))","v":45},{"$f":"ABS(INT(NORMINV(RAND(),$AE2,$AF2)))","v":57},24,54,34,28,43,62,43,14,{"$f":"IF($AD2<11,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":30},{"$f":"IF($AD2<12,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":19},{"$f":"IF($AD2<13,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":59},{"$f":"IF($AD2<14,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":43},{"$f":"IF($AD2<15,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":65},{"$f":"IF($AD2<16,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":32},{"$f":"IF($AD2<17,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":13},{"$f":"IF($AD2<18,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":54},{"$f":"IF($AD2<19,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":64},{"$f":"IF($AD2<20,\"\",ABS(INT(NORMINV(RAND(),$AE2,$AF2))))","v":34},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":48},{"$f":"RAND()*20","v":17.883429472747107}]
[null,{"$f":"IF(ISERROR(LARGE($B2:$U2,$AD2-COLUMN()+2)),\"\",LARGE($B2:$U2,$AD2-COLUMN()+2))","v":13},{"$f":"IF(ISERROR(LARGE($B2:$U2,$AD2-COLUMN()+2)),\"\",LARGE($B2:$U2,$AD2-COLUMN()+2))","v":14},{"$f":"IF(ISERROR(LARGE($B2:$U2,$AD2-COLUMN()+2)),\"\",LARGE($B2:$U2,$AD2-COLUMN()+2))","v":19},{"$f":"IF(ISERROR(LARGE($B2:$U2,$AD2-COLUMN()+2)),\"\",LARGE($B2:$U2,$AD2-COLUMN()+2))","v":24},{"$f":"IF(ISERROR(LARGE($B2:$U2,$AD2-COLUMN()+2)),\"\",LARGE($B2:$U2,$AD2-COLUMN()+2))","v":28},30,32,34,34,43,43,{"$f":"IF(ISERROR(LARGE($B2:$U2,$AD2-COLUMN()+2)),\"\",LARGE($B2:$U2,$AD2-COLUMN()+2))","v":43},45,54,54,57,59,62,64,65,null,{"$f":"QUARTILE($B2:$V2,2)","v":43},{"$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":29},{"$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":55.5},{"$f":"(Y3-X3)/Worksheet!$B$5","v":26.5},null,null,null,null,null,null,null,{"$f":"OFFSET(A3,0,5)","v":28}]
["b)",{"$f":"ABS(INT(NORMINV(RAND(),$AE4,$AF4)))","v":6},18,4,17,3,14,27,11,4,27,{"$f":"IF($AD4<11,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":44},{"$f":"IF($AD4<12,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":19},{"$f":"IF($AD4<13,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":25},{"$f":"IF($AD4<14,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":26},{"$f":"IF($AD4<15,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":3},{"$f":"IF($AD4<16,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":25},{"$f":"IF($AD4<17,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":19},{"$f":"IF($AD4<18,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":12},{"$f":"IF($AD4<19,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":11},{"$f":"IF($AD4<20,\"\",ABS(INT(NORMINV(RAND(),$AE4,$AF4))))","v":5},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":17},{"$f":"RAND()*20","v":13.008357395266966}]
[null,{"$f":"IF(ISERROR(LARGE($B4:$U4,$AD4-COLUMN()+2)),\"\",LARGE($B4:$U4,$AD4-COLUMN()+2))","v":3},3,4,4,5,6,11,11,12,14,17,18,19,19,25,25,26,27,27,44,null,{"$f":"QUARTILE($B4:$V4,2)","v":15.5},{"$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":5.5},{"$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":25},{"$f":"(Y5-X5)/Worksheet!$B$5","v":19.5}]
["c)",{"$f":"ABS(INT(NORMINV(RAND(),$AE6,$AF6)))","v":2},12,3,11,6,5,6,3,6,9,{"$f":"IF($AD6<11,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":5},{"$f":"IF($AD6<12,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":3},{"$f":"IF($AD6<13,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":4},{"$f":"IF($AD6<14,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":5},{"$f":"IF($AD6<15,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":2},{"$f":"IF($AD6<16,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":8},{"$f":"IF($AD6<17,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":2},{"$f":"IF($AD6<18,\"\",ABS(INT(NORMINV(RAND(),$AE6,$AF6))))","v":7},{"$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":18},{"$f":"IF(RAND()<0.7,RANDBETWEEN(3,20),RANDBETWEEN(20,100))","v":6},{"$f":"RAND()*20","v":2.3273854468138055}]
[null,{"$f":"IF(ISERROR(LARGE($B6:$U6,$AD6-COLUMN()+2)),\"\",LARGE($B6:$U6,$AD6-COLUMN()+2))","v":2},2,2,3,3,3,4,5,5,5,6,6,6,7,8,9,11,12,"","",null,{"$f":"QUARTILE($B6:$V6,2)","v":5},{"$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":3},{"$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":7},{"$f":"(Y7-X7)/Worksheet!$B$5","v":4}]
["d)",{"$f":"ABS(INT(NORMINV(RAND(),$AE8,$AF8)))","v":14},19,18,13,18,13,16,14,11,16,{"$f":"IF($AD8<11,\"\",ABS(INT(NORMINV(RAND(),$AE8,$AF8))))","v":17},{"$f":"IF($AD8<12,\"\",ABS(INT(NORMINV(RAND(),$AE8,$AF8))))","v":14},{"$f":"IF($AD8<13,\"\",ABS(INT(NORMINV(RAND(),$AE8,$AF8))))","v":15},{"$f":"IF($AD8<14,\"\",ABS(INT(NORMINV(RAND(),$AE8,$AF8))))","v":20},{"$f":"IF($AD8<15,\"\",ABS(INT(NORMINV(RAND(),$AE8,$AF8))))","v":16},{"$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":15},{"$f":"IF(RAND()<0.7,RANDBETWEEN(3,20),RANDBETWEEN(20,100))","v":16},{"$f":"RAND()*20","v":2.2242014920498221}]
[null,{"$f":"IF(ISERROR(LARGE($B8:$U8,$AD8-COLUMN()+2)),\"\",LARGE($B8:$U8,$AD8-COLUMN()+2))","v":11},13,13,14,14,14,15,16,16,16,17,18,18,19,20,"","","","","",null,{"$f":"QUARTILE($B8:$V8,2)","v":16},{"$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":"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":18},{"$f":"(Y9-X9)/Worksheet!$B$5","v":4}]
["e)",{"$f":"ABS(INT(NORMINV(RAND(),$AE10,$AF10)))","v":19},13,8,13,15,17,3,20,33,18,{"$f":"IF($AD10<11,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":12},{"$f":"IF($AD10<12,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":12},{"$f":"IF($AD10<13,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":15},{"$f":"IF($AD10<14,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":17},{"$f":"IF($AD10<15,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":4},{"$f":"IF($AD10<16,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":4},{"$f":"IF($AD10<17,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":""},{"$f":"IF($AD10<18,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":""},{"$f":"IF($AD10<19,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","v":""},{"$f":"IF($AD10<20,\"\",ABS(INT(NORMINV(RAND(),$AE10,$AF10))))","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":8},{"$f":"RAND()*20","v":13.618890034626411}]
[null,{"$f":"IF(ISERROR(LARGE($B10:$U10,$AD10-COLUMN()+2)),\"\",LARGE($B10:$U10,$AD10-COLUMN()+2))","v":3},4,4,8,12,12,13,13,15,15,17,17,18,19,20,33,"","","","",null,{"$f":"QUARTILE($B10:$V10,2)","v":14},{"$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":10},{"$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.5},{"$f":"(Y11-X11)/Worksheet!$B$5","v":7.5}]
["f)",{"$f":"ABS(INT(NORMINV(RAND(),$AE12,$AF12)))","v":17},23,9,2,14,11,19,13,8,21,{"$f":"IF($AD12<11,\"\",ABS(INT(NORMINV(RAND(),$AE12,$AF12))))","v":17},{"$f":"IF($AD12<12,\"\",ABS(INT(NORMINV(RAND(),$AE12,$AF12))))","v":24},{"$f":"IF($AD12<13,\"\",ABS(INT(NORMINV(RAND(),$AE12,$AF12))))","v":""},{"$f":"IF($AD12<14,\"\",ABS(INT(NORMINV(RAND(),$AE12,$AF12))))","v":""},{"$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":12},{"$f":"IF(RAND()<0.7,RANDBETWEEN(3,20),RANDBETWEEN(20,100))","v":19},{"$f":"RAND()*20","v":7.9715200935363946}]
[null,{"$f":"IF(ISERROR(LARGE($B12:$U12,$AD12-COLUMN()+2)),\"\",LARGE($B12:$U12,$AD12-COLUMN()+2))","v":2},8,9,11,13,14,17,17,19,21,23,24,"","","","","","","","",null,{"$f":"QUARTILE($B12:$V12,2)","v":15.5},{"$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":10},{"$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":20},{"$f":"(Y13-X13)/Worksheet!$B$5","v":10}]
["g)",{"$f":"ABS(INT(NORMINV(RAND(),$AE14,$AF14)))","v":7},19,1,8,0,20,14,1,2,10,{"$f":"IF($AD14<11,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":11},{"$f":"IF($AD14<12,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":6},{"$f":"IF($AD14<13,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":9},{"$f":"IF($AD14<14,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":10},{"$f":"IF($AD14<15,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":8},{"$f":"IF($AD14<16,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":13},{"$f":"IF($AD14<17,\"\",ABS(INT(NORMINV(RAND(),$AE14,$AF14))))","v":5},{"$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":17},{"$f":"IF(RAND()<0.7,RANDBETWEEN(3,20),RANDBETWEEN(20,100))","v":6},{"$f":"RAND()*20","v":5.8264452293697637}]
[null,{"$f":"IF(ISERROR(LARGE($B14:$U14,$AD14-COLUMN()+2)),\"\",LARGE($B14:$U14,$AD14-COLUMN()+2))","v":0},1,1,2,5,6,7,8,8,9,10,10,11,13,14,19,20,"","","",null,{"$f":"QUARTILE($B14:$V14,2)","v":8},{"$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":3.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":12},{"$f":"(Y15-X15)/Worksheet!$B$5","v":8.5}]
["h)",{"$f":"ABS(INT(NORMINV(RAND(),$AE16,$AF16)))","v":9},2,2,4,22,1,9,23,3,13,{"$f":"IF($AD16<11,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":11},{"$f":"IF($AD16<12,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":21},{"$f":"IF($AD16<13,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":4},{"$f":"IF($AD16<14,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":15},{"$f":"IF($AD16<15,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":5},{"$f":"IF($AD16<16,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":16},{"$f":"IF($AD16<17,\"\",ABS(INT(NORMINV(RAND(),$AE16,$AF16))))","v":35},{"$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":6},{"$f":"RAND()*20","v":16.007292690297305}]
[null,{"$f":"IF(ISERROR(LARGE($B16:$U16,$AD16-COLUMN()+2)),\"\",LARGE($B16:$U16,$AD16-COLUMN()+2))","v":1},2,2,3,4,4,5,9,9,11,13,15,16,21,22,23,35,"","","",null,{"$f":"QUARTILE($B16:$V16,2)","v":9},{"$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":3.5},{"$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":18.5},{"$f":"(Y17-X17)/Worksheet!$B$5","v":15}]
["i)",{"$f":"ABS(INT(NORMINV(RAND(),$AE18,$AF18)))","v":5},12,40,42,33,47,30,43,13,38,{"$f":"IF($AD18<11,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":19},{"$f":"IF($AD18<12,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":23},{"$f":"IF($AD18<13,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":41},{"$f":"IF($AD18<14,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":9},{"$f":"IF($AD18<15,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":31},{"$f":"IF($AD18<16,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":17},{"$f":"IF($AD18<17,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":21},{"$f":"IF($AD18<18,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":""},{"$f":"IF($AD18<19,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","v":""},{"$f":"IF($AD18<20,\"\",ABS(INT(NORMINV(RAND(),$AE18,$AF18))))","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":19},{"$f":"RAND()*20","v":15.162512881484096}]
[null,{"$f":"IF(ISERROR(LARGE($B18:$U18,$AD18-COLUMN()+2)),\"\",LARGE($B18:$U18,$AD18-COLUMN()+2))","v":5},9,12,13,17,19,21,23,30,31,33,38,40,41,42,43,47,"","","",null,{"$f":"QUARTILE($B18:$V18,2)","v":30},{"$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":15},{"$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":40.5},{"$f":"(Y19-X19)/Worksheet!$B$5","v":25.5}]