{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Worksheet","SYSTEM FORMULAE"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,2,0,14]]}
[null,null,"Find the mean and standard deviation of each set of numbers"]
["Variables",null,"a)",12,7,14,"","","","","","mean = ",11,"s.d. = ",3.6055512754639891]
["SHOW ANSWERS?",false,"b)",166,181,170,183,235,"","","","mean = ",187,"s.d. = ",27.775888824662299]
["Number of questions                     (minimum 6, maximum 24)",24,"c)",10,3,2,"","","","","","mean = ",5,"s.d. = ",4.358898943540674]
["Force mean to be a whole number?  (if you want your class to use the formula on the right, it would be wise to tick this box)",true,"d)",24,7,22,32,9,38,"","","mean = ",22,"s.d. = ",12.280065146407001]
[null,null,"e)",167,186,166,164,172,"","","","mean = ",171,"s.d. = ",8.8881944173155887]
[null,null,"f)",16,15,15,26,"","","","","mean = ",18,"s.d. = ",5.3541261347363367]
[null,null,"g)",26,25,9,"","","","","","mean = ",20,"s.d. = ",9.5393920141694561]
[null,null,"h)",7,16,28,3,4,8,"","","mean = ",11,"s.d. = ",9.5078914592037709]
[null,null,"i)",161,149,200,"","","","","","mean = ",170,"s.d. = ",26.664583251946766]
[null,null,"j)",170,178,192,201,154,"","","","mean = ",179,"s.d. = ",18.439088914585774]
[null,null,"k)",21,6,19,6,"","","","","mean = ",13,"s.d. = ",8.1240384046359608]
[null,null,"l)",1,16,9,10,9,"","","","mean = ",9,"s.d. = ",5.3385391260156556]
[null,null,"m)",18,18,25,11,"","","","","mean = ",18,"s.d. = ",5.715476066494082]
[null,null,"n)",89,79,33,"","","","","","mean = ",67,"s.d. = ",29.866369046136157]
[null,null,"o)",20,12,51,21,11,"","","","mean = ",23,"s.d. = ",16.294170736800325]
[null,null,"p)",9,6,9,13,4,31,"","","mean = ",12,"s.d. = ",9.7979589711327115]
[null,null,"q)",24,14,17,2,16,22,38,"","mean = ",19,"s.d. = ",10.969655114602888]
[null,null,"r)",9,3,15,9,"","","","","mean = ",9,"s.d. = ",4.8989794855663558]
[null,null,"s)",100,99,86,"","","","","","mean = ",95,"s.d. = ",7.810249675906654]
[null,null,"t)",9,7,19,13,4,7,11,"","mean = ",10,"s.d. = ",4.9328828623162471]
[null,null,"u)",62,59,68,62,44,"","","","mean = ",59,"s.d. = ",9]
[null,null,"v)",16,17,16,18,15,13,3,"","mean = ",14,"s.d. = ",5.0990195135927845]
[null,null,"w)",26,9,19,14,6,22,"","","mean = ",16,"s.d. = ",7.7201036262475133]
[null,null,"x)",64,57,86,"","","","","","mean = ",69,"s.d. = ",15.132745950421556]

{"sheet":"SYSTEM FORMULAE","index":1,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,1,2,3,4,5,6,7]
["a)",{"$f":"IF($Q2<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q2,(((INT(AVERAGE(A2:$B2,1)))+RANDBETWEEN(1,0.5*$R2))*$Q2)-SUM(A2:$B2),ABS(INT(NORMINV(RAND(),$R2,$S2)))),ABS(INT(NORMINV(RAND(),$R2,$S2)))))","v":118},{"$f":"IF($Q2<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q2,(((INT(AVERAGE($B2:B2,1)))+RANDBETWEEN(1,0.5*$R2))*$Q2)-SUM($B2:B2),ABS(INT(NORMINV(RAND(),$R2,$S2)))),ABS(INT(NORMINV(RAND(),$R2,$S2)))))","v":132},{"$f":"IF($Q2<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q2,(((INT(AVERAGE($B2:C2,1)))+RANDBETWEEN(1,0.5*$R2))*$Q2)-SUM($B2:C2),ABS(INT(NORMINV(RAND(),$R2,$S2)))),ABS(INT(NORMINV(RAND(),$R2,$S2)))))","v":130},{"$f":"IF($Q2<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q2,(((INT(AVERAGE($B2:D2,1)))+RANDBETWEEN(1,0.5*$R2))*$Q2)-SUM($B2:D2),ABS(INT(NORMINV(RAND(),$R2,$S2)))),ABS(INT(NORMINV(RAND(),$R2,$S2)))))","v":204},{"$f":"IF($Q2<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q2,(((INT(AVERAGE($B2:E2,1)))+RANDBETWEEN(1,0.5*$R2))*$Q2)-SUM($B2:E2),ABS(INT(NORMINV(RAND(),$R2,$S2)))),ABS(INT(NORMINV(RAND(),$R2,$S2)))))","v":""},{"$f":"IF($Q2<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q2,(((INT(AVERAGE($B2:F2,1)))+RANDBETWEEN(1,0.5*$R2))*$Q2)-SUM($B2:F2),ABS(INT(NORMINV(RAND(),$R2,$S2)))),ABS(INT(NORMINV(RAND(),$R2,$S2)))))","v":""},{"$f":"IF($Q2<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q2,(((INT(AVERAGE($B2:G2,1)))+RANDBETWEEN(1,0.5*$R2))*$Q2)-SUM($B2:G2),ABS(INT(NORMINV(RAND(),$R2,$S2)))),ABS(INT(NORMINV(RAND(),$R2,$S2)))))","v":""},{"$f":"IF($Q2<8,\"\",\"*\")","v":""},"mean = ",{"$f":"AVERAGE(B2:H2)","v":146},"s.d. = ",{"$f":"STDEV(B2:H2)","v":39.157800414902432},null,null,null,{"$f":"RANDBETWEEN(3,7)","v":4},{"$f":"IF(RAND()<0.7,RANDBETWEEN(3,20),RANDBETWEEN(20,200))","v":121},{"$f":"RAND()*15","v":12.713952204239977}]
["b)",{"$f":"IF($Q3<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q3,(((INT(AVERAGE(A3:$B3,1)))+RANDBETWEEN(1,0.5*$R3))*$Q3)-SUM(A3:$B3),ABS(INT(NORMINV(RAND(),$R3,$S3)))),ABS(INT(NORMINV(RAND(),$R3,$S3)))))","v":118},{"$f":"IF($Q3<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q3,(((INT(AVERAGE($B3:B3,1)))+RANDBETWEEN(1,0.5*$R3))*$Q3)-SUM($B3:B3),ABS(INT(NORMINV(RAND(),$R3,$S3)))),ABS(INT(NORMINV(RAND(),$R3,$S3)))))","v":121},{"$f":"IF($Q3<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q3,(((INT(AVERAGE($B3:C3,1)))+RANDBETWEEN(1,0.5*$R3))*$Q3)-SUM($B3:C3),ABS(INT(NORMINV(RAND(),$R3,$S3)))),ABS(INT(NORMINV(RAND(),$R3,$S3)))))","v":118},{"$f":"IF($Q3<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q3,(((INT(AVERAGE($B3:D3,1)))+RANDBETWEEN(1,0.5*$R3))*$Q3)-SUM($B3:D3),ABS(INT(NORMINV(RAND(),$R3,$S3)))),ABS(INT(NORMINV(RAND(),$R3,$S3)))))","v":113},{"$f":"IF($Q3<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q3,(((INT(AVERAGE($B3:E3,1)))+RANDBETWEEN(1,0.5*$R3))*$Q3)-SUM($B3:E3),ABS(INT(NORMINV(RAND(),$R3,$S3)))),ABS(INT(NORMINV(RAND(),$R3,$S3)))))","v":117},{"$f":"IF($Q3<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q3,(((INT(AVERAGE($B3:F3,1)))+RANDBETWEEN(1,0.5*$R3))*$Q3)-SUM($B3:F3),ABS(INT(NORMINV(RAND(),$R3,$S3)))),ABS(INT(NORMINV(RAND(),$R3,$S3)))))","v":122},{"$f":"IF($Q3<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q3,(((INT(AVERAGE($B3:G3,1)))+RANDBETWEEN(1,0.5*$R3))*$Q3)-SUM($B3:G3),ABS(INT(NORMINV(RAND(),$R3,$S3)))),ABS(INT(NORMINV(RAND(),$R3,$S3)))))","v":236},{"$f":"IF($Q3<8,\"\",\"*\")","v":""},"mean = ",{"$f":"AVERAGE(B3:H3)","v":135},"s.d. = ",{"$f":"STDEV(B3:H3)","v":44.631827208842793},null,null,null,{"$f":"RANDBETWEEN(3,7)","v":7},{"$f":"IF(RAND()<0.7,RANDBETWEEN(3,20),RANDBETWEEN(20,200))","v":119},{"$f":"RAND()*15","v":2.7708905423305747}]
["c)",{"$f":"IF($Q4<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q4,(((INT(AVERAGE(A4:$B4,1)))+RANDBETWEEN(1,0.5*$R4))*$Q4)-SUM(A4:$B4),ABS(INT(NORMINV(RAND(),$R4,$S4)))),ABS(INT(NORMINV(RAND(),$R4,$S4)))))","v":17},{"$f":"IF($Q4<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q4,(((INT(AVERAGE($B4:B4,1)))+RANDBETWEEN(1,0.5*$R4))*$Q4)-SUM($B4:B4),ABS(INT(NORMINV(RAND(),$R4,$S4)))),ABS(INT(NORMINV(RAND(),$R4,$S4)))))","v":12},{"$f":"IF($Q4<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q4,(((INT(AVERAGE($B4:C4,1)))+RANDBETWEEN(1,0.5*$R4))*$Q4)-SUM($B4:C4),ABS(INT(NORMINV(RAND(),$R4,$S4)))),ABS(INT(NORMINV(RAND(),$R4,$S4)))))","v":12},{"$f":"IF($Q4<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q4,(((INT(AVERAGE($B4:D4,1)))+RANDBETWEEN(1,0.5*$R4))*$Q4)-SUM($B4:D4),ABS(INT(NORMINV(RAND(),$R4,$S4)))),ABS(INT(NORMINV(RAND(),$R4,$S4)))))","v":7},{"$f":"IF($Q4<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q4,(((INT(AVERAGE($B4:E4,1)))+RANDBETWEEN(1,0.5*$R4))*$Q4)-SUM($B4:E4),ABS(INT(NORMINV(RAND(),$R4,$S4)))),ABS(INT(NORMINV(RAND(),$R4,$S4)))))","v":""},{"$f":"IF($Q4<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q4,(((INT(AVERAGE($B4:F4,1)))+RANDBETWEEN(1,0.5*$R4))*$Q4)-SUM($B4:F4),ABS(INT(NORMINV(RAND(),$R4,$S4)))),ABS(INT(NORMINV(RAND(),$R4,$S4)))))","v":""},{"$f":"IF($Q4<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q4,(((INT(AVERAGE($B4:G4,1)))+RANDBETWEEN(1,0.5*$R4))*$Q4)-SUM($B4:G4),ABS(INT(NORMINV(RAND(),$R4,$S4)))),ABS(INT(NORMINV(RAND(),$R4,$S4)))))","v":""},"","mean = ",12,"s.d. = ",4.0824829046386304,null,null,null,4,12,2.3669423543592218]
["d)",{"$f":"IF($Q5<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q5,(((INT(AVERAGE(A5:$B5,1)))+RANDBETWEEN(1,0.5*$R5))*$Q5)-SUM(A5:$B5),ABS(INT(NORMINV(RAND(),$R5,$S5)))),ABS(INT(NORMINV(RAND(),$R5,$S5)))))","v":35},{"$f":"IF($Q5<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q5,(((INT(AVERAGE($B5:B5,1)))+RANDBETWEEN(1,0.5*$R5))*$Q5)-SUM($B5:B5),ABS(INT(NORMINV(RAND(),$R5,$S5)))),ABS(INT(NORMINV(RAND(),$R5,$S5)))))","v":5},{"$f":"IF($Q5<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q5,(((INT(AVERAGE($B5:C5,1)))+RANDBETWEEN(1,0.5*$R5))*$Q5)-SUM($B5:C5),ABS(INT(NORMINV(RAND(),$R5,$S5)))),ABS(INT(NORMINV(RAND(),$R5,$S5)))))","v":14},{"$f":"IF($Q5<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q5,(((INT(AVERAGE($B5:D5,1)))+RANDBETWEEN(1,0.5*$R5))*$Q5)-SUM($B5:D5),ABS(INT(NORMINV(RAND(),$R5,$S5)))),ABS(INT(NORMINV(RAND(),$R5,$S5)))))","v":12},{"$f":"IF($Q5<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q5,(((INT(AVERAGE($B5:E5,1)))+RANDBETWEEN(1,0.5*$R5))*$Q5)-SUM($B5:E5),ABS(INT(NORMINV(RAND(),$R5,$S5)))),ABS(INT(NORMINV(RAND(),$R5,$S5)))))","v":4},{"$f":"IF($Q5<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q5,(((INT(AVERAGE($B5:F5,1)))+RANDBETWEEN(1,0.5*$R5))*$Q5)-SUM($B5:F5),ABS(INT(NORMINV(RAND(),$R5,$S5)))),ABS(INT(NORMINV(RAND(),$R5,$S5)))))","v":""},{"$f":"IF($Q5<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q5,(((INT(AVERAGE($B5:G5,1)))+RANDBETWEEN(1,0.5*$R5))*$Q5)-SUM($B5:G5),ABS(INT(NORMINV(RAND(),$R5,$S5)))),ABS(INT(NORMINV(RAND(),$R5,$S5)))))","v":""},"","mean = ",14,"s.d. = ",12.509996003196804,null,null,null,5,20,12.528515680801609]
["e)",{"$f":"IF($Q6<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q6,(((INT(AVERAGE(A6:$B6,1)))+RANDBETWEEN(1,0.5*$R6))*$Q6)-SUM(A6:$B6),ABS(INT(NORMINV(RAND(),$R6,$S6)))),ABS(INT(NORMINV(RAND(),$R6,$S6)))))","v":16},{"$f":"IF($Q6<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q6,(((INT(AVERAGE($B6:B6,1)))+RANDBETWEEN(1,0.5*$R6))*$Q6)-SUM($B6:B6),ABS(INT(NORMINV(RAND(),$R6,$S6)))),ABS(INT(NORMINV(RAND(),$R6,$S6)))))","v":12},{"$f":"IF($Q6<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q6,(((INT(AVERAGE($B6:C6,1)))+RANDBETWEEN(1,0.5*$R6))*$Q6)-SUM($B6:C6),ABS(INT(NORMINV(RAND(),$R6,$S6)))),ABS(INT(NORMINV(RAND(),$R6,$S6)))))","v":8},{"$f":"IF($Q6<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q6,(((INT(AVERAGE($B6:D6,1)))+RANDBETWEEN(1,0.5*$R6))*$Q6)-SUM($B6:D6),ABS(INT(NORMINV(RAND(),$R6,$S6)))),ABS(INT(NORMINV(RAND(),$R6,$S6)))))","v":14},{"$f":"IF($Q6<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q6,(((INT(AVERAGE($B6:E6,1)))+RANDBETWEEN(1,0.5*$R6))*$Q6)-SUM($B6:E6),ABS(INT(NORMINV(RAND(),$R6,$S6)))),ABS(INT(NORMINV(RAND(),$R6,$S6)))))","v":8},{"$f":"IF($Q6<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q6,(((INT(AVERAGE($B6:F6,1)))+RANDBETWEEN(1,0.5*$R6))*$Q6)-SUM($B6:F6),ABS(INT(NORMINV(RAND(),$R6,$S6)))),ABS(INT(NORMINV(RAND(),$R6,$S6)))))","v":8},{"$f":"IF($Q6<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q6,(((INT(AVERAGE($B6:G6,1)))+RANDBETWEEN(1,0.5*$R6))*$Q6)-SUM($B6:G6),ABS(INT(NORMINV(RAND(),$R6,$S6)))),ABS(INT(NORMINV(RAND(),$R6,$S6)))))","v":""},"","mean = ",11,"s.d. = ",3.5213633723318019,null,null,null,6,11,13.843454335272673]
["f)",{"$f":"IF($Q7<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q7,(((INT(AVERAGE(A7:$B7,1)))+RANDBETWEEN(1,0.5*$R7))*$Q7)-SUM(A7:$B7),ABS(INT(NORMINV(RAND(),$R7,$S7)))),ABS(INT(NORMINV(RAND(),$R7,$S7)))))","v":213},{"$f":"IF($Q7<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q7,(((INT(AVERAGE($B7:B7,1)))+RANDBETWEEN(1,0.5*$R7))*$Q7)-SUM($B7:B7),ABS(INT(NORMINV(RAND(),$R7,$S7)))),ABS(INT(NORMINV(RAND(),$R7,$S7)))))","v":188},{"$f":"IF($Q7<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q7,(((INT(AVERAGE($B7:C7,1)))+RANDBETWEEN(1,0.5*$R7))*$Q7)-SUM($B7:C7),ABS(INT(NORMINV(RAND(),$R7,$S7)))),ABS(INT(NORMINV(RAND(),$R7,$S7)))))","v":178},{"$f":"IF($Q7<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q7,(((INT(AVERAGE($B7:D7,1)))+RANDBETWEEN(1,0.5*$R7))*$Q7)-SUM($B7:D7),ABS(INT(NORMINV(RAND(),$R7,$S7)))),ABS(INT(NORMINV(RAND(),$R7,$S7)))))","v":49},{"$f":"IF($Q7<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q7,(((INT(AVERAGE($B7:E7,1)))+RANDBETWEEN(1,0.5*$R7))*$Q7)-SUM($B7:E7),ABS(INT(NORMINV(RAND(),$R7,$S7)))),ABS(INT(NORMINV(RAND(),$R7,$S7)))))","v":""},{"$f":"IF($Q7<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q7,(((INT(AVERAGE($B7:F7,1)))+RANDBETWEEN(1,0.5*$R7))*$Q7)-SUM($B7:F7),ABS(INT(NORMINV(RAND(),$R7,$S7)))),ABS(INT(NORMINV(RAND(),$R7,$S7)))))","v":""},{"$f":"IF($Q7<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q7,(((INT(AVERAGE($B7:G7,1)))+RANDBETWEEN(1,0.5*$R7))*$Q7)-SUM($B7:G7),ABS(INT(NORMINV(RAND(),$R7,$S7)))),ABS(INT(NORMINV(RAND(),$R7,$S7)))))","v":""},"","mean = ",157,"s.d. = ",73.489228235617404,null,null,null,4,188,9.7297852808791188]
["g)",{"$f":"IF($Q8<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q8,(((INT(AVERAGE(A8:$B8,1)))+RANDBETWEEN(1,0.5*$R8))*$Q8)-SUM(A8:$B8),ABS(INT(NORMINV(RAND(),$R8,$S8)))),ABS(INT(NORMINV(RAND(),$R8,$S8)))))","v":69},{"$f":"IF($Q8<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q8,(((INT(AVERAGE($B8:B8,1)))+RANDBETWEEN(1,0.5*$R8))*$Q8)-SUM($B8:B8),ABS(INT(NORMINV(RAND(),$R8,$S8)))),ABS(INT(NORMINV(RAND(),$R8,$S8)))))","v":45},{"$f":"IF($Q8<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q8,(((INT(AVERAGE($B8:C8,1)))+RANDBETWEEN(1,0.5*$R8))*$Q8)-SUM($B8:C8),ABS(INT(NORMINV(RAND(),$R8,$S8)))),ABS(INT(NORMINV(RAND(),$R8,$S8)))))","v":15},{"$f":"IF($Q8<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q8,(((INT(AVERAGE($B8:D8,1)))+RANDBETWEEN(1,0.5*$R8))*$Q8)-SUM($B8:D8),ABS(INT(NORMINV(RAND(),$R8,$S8)))),ABS(INT(NORMINV(RAND(),$R8,$S8)))))","v":""},{"$f":"IF($Q8<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q8,(((INT(AVERAGE($B8:E8,1)))+RANDBETWEEN(1,0.5*$R8))*$Q8)-SUM($B8:E8),ABS(INT(NORMINV(RAND(),$R8,$S8)))),ABS(INT(NORMINV(RAND(),$R8,$S8)))))","v":""},{"$f":"IF($Q8<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q8,(((INT(AVERAGE($B8:F8,1)))+RANDBETWEEN(1,0.5*$R8))*$Q8)-SUM($B8:F8),ABS(INT(NORMINV(RAND(),$R8,$S8)))),ABS(INT(NORMINV(RAND(),$R8,$S8)))))","v":""},{"$f":"IF($Q8<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q8,(((INT(AVERAGE($B8:G8,1)))+RANDBETWEEN(1,0.5*$R8))*$Q8)-SUM($B8:G8),ABS(INT(NORMINV(RAND(),$R8,$S8)))),ABS(INT(NORMINV(RAND(),$R8,$S8)))))","v":""},"","mean = ",43,"s.d. = ",27.055498516937366,null,null,null,3,60,12.373322083326439]
["h)",{"$f":"IF($Q9<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q9,(((INT(AVERAGE(A9:$B9,1)))+RANDBETWEEN(1,0.5*$R9))*$Q9)-SUM(A9:$B9),ABS(INT(NORMINV(RAND(),$R9,$S9)))),ABS(INT(NORMINV(RAND(),$R9,$S9)))))","v":3},{"$f":"IF($Q9<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q9,(((INT(AVERAGE($B9:B9,1)))+RANDBETWEEN(1,0.5*$R9))*$Q9)-SUM($B9:B9),ABS(INT(NORMINV(RAND(),$R9,$S9)))),ABS(INT(NORMINV(RAND(),$R9,$S9)))))","v":4},{"$f":"IF($Q9<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q9,(((INT(AVERAGE($B9:C9,1)))+RANDBETWEEN(1,0.5*$R9))*$Q9)-SUM($B9:C9),ABS(INT(NORMINV(RAND(),$R9,$S9)))),ABS(INT(NORMINV(RAND(),$R9,$S9)))))","v":28},{"$f":"IF($Q9<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q9,(((INT(AVERAGE($B9:D9,1)))+RANDBETWEEN(1,0.5*$R9))*$Q9)-SUM($B9:D9),ABS(INT(NORMINV(RAND(),$R9,$S9)))),ABS(INT(NORMINV(RAND(),$R9,$S9)))))","v":1},{"$f":"IF($Q9<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q9,(((INT(AVERAGE($B9:E9,1)))+RANDBETWEEN(1,0.5*$R9))*$Q9)-SUM($B9:E9),ABS(INT(NORMINV(RAND(),$R9,$S9)))),ABS(INT(NORMINV(RAND(),$R9,$S9)))))","v":25},{"$f":"IF($Q9<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q9,(((INT(AVERAGE($B9:F9,1)))+RANDBETWEEN(1,0.5*$R9))*$Q9)-SUM($B9:F9),ABS(INT(NORMINV(RAND(),$R9,$S9)))),ABS(INT(NORMINV(RAND(),$R9,$S9)))))","v":11},{"$f":"IF($Q9<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q9,(((INT(AVERAGE($B9:G9,1)))+RANDBETWEEN(1,0.5*$R9))*$Q9)-SUM($B9:G9),ABS(INT(NORMINV(RAND(),$R9,$S9)))),ABS(INT(NORMINV(RAND(),$R9,$S9)))))","v":""},"","mean = ",12,"s.d. = ",11.764352935882194,null,null,null,6,15,10.302920128930639]
["i)",{"$f":"IF($Q10<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q10,(((INT(AVERAGE(A10:$B10,1)))+RANDBETWEEN(1,0.5*$R10))*$Q10)-SUM(A10:$B10),ABS(INT(NORMINV(RAND(),$R10,$S10)))),ABS(INT(NORMINV(RAND(),$R10,$S10)))))","v":3},{"$f":"IF($Q10<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q10,(((INT(AVERAGE($B10:B10,1)))+RANDBETWEEN(1,0.5*$R10))*$Q10)-SUM($B10:B10),ABS(INT(NORMINV(RAND(),$R10,$S10)))),ABS(INT(NORMINV(RAND(),$R10,$S10)))))","v":6},{"$f":"IF($Q10<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q10,(((INT(AVERAGE($B10:C10,1)))+RANDBETWEEN(1,0.5*$R10))*$Q10)-SUM($B10:C10),ABS(INT(NORMINV(RAND(),$R10,$S10)))),ABS(INT(NORMINV(RAND(),$R10,$S10)))))","v":8},{"$f":"IF($Q10<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q10,(((INT(AVERAGE($B10:D10,1)))+RANDBETWEEN(1,0.5*$R10))*$Q10)-SUM($B10:D10),ABS(INT(NORMINV(RAND(),$R10,$S10)))),ABS(INT(NORMINV(RAND(),$R10,$S10)))))","v":1},{"$f":"IF($Q10<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q10,(((INT(AVERAGE($B10:E10,1)))+RANDBETWEEN(1,0.5*$R10))*$Q10)-SUM($B10:E10),ABS(INT(NORMINV(RAND(),$R10,$S10)))),ABS(INT(NORMINV(RAND(),$R10,$S10)))))","v":2},{"$f":"IF($Q10<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q10,(((INT(AVERAGE($B10:F10,1)))+RANDBETWEEN(1,0.5*$R10))*$Q10)-SUM($B10:F10),ABS(INT(NORMINV(RAND(),$R10,$S10)))),ABS(INT(NORMINV(RAND(),$R10,$S10)))))","v":10},{"$f":"IF($Q10<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q10,(((INT(AVERAGE($B10:G10,1)))+RANDBETWEEN(1,0.5*$R10))*$Q10)-SUM($B10:G10),ABS(INT(NORMINV(RAND(),$R10,$S10)))),ABS(INT(NORMINV(RAND(),$R10,$S10)))))","v":""},"","mean = ",5,"s.d. = ",3.5777087639996634,null,null,null,6,6,5.1887022077475091]
["j)",{"$f":"IF($Q11<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q11,(((INT(AVERAGE(A11:$B11,1)))+RANDBETWEEN(1,0.5*$R11))*$Q11)-SUM(A11:$B11),ABS(INT(NORMINV(RAND(),$R11,$S11)))),ABS(INT(NORMINV(RAND(),$R11,$S11)))))","v":15},{"$f":"IF($Q11<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q11,(((INT(AVERAGE($B11:B11,1)))+RANDBETWEEN(1,0.5*$R11))*$Q11)-SUM($B11:B11),ABS(INT(NORMINV(RAND(),$R11,$S11)))),ABS(INT(NORMINV(RAND(),$R11,$S11)))))","v":5},{"$f":"IF($Q11<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q11,(((INT(AVERAGE($B11:C11,1)))+RANDBETWEEN(1,0.5*$R11))*$Q11)-SUM($B11:C11),ABS(INT(NORMINV(RAND(),$R11,$S11)))),ABS(INT(NORMINV(RAND(),$R11,$S11)))))","v":9},{"$f":"IF($Q11<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q11,(((INT(AVERAGE($B11:D11,1)))+RANDBETWEEN(1,0.5*$R11))*$Q11)-SUM($B11:D11),ABS(INT(NORMINV(RAND(),$R11,$S11)))),ABS(INT(NORMINV(RAND(),$R11,$S11)))))","v":3},{"$f":"IF($Q11<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q11,(((INT(AVERAGE($B11:E11,1)))+RANDBETWEEN(1,0.5*$R11))*$Q11)-SUM($B11:E11),ABS(INT(NORMINV(RAND(),$R11,$S11)))),ABS(INT(NORMINV(RAND(),$R11,$S11)))))","v":""},{"$f":"IF($Q11<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q11,(((INT(AVERAGE($B11:F11,1)))+RANDBETWEEN(1,0.5*$R11))*$Q11)-SUM($B11:F11),ABS(INT(NORMINV(RAND(),$R11,$S11)))),ABS(INT(NORMINV(RAND(),$R11,$S11)))))","v":""},{"$f":"IF($Q11<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q11,(((INT(AVERAGE($B11:G11,1)))+RANDBETWEEN(1,0.5*$R11))*$Q11)-SUM($B11:G11),ABS(INT(NORMINV(RAND(),$R11,$S11)))),ABS(INT(NORMINV(RAND(),$R11,$S11)))))","v":""},"","mean = ",8,"s.d. = ",5.2915026221291814,null,null,null,4,5,9.7310088732426809]
["k)",{"$f":"IF($Q12<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q12,(((INT(AVERAGE(A12:$B12,1)))+RANDBETWEEN(1,0.5*$R12))*$Q12)-SUM(A12:$B12),ABS(INT(NORMINV(RAND(),$R12,$S12)))),ABS(INT(NORMINV(RAND(),$R12,$S12)))))","v":58},{"$f":"IF($Q12<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q12,(((INT(AVERAGE($B12:B12,1)))+RANDBETWEEN(1,0.5*$R12))*$Q12)-SUM($B12:B12),ABS(INT(NORMINV(RAND(),$R12,$S12)))),ABS(INT(NORMINV(RAND(),$R12,$S12)))))","v":55},{"$f":"IF($Q12<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q12,(((INT(AVERAGE($B12:C12,1)))+RANDBETWEEN(1,0.5*$R12))*$Q12)-SUM($B12:C12),ABS(INT(NORMINV(RAND(),$R12,$S12)))),ABS(INT(NORMINV(RAND(),$R12,$S12)))))","v":7},{"$f":"IF($Q12<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q12,(((INT(AVERAGE($B12:D12,1)))+RANDBETWEEN(1,0.5*$R12))*$Q12)-SUM($B12:D12),ABS(INT(NORMINV(RAND(),$R12,$S12)))),ABS(INT(NORMINV(RAND(),$R12,$S12)))))","v":""},{"$f":"IF($Q12<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q12,(((INT(AVERAGE($B12:E12,1)))+RANDBETWEEN(1,0.5*$R12))*$Q12)-SUM($B12:E12),ABS(INT(NORMINV(RAND(),$R12,$S12)))),ABS(INT(NORMINV(RAND(),$R12,$S12)))))","v":""},{"$f":"IF($Q12<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q12,(((INT(AVERAGE($B12:F12,1)))+RANDBETWEEN(1,0.5*$R12))*$Q12)-SUM($B12:F12),ABS(INT(NORMINV(RAND(),$R12,$S12)))),ABS(INT(NORMINV(RAND(),$R12,$S12)))))","v":""},{"$f":"IF($Q12<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q12,(((INT(AVERAGE($B12:G12,1)))+RANDBETWEEN(1,0.5*$R12))*$Q12)-SUM($B12:G12),ABS(INT(NORMINV(RAND(),$R12,$S12)))),ABS(INT(NORMINV(RAND(),$R12,$S12)))))","v":""},"","mean = ",40,"s.d. = ",28.61817604250837,null,null,null,3,53,13.006625252043369]
["l)",{"$f":"IF($Q13<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q13,(((INT(AVERAGE(A13:$B13,1)))+RANDBETWEEN(1,0.5*$R13))*$Q13)-SUM(A13:$B13),ABS(INT(NORMINV(RAND(),$R13,$S13)))),ABS(INT(NORMINV(RAND(),$R13,$S13)))))","v":21},{"$f":"IF($Q13<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q13,(((INT(AVERAGE($B13:B13,1)))+RANDBETWEEN(1,0.5*$R13))*$Q13)-SUM($B13:B13),ABS(INT(NORMINV(RAND(),$R13,$S13)))),ABS(INT(NORMINV(RAND(),$R13,$S13)))))","v":26},{"$f":"IF($Q13<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q13,(((INT(AVERAGE($B13:C13,1)))+RANDBETWEEN(1,0.5*$R13))*$Q13)-SUM($B13:C13),ABS(INT(NORMINV(RAND(),$R13,$S13)))),ABS(INT(NORMINV(RAND(),$R13,$S13)))))","v":20},{"$f":"IF($Q13<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q13,(((INT(AVERAGE($B13:D13,1)))+RANDBETWEEN(1,0.5*$R13))*$Q13)-SUM($B13:D13),ABS(INT(NORMINV(RAND(),$R13,$S13)))),ABS(INT(NORMINV(RAND(),$R13,$S13)))))","v":21},{"$f":"IF($Q13<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q13,(((INT(AVERAGE($B13:E13,1)))+RANDBETWEEN(1,0.5*$R13))*$Q13)-SUM($B13:E13),ABS(INT(NORMINV(RAND(),$R13,$S13)))),ABS(INT(NORMINV(RAND(),$R13,$S13)))))","v":42},{"$f":"IF($Q13<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q13,(((INT(AVERAGE($B13:F13,1)))+RANDBETWEEN(1,0.5*$R13))*$Q13)-SUM($B13:F13),ABS(INT(NORMINV(RAND(),$R13,$S13)))),ABS(INT(NORMINV(RAND(),$R13,$S13)))))","v":""},{"$f":"IF($Q13<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q13,(((INT(AVERAGE($B13:G13,1)))+RANDBETWEEN(1,0.5*$R13))*$Q13)-SUM($B13:G13),ABS(INT(NORMINV(RAND(),$R13,$S13)))),ABS(INT(NORMINV(RAND(),$R13,$S13)))))","v":""},"","mean = ",26,"s.d. = ",9.2466210044534645,null,null,null,5,19,5.8714066685165927]
["m)",{"$f":"IF($Q14<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q14,(((INT(AVERAGE(A14:$B14,1)))+RANDBETWEEN(1,0.5*$R14))*$Q14)-SUM(A14:$B14),ABS(INT(NORMINV(RAND(),$R14,$S14)))),ABS(INT(NORMINV(RAND(),$R14,$S14)))))","v":14},{"$f":"IF($Q14<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q14,(((INT(AVERAGE($B14:B14,1)))+RANDBETWEEN(1,0.5*$R14))*$Q14)-SUM($B14:B14),ABS(INT(NORMINV(RAND(),$R14,$S14)))),ABS(INT(NORMINV(RAND(),$R14,$S14)))))","v":3},{"$f":"IF($Q14<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q14,(((INT(AVERAGE($B14:C14,1)))+RANDBETWEEN(1,0.5*$R14))*$Q14)-SUM($B14:C14),ABS(INT(NORMINV(RAND(),$R14,$S14)))),ABS(INT(NORMINV(RAND(),$R14,$S14)))))","v":8},{"$f":"IF($Q14<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q14,(((INT(AVERAGE($B14:D14,1)))+RANDBETWEEN(1,0.5*$R14))*$Q14)-SUM($B14:D14),ABS(INT(NORMINV(RAND(),$R14,$S14)))),ABS(INT(NORMINV(RAND(),$R14,$S14)))))","v":17},{"$f":"IF($Q14<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q14,(((INT(AVERAGE($B14:E14,1)))+RANDBETWEEN(1,0.5*$R14))*$Q14)-SUM($B14:E14),ABS(INT(NORMINV(RAND(),$R14,$S14)))),ABS(INT(NORMINV(RAND(),$R14,$S14)))))","v":13},{"$f":"IF($Q14<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q14,(((INT(AVERAGE($B14:F14,1)))+RANDBETWEEN(1,0.5*$R14))*$Q14)-SUM($B14:F14),ABS(INT(NORMINV(RAND(),$R14,$S14)))),ABS(INT(NORMINV(RAND(),$R14,$S14)))))","v":23},{"$f":"IF($Q14<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q14,(((INT(AVERAGE($B14:G14,1)))+RANDBETWEEN(1,0.5*$R14))*$Q14)-SUM($B14:G14),ABS(INT(NORMINV(RAND(),$R14,$S14)))),ABS(INT(NORMINV(RAND(),$R14,$S14)))))","v":""},"","mean = ",13,"s.d. = ",6.9570108523704342,null,null,null,6,15,7.5549981892172982]
["n)",{"$f":"IF($Q15<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q15,(((INT(AVERAGE(A15:$B15,1)))+RANDBETWEEN(1,0.5*$R15))*$Q15)-SUM(A15:$B15),ABS(INT(NORMINV(RAND(),$R15,$S15)))),ABS(INT(NORMINV(RAND(),$R15,$S15)))))","v":35},{"$f":"IF($Q15<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q15,(((INT(AVERAGE($B15:B15,1)))+RANDBETWEEN(1,0.5*$R15))*$Q15)-SUM($B15:B15),ABS(INT(NORMINV(RAND(),$R15,$S15)))),ABS(INT(NORMINV(RAND(),$R15,$S15)))))","v":14},{"$f":"IF($Q15<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q15,(((INT(AVERAGE($B15:C15,1)))+RANDBETWEEN(1,0.5*$R15))*$Q15)-SUM($B15:C15),ABS(INT(NORMINV(RAND(),$R15,$S15)))),ABS(INT(NORMINV(RAND(),$R15,$S15)))))","v":20},{"$f":"IF($Q15<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q15,(((INT(AVERAGE($B15:D15,1)))+RANDBETWEEN(1,0.5*$R15))*$Q15)-SUM($B15:D15),ABS(INT(NORMINV(RAND(),$R15,$S15)))),ABS(INT(NORMINV(RAND(),$R15,$S15)))))","v":7},{"$f":"IF($Q15<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q15,(((INT(AVERAGE($B15:E15,1)))+RANDBETWEEN(1,0.5*$R15))*$Q15)-SUM($B15:E15),ABS(INT(NORMINV(RAND(),$R15,$S15)))),ABS(INT(NORMINV(RAND(),$R15,$S15)))))","v":""},{"$f":"IF($Q15<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q15,(((INT(AVERAGE($B15:F15,1)))+RANDBETWEEN(1,0.5*$R15))*$Q15)-SUM($B15:F15),ABS(INT(NORMINV(RAND(),$R15,$S15)))),ABS(INT(NORMINV(RAND(),$R15,$S15)))))","v":""},{"$f":"IF($Q15<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q15,(((INT(AVERAGE($B15:G15,1)))+RANDBETWEEN(1,0.5*$R15))*$Q15)-SUM($B15:G15),ABS(INT(NORMINV(RAND(),$R15,$S15)))),ABS(INT(NORMINV(RAND(),$R15,$S15)))))","v":""},"","mean = ",19,"s.d. = ",11.916375287812984,null,null,null,4,14,11.749688557249012]
["o)",{"$f":"IF($Q16<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q16,(((INT(AVERAGE(A16:$B16,1)))+RANDBETWEEN(1,0.5*$R16))*$Q16)-SUM(A16:$B16),ABS(INT(NORMINV(RAND(),$R16,$S16)))),ABS(INT(NORMINV(RAND(),$R16,$S16)))))","v":18},{"$f":"IF($Q16<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q16,(((INT(AVERAGE($B16:B16,1)))+RANDBETWEEN(1,0.5*$R16))*$Q16)-SUM($B16:B16),ABS(INT(NORMINV(RAND(),$R16,$S16)))),ABS(INT(NORMINV(RAND(),$R16,$S16)))))","v":7},{"$f":"IF($Q16<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q16,(((INT(AVERAGE($B16:C16,1)))+RANDBETWEEN(1,0.5*$R16))*$Q16)-SUM($B16:C16),ABS(INT(NORMINV(RAND(),$R16,$S16)))),ABS(INT(NORMINV(RAND(),$R16,$S16)))))","v":6},{"$f":"IF($Q16<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q16,(((INT(AVERAGE($B16:D16,1)))+RANDBETWEEN(1,0.5*$R16))*$Q16)-SUM($B16:D16),ABS(INT(NORMINV(RAND(),$R16,$S16)))),ABS(INT(NORMINV(RAND(),$R16,$S16)))))","v":25},{"$f":"IF($Q16<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q16,(((INT(AVERAGE($B16:E16,1)))+RANDBETWEEN(1,0.5*$R16))*$Q16)-SUM($B16:E16),ABS(INT(NORMINV(RAND(),$R16,$S16)))),ABS(INT(NORMINV(RAND(),$R16,$S16)))))","v":4},{"$f":"IF($Q16<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q16,(((INT(AVERAGE($B16:F16,1)))+RANDBETWEEN(1,0.5*$R16))*$Q16)-SUM($B16:F16),ABS(INT(NORMINV(RAND(),$R16,$S16)))),ABS(INT(NORMINV(RAND(),$R16,$S16)))))","v":""},{"$f":"IF($Q16<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q16,(((INT(AVERAGE($B16:G16,1)))+RANDBETWEEN(1,0.5*$R16))*$Q16)-SUM($B16:G16),ABS(INT(NORMINV(RAND(),$R16,$S16)))),ABS(INT(NORMINV(RAND(),$R16,$S16)))))","v":""},"","mean = ",{"$f":"AVERAGE(B16:H16)","v":12},"s.d. = ",{"$f":"STDEV(B16:H16)","v":9.0829510622924747},null,null,null,5,5,13.5597269444884]
["p)",{"$f":"IF($Q17<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q17,(((INT(AVERAGE(A17:$B17,1)))+RANDBETWEEN(1,0.5*$R17))*$Q17)-SUM(A17:$B17),ABS(INT(NORMINV(RAND(),$R17,$S17)))),ABS(INT(NORMINV(RAND(),$R17,$S17)))))","v":6},{"$f":"IF($Q17<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q17,(((INT(AVERAGE($B17:B17,1)))+RANDBETWEEN(1,0.5*$R17))*$Q17)-SUM($B17:B17),ABS(INT(NORMINV(RAND(),$R17,$S17)))),ABS(INT(NORMINV(RAND(),$R17,$S17)))))","v":0},{"$f":"IF($Q17<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q17,(((INT(AVERAGE($B17:C17,1)))+RANDBETWEEN(1,0.5*$R17))*$Q17)-SUM($B17:C17),ABS(INT(NORMINV(RAND(),$R17,$S17)))),ABS(INT(NORMINV(RAND(),$R17,$S17)))))","v":8},{"$f":"IF($Q17<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q17,(((INT(AVERAGE($B17:D17,1)))+RANDBETWEEN(1,0.5*$R17))*$Q17)-SUM($B17:D17),ABS(INT(NORMINV(RAND(),$R17,$S17)))),ABS(INT(NORMINV(RAND(),$R17,$S17)))))","v":6},{"$f":"IF($Q17<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q17,(((INT(AVERAGE($B17:E17,1)))+RANDBETWEEN(1,0.5*$R17))*$Q17)-SUM($B17:E17),ABS(INT(NORMINV(RAND(),$R17,$S17)))),ABS(INT(NORMINV(RAND(),$R17,$S17)))))","v":""},{"$f":"IF($Q17<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q17,(((INT(AVERAGE($B17:F17,1)))+RANDBETWEEN(1,0.5*$R17))*$Q17)-SUM($B17:F17),ABS(INT(NORMINV(RAND(),$R17,$S17)))),ABS(INT(NORMINV(RAND(),$R17,$S17)))))","v":""},{"$f":"IF($Q17<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q17,(((INT(AVERAGE($B17:G17,1)))+RANDBETWEEN(1,0.5*$R17))*$Q17)-SUM($B17:G17),ABS(INT(NORMINV(RAND(),$R17,$S17)))),ABS(INT(NORMINV(RAND(),$R17,$S17)))))","v":""},"","mean = ",5,"s.d. = ",3.4641016151377544,null,null,null,4,4,10.095759116760558]
["q)",{"$f":"IF($Q18<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q18,(((INT(AVERAGE(A18:$B18,1)))+RANDBETWEEN(1,0.5*$R18))*$Q18)-SUM(A18:$B18),ABS(INT(NORMINV(RAND(),$R18,$S18)))),ABS(INT(NORMINV(RAND(),$R18,$S18)))))","v":10},{"$f":"IF($Q18<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q18,(((INT(AVERAGE($B18:B18,1)))+RANDBETWEEN(1,0.5*$R18))*$Q18)-SUM($B18:B18),ABS(INT(NORMINV(RAND(),$R18,$S18)))),ABS(INT(NORMINV(RAND(),$R18,$S18)))))","v":9},{"$f":"IF($Q18<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q18,(((INT(AVERAGE($B18:C18,1)))+RANDBETWEEN(1,0.5*$R18))*$Q18)-SUM($B18:C18),ABS(INT(NORMINV(RAND(),$R18,$S18)))),ABS(INT(NORMINV(RAND(),$R18,$S18)))))","v":9},{"$f":"IF($Q18<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q18,(((INT(AVERAGE($B18:D18,1)))+RANDBETWEEN(1,0.5*$R18))*$Q18)-SUM($B18:D18),ABS(INT(NORMINV(RAND(),$R18,$S18)))),ABS(INT(NORMINV(RAND(),$R18,$S18)))))","v":10},{"$f":"IF($Q18<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q18,(((INT(AVERAGE($B18:E18,1)))+RANDBETWEEN(1,0.5*$R18))*$Q18)-SUM($B18:E18),ABS(INT(NORMINV(RAND(),$R18,$S18)))),ABS(INT(NORMINV(RAND(),$R18,$S18)))))","v":2},{"$f":"IF($Q18<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q18,(((INT(AVERAGE($B18:F18,1)))+RANDBETWEEN(1,0.5*$R18))*$Q18)-SUM($B18:F18),ABS(INT(NORMINV(RAND(),$R18,$S18)))),ABS(INT(NORMINV(RAND(),$R18,$S18)))))","v":12},{"$f":"IF($Q18<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q18,(((INT(AVERAGE($B18:G18,1)))+RANDBETWEEN(1,0.5*$R18))*$Q18)-SUM($B18:G18),ABS(INT(NORMINV(RAND(),$R18,$S18)))),ABS(INT(NORMINV(RAND(),$R18,$S18)))))","v":11},"","mean = ",9,"s.d. = ",3.2659863237109041,null,null,null,7,11,6.967276705844986]
["r)",{"$f":"IF($Q19<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q19,(((INT(AVERAGE(A19:$B19,1)))+RANDBETWEEN(1,0.5*$R19))*$Q19)-SUM(A19:$B19),ABS(INT(NORMINV(RAND(),$R19,$S19)))),ABS(INT(NORMINV(RAND(),$R19,$S19)))))","v":13},{"$f":"IF($Q19<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q19,(((INT(AVERAGE($B19:B19,1)))+RANDBETWEEN(1,0.5*$R19))*$Q19)-SUM($B19:B19),ABS(INT(NORMINV(RAND(),$R19,$S19)))),ABS(INT(NORMINV(RAND(),$R19,$S19)))))","v":23},{"$f":"IF($Q19<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q19,(((INT(AVERAGE($B19:C19,1)))+RANDBETWEEN(1,0.5*$R19))*$Q19)-SUM($B19:C19),ABS(INT(NORMINV(RAND(),$R19,$S19)))),ABS(INT(NORMINV(RAND(),$R19,$S19)))))","v":25},{"$f":"IF($Q19<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q19,(((INT(AVERAGE($B19:D19,1)))+RANDBETWEEN(1,0.5*$R19))*$Q19)-SUM($B19:D19),ABS(INT(NORMINV(RAND(),$R19,$S19)))),ABS(INT(NORMINV(RAND(),$R19,$S19)))))","v":18},{"$f":"IF($Q19<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q19,(((INT(AVERAGE($B19:E19,1)))+RANDBETWEEN(1,0.5*$R19))*$Q19)-SUM($B19:E19),ABS(INT(NORMINV(RAND(),$R19,$S19)))),ABS(INT(NORMINV(RAND(),$R19,$S19)))))","v":36},{"$f":"IF($Q19<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q19,(((INT(AVERAGE($B19:F19,1)))+RANDBETWEEN(1,0.5*$R19))*$Q19)-SUM($B19:F19),ABS(INT(NORMINV(RAND(),$R19,$S19)))),ABS(INT(NORMINV(RAND(),$R19,$S19)))))","v":""},{"$f":"IF($Q19<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q19,(((INT(AVERAGE($B19:G19,1)))+RANDBETWEEN(1,0.5*$R19))*$Q19)-SUM($B19:G19),ABS(INT(NORMINV(RAND(),$R19,$S19)))),ABS(INT(NORMINV(RAND(),$R19,$S19)))))","v":""},"","mean = ",23,"s.d. = ",8.6313382508160341,null,null,null,5,16,4.8806767360402867]
["s)",{"$f":"IF($Q20<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q20,(((INT(AVERAGE(A20:$B20,1)))+RANDBETWEEN(1,0.5*$R20))*$Q20)-SUM(A20:$B20),ABS(INT(NORMINV(RAND(),$R20,$S20)))),ABS(INT(NORMINV(RAND(),$R20,$S20)))))","v":92},{"$f":"IF($Q20<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q20,(((INT(AVERAGE($B20:B20,1)))+RANDBETWEEN(1,0.5*$R20))*$Q20)-SUM($B20:B20),ABS(INT(NORMINV(RAND(),$R20,$S20)))),ABS(INT(NORMINV(RAND(),$R20,$S20)))))","v":75},{"$f":"IF($Q20<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q20,(((INT(AVERAGE($B20:C20,1)))+RANDBETWEEN(1,0.5*$R20))*$Q20)-SUM($B20:C20),ABS(INT(NORMINV(RAND(),$R20,$S20)))),ABS(INT(NORMINV(RAND(),$R20,$S20)))))","v":93},{"$f":"IF($Q20<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q20,(((INT(AVERAGE($B20:D20,1)))+RANDBETWEEN(1,0.5*$R20))*$Q20)-SUM($B20:D20),ABS(INT(NORMINV(RAND(),$R20,$S20)))),ABS(INT(NORMINV(RAND(),$R20,$S20)))))","v":112},{"$f":"IF($Q20<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q20,(((INT(AVERAGE($B20:E20,1)))+RANDBETWEEN(1,0.5*$R20))*$Q20)-SUM($B20:E20),ABS(INT(NORMINV(RAND(),$R20,$S20)))),ABS(INT(NORMINV(RAND(),$R20,$S20)))))","v":88},{"$f":"IF($Q20<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q20,(((INT(AVERAGE($B20:F20,1)))+RANDBETWEEN(1,0.5*$R20))*$Q20)-SUM($B20:F20),ABS(INT(NORMINV(RAND(),$R20,$S20)))),ABS(INT(NORMINV(RAND(),$R20,$S20)))))","v":164},{"$f":"IF($Q20<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q20,(((INT(AVERAGE($B20:G20,1)))+RANDBETWEEN(1,0.5*$R20))*$Q20)-SUM($B20:G20),ABS(INT(NORMINV(RAND(),$R20,$S20)))),ABS(INT(NORMINV(RAND(),$R20,$S20)))))","v":""},"","mean = ",104,"s.d. = ",31.704889212864316,null,null,null,6,101,11.356596175052584]
["t)",{"$f":"IF($Q21<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q21,(((INT(AVERAGE(A21:$B21,1)))+RANDBETWEEN(1,0.5*$R21))*$Q21)-SUM(A21:$B21),ABS(INT(NORMINV(RAND(),$R21,$S21)))),ABS(INT(NORMINV(RAND(),$R21,$S21)))))","v":4},{"$f":"IF($Q21<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q21,(((INT(AVERAGE($B21:B21,1)))+RANDBETWEEN(1,0.5*$R21))*$Q21)-SUM($B21:B21),ABS(INT(NORMINV(RAND(),$R21,$S21)))),ABS(INT(NORMINV(RAND(),$R21,$S21)))))","v":9},{"$f":"IF($Q21<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q21,(((INT(AVERAGE($B21:C21,1)))+RANDBETWEEN(1,0.5*$R21))*$Q21)-SUM($B21:C21),ABS(INT(NORMINV(RAND(),$R21,$S21)))),ABS(INT(NORMINV(RAND(),$R21,$S21)))))","v":17},{"$f":"IF($Q21<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q21,(((INT(AVERAGE($B21:D21,1)))+RANDBETWEEN(1,0.5*$R21))*$Q21)-SUM($B21:D21),ABS(INT(NORMINV(RAND(),$R21,$S21)))),ABS(INT(NORMINV(RAND(),$R21,$S21)))))","v":6},{"$f":"IF($Q21<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q21,(((INT(AVERAGE($B21:E21,1)))+RANDBETWEEN(1,0.5*$R21))*$Q21)-SUM($B21:E21),ABS(INT(NORMINV(RAND(),$R21,$S21)))),ABS(INT(NORMINV(RAND(),$R21,$S21)))))","v":""},{"$f":"IF($Q21<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q21,(((INT(AVERAGE($B21:F21,1)))+RANDBETWEEN(1,0.5*$R21))*$Q21)-SUM($B21:F21),ABS(INT(NORMINV(RAND(),$R21,$S21)))),ABS(INT(NORMINV(RAND(),$R21,$S21)))))","v":""},{"$f":"IF($Q21<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q21,(((INT(AVERAGE($B21:G21,1)))+RANDBETWEEN(1,0.5*$R21))*$Q21)-SUM($B21:G21),ABS(INT(NORMINV(RAND(),$R21,$S21)))),ABS(INT(NORMINV(RAND(),$R21,$S21)))))","v":""},"","mean = ",9,"s.d. = ",5.715476066494082,null,null,null,4,6,4.9659994652128896]
["u)",{"$f":"IF($Q22<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q22,(((INT(AVERAGE(A22:$B22,1)))+RANDBETWEEN(1,0.5*$R22))*$Q22)-SUM(A22:$B22),ABS(INT(NORMINV(RAND(),$R22,$S22)))),ABS(INT(NORMINV(RAND(),$R22,$S22)))))","v":19},{"$f":"IF($Q22<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q22,(((INT(AVERAGE($B22:B22,1)))+RANDBETWEEN(1,0.5*$R22))*$Q22)-SUM($B22:B22),ABS(INT(NORMINV(RAND(),$R22,$S22)))),ABS(INT(NORMINV(RAND(),$R22,$S22)))))","v":17},{"$f":"IF($Q22<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q22,(((INT(AVERAGE($B22:C22,1)))+RANDBETWEEN(1,0.5*$R22))*$Q22)-SUM($B22:C22),ABS(INT(NORMINV(RAND(),$R22,$S22)))),ABS(INT(NORMINV(RAND(),$R22,$S22)))))","v":24},{"$f":"IF($Q22<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q22,(((INT(AVERAGE($B22:D22,1)))+RANDBETWEEN(1,0.5*$R22))*$Q22)-SUM($B22:D22),ABS(INT(NORMINV(RAND(),$R22,$S22)))),ABS(INT(NORMINV(RAND(),$R22,$S22)))))","v":""},{"$f":"IF($Q22<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q22,(((INT(AVERAGE($B22:E22,1)))+RANDBETWEEN(1,0.5*$R22))*$Q22)-SUM($B22:E22),ABS(INT(NORMINV(RAND(),$R22,$S22)))),ABS(INT(NORMINV(RAND(),$R22,$S22)))))","v":""},{"$f":"IF($Q22<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q22,(((INT(AVERAGE($B22:F22,1)))+RANDBETWEEN(1,0.5*$R22))*$Q22)-SUM($B22:F22),ABS(INT(NORMINV(RAND(),$R22,$S22)))),ABS(INT(NORMINV(RAND(),$R22,$S22)))))","v":""},{"$f":"IF($Q22<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q22,(((INT(AVERAGE($B22:G22,1)))+RANDBETWEEN(1,0.5*$R22))*$Q22)-SUM($B22:G22),ABS(INT(NORMINV(RAND(),$R22,$S22)))),ABS(INT(NORMINV(RAND(),$R22,$S22)))))","v":""},"","mean = ",20,"s.d. = ",3.6055512754639891,null,null,null,3,18,1.5087583157068551]
["v)",{"$f":"IF($Q23<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q23,(((INT(AVERAGE(A23:$B23,1)))+RANDBETWEEN(1,0.5*$R23))*$Q23)-SUM(A23:$B23),ABS(INT(NORMINV(RAND(),$R23,$S23)))),ABS(INT(NORMINV(RAND(),$R23,$S23)))))","v":12},{"$f":"IF($Q23<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q23,(((INT(AVERAGE($B23:B23,1)))+RANDBETWEEN(1,0.5*$R23))*$Q23)-SUM($B23:B23),ABS(INT(NORMINV(RAND(),$R23,$S23)))),ABS(INT(NORMINV(RAND(),$R23,$S23)))))","v":12},{"$f":"IF($Q23<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q23,(((INT(AVERAGE($B23:C23,1)))+RANDBETWEEN(1,0.5*$R23))*$Q23)-SUM($B23:C23),ABS(INT(NORMINV(RAND(),$R23,$S23)))),ABS(INT(NORMINV(RAND(),$R23,$S23)))))","v":6},{"$f":"IF($Q23<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q23,(((INT(AVERAGE($B23:D23,1)))+RANDBETWEEN(1,0.5*$R23))*$Q23)-SUM($B23:D23),ABS(INT(NORMINV(RAND(),$R23,$S23)))),ABS(INT(NORMINV(RAND(),$R23,$S23)))))","v":6},{"$f":"IF($Q23<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q23,(((INT(AVERAGE($B23:E23,1)))+RANDBETWEEN(1,0.5*$R23))*$Q23)-SUM($B23:E23),ABS(INT(NORMINV(RAND(),$R23,$S23)))),ABS(INT(NORMINV(RAND(),$R23,$S23)))))","v":7},{"$f":"IF($Q23<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q23,(((INT(AVERAGE($B23:F23,1)))+RANDBETWEEN(1,0.5*$R23))*$Q23)-SUM($B23:F23),ABS(INT(NORMINV(RAND(),$R23,$S23)))),ABS(INT(NORMINV(RAND(),$R23,$S23)))))","v":11},{"$f":"IF($Q23<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q23,(((INT(AVERAGE($B23:G23,1)))+RANDBETWEEN(1,0.5*$R23))*$Q23)-SUM($B23:G23),ABS(INT(NORMINV(RAND(),$R23,$S23)))),ABS(INT(NORMINV(RAND(),$R23,$S23)))))","v":9},"","mean = ",9,"s.d. = ",2.70801280154532,null,null,null,7,9,5.0733143191950845]
["w)",{"$f":"IF($Q24<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q24,(((INT(AVERAGE(A24:$B24,1)))+RANDBETWEEN(1,0.5*$R24))*$Q24)-SUM(A24:$B24),ABS(INT(NORMINV(RAND(),$R24,$S24)))),ABS(INT(NORMINV(RAND(),$R24,$S24)))))","v":14},{"$f":"IF($Q24<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q24,(((INT(AVERAGE($B24:B24,1)))+RANDBETWEEN(1,0.5*$R24))*$Q24)-SUM($B24:B24),ABS(INT(NORMINV(RAND(),$R24,$S24)))),ABS(INT(NORMINV(RAND(),$R24,$S24)))))","v":18},{"$f":"IF($Q24<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q24,(((INT(AVERAGE($B24:C24,1)))+RANDBETWEEN(1,0.5*$R24))*$Q24)-SUM($B24:C24),ABS(INT(NORMINV(RAND(),$R24,$S24)))),ABS(INT(NORMINV(RAND(),$R24,$S24)))))","v":13},{"$f":"IF($Q24<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q24,(((INT(AVERAGE($B24:D24,1)))+RANDBETWEEN(1,0.5*$R24))*$Q24)-SUM($B24:D24),ABS(INT(NORMINV(RAND(),$R24,$S24)))),ABS(INT(NORMINV(RAND(),$R24,$S24)))))","v":14},{"$f":"IF($Q24<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q24,(((INT(AVERAGE($B24:E24,1)))+RANDBETWEEN(1,0.5*$R24))*$Q24)-SUM($B24:E24),ABS(INT(NORMINV(RAND(),$R24,$S24)))),ABS(INT(NORMINV(RAND(),$R24,$S24)))))","v":9},{"$f":"IF($Q24<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q24,(((INT(AVERAGE($B24:F24,1)))+RANDBETWEEN(1,0.5*$R24))*$Q24)-SUM($B24:F24),ABS(INT(NORMINV(RAND(),$R24,$S24)))),ABS(INT(NORMINV(RAND(),$R24,$S24)))))","v":34},{"$f":"IF($Q24<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q24,(((INT(AVERAGE($B24:G24,1)))+RANDBETWEEN(1,0.5*$R24))*$Q24)-SUM($B24:G24),ABS(INT(NORMINV(RAND(),$R24,$S24)))),ABS(INT(NORMINV(RAND(),$R24,$S24)))))","v":""},"","mean = ",17,"s.d. = ",8.8090862182180967,null,null,null,6,13,5.320355353571645]
["x)",{"$f":"IF($Q25<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q25,(((INT(AVERAGE(A25:$B25,1)))+RANDBETWEEN(1,0.5*$R25))*$Q25)-SUM(A25:$B25),ABS(INT(NORMINV(RAND(),$R25,$S25)))),ABS(INT(NORMINV(RAND(),$R25,$S25)))))","v":18},{"$f":"IF($Q25<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q25,(((INT(AVERAGE($B25:B25,1)))+RANDBETWEEN(1,0.5*$R25))*$Q25)-SUM($B25:B25),ABS(INT(NORMINV(RAND(),$R25,$S25)))),ABS(INT(NORMINV(RAND(),$R25,$S25)))))","v":11},{"$f":"IF($Q25<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q25,(((INT(AVERAGE($B25:C25,1)))+RANDBETWEEN(1,0.5*$R25))*$Q25)-SUM($B25:C25),ABS(INT(NORMINV(RAND(),$R25,$S25)))),ABS(INT(NORMINV(RAND(),$R25,$S25)))))","v":7},{"$f":"IF($Q25<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q25,(((INT(AVERAGE($B25:D25,1)))+RANDBETWEEN(1,0.5*$R25))*$Q25)-SUM($B25:D25),ABS(INT(NORMINV(RAND(),$R25,$S25)))),ABS(INT(NORMINV(RAND(),$R25,$S25)))))","v":""},{"$f":"IF($Q25<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q25,(((INT(AVERAGE($B25:E25,1)))+RANDBETWEEN(1,0.5*$R25))*$Q25)-SUM($B25:E25),ABS(INT(NORMINV(RAND(),$R25,$S25)))),ABS(INT(NORMINV(RAND(),$R25,$S25)))))","v":""},{"$f":"IF($Q25<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q25,(((INT(AVERAGE($B25:F25,1)))+RANDBETWEEN(1,0.5*$R25))*$Q25)-SUM($B25:F25),ABS(INT(NORMINV(RAND(),$R25,$S25)))),ABS(INT(NORMINV(RAND(),$R25,$S25)))))","v":""},{"$f":"IF($Q25<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q25,(((INT(AVERAGE($B25:G25,1)))+RANDBETWEEN(1,0.5*$R25))*$Q25)-SUM($B25:G25),ABS(INT(NORMINV(RAND(),$R25,$S25)))),ABS(INT(NORMINV(RAND(),$R25,$S25)))))","v":""},"","mean = ",12,"s.d. = ",5.5677643628300215,null,null,null,3,4,13.397522001581669]
["y)",{"$f":"IF($Q26<B$1,\"\",IF(Worksheet!$B$5,IF(B$1=$Q26,(((INT(AVERAGE(A26:$B26,1)))+RANDBETWEEN(1,0.5*$R26))*$Q26)-SUM(A26:$B26),ABS(INT(NORMINV(RAND(),$R26,$S26)))),ABS(INT(NORMINV(RAND(),$R26,$S26)))))","v":7},{"$f":"IF($Q26<C$1,\"\",IF(Worksheet!$B$5,IF(C$1=$Q26,(((INT(AVERAGE($B26:B26,1)))+RANDBETWEEN(1,0.5*$R26))*$Q26)-SUM($B26:B26),ABS(INT(NORMINV(RAND(),$R26,$S26)))),ABS(INT(NORMINV(RAND(),$R26,$S26)))))","v":20},{"$f":"IF($Q26<D$1,\"\",IF(Worksheet!$B$5,IF(D$1=$Q26,(((INT(AVERAGE($B26:C26,1)))+RANDBETWEEN(1,0.5*$R26))*$Q26)-SUM($B26:C26),ABS(INT(NORMINV(RAND(),$R26,$S26)))),ABS(INT(NORMINV(RAND(),$R26,$S26)))))","v":15},{"$f":"IF($Q26<E$1,\"\",IF(Worksheet!$B$5,IF(E$1=$Q26,(((INT(AVERAGE($B26:D26,1)))+RANDBETWEEN(1,0.5*$R26))*$Q26)-SUM($B26:D26),ABS(INT(NORMINV(RAND(),$R26,$S26)))),ABS(INT(NORMINV(RAND(),$R26,$S26)))))","v":29},{"$f":"IF($Q26<F$1,\"\",IF(Worksheet!$B$5,IF(F$1=$Q26,(((INT(AVERAGE($B26:E26,1)))+RANDBETWEEN(1,0.5*$R26))*$Q26)-SUM($B26:E26),ABS(INT(NORMINV(RAND(),$R26,$S26)))),ABS(INT(NORMINV(RAND(),$R26,$S26)))))","v":29},{"$f":"IF($Q26<G$1,\"\",IF(Worksheet!$B$5,IF(G$1=$Q26,(((INT(AVERAGE($B26:F26,1)))+RANDBETWEEN(1,0.5*$R26))*$Q26)-SUM($B26:F26),ABS(INT(NORMINV(RAND(),$R26,$S26)))),ABS(INT(NORMINV(RAND(),$R26,$S26)))))","v":""},{"$f":"IF($Q26<H$1,\"\",IF(Worksheet!$B$5,IF(H$1=$Q26,(((INT(AVERAGE($B26:G26,1)))+RANDBETWEEN(1,0.5*$R26))*$Q26)-SUM($B26:G26),ABS(INT(NORMINV(RAND(),$R26,$S26)))),ABS(INT(NORMINV(RAND(),$R26,$S26)))))","v":""},"","mean = ",20,"s.d. = ",9.4339811320566032,null,null,null,5,15,8.7984527949273961]