{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["sbExactRandHistoGrm"],"not_rendered":{"charts":0,"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":"sbExactRandHistoGrm","index":0,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,3,0,8],[0,9,0,11],[15,3,15,8],[15,9,15,11]]}
[null,null,null,"Just statistical likelihood",null,null,null,null,null,"Total"]
["Color","Likelihood","Pos / Iteration","One","Two","Three","Four","Five","Six","Green","Yellow","Red"]
["Green",{"$f":"0.5","v":0.5},1,{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Red"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"COUNTIF($D3:$I3,J$2)","v":3},{"$f":"COUNTIF($D3:$I3,K$2)","v":2},1]
["Yellow",{"$f":"1/3","v":0.33333333333333331},2,{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"COUNTIF($D4:$I4,J$2)","v":4},2,0]
["Red",{"$f":"1/6","v":0.16666666666666666},3,{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Red"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Red"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Red"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},3,0,3]
[null,null,4,{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Red"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},5,0,1]
[null,null,5,{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},3,3,0]
[null,null,6,{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Red"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},3,2,1]
[null,null,7,{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},4,2,0]
[null,null,8,{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Red"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},1,4,1]
[null,null,9,{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Red"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},2,3,1]
[null,null,10,{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Red"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Yellow"},{"$f":"INDEX($A$3:$A$5,INT(sbRandHistogrm(1,4,$B$3:$B$5)))","v":"Green"},2,3,1]
[null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(J3:J12)","v":30},{"$f":"SUM(K3:K12)","v":21},{"$f":"SUM(L3:L12)","v":9}]
[null,null,null,null,null,null,null,null,"Should stochastically be:",{"$f":"COUNTA($D$3:$I$12)*TRANSPOSE($B$3:$B$5)","v":30},20,10]
[]
[null,null,null,"Exact likelihood",null,null,null,null,null,"Total"]
[null,null,"Pos / Iteration","One","Two","Three","Four","Five","Six","Green","Yellow","Red"]
[null,null,1,{"$f":"INDEX($A$3:$A$5,INT(sbExactRandHistogrm(6,1,4,$B$3:$B$5)))","v":"Yellow"},"Green","Yellow","Red","Green","Green",{"$f":"COUNTIF($D18:$I18,J$2)","v":3},{"$f":"COUNTIF($D18:$I18,K$2)","v":2},1]
[null,null,2,{"$f":"INDEX($A$3:$A$5,INT(sbExactRandHistogrm(6,1,4,$B$3:$B$5)))","v":"Yellow"},"Green","Yellow","Green","Green","Red",{"$f":"COUNTIF($D19:$I19,J$2)","v":3},2,1]
[null,null,3,{"$f":"INDEX($A$3:$A$5,INT(sbExactRandHistogrm(6,1,4,$B$3:$B$5)))","v":"Yellow"},"Red","Green","Yellow","Green","Green",3,2,1]
[null,null,4,{"$f":"INDEX($A$3:$A$5,INT(sbExactRandHistogrm(6,1,4,$B$3:$B$5)))","v":"Yellow"},"Green","Green","Yellow","Green","Red",3,2,1]
[null,null,5,{"$f":"INDEX($A$3:$A$5,INT(sbExactRandHistogrm(6,1,4,$B$3:$B$5)))","v":"Yellow"},"Yellow","Red","Green","Green","Green",3,2,1]
[null,null,6,{"$f":"INDEX($A$3:$A$5,INT(sbExactRandHistogrm(6,1,4,$B$3:$B$5)))","v":"Green"},"Green","Yellow","Green","Yellow","Red",3,2,1]
[null,null,7,{"$f":"INDEX($A$3:$A$5,INT(sbExactRandHistogrm(6,1,4,$B$3:$B$5)))","v":"Green"},"Green","Yellow","Green","Yellow","Red",3,2,1]
[null,null,8,{"$f":"INDEX($A$3:$A$5,INT(sbExactRandHistogrm(6,1,4,$B$3:$B$5)))","v":"Green"},"Green","Yellow","Red","Yellow","Green",3,2,1]
[null,null,9,{"$f":"INDEX($A$3:$A$5,INT(sbExactRandHistogrm(6,1,4,$B$3:$B$5)))","v":"Green"},"Green","Green","Red","Yellow","Yellow",3,2,1]
[null,null,10,{"$f":"INDEX($A$3:$A$5,INT(sbExactRandHistogrm(6,1,4,$B$3:$B$5)))","v":"Green"},"Yellow","Red","Green","Yellow","Green",3,2,1]
[null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(J18:J27)","v":30},{"$f":"SUM(K18:K27)","v":20},{"$f":"SUM(L18:L27)","v":10}]
[null,null,null,null,null,null,null,null,"Should stochastically be:",{"$f":"COUNTA($D$3:$I$12)*TRANSPOSE($B$3:$B$5)","v":30},20,10]