{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Notes","Section 7","Section 8","Section 9"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Notes","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["This spreadsheet illustrates many of the numbered formulas in Sections 7,8 and 9."]
[]
["Color Codes"]
[null,"Columns with Yellow Header"]
[null,null,"Inputs -- these can be modified to see results in the other columns"]
[]
[null,"Columns with Green Header"]
[null,null,"These implement the solution using standard Excel functions"]
[null,null,"Do not modify -- or modify only if you intend to modify the logic or implement alternative logic"]
[]
[null,"Columns with Blue Header"]
[null,null,"These implement the solution using (Visual Basic for Application (VBA)  functions.  I.e., \"macros\""]
[null,null,"Do not modify -- or modify only if you intend to modify the logic or implement alternative logic"]

{"sheet":"Section 7","index":1,"n_rows":71,"n_cols":9,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["Section","Formula","x","n","p","Pr (X = x)"]
[7.2,"7.2.1",115,400,0.3,{"$f":"_xlfn.BINOM.DIST(C2,D2,E2,FALSE)","v":3.7902074613855835E-2}]
[]
["Section","Formula","x","n","p","Pr (X <= x)"]
[7.2,"7.2.2",115,400,0.3,{"$f":"_xlfn.BINOM.DIST(C5,D5,E5,TRUE)","v":0.31370671847603604}]
[]
[]
[]
["Section","Formula","x","n","M","N","Pr (X = x)"]
[7.3,"7.3.1",115,400,3000,10000,{"$f":"_xlfn.HYPGEOM.DIST(C10,D10,E10,F10,FALSE)","v":3.8425530378906059E-2}]
[]
["Section","Formula","x","n","M","N","Pr (X <= x)"]
[7.3,"7.3.2",115,400,3000,10000,{"$f":"_xlfn.HYPGEOM.DIST(C13,D13,E13,F13,TRUE)","v":0.30998040251554931}]
[]
[]
[]
["Section","Formula","n","p","Mean of X"]
[7.4,"7.4.1",400,0.3,{"$f":"C18*D18","v":120}]
[]
["Section","Formula","n","p","Std Dev of X"]
[7.4,"7.4.2",400,0.3,{"$f":"(C21*D21*(1-D21))^0.5","v":9.1651513899116797}]
[]
["Section","Formula","n","p","Mean of (X/n)"]
[7.4,"7.4.4",400,0.3,{"$f":"D24","v":0.3}]
[]
["Section","Formula","n","p","Std Dev of (X/n)"]
[7.4,"7.4.5",400,0.3,{"$f":"(D27*(1-D27)/C27)^0.5","v":2.29128784747792E-2}]
[]
[]
[]
["Section","Formula","x","µ","σ","Pr (X <= x)"]
[7.5,"7.5.1",115,120,9.1651513899116797,{"$f":"_xlfn.NORM.DIST(C32,D32,E32,TRUE)","v":0.2926894642304807}]
[]
["Section","Formula","µ","z","σ","x"]
[7.5,"7.5.2",120,-0.54554472558998102,9.1651513899116797,{"$f":"C35+D35*E35","v":115}]
[]
["Section","Formula","x","µ","σ","z"]
[7.5,"7.5.4",115,120,9.1651513899116797,{"$f":"(C38-D38)/E38","v":-0.54554472558998102}]
[]
["Section","Formula","x","µ","σ","z","Pr (Z <= z)"]
[7.5,"7.5.5",115,120,9.1651513899116797,{"$f":"(C41-D41)/E41","v":-0.54554472558998102},{"$f":"_xlfn.NORM.DIST(F41,0,1,TRUE)","v":0.2926894642304807}]
[]
["Section","Formula","x","µ","σ","z","Pr (Z <= z)"]
[7.5,"7.5.6",115,120,9.1651513899116797,{"$f":"(C44-D44)/E44","v":-0.54554472558998102},{"$f":"_xlfn.NORM.S.DIST(F44,TRUE)","v":0.2926894642304807}]
[]
[]
[]
["Section","Formula","x","µ","σ","z","Pr (Z <= z)","-z","1-Pr (Z <= -z)"]
[7.6,"7.6.1",115,120,9.1651513899116797,{"$f":"(C49-D49)/E49","v":-0.54554472558998102},{"$f":"_xlfn.NORM.S.DIST(F49,TRUE)","v":0.2926894642304807},{"$f":"-F49","v":0.54554472558998102},{"$f":"1-_xlfn.NORM.S.DIST(H49,TRUE)","v":0.2926894642304807}]
[]
[]
[]
["Section","Formula","x","n","p","Binom","Norm"]
[7.7,"7.7.1",115,400,0.3,{"$f":"_xlfn.BINOM.DIST(C54,D54,E54,TRUE)","v":0.31370671847603604},{"$f":"_xlfn.NORM.DIST(C54/D54,E54,(E54*(1-E54)/D54)^0.5,TRUE)","v":0.29268946423048048}]
[]
["Section","Formula","x","n","p","z","Binom","Norm"]
[7.7,"7.7.2\n7.7.3",115,400,0.3,{"$f":"(C57/D57-E57)/((E57*(1-E57)/D57)^0.5)","v":-0.54554472558998146},{"$f":"_xlfn.BINOM.DIST(C57,D57,E57,TRUE)","v":0.31370671847603604},{"$f":"_xlfn.NORM.DIST(F57,0,1,TRUE)","v":0.29268946423048048}]
[]
["Section","Formula","x","n","p","Binom","Norm"]
[7.7,"7.7.5",115,400,0.3,{"$f":"_xlfn.BINOM.DIST(C60,D60,E60,TRUE)","v":0.31370671847603604},{"$f":"_xlfn.NORM.DIST((C60+0.5)/D60,E60,(E60*(1-E60)/D60)^0.5,TRUE)","v":0.31171667069105269}]
[]
["Section","Formula","x","n","p","z","Binom","Norm"]
[7.7,"7.7.6\n7.7.7",115,400,0.3,{"$f":"((C63+0.5)/D63-E63)/((E63*(1-E63)/D63)^0.5)","v":-0.49099025303098209},{"$f":"_xlfn.BINOM.DIST(C63,D63,E63,TRUE)","v":0.31370671847603604},{"$f":"_xlfn.NORM.DIST(F63,0,1,TRUE)","v":0.31171667069105269}]
[]
[]
[]
["Section","Formula","Pr (X <= x)","µ","σ","x"]
[7.8,"7.8.2",0.2926894642304807,120,9.1651513899116797,{"$f":"_xlfn.NORM.INV(C68,D68,E68)","v":115}]
[]
["Section","Formula","Pr (Z <= z)","µ","σ","z","x"]
[7.8,"7.8.3\n7.8.4",0.2926894642304807,120,{"$f":"E38","v":9.1651513899116797},{"$f":"_xlfn.NORM.INV(C71,0,1)","v":-0.54554472558998113},{"$f":"F71*E71+D71","v":115}]

{"sheet":"Section 8","index":2,"n_rows":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Section","Formula","µ","σ","e","Pr (X <= µ - e)"]
[8.1,"8.1.1",0.3,2.29128784747792E-2,{"$f":"18/400","v":4.4999999999999998E-2},{"$f":"_xlfn.NORM.DIST(C2-E2,C2,D2,TRUE)","v":2.4767306717813395E-2}]
[]
["Section","Formula","µ","σ","e","Pr (µ-e ≤ X ≤ µ+e)"]
[8.1,"8.1.2",0.3,2.29128784747792E-2,{"$f":"18/400","v":4.4999999999999998E-2},{"$f":"_xlfn.NORM.DIST(C5+E5,C5,D5,TRUE)-_xlfn.NORM.DIST(C5-E5,C5,D5,TRUE)","v":0.95046538656437329}]
[]
["Section","Formula","µ","σ","e","Pr (X ≥ µ + e)"]
[8.1,"8.1.3",0.3,2.29128784747792E-2,{"$f":"18/400","v":4.4999999999999998E-2},{"$f":"_xlfn.NORM.DIST(C8+E8,C8,D8,TRUE)","v":0.97523269328218665}]
[]
["Section","Formula","n","p","e","Pr (X <= p - e)"]
[8.1,"8.1.4",400,0.3,{"$f":"18/400","v":4.4999999999999998E-2},{"$f":"_xlfn.NORM.DIST(D11-E11,D11,(D11*(1-D11)/C11)^0.5,TRUE)","v":2.4767306717813395E-2}]
[]
["Section","Formula","n","p","e","Pr (p-e ≤ X ≤p +e)"]
[8.1,"8.1.5",400,0.3,{"$f":"18/400","v":4.4999999999999998E-2},{"$f":"_xlfn.NORM.DIST(D14+E14,D14,(D14*(1-D14)/C14)^0.5,TRUE)-_xlfn.NORM.DIST(D14-E14,D14,(D14*(1-D14)/C14)^0.5,TRUE)","v":0.95046538656437329}]
[]
["Section","Formula","n","p","e","Pr (X ≥ p + e)"]
[8.1,"8.1.6",400,0.3,{"$f":"18/400","v":4.4999999999999998E-2},{"$f":"_xlfn.NORM.DIST(D17+E17,D17,(D17*(1-D17)/C17)^0.5,TRUE)","v":0.97523269328218665}]
[]
[]
[]
["Section","Formula","x","n","CL","x/n","pU","ME"]
[8.1999999999999993,"8.2.6\n8.2.7",120,400,0.95,{"$f":"C22/D22","v":0.3},{"$f":"_xlfn.NORM.INV(1-(1-E22)/2, F22, (F22*(1-F22)/D22)^0.5)","v":0.34490841659271027},{"$f":"G22-F22","v":4.4908416592710276E-2}]
[]
["Section","Formula","x","n","CL","x/n","pL","ME"]
[8.1999999999999993,"8.2.8\n8.2.9",120,400,0.95,{"$f":"C25/D25","v":0.3},{"$f":"_xlfn.NORM.INV((1-E25)/2, F25, (F25*(1-F25)/D25)^0.5)","v":0.25509158340728971},{"$f":"F25-G25","v":4.4908416592710276E-2}]
[]
["Section","Formula","x","n","ME","x/n","CL"]
[8.1999999999999993,"8.2.10",120,400,0.05,{"$f":"C28/D28","v":0.3},{"$f":"_xlfn.NORM.DIST(F28+E28,F28,(F28*(1-F28)/D28)^0.5,TRUE)-_xlfn.NORM.DIST(F28-E28,F28,(F28*(1-F28)/D28)^0.5,TRUE)","v":0.97090366825874774}]
[]
["Section","Formula","p","CL","ME","n"]
[8.1999999999999993,"8.2.11",0.5,{"$f":"E22","v":0.95},{"$f":"E28","v":0.05},{"$f":"C31*(1-C31)/    ((E31/_xlfn.NORM.INV(1-(1-D31)/2,0,1))^2)","v":384.14588206941232}]
[]
[]
[]
["Section","Formula","n","x","CL","p","a","b","c","pL","pU"]
[8.3000000000000007,"8.3.4",120,400,0.95,{"$f":"C36/D36","v":0.3},{"$f":"1+(_xlfn.NORM.INV((1 - (1 - E36)/2), 0, 1)^2)/D36","v":1.0096036470517353}]
[null,"8.3.5",null,null,null,null,null,{"$f":"-(2*F36+(_xlfn.NORM.INV((1-(1-E36)/2),0,1)^2/D36))","v":-0.60960364705173531}]
[null,"8.3.6",null,null,null,null,null,null,{"$f":"F36^2","v":0.09}]
[null,"8.3.7",null,null,null,null,null,null,null,{"$f":"(-H37-(H37^2-4*G36*I38)^0.5)/(2*G36)","v":0.25716767195619694},{"$f":"(-H37+(H37^2-4*G36*I38)^0.5)/(2*G36)","v":0.34663724577752164}]
[]
[]
[]
["Section","Formula","n","x","sample p","CL","pL","pU","pL","pU"]
[8.4,"8.4.1\n8.4.2",400,120,{"$f":"D44/C44","v":0.3},0.95,{"$f":"Binom_CI_L(F44,D44,C44)","v":0.25546672809530985},{"$f":"Binom_CI_U(F44,D44,C44)","v":0.34752187907364973},{"$f":"_xlfn.BETA.INV((1-F44)/2,D44,C44-D44+1)","v":0.25546672809530985},{"$f":"_xlfn.BETA.INV(1-(1-F44)/2,D44+1,C44-D44)","v":0.34752187907364973}]

{"sheet":"Section 9","index":3,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Section","Formula","u","n","(1-u)^n"]
[9.1,"9.1.2",0.1,2,{"$f":"(1-C2)^D2","v":0.81}]
[9.1,"9.1.2",0.1,28,{"$f":"(1-C3)^D3","v":5.2334763302736127E-2}]
[9.1,"9.1.2",0.1,29,{"$f":"(1-C4)^D4","v":4.7101286972462519E-2}]
[]
["Section","Formula","u","CL","n","n (rounded up)"]
[9.1,"9.1.5\n9.1.6",0.1,0.95,{"$f":"LN(1-D7)/LN(1-C7)","v":28.43315880574341},{"$f":"ROUNDUP(E7,0)","v":29}]
[]
["Section","Formula","u","MaxAccUn","n","Pr (X <= 0)"]
[9.1,"9.1.8",0.1,0.05,28,{"$f":"_xlfn.BINOM.DIST(0,E10,C10,TRUE)","v":5.2334763302736051E-2}]
[9.1,"9.1.8",0.1,0.05,29,{"$f":"_xlfn.BINOM.DIST(0,E11,C11,TRUE)","v":4.7101286972462443E-2}]
[]
["Section","Formula","u","MaxAccUn","n","N","Pr (X <= 0)"]
[9.1,"9.1.10",0.1,0.05,28,2000,{"$f":"_xlfn.HYPGEOM.DIST(0,E14,C14*F14,F14,TRUE)","v":5.1236665915224584E-2}]
[9.1,"9.1.10",0.1,0.05,29,2000,{"$f":"_xlfn.HYPGEOM.DIST(0,E15,C15*F15,F15,TRUE)","v":4.604024949380222E-2}]
[]
[]
[]
["Section","Formula","x","n","M","N","1 - Pr (X <= x)"]
[9.1999999999999993,"9.2.1\n9.2.2\n9.2.3",0,29,20,2000,{"$f":"1-_xlfn.HYPGEOM.DIST(C20,D20,E20,F20,TRUE)","v":0.25437317286266525}]
[]
["Section","Formula","u","MaxAccUn","a","MaxRejAcc","N","x","n"]
[9.1999999999999993,"9.2.4\n9.2.6",0.1,0.05,0.01,0.05,2000,{"$f":"Acc_HypGeom_Array(C23,D23,E23,F23,G23)","v":2},61]
[9.1999999999999993,"9.2.4\n9.2.6",0.1,0.02,0.01,0.02,2000,{"$f":"Acc_HypGeom_Array(C24,D24,E24,F24,G24)","v":3},87]
[9.1999999999999993,"9.2.4\n9.2.6",0.1,0.05,0.01,1,2000,{"$f":"Acc_HypGeom_Array(C25,D25,E25,F25,G25)","v":0},29]