{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Each Sample Prob Same","Each Sample Prob Same (an)","SRS","Combinations"],"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":"Each Sample Prob Same","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Elements in Population:",null,"n = Pop Size",{"$f":"\"Sample Size = \"&D2","v":"Sample Size = 2"},"Combinations of Samples"]
["Jo",null,{"$f":"COUNTA(A2:A6)","v":5},2,{"$f":"COMBIN(C2,D2)","v":10}]
["Tyrone"]
["Sioux",null,"Sample #","Element 1","Element 2","p(X)"]
["Sue",null,1,{"$f":"$A$2","v":"Jo"},{"$f":"A3","v":"Tyrone"}]
["Chin",null,2,"Jo","Sioux"]
[null,null,3,"Jo","Sue"]
[null,null,4,"Jo","Chin"]
[null,null,5,{"$f":"$A$3","v":"Tyrone"},{"$f":"A4","v":"Sioux"}]
[null,null,6,"Tyrone","Sue"]
[null,null,7,"Tyrone","Chin"]
[null,null,8,{"$f":"$A$4","v":"Sioux"},{"$f":"A5","v":"Sue"}]
[null,null,9,"Sioux","Chin"]
[null,null,10,{"$f":"A5","v":"Sue"},{"$f":"A6","v":"Chin"}]

{"sheet":"Each Sample Prob Same (an)","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Elements in Population:",null,"n = Pop Size",{"$f":"\"Sample Size = \"&D2","v":"Sample Size = 2"},"Combinations of Samples"]
["Jo",null,{"$f":"COUNTA(A2:A6)","v":5},2,{"$f":"COMBIN(C2,D2)","v":10}]
["Tyrone"]
["Sioux",null,"Sample #","Element 1","Element 2","p(X)"]
["Sue",null,1,{"$f":"$A$2","v":"Jo"},{"$f":"A3","v":"Tyrone"},{"$f":"1/$E$2","v":0.1}]
["Chin",null,2,"Jo","Sioux",{"$f":"1/$E$2","v":0.1}]
[null,null,3,"Jo","Sue",0.1]
[null,null,4,"Jo","Chin",0.1]
[null,null,5,{"$f":"$A$3","v":"Tyrone"},{"$f":"A4","v":"Sioux"},0.1]
[null,null,6,"Tyrone","Sue",0.1]
[null,null,7,"Tyrone","Chin",0.1]
[null,null,8,{"$f":"$A$4","v":"Sioux"},{"$f":"A5","v":"Sue"},0.1]
[null,null,9,"Sioux","Chin",0.1]
[null,null,10,{"$f":"A5","v":"Sue"},{"$f":"A6","v":"Chin"},0.1]

{"sheet":"SRS","index":2,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["RAND","SalesRep","Sales",null,"Sample Size, n",null,"Number","Smallest RAND","SalesRep","Sales"]
[{"$f":"RAND()","v":0.56333018604276952},"Ashleigh",83064,null,5,null,1,{"$f":"SMALL($A$2:$A$18,G2)","v":6.3127271762740023E-2},{"$f":"VLOOKUP($H2,$A$2:$C$18,COLUMNS($H2:I2),0)","v":"Chin"},{"$f":"VLOOKUP($H2,$A$2:$C$18,COLUMNS($H2:J2),0)","v":83768}]
[0.52015143932110641,"Chauncey",43040,null,null,null,2,{"$f":"SMALL($A$2:$A$18,G3)","v":0.13929289010239199},{"$f":"VLOOKUP($H3,$A$2:$C$18,COLUMNS($H3:I3),0)","v":"Delila"},{"$f":"VLOOKUP($H3,$A$2:$C$18,COLUMNS($H3:J3),0)","v":101112}]
[6.3127271762740023E-2,"Chin",83768,null,null,null,3,0.18733545708994437,{"$f":"VLOOKUP($H4,$A$2:$C$18,COLUMNS($H4:I4),0)","v":"Kenia"},{"$f":"VLOOKUP($H4,$A$2:$C$18,COLUMNS($H4:J4),0)","v":97051}]
[0.13929289010239199,"Delila",101112,null,null,null,4,0.28207071346829937,{"$f":"VLOOKUP($H5,$A$2:$C$18,COLUMNS($H5:I5),0)","v":"Pham"},{"$f":"VLOOKUP($H5,$A$2:$C$18,COLUMNS($H5:J5),0)","v":36016}]
[0.90180968142674056,"Elina",19868,null,null,null,5,0.36100571088993838,{"$f":"VLOOKUP($H6,$A$2:$C$18,COLUMNS($H6:I6),0)","v":"Kip"},{"$f":"VLOOKUP($H6,$A$2:$C$18,COLUMNS($H6:J6),0)","v":50249}]
[0.99281227478787015,"Garland",36021]
[0.68660807290549419,"Gigi",12030,null,null,null,null,null,"Xbar",{"$f":"AVERAGE(J2:J6)","v":73639.199999999997}]
[0.54346464009225381,"Gregoria",65219,null,null,null,null,null,"Pop Mean",{"$f":"AVERAGE(C2:C18)","v":64706}]
[0.38229476851652422,"Kacey",94450,null,null,null,null,null,"Sampling Error",{"$f":"J8-J9","v":8933.1999999999971}]
[0.18733545708994437,"Kenia",97051]
[0.36100571088993838,"Kip",50249]
[0.37587518701979972,"Paige",117461]
[0.28207071346829937,"Pham",36016]
[0.60815194947824169,"Reuben",41696]
[0.74317701403854286,"Roslyn",84732]
[0.68524528399049123,"Sheladawn",100893]
[0.75532257003802006,"Tyrone",33332]

{"sheet":"Combinations","index":3,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Population Items",null,"Sample Size = n"]
[null,null,6]
[]
[null,null,"Pop Size = N"]
[null,null,{"$f":"COUNTA(A2:A1048576)","v":0}]
[]
[null,null,"Combinations"]
[]
[]
[null,null,"Steps:"]
[null,null,"1) Type pop. items in cell A2 and below"]
[null,null,"2) Type sample size in cell C2"]
[null,null,"3) Click Button"]
[null,null,"Then combination of items appear in cell E2 and below and to right"]
[]
[]
[]
[]
[]
[]
[null,null,"http://www.mrexcel.com/forum/showthread.php?t=277924"]