{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Topics","SS","SS(an)","Dice","Dice(an)","C","C(an)","C(1)","C(1an)","Comp","Comp(an)","A","A(an)","CP","CP(an)","M","M(an)","HYPGEOM.DIST","HYPGEOM.DIST (an)","CT","CT(an)","RawData","PT(an)","B","B(1)an"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":9,"pivot_tables":4},"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":"Topics","index":0,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[1,"Probability"]
[2,"Experiment & Experimental Outcomes"]
[3,"Sample Point (Experimental Outcome)"]
[4,"Sample Space"]
[5,"Multi-step Experiment"]
[6,"Tree Diagram"]
[7,"Counting Rule for Multi-step Experiment"]
[8,"Combinations"]
[9,"Permutations"]
[10,"Methods of Assigning Probabilities"]
["a","Classical Method"]
["b","Relative Frequency Method & Law of Large Numbers"]
["c","Subjective Method"]
[11,"Requirements for Assigning Probabilities"]
[12,"Event"]
[13,"Probability of an Event"]
[14,"P(S) =1"]
[15,"Calculating Probability for Classical Method"]
[16,"Venn Diagram"]
[17,"Complement Rule"]
[18,"Mutually Exclusive"]
[19,"Union"]
[20,"Intersection"]
[21,"Addition Law for Probability & Addition Law for Probability for Mutually Exclusive"]
[22,"Conditional Probability & HYPGOEMDIST and HYPGEOM.DIST functions"]
[23,"Joint Probability"]
[24,"Joint Probability Table"]
[25,"Independence & Dependence"]
[26,"Multiplication Law for Probability"]
[27,"Multiplication Law for Probability for Independence"]
[28,"Calculating Conditional Probability"]
[29,"Cross Tabulation from Raw Data and Probability Pivot Table"]
[]
[]
[]
[]
[null,"Probability Concepts in this chapter: Probability, Experiment & Experimental Outcomes, Sample Point (Experimental Outcome), Sample Space, Multi-step Experiment, Tree Diagram, Counting Rule for Multi-step Experiment, Combinations, Permutations, Methods of Assigning Probabilities, Classical Method, Relative Frequency Method & Law of Large Numbers, Subjective Method, Requirements for Assigning Probabilities, Event, Probability of an Event, P(S) =1, Calculating Probability for Classical Method, Venn Diagram, Complement Rule, Mutually Exclusive, Union, Intersection, Addition Law for Probability & Addition Law for Probability for Mutually Exclusive, Conditional Probability, Joint Probability, Joint Probability Table, Independence & Dependence, Multiplication Law for Probability, Multiplication Law for Probability for Independence, Calculating Conditional Probability, Cross Tabulation from Raw Data and Probability Pivot Table"]

{"sheet":"SS","index":1,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[15,12,18,12]]}
["Experiment of tossing coin three times"]
["Steps in Experiment",3]
["Outcomes Step 1",2]
["Outcomes Step 2",2]
["Outcomes Step 3",2,null,null,null,"Success ="]
["Total Experimental Outcomes",null,"(Sample Points)",null,null,"Heads"]
["P(for each) =",null,"Classical",null,null,{"$f":"\"Notation for \"&F6&\" is \"&LEFT(F6,1)","v":"Notation for Heads is H"}]
[null,null,null,null,null,{"$f":"LEFT(F6,1)","v":"H"}]
["Number of Sample Points (# of Unique Experimental Outcomes)","Toss 1","Toss 2","Toss 3","Sample Space = List of Sample Points\nor Experimental Outcomes","Probability of Sample Point (classical = each is equally likely)",null,"Number of Heads",null,"Event = Number of Heads (Category)","Frequency","Formula","Relative Frequency"]
[1,"H","H","H",null,null,null,null,null,3]
[2,"T","H","H",null,null,null,null,null,2]
[3,"H","T","H",null,null,null,null,null,1]
[4,"H","H","T",null,null,null,null,null,0]
[5,"T","T","H"]
[6,"T","H","T",null,null,null,null,null,"Event","Probability"]
[7,"H","T","T",null,null,null,null,null,{"$f":"\"P(Get \"&J10&\" Heads in 3 Tosses )\"","v":"P(Get 3 Heads in 3 Tosses )"},null,null,"Requirement 1 = Each is between 0 and 1 (inclusive)"]
[8,"T","T","T",null,null,null,null,null,{"$f":"\"P(Get \"&J11&\" Heads in 3 Tosses )\"","v":"P(Get 2 Heads in 3 Tosses )"}]
[null,null,null,null,null,{"$f":"SUM(F10:F17)","v":0},null,null,null,{"$f":"\"P(Get \"&J12&\" Heads in 3 Tosses )\"","v":"P(Get 1 Heads in 3 Tosses )"}]
["Tree Diagram",null,null,null,null,null,null,null,null,{"$f":"\"P(Get \"&J13&\" Heads in 3 Tosses )\"","v":"P(Get 0 Heads in 3 Tosses )"}]
[null,"Step 1","Step 2","Step 3","List of Sample Points (Experimental Outcomes)",null,null,null,null,"Probability Requirement 2\nSum of all probabilities in sample space = 1"]
[]
[null,null,null,"Head","(H, H, H)",null,null,null,null,"P(At least 1 head in 3 Tosses)"]
[null,null,"Head",null,null,null,null,null,null,"P(At least 1 head in 3 Tosses)"]
[null,null,null,"Tail","(H, H, T)"]
[null,"Head"]
[null,null,null,"Head","(H, T, H)"]
[null,null,"Tail"]
[null,null,null,"Tail","(H, T, T)"]
[]
[null,null,null,"Head","(T, H, H)"]
[null,null,"Head"]
[null,null,null,"Tail","(T, H, T)"]
[null,"Tail"]
[null,null,null,"Head","(T, T, H)"]
[null,null,"Tail"]
[null,null,null,"Tail","(T, T, T)"]

{"sheet":"SS(an)","index":2,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[15,12,18,12]]}
["Experiment of tossing coin three times"]
["Steps in Experiment",3]
["Outcomes Step 1",2]
["Outcomes Step 2",2]
["Outcomes Step 3",2,null,null,null,"Success ="]
["Total Experimental Outcomes",{"$f":"PRODUCT(B3:B5)","v":8},"(Sample Points)",null,null,"Heads"]
["P(for each) =",{"$f":"1/B6","v":0.125},"Classical",null,null,{"$f":"\"Notation for \"&F6&\" is \"&LEFT(F6,1)","v":"Notation for Heads is H"}]
[null,null,null,null,null,{"$f":"LEFT(F6,1)","v":"H"}]
["Number of Sample Points (# of Unique Experimental Outcomes)","Toss 1","Toss 2","Toss 3","Sample Space = List of Sample Points\nor Experimental Outcomes","Probability of Sample Point (classical = each is equally likely)",null,"Number of Heads",null,"Event = Number of Heads (Category)","Frequency","Formula","Relative Frequency"]
[1,"H","H","H",{"$f":"\"(\"&B10&\", \"&C10&\", \"&D10&\")\"","v":"(H, H, H)"},{"$f":"1/$B$6","v":0.125},null,{"$f":"COUNTIF(B10:D10,$F$8)","v":3},null,3,{"$f":"COUNTIF($H$10:$H$17,J10)","v":1},{"$f":"IF(K10=\"\",\"\",\" \"&K10&\"/\"&$K$14&\" =\")","v":" 1/8 ="},{"$f":"K10/$K$14","v":0.125},{"$f":"SUM(F10)","v":0.125}]
[2,"T","H","H",{"$f":"\"(\"&B11&\", \"&C11&\", \"&D11&\")\"","v":"(T, H, H)"},0.125,null,2,null,2,{"$f":"COUNTIF($H$10:$H$17,J11)","v":3},{"$f":"IF(K11=\"\",\"\",\" \"&K11&\"/\"&$K$14&\" =\")","v":" 3/8 ="},{"$f":"K11/$K$14","v":0.375},{"$f":"SUM(F11:F13)","v":0.375}]
[3,"H","T","H","(H, T, H)",0.125,null,2,null,1,{"$f":"COUNTIF($H$10:$H$17,J12)","v":3},{"$f":"IF(K12=\"\",\"\",\" \"&K12&\"/\"&$K$14&\" =\")","v":" 3/8 ="},{"$f":"K12/$K$14","v":0.375}]
[4,"H","H","T","(H, H, T)",0.125,null,2,null,0,{"$f":"COUNTIF($H$10:$H$17,J13)","v":1},{"$f":"IF(K13=\"\",\"\",\" \"&K13&\"/\"&$K$14&\" =\")","v":" 1/8 ="},{"$f":"K13/$K$14","v":0.125}]
[5,"T","T","H","(T, T, H)",0.125,null,1,null,null,{"$f":"SUM(K10:K13)","v":8}]
[6,"T","H","T","(T, H, T)",0.125,null,1,null,"Event","Probability"]
[7,"H","T","T","(H, T, T)",0.125,null,1,null,{"$f":"\"P(Get \"&J10&\" Heads in 3 Tosses )\"","v":"P(Get 3 Heads in 3 Tosses )"},{"$f":"M10","v":0.125},null,"Requirement 1 = Each is between 0 and 1 (inclusive)"]
[8,"T","T","T","(T, T, T)",0.125,null,0,null,{"$f":"\"P(Get \"&J11&\" Heads in 3 Tosses )\"","v":"P(Get 2 Heads in 3 Tosses )"},{"$f":"M11","v":0.375}]
[null,null,null,null,null,{"$f":"SUM(F10:F17)","v":1},null,null,null,{"$f":"\"P(Get \"&J12&\" Heads in 3 Tosses )\"","v":"P(Get 1 Heads in 3 Tosses )"},{"$f":"M12","v":0.375}]
["Tree Diagram",null,null,null,null,null,null,null,null,{"$f":"\"P(Get \"&J13&\" Heads in 3 Tosses )\"","v":"P(Get 0 Heads in 3 Tosses )"},{"$f":"M13","v":0.125}]
[null,"Step 1","Step 2","Step 3","List of Sample Points (Experimental Outcomes)",null,null,null,null,"Probability Requirement 2\nSum of all probabilities in sample space = 1",{"$f":"SUM(K16:K19)","v":1}]
[]
[null,null,null,"Head","(H, H, H)",null,null,null,null,"P(At least 1 head in 3 Tosses)",{"$f":"SUM(K16:K18)","v":0.875}]
[null,null,"Head",null,null,null,null,null,null,"P(At least 1 head in 3 Tosses)",{"$f":"1-K19","v":0.875}]
[null,null,null,"Tail","(H, H, T)"]
[null,"Head"]
[null,null,null,"Head","(H, T, H)"]
[null,null,"Tail"]
[null,null,null,"Tail","(H, T, T)"]
[]
[null,null,null,"Head","(T, H, H)"]
[null,null,"Head"]
[null,null,null,"Tail","(T, H, T)"]
[null,"Tail"]
[null,null,null,"Head","(T, T, H)"]
[null,null,"Tail"]
[null,null,null,"Tail","(T, T, T)"]

{"sheet":"Dice","index":3,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[9,2,14,2],[19,2,24,2]]}
["Experiment = Roll die twice"]
["# of Steps or Trials ="]
[" = Roll dice once with two die =",2]
["Possible outcomes from one die",6]
["Possible outcomes from two dice",{"$f":"IF(B4=\"\",\"\",B4&\"*\"&B4&\" = \"&B4*B4)","v":"6*6 = 36"},{"$f":"B4*B4","v":36}]
[]
[null,null,"List Sample Space"]
[null,null,null,null,"Die 2"]
[null,null,null,null,1,2,3,4,5,6]
[null,null,"Die 1",1]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[]
[null,null,"Sum of each possibility"]
[null,null,null,null,"Die 2"]
[null,null,null,null,1,2,3,4,5,6]
[null,null,"Die 1",1]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]

{"sheet":"Dice(an)","index":4,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[9,2,14,2],[19,2,24,2]]}
["Experiment = Roll die twice"]
["# of Steps or Trials ="]
[" = Roll dice once with two die =",2]
["Possible outcomes from one die",6]
["Possible outcomes from two dice",{"$f":"IF(B4=\"\",\"\",B4&\"*\"&B4&\" = \"&B4*B4)","v":"6*6 = 36"},{"$f":"B4*B4","v":36}]
[]
[null,null,"List Sample Space"]
[null,null,null,null,"Die 2"]
[null,null,null,null,1,2,3,4,5,6]
[null,null,"Die 1",1,{"$f":"\"(\"&$D10&\", \"&E$9&\")\"","v":"(1, 1)"},"(1, 2)","(1, 3)","(1, 4)","(1, 5)","(1, 6)"]
[null,null,null,2,"(2, 1)","(2, 2)","(2, 3)","(2, 4)","(2, 5)","(2, 6)"]
[null,null,null,3,"(3, 1)","(3, 2)","(3, 3)","(3, 4)","(3, 5)","(3, 6)"]
[null,null,null,4,"(4, 1)","(4, 2)","(4, 3)","(4, 4)","(4, 5)","(4, 6)"]
[null,null,null,5,"(5, 1)","(5, 2)","(5, 3)","(5, 4)","(5, 5)","(5, 6)"]
[null,null,null,6,"(6, 1)","(6, 2)","(6, 3)","(6, 4)","(6, 5)","(6, 6)"]
[]
[null,null,"Sum of each possibility"]
[null,null,null,null,"Die 2"]
[null,null,null,null,1,2,3,4,5,6]
[null,null,"Die 1",1,{"$f":"E$19+$D20","v":2},3,4,5,6,7]
[null,null,null,2,3,4,5,6,7,8]
[null,null,null,3,4,5,6,7,8,9]
[null,null,null,4,5,6,7,8,9,10]
[null,null,null,5,6,7,8,9,10,11]
[null,null,null,6,7,8,9,10,11,12]

{"sheet":"C","index":5,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Use FACT function for factorials"]
["5! = 1*2*3*4*5"]
[5]
[5]
[]
["Counting Rule for Multi-Step Experiment"]
["Number of steps = k",3]
["Outcomes in 1st step = n1",2]
["Outcomes in 1st step = n2",2]
["Outcomes in 1st step = n3",2]
["Total Number of Sample Points (Experimental Outcomes)\n= n1 * n2 * … *nk"]
[]
[]
["Use COMBIN function for combinations"]
["Palyers",12]
["Team size",5]
["Total Combinations",null,"2,1"]
[null,null,"1,2"]
["Use PERMUT function for combinations"]
["Palyers",12]
["Team size",5]
["Total Combinations",null,"2,1"]
[null,null,"1,2"]

{"sheet":"C(an)","index":6,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Use FACT function for factorials"]
["5! = 1*2*3*4*5"]
[5,{"$f":"1*2*3*4*5","v":120}]
[5,{"$f":"FACT(A4)","v":120}]
[]
["Counting Rule for Multi-Step Experiment"]
["Number of steps = k",3]
["Outcomes in 1st step = n1",2]
["Outcomes in 1st step = n2",2]
["Outcomes in 1st step = n3",2]
["Total Number of Sample Points (Experimental Outcomes)\n= n1 * n2 * … *nk",{"$f":"PRODUCT(B8:B10)","v":8}]
[]
[]
["Use COMBIN function for combinations"]
["Palyers",12]
["Team size",5]
["Total Combinations",{"$f":"COMBIN(B15,B16)","v":792},"2,1"]
[null,null,"1,2"]
["Use PERMUT function for combinations"]
["Palyers",12]
["Team size",5]
["Total Combinations",{"$f":"PERMUT(B20,B21)","v":95040},"2,1"]
[null,null,"1,2"]

{"sheet":"C(1)","index":7,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Boomerang \"&B1","v":"Boomerang B"},"B"]
[{"$f":"\"Boomerang \"&B2","v":"Boomerang C"},"C"]
[{"$f":"\"Boomerang \"&B3","v":"Boomerang S"},"S"]
[{"$f":"\"Boomerang \"&B4","v":"Boomerang D"},"D"]
[]
["We would like to find all possible combinations of sample size 2, from population size 4 (Used later to help prove the Central Limit Theorem)"]
[]
["N = pop size =",4]
["n = sample size =",2]
["All combinations of sample size 2 ="]
[]
["List all Experimental Outcomes:"]
[]
[]
[]
[]
[]
[]
["Find All Permutations"]
[]
["N =",4]
["n =",2]
["All combinations of sample size 2 ="]
[]
["List all Experimental Outcomes:"]

{"sheet":"C(1an)","index":8,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Boomerang \"&B1","v":"Boomerang B"},"B"]
[{"$f":"\"Boomerang \"&B2","v":"Boomerang C"},"C"]
[{"$f":"\"Boomerang \"&B3","v":"Boomerang S"},"S"]
[{"$f":"\"Boomerang \"&B4","v":"Boomerang D"},"D"]
[]
["We would like to find all possible combinations of sample size 2, from population size 4 (Used later to help prove the Central Limit Theorem)"]
[]
["N = pop size =",4]
["n = sample size =",2]
["All combinations of sample size 2 =",{"$f":"COMBIN(B8,B9)","v":6}]
[]
["List all Experimental Outcomes:","B","C"]
[null,"B","S"]
[null,"B","D"]
[null,"C","S"]
[null,"C","D"]
[null,"S","D"]
[]
["Find All Permutations"]
[]
["N =",4]
["n =",2]
["All combinations of sample size 2 =",{"$f":"PERMUT(B21,B22)","v":12}]
[]
["List all Experimental Outcomes:","B","C"]
[null,"B","S"]
[null,"B","D"]
[null,"C","B"]
[null,"C","S"]
[null,"C","D"]
[null,"S","B"]
[null,"S","C"]
[null,"S","D"]
[null,"D","B"]
[null,"D","C"]
[null,"D","S"]

{"sheet":"Comp","index":9,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["P(Get 2 heads in 3 Flips) =",0.375,null,{"$f":"A1&\" \"&B1","v":"P(Get 2 heads in 3 Flips) = 0.375"}]
["P(Not get 2 heads in 3 Flips) =",null,null,{"$f":"A4&\" 1 - \"&B1","v":"P(Get 0, 1, or 3 Heads on 3 flips) = 1 - 0.375"}]
["or"]
["P(Get 0, 1, or 3 Heads on 3 flips) ="]

{"sheet":"Comp(an)","index":10,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["P(Get 2 heads in 3 Flips) =",0.375,null,{"$f":"A1&\" \"&B1","v":"P(Get 2 heads in 3 Flips) = 0.375"}]
["P(Not get 2 heads in 3 Flips) =",null,null,{"$f":"A4&\" 1 - \"&B1","v":"P(Get 0, 1, or 3 Heads on 3 flips) = 1 - 0.375"}]
["or"]
["P(Get 0, 1, or 3 Heads on 3 flips) =",{"$f":"1-B1","v":0.625}]

{"sheet":"A","index":11,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Adding Law For Probability\n= P(A or B) = P(A) + P(B) - P(A and B)\nIf events are mutaully exclusive, then:\n= P(A or B) = P(A) + P(B)"]
["Note: Add = OR = U = Union = +"]
[]
["Arrival","Event","Frequency","P(X)","P(X)"]
["Early",{"$f":"LEFT(A5,1)","v":"E"},100,{"$f":"\"P(\"&B5&\")\"","v":"P(E)"}]
["On Time",{"$f":"LEFT(A6,1)","v":"O"},800,{"$f":"\"P(\"&B6&\")\"","v":"P(O)"}]
["Late",{"$f":"LEFT(A7,1)","v":"L"},75,{"$f":"\"P(\"&B7&\")\"","v":"P(L)"}]
["Canceled",{"$f":"LEFT(A8,1)","v":"C"},25,{"$f":"\"P(\"&B8&\")\"","v":"P(C)"}]
[]
[]
[]
[{"$f":"CONCATENATE(\"P(\",A5,\" or \",A6,\")\")","v":"P(Early or On Time)"}," =",{"$f":"CONCATENATE(\"P(\",B5,\" or \",B6,\")\")","v":"P(E or O)"}," =",{"$f":"E5","v":0}," +",{"$f":"E6","v":0}," ="]
[{"$f":"CONCATENATE(\"P(Not \",A8,\")\")","v":"P(Not Canceled)"}," =",{"$f":"CONCATENATE(\"P(Not \",B8,\")\")","v":"P(Not C)"}," =",{"$f":"+E9","v":0}," -",{"$f":"E8","v":0}," ="]
[{"$f":"CONCATENATE(\"P(\",A5,\" or \",A7,\")\")","v":"P(Early or Late)"}," =",{"$f":"CONCATENATE(\"P(\",B5,\" or \",B7,\")\")","v":"P(E or L)"}," =",{"$f":"E5","v":0}," +",{"$f":"E7","v":0}," ="]
[]
[]
["Travel survey of people who visit Seattle"]
["Visit Space Needle","SN",{"$f":"\"P(\"&B18&\")\"","v":"P(SN)"},0.45]
["Visit Pike's Place Market","PP",{"$f":"\"P(\"&B19&\")\"","v":"P(PP)"},0.65]
["Visit Both","SN & PP",{"$f":"\"P(\"&B20&\")\"","v":"P(SN & PP)"},0.25]
[{"$f":"\"P(\"&B18&\" OR \"&B19&\") \"&CHAR(10)&\"= \"&C18&\" + \"&C19&\" - \"&C20","v":"P(SN OR PP) \n= P(SN) + P(PP) - P(SN & PP)"}]
["or"]
["P(visit at least 1)"]

{"sheet":"A(an)","index":12,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Adding Law For Probability\n= P(A or B) = P(A) + P(B) - P(A and B)\nIf events are mutaully exclusive, then:\n= P(A or B) = P(A) + P(B)"]
["Note: Add = OR = U = Union = +"]
[]
["Arrival","Event","Frequency","P(X)","P(X)"]
["Early",{"$f":"LEFT(A5,1)","v":"E"},100,{"$f":"\"P(\"&B5&\")\"","v":"P(E)"},{"$f":"C5/$C$9","v":0.1}]
["On Time",{"$f":"LEFT(A6,1)","v":"O"},800,{"$f":"\"P(\"&B6&\")\"","v":"P(O)"},{"$f":"C6/$C$9","v":0.8}]
["Late",{"$f":"LEFT(A7,1)","v":"L"},75,{"$f":"\"P(\"&B7&\")\"","v":"P(L)"},{"$f":"C7/$C$9","v":7.4999999999999997E-2}]
["Canceled",{"$f":"LEFT(A8,1)","v":"C"},25,{"$f":"\"P(\"&B8&\")\"","v":"P(C)"},{"$f":"C8/$C$9","v":2.5000000000000001E-2}]
[null,null,{"$f":"SUM(C5:C8)","v":1000},null,{"$f":"SUM(E5:E8)","v":1}]
[]
[]
[{"$f":"CONCATENATE(\"P(\",A5,\" or \",A6,\")\")","v":"P(Early or On Time)"}," =",{"$f":"CONCATENATE(\"P(\",B5,\" or \",B6,\")\")","v":"P(E or O)"}," =",{"$f":"E5","v":0.1}," +",{"$f":"E6","v":0.8}," =",{"$f":"E5+E6","v":0.9}]
[{"$f":"CONCATENATE(\"P(Not \",A8,\")\")","v":"P(Not Canceled)"}," =",{"$f":"CONCATENATE(\"P(Not \",B8,\")\")","v":"P(Not C)"}," =",{"$f":"+E9","v":1}," -",{"$f":"E8","v":2.5000000000000001E-2}," =",{"$f":"1-E8","v":0.97499999999999998}]
[{"$f":"CONCATENATE(\"P(\",A5,\" or \",A7,\")\")","v":"P(Early or Late)"}," =",{"$f":"CONCATENATE(\"P(\",B5,\" or \",B7,\")\")","v":"P(E or L)"}," =",{"$f":"E5","v":0.1}," +",{"$f":"E7","v":7.4999999999999997E-2}," =",{"$f":"E5+E7","v":0.17499999999999999}]
[]
[]
["Travel survey of people who visit Seattle"]
["Visit Space Needle","SN",{"$f":"\"P(\"&B18&\")\"","v":"P(SN)"},0.45]
["Visit Pike's Place Market","PP",{"$f":"\"P(\"&B19&\")\"","v":"P(PP)"},0.65]
["Visit Both","SN & PP",{"$f":"\"P(\"&B20&\")\"","v":"P(SN & PP)"},0.25]
[{"$f":"\"P(\"&B18&\" OR \"&B19&\") \"&CHAR(10)&\"= \"&C18&\" + \"&C19&\" - \"&C20","v":"P(SN OR PP) \n= P(SN) + P(PP) - P(SN & PP)"},{"$f":"D18+D19-D20","v":0.85000000000000009}]
["or"]
["P(visit at least 1)"]

{"sheet":"CP","index":13,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Conditional Probability"]
["Cards in Deck (Population)",52]
["Queens in deck (total # successes)",4]
["# of cards to pull (Sample Size) =",1]
["# of Queens (# of successes) =",1]
["P(Pull 1 Queen w/out Replcement) =",null,{"$f":"B3&\"/\"&B2&\" = \"&TEXT(B3/B2,\"?/??\")","v":"4/52 = 1/13"},"P(Q1)"]
["How total many Cards Left?",51]
["How Queens Left?",3]
["P(Q2 | Q1)",null,{"$f":"B8&\"/\"&B7&\" = \"&TEXT(B8/B7,\"?/??\")","v":"3/51 = 1/17"}]
["How total many Cards Left?",50]
["How Queens Left?",2]
["P(Q3 | Q2 | Q1)",null,{"$f":"B11&\"/\"&B10&\" = \"&TEXT(B11/B10,\"?/??\")","v":"2/50 = 1/25"}]

{"sheet":"CP(an)","index":14,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Conditional Probability"]
["Cards in Deck (Population)",52]
["Queens in deck (total # successes)",4]
["# of cards to pull (Sample Size) =",1]
["# of Queens (# of successes) =",1]
["P(Pull 1 Queen w/out Replcement) =",{"$f":"B3/B2","v":7.6923076923076927E-2},{"$f":"B3&\"/\"&B2&\" = \"&TEXT(B3/B2,\"?/??\")","v":"4/52 = 1/13"},"P(Q1)"]
["How total many Cards Left?",51]
["How Queens Left?",3]
["P(Q2 | Q1)",{"$f":"B8/B7","v":5.8823529411764705E-2},{"$f":"B8&\"/\"&B7&\" = \"&TEXT(B8/B7,\"?/??\")","v":"3/51 = 1/17"}]
["How total many Cards Left?",50]
["How Queens Left?",2]
["P(Q3 | Q2 | Q1)",{"$f":"B11/B10","v":0.04},{"$f":"B11&\"/\"&B10&\" = \"&TEXT(B11/B10,\"?/??\")","v":"2/50 = 1/25"}]

{"sheet":"M","index":15,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Multiplication Law for Probability\n= P(A and B) = P(B) * P(A | B)\nor\n=P(A and B) = P(A) * P(B | A)\nif events are independent, then:\n=P(A and B) = P(A) * P(B)"]
["Note: Multiply = AND = ∩ = Intersection = *"]
[]
["Cards in Deck (Population)",52]
["Queens in deck (total # successes)",4]
["# of cards to pull (Sample Size) =",1]
["# of Queens (# of successes) =",1]
["P(Pull 1 Queen w/out Replcement) =",{"$f":"B5/B4","v":7.6923076923076927E-2},{"$f":"B5&\"/\"&B4&\" = \"&TEXT(B5/B4,\"?/??\")","v":"4/52 = 1/13"},"P(Q1)"]
["How total many Cards Left?",51]
["How Queens Left?",3]
["P(Q2 | Q1)",{"$f":"B10/B9","v":5.8823529411764705E-2},{"$f":"B10&\"/\"&B9&\" = \"&TEXT(B10/B9,\"?/??\")","v":"3/51 = 1/17"}]
["How total many Cards Left?",50]
["How Queens Left?",2]
["P(Q3 | Q2 | Q1)",{"$f":"B13/B12","v":0.04},{"$f":"B13&\"/\"&B12&\" = \"&TEXT(B13/B12,\"?/??\")","v":"2/50 = 1/25"}]
[]
["P(Pull 3 striaght Queens)",null,{"$f":"B5&\"/\"&B4&\" * \"&B10&\"/\"&B9&\" * \"&B13&\"/\"&B12","v":"4/52 * 3/51 * 2/50"},null,null,{"$f":"4/52 * 3/51 * 2/50","v":1.809954751131222E-4}]
["or"]
["Use HYPGEOMDIST function to calculate Conditional Probabilities"]
["Cards in Deck (Population)",52,null,"number_pop = population size"]
["Queens in deck (total # successes)",4,null,"population_s = # successes in population"]
["# of cards to pull (Sample Size) =",3,null,"number_sample = sample size"]
["# of Queens (# of successes) =",3,null,"sample_s = # of successes in sample"]
["P(Pull 3 striaght Queens)"]
["Excel 2010 function: ",null,{"$f":"IF(OR(B23=\"\",B24=\"\"),\"\",B24=B23)","v":""},"Excel 2007 and Excel 2010 function results the same?"]
[]
["Example 2:"]
["P(Google stock goes up next year) =","G",{"$f":"\"P(\"&B27&\")\"","v":"P(G)"},0.2]
["P(WFMI stock goes up next year) =","W",{"$f":"\"P(\"&B28&\")\"","v":"P(W)"},0.35]
[{"$f":"\"P(\"&B27&\" and \"&B28&\")\"","v":"P(G and W)"}]

{"sheet":"M(an)","index":16,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Multiplication Law for Probability\n= P(A and B) = P(B) * P(A | B)\nor\n=P(A and B) = P(A) * P(B | A)\nif events are independent, then:\n=P(A and B) = P(A) * P(B)"]
["Note: Multiply = AND = ∩ = Intersection = *"]
[]
["Cards in Deck (Population)",52]
["Queens in deck (total # successes)",4]
["# of cards to pull (Sample Size) =",1]
["# of Queens (# of successes) =",1]
["P(Pull 1 Queen w/out Replcement) =",{"$f":"B5/B4","v":7.6923076923076927E-2},{"$f":"B5&\"/\"&B4&\" = \"&TEXT(B5/B4,\"?/??\")","v":"4/52 = 1/13"},"P(Q1)"]
["How total many Cards Left?",51]
["How Queens Left?",3]
["P(Q2 | Q1)",{"$f":"B10/B9","v":5.8823529411764705E-2},{"$f":"B10&\"/\"&B9&\" = \"&TEXT(B10/B9,\"?/??\")","v":"3/51 = 1/17"}]
["How total many Cards Left?",50]
["How Queens Left?",2]
["P(Q3 | Q2 | Q1)",{"$f":"B13/B12","v":0.04},{"$f":"B13&\"/\"&B12&\" = \"&TEXT(B13/B12,\"?/??\")","v":"2/50 = 1/25"}]
[]
["P(Pull 3 striaght Queens)",{"$f":"B8*B11*B14","v":1.809954751131222E-4},{"$f":"B5&\"/\"&B4&\" * \"&B10&\"/\"&B9&\" * \"&B13&\"/\"&B12","v":"4/52 * 3/51 * 2/50"}]
["or"]
["Use HYPGEOMDIST function to calculate Conditional Probabilities"]
["Cards in Deck (Population)",52,null,"number_pop = population size"]
["Queens in deck (total # successes)",4,null,"population_s = # successes in population"]
["# of cards to pull (Sample Size) =",3,null,"number_sample = sample size"]
["# of Queens (# of successes) =",3,null,"sample_s = # of successes in sample"]
["P(Pull 3 striaght Queens)",{"$f":"HYPGEOMDIST(B22,B21,B20,B19)","v":1.8099547511312201E-4}]
["Excel 2010 function: ",{"$f":"_xlfn.HYPGEOM.DIST(B22,B21,B20,B19,0)","v":1.8099547511312201E-4},{"$f":"IF(OR(B23=\"\",B24=\"\"),\"\",B24=B23)","v":true},"Excel 2007 and Excel 2010 function results the same?"]
[]
["Example 2:"]
["P(Google stock goes up next year) =","G",{"$f":"\"P(\"&B27&\")\"","v":"P(G)"},0.2]
["P(WFMI stock goes up next year) =","W",{"$f":"\"P(\"&B28&\")\"","v":"P(W)"},0.35]
[{"$f":"\"P(\"&B27&\" and \"&B28&\")\"","v":"P(G and W)"},{"$f":"D27*D28","v":6.9999999999999993E-2}]

{"sheet":"HYPGEOM.DIST","index":17,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Hypergeometric distribution: Discrete Probability Distribution"]
["Excel 2007 and before: HYPGEOMDIST. Excel 2010: HYPGEOM.DIST"]
["HYPGEOM.DIST is used in sampling without replacement from a finite population to calculate Conditional Probability."]
[{"$f":"\"What is the probability of pulling \"&C11&\" woman's name from a hat in \"&C10&\" tries when the hat has \"&C7&\" women's names and \"&C8&\" men's names?\"","v":"What is the probability of pulling 1 woman's name from a hat in 3 tries when the hat has 6 women's names and 4 men's names?"}]
["HYPGEOM.DIST arguments","Items","Number"]
["Number_pop ","# in Population = Total In Class",10,null,"Notation"]
["Population_s","Women",6,"# Successes in Pop","W"]
[null,"Men",{"$f":"C6-C7","v":4},null,"M"]
[null,"Success =",{"$f":"B7","v":"Women"}]
["Number_sample","Sample Size",3]
["Sample_s",{"$f":"\"Number Success in Sample (we pull \"&C11&\" in \"&C10&\" tries)\"","v":"Number Success in Sample (we pull 1 in 3 tries)"},1,null,"Check"]
["cumulative","returns the probability mass function = 0",null,0,null,"P(1 women's Name in 3 Tries)"]
["cumulative","returns the cumulative distribution function = 1",null,1,null,"P(Less Than or Eqaul to 1 women's Name in 3 Tries)"]
[]
[{"$f":"\"Experiment: pull \"&C10&\" names from a population of \"&C6&\" names\"","v":"Experiment: pull 3 names from a population of 10 names"}]
[{"$f":"\"What is probability that you will get \"&C11&\" Women's name?\"","v":"What is probability that you will get 1 Women's name?"},null,null,"3 straight names"]
["All Sample Points:"]
["Trial 1","Trial 2","Trial 3","P(Sample Point)"]
["M","M","M"]
["W","M","M"]
["M","W","M"]
["M","M","W"]
["W","W","M"]
["W","M","W"]
["M","W","W"]
["W","W","W"]
[null,null,"Total",{"$f":"SUM(D19:D26)","v":0}]

{"sheet":"HYPGEOM.DIST (an)","index":18,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Hypergeometric distribution: Discrete Probability Distribution"]
["Excel 2007 and before: HYPGEOMDIST. Excel 2010: HYPGEOM.DIST"]
["HYPGEOM.DIST is used in sampling without replacement from a finite population to calculate Conditional Probability."]
[{"$f":"\"What is the probability of pulling \"&C11&\" woman's name from a hat in \"&C10&\" tries when the hat has \"&C7&\" women's names and \"&C8&\" men's names?\"","v":"What is the probability of pulling 1 woman's name from a hat in 3 tries when the hat has 6 women's names and 4 men's names?"}]
["HYPGEOM.DIST arguments","Items","Number"]
["Number_pop ","# in Population = Total In Class",10,null,"Notation"]
["Population_s","Women",6,"# Successes in Pop","W"]
[null,"Men",{"$f":"C6-C7","v":4},null,"M"]
[null,"Success =",{"$f":"B7","v":"Women"}]
["Number_sample","Sample Size",3]
["Sample_s",{"$f":"\"Number Success in Sample (we pull \"&C11&\" in \"&C10&\" tries)\"","v":"Number Success in Sample (we pull 1 in 3 tries)"},1,null,"Check"]
["cumulative","returns the probability mass function = 0",{"$f":"_xlfn.HYPGEOM.DIST(C11,C10,C7,C6,0)","v":0.29999999999999988},0,{"$f":"SUM(D20:D22)","v":0.30000000000000004},"P(1 women's Name in 3 Tries)"]
["cumulative","returns the cumulative distribution function = 1",{"$f":"_xlfn.HYPGEOM.DIST(C11,C10,C7,C6,1)","v":0.3333333333333332},1,{"$f":"SUM(D19:D22)","v":0.33333333333333343},"P(Less Than or Eqaul to 1 women's Name in 3 Tries)"]
[]
[{"$f":"\"Experiment: pull \"&C10&\" names from a population of \"&C6&\" names\"","v":"Experiment: pull 3 names from a population of 10 names"}]
[{"$f":"\"What is probability that you will get \"&C11&\" Women's name?\"","v":"What is probability that you will get 1 Women's name?"},null,null,"3 straight names",{"$f":"6/10*5/9*4/8","v":0.16666666666666666}]
["All Sample Points:"]
["Trial 1","Trial 2","Trial 3","P(Sample Point)"]
["M","M","M",{"$f":"4/10*3/9*2/8","v":3.333333333333334E-2}]
["W","M","M",{"$f":"6/10*4/9*3/8","v":0.1}]
["M","W","M",{"$f":"4/10*6/9*3/8","v":0.10000000000000002}]
["M","M","W",{"$f":"4/10*3/9*6/8","v":0.10000000000000002}]
["W","W","M",{"$f":"6/10*5/9*4/8","v":0.16666666666666666}]
["W","M","W",{"$f":"6/10*4/9*5/8","v":0.16666666666666666}]
["M","W","W",{"$f":"4/10*6/9*5/8","v":0.16666666666666669}]
["W","W","W",{"$f":"6/10*5/9*4/8","v":0.16666666666666666}]
[null,null,"Total",{"$f":"SUM(D19:D26)","v":1.0000000000000002}]

{"sheet":"CT","index":19,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,5],[8,1,8,5]]}
["Executives were asked whether or not they would remain with the company if they received a better offer from a different company"]
[null,"Length of Service"]
["Loyalty","Less than 1 year","1-5 \nyears","6-10 years","More than 10 years","Total"]
["Would remain",10,30,5,75,{"$f":"SUM(B4:E4)","v":120}]
["Would not remain",25,15,10,30,{"$f":"SUM(B5:E5)","v":80}]
[null,{"$f":"SUM(B4:B5)","v":35},{"$f":"SUM(C4:C5)","v":45},{"$f":"SUM(D4:D5)","v":15},{"$f":"SUM(E4:E5)","v":105},{"$f":"SUM(F4:F5)","v":200}]
[]
["Joint Probability Table"]
[null,"Length of Service"]
["Loyalty","Less than 1 year","1-5 \nyears","6-10 years","More than 10 years","Total"]
["Would remain"]
["Would not remain"]
[]
[]
[{"$f":"CONCATENATE(\"P(\",\"Randomly selecting executive who \",A4,\" AND who has \",CLEAN(E3),\") =\")","v":"P(Randomly selecting executive who Would remain AND who has More than 10 years) ="},null,null,null,"Joint"]
[{"$f":"CONCATENATE(\"P(\",\"Randomly selecting executive who \",A5,\" AND who has \",CLEAN(E3),\") =\")","v":"P(Randomly selecting executive who Would not remain AND who has More than 10 years) ="},null,"Joint"]
[{"$f":"\"P(Randomly selecting executive who \"&A5&\" OR \"&CLEAN(B3)&\") =\"","v":"P(Randomly selecting executive who Would not remain OR Less than 1 year) ="},null,null,"Or",{"$f":"(F5+B6-B5)/F6","v":0.45}]
[{"$f":"\"P(Randomly selecting executive who \"&A5&\" GIVEN THAT \"&CLEAN(C3)&\") =\"","v":"P(Randomly selecting executive who Would not remain GIVEN THAT 1-5 years) ="},null,null,"Conditional"," <<<","AND/ Marginal"]
[{"$f":"\"P(Randomly selecting executive who has \"&C3&\") =\"","v":"P(Randomly selecting executive who has 1-5 \nyears) ="},null,"Marginal"]
["P(Randomly selecting executive who has at least 6 years experience)",null,"Adding Marginal"]
[{"$f":"\"P(Randomly selecting executive who \"&A5&\" OR \"&CLEAN(C3)&\") =\"","v":"P(Randomly selecting executive who Would not remain OR 1-5 years) ="},null,null,"Or"]

{"sheet":"CT(an)","index":20,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,5],[8,1,8,5]]}
["Executives were asked whether or not they would remain with the company if they received a better offer from a different company"]
[null,"Length of Service"]
["Loyalty","Less than 1 year","1-5 \nyears","6-10 years","More than 10 years","Total"]
["Would remain",10,30,5,75,{"$f":"SUM(B4:E4)","v":120}]
["Would not remain",25,15,10,30,{"$f":"SUM(B5:E5)","v":80}]
[null,{"$f":"SUM(B4:B5)","v":35},{"$f":"SUM(C4:C5)","v":45},{"$f":"SUM(D4:D5)","v":15},{"$f":"SUM(E4:E5)","v":105},{"$f":"SUM(F4:F5)","v":200}]
[]
["Joint Probability Table"]
[null,"Length of Service"]
["Loyalty","Less than 1 year","1-5 \nyears","6-10 years","More than 10 years","Total"]
["Would remain",{"$f":"B4/$F$6","v":0.05},0.15,2.5000000000000001E-2,0.375,0.6]
["Would not remain",0.125,7.4999999999999997E-2,0.05,0.15,0.4]
[null,0.17499999999999999,0.22500000000000001,7.4999999999999997E-2,0.52500000000000002,1]
[]
[{"$f":"CONCATENATE(\"P(\",\"Randomly selecting executive who \",A4,\" AND who has \",CLEAN(E3),\") =\")","v":"P(Randomly selecting executive who Would remain AND who has More than 10 years) ="},{"$f":"F4/F6*E4/F4","v":0.375},{"$f":"E4/F6","v":0.375},{"$f":"E11","v":0.375},"Joint"]
[{"$f":"CONCATENATE(\"P(\",\"Randomly selecting executive who \",A5,\" AND who has \",CLEAN(E3),\") =\")","v":"P(Randomly selecting executive who Would not remain AND who has More than 10 years) ="},{"$f":"E5/F6","v":0.15},"Joint"]
[{"$f":"\"P(Randomly selecting executive who \"&A5&\" OR \"&CLEAN(B3)&\") =\"","v":"P(Randomly selecting executive who Would not remain OR Less than 1 year) ="},{"$f":"F5/F6+B6/F6-B5/F6","v":0.44999999999999996},{"$f":"F12+B13-B12","v":0.44999999999999996},"Or",{"$f":"(F5+B6-B5)/F6","v":0.45}]
[{"$f":"\"P(Randomly selecting executive who \"&A5&\" GIVEN THAT \"&CLEAN(C3)&\") =\"","v":"P(Randomly selecting executive who Would not remain GIVEN THAT 1-5 years) ="},{"$f":"C5/C6","v":0.33333333333333331},{"$f":"C12/C13","v":0.33333333333333331},"Conditional"," <<<","AND/ Marginal"]
[{"$f":"\"P(Randomly selecting executive who has \"&C3&\") =\"","v":"P(Randomly selecting executive who has 1-5 \nyears) ="},{"$f":"C6/F6","v":0.22500000000000001},"Marginal"]
["P(Randomly selecting executive who has at least 6 years experience)",{"$f":"SUM(D6:E6)/F6","v":0.6},"Adding Marginal"]
[{"$f":"\"P(Randomly selecting executive who \"&A5&\" OR \"&CLEAN(C3)&\") =\"","v":"P(Randomly selecting executive who Would not remain OR 1-5 years) ="},{"$f":"F5/F6+C6/F6-C5/F6","v":0.55000000000000004},{"$f":"(F5+C6-C5)/F6","v":0.55000000000000004},{"$f":"F12+C13-C12","v":0.55000000000000004},"Or"]

{"sheet":"RawData","index":21,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["The question is: How do you rate your instructor? Then, let's find out how ratings change depending on how long they have been tenured!"]
["Class Rating","Tenured"]
["OK","1 up to 5 Years"]
["Good","5 up to 10 Years"]
["Excellent","10 up to 20 Years"]
[null,null,null,"Count",{"$f":"A2","v":"Class Rating"},{"$f":"B2","v":"Tenured"}]
[null,null,null,1,"OK","1 up to 5 Years"]
[null,null,null,2,"OK","1 up to 5 Years"]
[null,null,null,3,"OK","1 up to 5 Years"]
[null,null,null,4,"OK","1 up to 5 Years"]
[null,null,null,5,"OK","1 up to 5 Years"]
[null,null,null,6,"OK","5 up to 10 Years"]
[null,null,null,7,"OK","5 up to 10 Years"]
[null,null,null,8,"OK","5 up to 10 Years"]
[null,null,null,9,"OK","5 up to 10 Years"]
[null,null,null,10,"OK","5 up to 10 Years"]
[null,null,null,11,"OK","10 up to 20 Years"]
[null,null,null,12,"OK","10 up to 20 Years"]
[null,null,null,13,"OK","10 up to 20 Years"]
[null,null,null,14,"OK","10 up to 20 Years"]
[null,null,null,15,"OK","10 up to 20 Years"]
[null,null,null,1,"Good","1 up to 5 Years"]
[null,null,null,2,"Good","1 up to 5 Years"]
[null,null,null,3,"Good","1 up to 5 Years"]
[null,null,null,4,"Good","1 up to 5 Years"]
[null,null,null,5,"Good","1 up to 5 Years"]
[null,null,null,6,"Good","1 up to 5 Years"]
[null,null,null,7,"Good","1 up to 5 Years"]
[null,null,null,8,"Good","5 up to 10 Years"]
[null,null,null,9,"Good","5 up to 10 Years"]
[null,null,null,10,"Good","5 up to 10 Years"]
[null,null,null,11,"Good","5 up to 10 Years"]
[null,null,null,12,"Good","5 up to 10 Years"]
[null,null,null,13,"Good","10 up to 20 Years"]
[null,null,null,14,"Good","10 up to 20 Years"]
[null,null,null,1,"Excellent","1 up to 5 Years"]
[null,null,null,2,"Excellent","1 up to 5 Years"]
[null,null,null,3,"Excellent","1 up to 5 Years"]
[null,null,null,4,"Excellent","1 up to 5 Years"]
[null,null,null,5,"Excellent","1 up to 5 Years"]
[null,null,null,6,"Excellent","1 up to 5 Years"]
[null,null,null,7,"Excellent","1 up to 5 Years"]
[null,null,null,8,"Excellent","1 up to 5 Years"]
[null,null,null,9,"Excellent","5 up to 10 Years"]
[null,null,null,10,"Excellent","5 up to 10 Years"]
[null,null,null,11,"Excellent","5 up to 10 Years"]
[null,null,null,12,"Excellent","5 up to 10 Years"]
[null,null,null,13,"Excellent","5 up to 10 Years"]
[null,null,null,14,"Excellent","10 up to 20 Years"]
[null,null,null,15,"Excellent","10 up to 20 Years"]
[null,null,null,16,"Excellent","10 up to 20 Years"]

{"sheet":"PT(an)","index":22,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Count of Class Rating","Tenured"]
["Class Rating","1 up to 5 Years","5 up to 10 Years","10 up to 20 Years","Grand Total"]
["Excellent",8,5,3,16]
["Good",7,5,2,14]
["OK",5,5,5,15,null,"P(Excellent | 5 up to 10 years)",{"$f":"C5/C8","v":0.33333333333333331}]
["Grand Total",20,15,10,45,null,null,{"$f":"C5/C8","v":0.33333333333333331}]
[]
[]
["Count of Class Rating","Tenured"]
["Class Rating","1 up to 5 Years","5 up to 10 Years","10 up to 20 Years","Grand Total",null,"Joint and Marginal Probabilities"]
["Excellent",0.17777777777777778,0.1111111111111111,6.6666666666666666E-2,0.35555555555555557]
["Good",0.15555555555555556,0.1111111111111111,4.4444444444444446E-2,0.31111111111111112]
["OK",0.1111111111111111,0.1111111111111111,0.1111111111111111,0.33333333333333331]
["Grand Total",0.44444444444444442,0.33333333333333331,0.22222222222222221,1]
[]
[]
["Count of Class Rating","Tenured"]
["Class Rating","1 up to 5 Years","5 up to 10 Years","10 up to 20 Years","Grand Total",null,"Conditional Probabilities for Tenured Category"]
["Excellent",0.4,0.33333333333333331,0.3,0.35555555555555557]
["Good",0.35,0.33333333333333331,0.2,0.31111111111111112]
["OK",0.25,0.33333333333333331,0.5,0.33333333333333331]
["Grand Total",1,1,1,1]
[]
[]
["Count of Class Rating","Tenured",null,null,null,null,"P(Excellent | 10 up to 20 years)",{"$f":"3/16","v":0.1875}]
["Class Rating","1 up to 5 Years","5 up to 10 Years","10 up to 20 Years","Grand Total"]
["Excellent",0.5,0.3125,0.1875,1]
["Good",0.5,0.35714285714285715,0.14285714285714285,1,null,"Conditional Probabilities for Class Rating Category"]
["OK",0.33333333333333331,0.33333333333333331,0.33333333333333331,1]
["Grand Total",0.44444444444444442,0.33333333333333331,0.22222222222222221,1]

{"sheet":"B","index":23,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[{"$f":"ROW()&\")\"","v":"1)"},"Array: Bayes' Theorem"]
[{"$f":"ROW()&\")\"","v":"2)"},"SUMPRODUCT function"]
[]
[null,"Event","Prior Probability","P(x)","Conditional Probability","Joint Probability","P(x)","Posterior Probability"]
[null,"Leave garage open",0.25,"Stuff Stolen, Given Leave garage open = P(SS | GO)",0.05,null,"P(GO | SS)"]
[null,"Not Leave garage open",0.75,"Stuff Stolen, Given Not Leave garage open = P(SS | GNO)",0.01,null,"P(GNO | SS)"]
[null,null,null,null,"P(Stuff Stolen)"]
[null,"Posterior Probability"]
[null,"Doors open given Stuff Stolen Stolen","P(GO | SS)",null,null,"SS = Stuff Stolen"]
[null,null,null,null,null,"GO = Garage Open"]
[null,null,null,null,null,"GNO = Garage Not Open"]
[]
[null,null,null,null,null,"P(GO AND SS)"]
[null,null,null,null,null,"P(GNO AND SS)"]

{"sheet":"B(1)an","index":24,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[{"$f":"ROW()&\")\"","v":"1)"},"Array: Bayes' Theorem"]
[{"$f":"ROW()&\")\"","v":"2)"},"SUMPRODUCT function"]
[]
[null,"Event","Prior Probability","P(x)","Conditional Probability","Joint Probability","P(x)","Posterior Probability"]
[null,"Leave garage open",0.25,"Stuff Stolen, Given Leave garage open = P(SS | GO)",0.05,{"$f":"C5*E5","v":1.2500000000000001E-2},"P(GO | SS)",{"$f":"F5/$F$7","v":0.625}]
[null,"Not Leave garage open",0.75,"Stuff Stolen, Given Not Leave garage open = P(SS | GNO)",0.01,{"$f":"C6*E6","v":7.4999999999999997E-3},"P(GNO | SS)",{"$f":"F6/$F$7","v":0.375}]
[null,null,null,null,"P(Stuff Stolen)",{"$f":"SUM(F5:F6)","v":0.02}]
[null,"Posterior Probability",null,null,null,{"$f":"SUMPRODUCT(C5:C6,E5:E6)","v":0.02}]
[null,"Doors open given Stuff Stolen Stolen","P(GO | SS)",{"$f":"(C5*E5)/SUMPRODUCT(C5:C6,E5:E6)","v":0.625},null,"SS = Stuff Stolen"]
[null,null,null,null,null,"GO = Garage Open"]
[null,null,null,null,null,"GNO = Garage Not Open"]
[]
[null,null,null,null,null,"P(GO AND SS)"]
[null,null,null,null,null,"P(GNO AND SS)"]