{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["(1)","(2)","(3)","(4)","(5)","(6)","(7)","(8)","(9-old)","(9)","(10)","(11)","(12)","(14)","(18)","(20)","(21)","(22)","(28)","(29)","(35)","(36)","(40)","(42)","(49)"],"not_rendered":{"charts":11,"images":1,"macros":0,"external_links":0,"defined_names":2,"comments":1,"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":"(1)","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"n = # of trials =",2]
[null,"Outcomes = ",2]
[null,"Total Outcomes (Samples Points)",{"$f":"C2^C1","v":4}]
["b","Random Variable = ",{"$f":"C5","v":"Heads"},{"$f":"D5","v":"H"},"# of heads that we can get in 2 tosses"]
[null,"Success =","Heads","H"]
[null,"pi = Probability of Success =",0.5]
[null,"1- pi = Not Success",{"$f":"1-C6","v":0.5},"Tails","T"]
[null,null,null,null,null,"c"]
["a","Count of all Outcomes",null,null,null,"X = # Heads in 2 Tosses"]
[null,1,"H","H",{"$f":"\"(\"&C10&\", \"&D10&\")\"","v":"(H, H)"},{"$f":"COUNTIF(C10:D10,$D$5)","v":2}]
[null,2,"T","H",{"$f":"\"(\"&C11&\", \"&D11&\")\"","v":"(T, H)"},{"$f":"COUNTIF(C11:D11,$D$5)","v":1}]
[null,3,"H","T",{"$f":"\"(\"&C12&\", \"&D12&\")\"","v":"(H, T)"},{"$f":"COUNTIF(C12:D12,$D$5)","v":1}]
[null,4,"T","T",{"$f":"\"(\"&C13&\", \"&D13&\")\"","v":"(T, T)"},{"$f":"COUNTIF(C13:D13,$D$5)","v":0}]
[]
["d","The Variable is discrete because the possible values are 0, 1, 2. We can count."]
[]
[null,null,"X","Frequency","P(X) Relative Frequency"]
[null,null,0,{"$f":"COUNTIF($F$10:$F$13,C18)","v":1},{"$f":"D18/$D$21","v":0.25}]
[null,null,1,{"$f":"COUNTIF($F$10:$F$13,C19)","v":2},{"$f":"D19/$D$21","v":0.5}]
[null,null,2,{"$f":"COUNTIF($F$10:$F$13,C20)","v":1},{"$f":"D20/$D$21","v":0.25}]
[null,null,null,{"$f":"SUM(D18:D20)","v":4},{"$f":"SUM(E18:E20)","v":1}]

{"sheet":"(2)","index":1,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["a","Continuous Random Variable =","Time in minutes it takes to assemble product"]
["b","any number between 0 and some upper limit. X > 0"]
["c","Continuous because we could get 1.2 minutes, or 1.2367 minutes. It depends on the measurement instrument"]

{"sheet":"(3)","index":2,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"# students Interviewed =",3,"# Trials"]
[null,"# outcomes =",2]
[null,"Total Experimental Outcomes =",{"$f":"C2^C1","v":8}]
[]
["b","Random Variable =","Number of offers in 3 students interviewed"]
[null,"Success =","Offer",{"$f":"LEFT(C6,1)","v":"O"},1]
[null,null,"No Offer",{"$f":"LEFT(C7,1)","v":"N"},0]
["b","Discrete, the discrete possibilities are: 0,1,2,3"]
[null,null,null,null,null,"a","c"]
[null,"# Trials (Experimental Outcomes, or Sample Points)","Trial 1","Trial 2","Trial 3","Sample Points","X = O"]
[null,1,"O","O","O",{"$f":"\"(\"&C11&\", \"&D11&\", \"&E11&\")\"","v":"(O, O, O)"},{"$f":"COUNTIF(C11:E11,$D$6)","v":3}]
[null,2,"N","O","O",{"$f":"\"(\"&C12&\", \"&D12&\", \"&E12&\")\"","v":"(N, O, O)"},2]
[null,3,"O","N","O","(O, N, O)",2]
[null,4,"O","O","N","(O, O, N)",2]
[null,5,"N","N","O","(N, N, O)",1]
[null,6,"N","O","N","(N, O, N)",1]
[null,7,"O","N","N","(O, N, N)",1]
[null,8,"N","N","N","(N, N, N)",0]
[]
[null,null,"X","Frequency","P(X) Relative Frequency"]
[null,null,0,{"$f":"COUNTIF($G$11:$G$18,C21)","v":1},{"$f":"D21/$D$25","v":0.125}]
[null,null,1,{"$f":"COUNTIF($G$11:$G$18,C22)","v":3},{"$f":"D22/$D$25","v":0.375}]
[null,null,2,{"$f":"COUNTIF($G$11:$G$18,C23)","v":3},{"$f":"D23/$D$25","v":0.375}]
[null,null,3,{"$f":"COUNTIF($G$11:$G$18,C24)","v":1},{"$f":"D24/$D$25","v":0.125}]
[null,null,null,{"$f":"SUM(D21:D24)","v":8},{"$f":"SUM(E21:E24)","v":1}]

{"sheet":"(4)","index":3,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[0,1,2,3,4,5,6,7,8,9]
[]
["The random Variable could assume these values : 0, 1, 2, 3, 4, 5, 6, 7, 8, 9"]

{"sheet":"(5)","index":4,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Random Variable = Total Steps"]
[]
[null,null,null,1,{"$f":"\"(\"&$B$5&\", \"&D3&\")\"","v":"(1, 1)"},{"$f":"$B$5+D3","v":2}]
[]
[null,1,null,2,{"$f":"\"(\"&$B$5&\", \"&D5&\")\"","v":"(1, 2)"},{"$f":"$B$5+D5","v":3}]
[]
[null,null,null,3,{"$f":"\"(\"&$B$5&\", \"&D7&\")\"","v":"(1, 3)"},{"$f":"$B$5+D7","v":4}]
[]
[null,null,null,1,{"$f":"\"(\"&$B$11&\", \"&D9&\")\"","v":"(2, 1)"},{"$f":"$B$11+D9","v":3}]
[]
[null,2,null,2,{"$f":"\"(\"&$B$11&\", \"&D11&\")\"","v":"(2, 2)"},{"$f":"$B$11+D11","v":4}]
[]
[null,null,null,3,{"$f":"\"(\"&$B$11&\", \"&D13&\")\"","v":"(2, 3)"},{"$f":"$B$11+D13","v":5}]
[]
[]
[null,null,null,"X","Frequency","P(X) Relative Frequency"]
[null,null,null,2,{"$f":"COUNTIF($F$3:$F$13,D17)","v":1},{"$f":"E17/$E$21","v":0.16666666666666666}]
[null,null,null,3,{"$f":"COUNTIF($F$3:$F$13,D18)","v":2},{"$f":"E18/$E$21","v":0.33333333333333331}]
[null,null,null,4,{"$f":"COUNTIF($F$3:$F$13,D19)","v":2},{"$f":"E19/$E$21","v":0.33333333333333331}]
[null,null,null,5,{"$f":"COUNTIF($F$3:$F$13,D20)","v":1},{"$f":"E20/$E$21","v":0.16666666666666666}]
[null,null,null,null,{"$f":"SUM(E17:E20)","v":6},{"$f":"SUM(F17:F20)","v":0.99999999999999989}]

{"sheet":"(6)","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Letter","Experiment","Random Variable (X)","D/C","Values"]
["a","20 Q Exam","# answered correctly","Discrete","1,2,3,…19,20"]
["b","Observe cars arriving at toll booth","# cars","Discrete","1,2,3…"]
["c","Audit 50 tax returns","# errors","Discrete","1,2,…49,50"]
["d","Observe Employee work","# of non-productive hours in an 8-hour day","Continuous","0 >= X <= 8"]
["e","Weight","Number of pounds","Continuous","X > 0"]
[]
[null,null,null,"Discrete"]
[null,null,null,"Continuous"]

{"sheet":"(7)","index":6,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"X","F(X)"]
[null,20,0.2,{"$f":"\"P(\"&B2&\")\"","v":"P(20)"},{"$f":"\"P(\"&B2&\") = \"&C2","v":"P(20) = 0.2"}]
[null,25,0.15,{"$f":"\"P(\"&B3&\")\"","v":"P(25)"},{"$f":"\"P(\"&B3&\") = \"&C3","v":"P(25) = 0.15"}]
[null,30,0.25,{"$f":"\"P(\"&B4&\")\"","v":"P(30)"},{"$f":"\"P(\"&B4&\") = \"&C4","v":"P(30) = 0.25"}]
[null,35,0.4,{"$f":"\"P(\"&B5&\")\"","v":"P(35)"},{"$f":"\"P(\"&B5&\") = \"&C5","v":"P(35) = 0.4"}]
[null,null,{"$f":"SUM(C2:C5)","v":1}]
[]
["a","Yes. P(20) + P(25) + P(30) + P(35) = 0.2 + 0.15 + 0.25 + 0.4 = 1 AND each probability is greater than zero\nx >= 0\nΣX = 1",null,null,null,null,null,null,null,null,null,null,null,null,null," =\"Yes. \"&MCONCAT(D2:D5,\" + \")&\" = \"&MCONCAT(C2:C5,\" + \")&\" = \"&SUM(C2:C5)"]
["b",{"$f":"D4","v":"P(30)"},{"$f":"C4","v":0.25}]
["c","P(X <= 25), for domain given {20, 25, 30, 35}",{"$f":"SUM(C2:C3)","v":0.35},"or","<=25",{"$f":"SUMIF($B$2:$B$5,E10,$C$2:$C$5)","v":0.35}," =SUMIF($B$2:$B$5,E10,$C$2:$C$5)"]
["d","P(X > 30), for domain given {20, 25, 30, 35}",{"$f":"C5","v":0.4},"or",">30",0.4]

{"sheet":"(8)","index":7,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Count number of operating rooms in use over a 20 day period"]
["Number of operating rooms =",4]
["x =","# operating rooms in use for 1 day"]
[]
["a",null,null,"c",null,"b"]
["x = # operating rooms in use for 1 day","Frequency (# of days","Relative Frequency P(x) = f(x) = Probability","Is each f(x) >= 0?"]
[1,3,{"$f":"B7/$B$11","v":0.15},{"$f":"C7>=0","v":true}]
[2,5,{"$f":"B8/$B$11","v":0.25},{"$f":"C8>=0","v":true}]
[3,8,{"$f":"B9/$B$11","v":0.4},{"$f":"C9>=0","v":true}]
[4,4,{"$f":"B10/$B$11","v":0.2},{"$f":"C10>=0","v":true}]
[null,{"$f":"SUM(B7:B10)","v":20},{"$f":"SUM(C7:C10)","v":1}]
[null,null,"c"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Discrete Probability Charts don't have columns that touch."]

{"sheet":"(9-old)","index":8,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,"National Percentage of 4th graders that can't read an age-appropriate book =",0.38]
[null,"Most that have reading problem should be identified before 3rd grade",3]
[null,"Fed law says they can't get help until they fall 2 years behind",2,"typically =",3,"rd grade"]
[null,"Random variable = age of one randomly selected child","x ="]
[null,"Goal: select a sample of children identified as learning disabled under special education for a program designed to improve reading ability"]
["a",null,null,"c",null,"b"]
["Age x ","Frequency # of children identified as learning disabled under special education","f(x) = p(x)","Is each f(x) >= 0?"]
[6,37369,{"$f":"B8/$B$17","v":1.8488750355609981E-2},{"$f":"C8>0","v":true}]
[7,87436,4.3259984909767832E-2,true]
[8,160840,7.9577473499325882E-2,true]
[9,239719,0.11860378245327594,true]
[10,286719,0.14185758284166389,true]
[11,306533,0.15166079137135577,true]
[12,310787,0.15376550768736008,true]
[13,302604,0.14971687261122862,true]
[14,289168,0.14306925427041201,true]
[null,{"$f":"SUM(B8:B16)","v":2021175},{"$f":"SUM(C8:C16)","v":1}]
[null,null,"c"]
[]
[null,null,null,null,null,"Discrete Probability Charts don't have columns that touch."]

{"sheet":"(9)","index":9,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"a","b",null,null,null,null,"not rounded like in solution manual"]
["Months Unemployed","Number Unemployed = Frequency at # months unemployed","P(x)","P(x)","P9x) > = 0?",null,null,null,null,"P(x)"]
[1,1029,{"$f":"\"P(\"&A3&\")\"","v":"P(1)"},{"$f":"B3/$B$13","v":3.8146431881371644E-2},{"$f":"D3>=0","v":true},null,null,null,null,{"$f":"ROUND(D3,4)","v":3.8100000000000002E-2}]
[2,1686,"P(2)",6.2502316960148283E-2,true,null,null,null,null,6.25E-2]
[3,2269,"P(3)",8.4114921223354955E-2,true,null,null,null,null,8.4099999999999994E-2]
[4,2675,"P(4)",9.9165894346617239E-2,true,null,null,null,null,9.9199999999999997E-2]
[5,3487,"P(5)",0.12926784059314181,true,null,null,null,null,0.1293]
[6,4652,"P(6)",0.17245597775718258,true,null,null,null,null,0.17249999999999999]
[7,4145,"P(7)",0.153660797034291,true,null,null,null,null,0.1537]
[8,3587,"P(8)",0.13297497683039852,true,null,null,null,null,0.13300000000000001]
[9,2325,"P(9)",8.6190917516218726E-2,true,null,null,null,null,8.6199999999999999E-2]
[10,1120,"P(10)",4.1519925857275257E-2,true,null,null,null,null,4.1500000000000002E-2]
[null,{"$f":"SUM(B3:B12)","v":26975},"b",{"$f":"SUM(D3:D12)","v":1},null,null,null,null,null,{"$f":"SUM(J3:J12)","v":1.0001000000000002}]
[]
["x = random variable = # months unemployed"]
[]
["c","<=2",{"$f":"\"P(x\"&B17&\")\"","v":"P(x<=2)"},{"$f":"SUMIF($A$3:$A$12,B17,$D$3:$D$12)","v":0.10064874884151992}]
[null,">2","P(x>2)",{"$f":"SUMIF($A$3:$A$12,B18,$D$3:$D$12)","v":0.89935125115848014}]
["d",">6","P(x>6)",{"$f":"SUMIF($A$3:$A$12,B19,$D$3:$D$12)","v":0.4143466172381835}]

{"sheet":"(10)","index":10,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["a","Job satisfaction score","IS Senior Executives","Is each f(x) >= 0?","IS Middle Executives","Is each f(x) >= 0?"]
[null,1,0.05,{"$f":"C2>0","v":true},0.04,{"$f":"E2>0","v":true}]
[null,2,0.09,{"$f":"C3>0","v":true},0.1,{"$f":"E3>0","v":true}]
[null,3,0.03,{"$f":"C4>0","v":true},0.12,{"$f":"E4>0","v":true}]
[null,4,0.42,{"$f":"C5>0","v":true},0.46,{"$f":"E5>0","v":true}]
[null,5,0.41,{"$f":"C6>0","v":true},0.28000000000000003,{"$f":"E6>0","v":true}]
[null,null,{"$f":"SUM(C2:C6)","v":1},null,{"$f":"SUM(E2:E6)","v":1}]
[]
[]
[]
[null,null,null,"or"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"c","P(Senior score = 4 or 5)= f(4) + f(5) =",{"$f":"SUM(C5:C6)","v":0.83}]
[null,null,null,null,"d","P(Middle = 5) = f(5) =",{"$f":"E6","v":0.28000000000000003}]
[null,null,null,null,"e","It is a tie for the scores 1 and 2, Middle managers claim more at a score of 3 and 4, but senior managers claim many more at a score of 5. Over all Senior managers claim more satisfaction."]

{"sheet":"(11)","index":11,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["a","x = # hours for service call","f(x) = (1/4)","Is each f(x) >= 0?","c"]
[null,1,{"$f":"1/4","v":0.25},{"$f":"C2>0","v":true}]
[null,2,{"$f":"1/4","v":0.25},{"$f":"C3>0","v":true}]
[null,3,{"$f":"1/4","v":0.25},{"$f":"C4>0","v":true}]
[null,4,{"$f":"1/4","v":0.25},{"$f":"C5>0","v":true}]
[null,null,{"$f":"SUM(C2:C5)","v":1}]
[null,null,"c",null,null,"b"]
[]
[]
["d"]
["P(3) =",{"$f":"C4","v":0.25}]
[]
["e","P(given only 2 hours,overtime) = P(3) + P(4)",{"$f":"SUM(C4:C5)","v":0.5}]

{"sheet":"(12)","index":12,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"x = # new subscribers in next year","f(x) = Probability of new subscribers in next year","Is each f(x) >= 0?"]
[null,100000,0.1,{"$f":"C2>0","v":true}]
[null,200000,0.2,true]
[null,300000,0.25,true]
[null,400000,0.3,true]
[null,500000,0.1,true]
[null,600000,0.05,true]
[null,null,{"$f":"SUM(C2:C7)","v":1}]
[]
["a","Yes because X>0 and Σf(x) = 1"]
[]
["b"]
["P(X>400000) =",{"$f":"SUM(C6:C7)","v":0.15000000000000002}]
[]
["b"]
["P(X<200000) =",{"$f":"SUM(C2)","v":0.1}]

{"sheet":"(14)","index":13,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"x (profits in $1,000)","f(x)"]
[null,-100,0.1]
[null,0,0.2]
[null,50,0.3]
[null,100,0.25]
[null,150,0.1]
[null,200,{"$f":"1-SUM(C2:C6)","v":4.9999999999999933E-2},"a","Probability of $200,000 profits"]
[null,null,{"$f":"SUM(C2:C7)","v":1}]
[]
["b",null,"check"]
[{"$f":"\"P(X > \"&DOLLAR(A12)&\")\"","v":"P(X > $0.00)"},{"$f":"SUM(C4:C7)","v":0.7},{"$f":"SUMIF($B$2:$B$7,\">\"&A12,$C$2:$C$7)","v":0.7}]
[0]
["c",null,"check"]
[{"$f":"\"P(X > = \"&DOLLAR(A15*1000)&\")\"","v":"P(X > = $100,000.00)"},{"$f":"SUM(C5:C7)","v":0.39999999999999991},{"$f":"SUMIF($B$2:$B$7,\">=\"&A15,$C$2:$C$7)","v":0.39999999999999991}]
[100]

{"sheet":"(18)","index":14,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Data on Central Cities"]
[]
[]
[]
["X = # Bedrooms in House","Renter-Occupied\nFrequency\n# Houses (1,000s)","f(x)","(X-E(x))^2",null,"y = # Bedrooms in House","Owner-Occupied\nFrequency\n# Houses (1,000s)","f(x)","(X-E(x))^2"]
[0,547,{"$f":"B6/B$11","v":3.6810228802153434E-2},{"$f":"(A6-C$13)^2","v":3.3929342504016851},null,{"$f":"A6","v":0},23,{"$f":"G6/G$11","v":1.3634477443831882E-3},{"$f":"(F6-H$13)^2","v":8.5782419636531966}]
[1,5012,{"$f":"B7/B$11","v":0.33728129205921936},{"$f":"(A7-C$13)^2","v":0.70895040114192753},null,{"$f":"A7","v":1},541,{"$f":"G7/G$11","v":3.2070662161361077E-2},{"$f":"(F7-H$13)^2","v":3.7205147717627458}]
[2,6100,{"$f":"B8/B$11","v":0.41049798115746972},{"$f":"(A8-C$13)^2","v":2.4966551882169896E-2},null,{"$f":"A8","v":2},3832,{"$f":"G8/G$11","v":0.2271622502815816},{"$f":"(F8-H$13)^2","v":0.86278757987229493}]
[3,2644,{"$f":"B9/B$11","v":0.17792732166890982},{"$f":"(A9-C$13)^2","v":1.3409827026224121},null,{"$f":"A9","v":3},8690,{"$f":"G9/G$11","v":0.51514612602999588},{"$f":"(F9-H$13)^2","v":5.0603879818441541E-3}]
[4,557,{"$f":"B10/B$11","v":3.7483176312247644E-2},{"$f":"(A10-C$13)^2","v":4.6569988533626558},null,4,3783,{"$f":"G10/G$11","v":0.22425751378267827},{"$f":"(F10-H$13)^2","v":1.1473331960913933}]
[null,{"$f":"SUM(B6:B10)","v":14860},{"$f":"SUM(C6:C10)","v":0.99999999999999989},null,null,null,{"$f":"SUM(G6:G10)","v":16869},{"$f":"SUM(H6:H10)","v":1}]
[]
["a, b","E(x)",{"$f":"SUMPRODUCT(A6:A10,C6:C10)","v":1.8419919246298788},null,null,"c, d","E(x)",{"$f":"SUMPRODUCT(F6:F10,H6:H10)","v":2.9288635959452254}]
[null,"Var(x)",{"$f":"SUMPRODUCT(D6:D10,C6:C10)","v":0.78741568230356362},null,null,null,"Var(x)",{"$f":"SUMPRODUCT(I6:I10,H6:H10)","v":0.58691305442730868}]
[null,"SD for Discrete Variable",{"$f":"SQRT(SUMPRODUCT(C6:C10,D6:D10))","v":0.88736445855328439},null,null,null,"SD for Discrete Variable",{"$f":"SQRT(SUMPRODUCT(H6:H10,I6:I10))","v":0.76610250908563715}]
[null,"check",{"$f":"SQRT(SUMPRODUCT((A6:A10-C13)^2,C6:C10))","v":0.88736445855328439},null,null,null,"check",{"$f":"SQRT(SUMPRODUCT((F6:F10-H13)^2,H6:H10))","v":0.76610250908563715}]
["e","The average number of bedrooms in an owner occupied house is large than the that of the renter occupied houses -- about 1 whole bedroom more. In addition, the data points are less spread out for the owner group than for the renter group - that is to say, the data points for the owner group are more clustered around its mean than for the renter group. The mean for the owner occupied houses more fairly represents its data points than does the mean for the renter-occupied data points"]

{"sheet":"(20)","index":15,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Probability Distribution for Damage Claims Paid for NAI"]
[]
[]
[null,"Payment$","Probability"]
[null,0,0.85]
[null,500,0.04]
[null,1000,0.04]
[null,3000,0.03]
[null,5000,0.02]
[null,8000,0.01]
[null,10000,0.01]
[]
["a","E(x) = Expected collision Payment = Long-run average =",{"$f":"SUMPRODUCT(B5:B11,C5:C11)","v":430}]
[null,"Annual Rate",520]
["b","Expected Value (profit) =",{"$f":"C14-C13","v":90}]
["c","Because if they had a big accident (like $5000), 5000>520"]

{"sheet":"(21)","index":16,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"Job satisfaction score","IS Senior Executives","IS Middle Executives"]
[null,1,0.05,0.04]
[null,2,0.09,0.1]
[null,3,0.03,0.12]
[null,4,0.42,0.46]
[null,5,0.41,0.28000000000000003]
[null,null,{"$f":"SUM(C2:C6)","v":1},{"$f":"SUM(D2:D6)","v":1}]
[]
["a",{"$f":"\"E(x) = Expected value for job satisfaction score for \"&TRANSPOSE(C1:D1)","v":"E(x) = Expected value for job satisfaction score for IS Senior Executives"},{"$f":"SUMPRODUCT(B2:B6,C2:C6)","v":4.05}]
["b","E(x) = Expected value for job satisfaction score for IS Middle Executives",{"$f":"SUMPRODUCT(B2:B6,D2:D6)","v":3.84}]
["c,d",{"$f":"\"SD for \"&TRANSPOSE(C1:D1)","v":"SD for IS Senior Executives"},{"$f":"SUMPRODUCT((B2:B6-C9)^2,C2:C6)","v":1.2475000000000001}]
["c,d","SD for IS Middle Executives",{"$f":"SUMPRODUCT((B2:B6-C10)^2,D2:D6)","v":1.1344000000000001}]
["e","The Senior managers seem to be slightly more satisfied, but the spread in the data points is more. Although the Seniors have a higher mean, at 4.05, the Middle managers have a similar mean, at 3.84, but the middle managers have the data points more closely clustered around the 3.84 (maybe they are more satisfied)."]

{"sheet":"(22)","index":17,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Unit Demand = x","Prob = f(x)"]
[null,300,0.2]
[null,400,0.3]
[null,500,0.35]
[null,600,0.15]
[null,null,{"$f":"SUM(C2:C5)","v":1}]
[]
["a","Mean",{"$f":"SUMPRODUCT(B2:B5,C2:C5)","v":445}," = monthly order quantity"]
[null,"SD",{"$f":"SQRT(SUMPRODUCT((B2:B5-C8)^2,C2:C5))","v":97.339611669658922}]
[]
[null,"Price per unit",70]
[null,"Cost per unit",50]
[null,"Actual Units sold",300]
["b","Sales",{"$f":"C11*C13","v":21000}]
[null,"Expenses",{"$f":"C12*C8","v":22250}]
[null,null,{"$f":"C14-C15","v":-1250}]

{"sheet":"(28)","index":18,"n_rows":69,"n_cols":12,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["Binomial Experiment 4 Requirements:"]
[1,"Experiment consists of a sequence of n identical trials. Random Variable counts the number of successes in a Fixed number of trials, n."]
[null,"Fixed # of Identical Trials = n","Yes"]
[2,"Only 2 outcomes are possible on each identical trial. Success or Failure."]
[null,"Each trial only results in S or F","Yes"]
[3,"Probability of Success = p = (π \"pi\"). Probability of Failure = 1-p. Probability remains the same on each trial."]
[null,"p remains the same for each trial","Yes"]
[4,"The trials are independent (one does not affect the next)"]
[null,"All events are independent","Yes"]
[null,null,null,null,null,null,null,null,{"$f":"B16&\" = \"&C16&\" = \"&D16&CHAR(10)&B3&\" = \"&D14","v":"Probability of Stick with group = p (π) = 0.23\nFixed # of Identical Trials = n = 6"}]
[null,"Variables",null,null,null,null,"n","x","P(x) = f(x)","P(x) = f(x)","SUM"]
[null,"Stick with group","Success",null,null,"a",null,{"$f":"$D$15","v":2},{"$f":"\"P(x = \"&H12&\")\"","v":"P(x = 2)"},{"$f":"_xlfn.BINOM.DIST(H12,$D$14,$D$16,0)","v":0.27893938033499999},{"$f":"SUM(D21)","v":0.27893938033499999}]
[null,{"$f":"\"Not \"&B12","v":"Not Stick with group"},"Failure",null,null,"b",null,{"$f":"$D$15","v":2},{"$f":"\"P(x >= \"&H13&\")\"","v":"P(x >= 2)"},{"$f":"1-_xlfn.BINOM.DIST(H13-1,$D$14,$D$16,1)","v":0.41804140624499997},{"$f":"SUM(D21:D25)","v":0.41804140624499997},"at least 2"]
[null,"Group of international travelers","n",6,null,"c",10,0,{"$f":"\"P(x = \"&H14&\")\"","v":"P(x = 0)"},{"$f":"_xlfn.BINOM.DIST(H14,G14,$D$16,0)","v":7.3266804725862014E-2},null,"None = all 10"]
[null,{"$f":"\"# successes = # that \"&B12","v":"# successes = # that Stick with group"},"x",2]
[null,{"$f":"\"Probability of \"&B12","v":"Probability of Stick with group"},"p (π)",0.23]
[]
[null,null,"X","P(x) = f(x)"]
[null,null,{"$f":"IF(ROWS(C$19:C19)<=$D$14+1,ROWS(C$19:C19)-1,\"\")","v":0},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C19,$D$14,$D$16,0)),ROWS(C$19:C19)<=$D$14+1),_xlfn.BINOM.DIST(C19,$D$14,$D$16,0),\"\")","v":0.20842238008899999}]
[null,null,{"$f":"IF(ROWS(C$19:C20)<=$D$14+1,ROWS(C$19:C20)-1,\"\")","v":1},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C20,$D$14,$D$16,0)),ROWS(C$19:C20)<=$D$14+1),_xlfn.BINOM.DIST(C20,$D$14,$D$16,0),\"\")","v":0.37353621366600004}]
[null,null,{"$f":"IF(ROWS(C$19:C21)<=$D$14+1,ROWS(C$19:C21)-1,\"\")","v":2},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C21,$D$14,$D$16,0)),ROWS(C$19:C21)<=$D$14+1),_xlfn.BINOM.DIST(C21,$D$14,$D$16,0),\"\")","v":0.27893938033499999}]
[null,null,{"$f":"IF(ROWS(C$19:C22)<=$D$14+1,ROWS(C$19:C22)-1,\"\")","v":3},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C22,$D$14,$D$16,0)),ROWS(C$19:C22)<=$D$14+1),_xlfn.BINOM.DIST(C22,$D$14,$D$16,0),\"\")","v":0.11109274021999997}]
[null,null,{"$f":"IF(ROWS(C$19:C23)<=$D$14+1,ROWS(C$19:C23)-1,\"\")","v":4},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C23,$D$14,$D$16,0)),ROWS(C$19:C23)<=$D$14+1),_xlfn.BINOM.DIST(C23,$D$14,$D$16,0),\"\")","v":2.4887659335000017E-2}]
[null,null,{"$f":"IF(ROWS(C$19:C24)<=$D$14+1,ROWS(C$19:C24)-1,\"\")","v":5},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C24,$D$14,$D$16,0)),ROWS(C$19:C24)<=$D$14+1),_xlfn.BINOM.DIST(C24,$D$14,$D$16,0),\"\")","v":2.9735904660000002E-3}]
[null,null,{"$f":"IF(ROWS(C$19:C25)<=$D$14+1,ROWS(C$19:C25)-1,\"\")","v":6},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C25,$D$14,$D$16,0)),ROWS(C$19:C25)<=$D$14+1),_xlfn.BINOM.DIST(C25,$D$14,$D$16,0),\"\")","v":1.4803588900000014E-4}]
[null,null,{"$f":"IF(ROWS(C$19:C26)<=$D$14+1,ROWS(C$19:C26)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C26,$D$14,$D$16,0)),ROWS(C$19:C26)<=$D$14+1),_xlfn.BINOM.DIST(C26,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C27)<=$D$14+1,ROWS(C$19:C27)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C27,$D$14,$D$16,0)),ROWS(C$19:C27)<=$D$14+1),_xlfn.BINOM.DIST(C27,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C28)<=$D$14+1,ROWS(C$19:C28)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C28,$D$14,$D$16,0)),ROWS(C$19:C28)<=$D$14+1),_xlfn.BINOM.DIST(C28,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C29)<=$D$14+1,ROWS(C$19:C29)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C29,$D$14,$D$16,0)),ROWS(C$19:C29)<=$D$14+1),_xlfn.BINOM.DIST(C29,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C30)<=$D$14+1,ROWS(C$19:C30)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C30,$D$14,$D$16,0)),ROWS(C$19:C30)<=$D$14+1),_xlfn.BINOM.DIST(C30,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C31)<=$D$14+1,ROWS(C$19:C31)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C31,$D$14,$D$16,0)),ROWS(C$19:C31)<=$D$14+1),_xlfn.BINOM.DIST(C31,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C32)<=$D$14+1,ROWS(C$19:C32)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C32,$D$14,$D$16,0)),ROWS(C$19:C32)<=$D$14+1),_xlfn.BINOM.DIST(C32,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C33)<=$D$14+1,ROWS(C$19:C33)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C33,$D$14,$D$16,0)),ROWS(C$19:C33)<=$D$14+1),_xlfn.BINOM.DIST(C33,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C34)<=$D$14+1,ROWS(C$19:C34)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C34,$D$14,$D$16,0)),ROWS(C$19:C34)<=$D$14+1),_xlfn.BINOM.DIST(C34,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C35)<=$D$14+1,ROWS(C$19:C35)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C35,$D$14,$D$16,0)),ROWS(C$19:C35)<=$D$14+1),_xlfn.BINOM.DIST(C35,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C36)<=$D$14+1,ROWS(C$19:C36)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C36,$D$14,$D$16,0)),ROWS(C$19:C36)<=$D$14+1),_xlfn.BINOM.DIST(C36,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C37)<=$D$14+1,ROWS(C$19:C37)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C37,$D$14,$D$16,0)),ROWS(C$19:C37)<=$D$14+1),_xlfn.BINOM.DIST(C37,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C38)<=$D$14+1,ROWS(C$19:C38)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C38,$D$14,$D$16,0)),ROWS(C$19:C38)<=$D$14+1),_xlfn.BINOM.DIST(C38,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C39)<=$D$14+1,ROWS(C$19:C39)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C39,$D$14,$D$16,0)),ROWS(C$19:C39)<=$D$14+1),_xlfn.BINOM.DIST(C39,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C40)<=$D$14+1,ROWS(C$19:C40)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C40,$D$14,$D$16,0)),ROWS(C$19:C40)<=$D$14+1),_xlfn.BINOM.DIST(C40,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C41)<=$D$14+1,ROWS(C$19:C41)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C41,$D$14,$D$16,0)),ROWS(C$19:C41)<=$D$14+1),_xlfn.BINOM.DIST(C41,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C42)<=$D$14+1,ROWS(C$19:C42)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C42,$D$14,$D$16,0)),ROWS(C$19:C42)<=$D$14+1),_xlfn.BINOM.DIST(C42,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C43)<=$D$14+1,ROWS(C$19:C43)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C43,$D$14,$D$16,0)),ROWS(C$19:C43)<=$D$14+1),_xlfn.BINOM.DIST(C43,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C44)<=$D$14+1,ROWS(C$19:C44)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C44,$D$14,$D$16,0)),ROWS(C$19:C44)<=$D$14+1),_xlfn.BINOM.DIST(C44,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C45)<=$D$14+1,ROWS(C$19:C45)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C45,$D$14,$D$16,0)),ROWS(C$19:C45)<=$D$14+1),_xlfn.BINOM.DIST(C45,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C46)<=$D$14+1,ROWS(C$19:C46)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C46,$D$14,$D$16,0)),ROWS(C$19:C46)<=$D$14+1),_xlfn.BINOM.DIST(C46,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C47)<=$D$14+1,ROWS(C$19:C47)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C47,$D$14,$D$16,0)),ROWS(C$19:C47)<=$D$14+1),_xlfn.BINOM.DIST(C47,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C48)<=$D$14+1,ROWS(C$19:C48)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C48,$D$14,$D$16,0)),ROWS(C$19:C48)<=$D$14+1),_xlfn.BINOM.DIST(C48,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C49)<=$D$14+1,ROWS(C$19:C49)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C49,$D$14,$D$16,0)),ROWS(C$19:C49)<=$D$14+1),_xlfn.BINOM.DIST(C49,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C50)<=$D$14+1,ROWS(C$19:C50)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C50,$D$14,$D$16,0)),ROWS(C$19:C50)<=$D$14+1),_xlfn.BINOM.DIST(C50,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C51)<=$D$14+1,ROWS(C$19:C51)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C51,$D$14,$D$16,0)),ROWS(C$19:C51)<=$D$14+1),_xlfn.BINOM.DIST(C51,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C52)<=$D$14+1,ROWS(C$19:C52)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C52,$D$14,$D$16,0)),ROWS(C$19:C52)<=$D$14+1),_xlfn.BINOM.DIST(C52,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C53)<=$D$14+1,ROWS(C$19:C53)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C53,$D$14,$D$16,0)),ROWS(C$19:C53)<=$D$14+1),_xlfn.BINOM.DIST(C53,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C54)<=$D$14+1,ROWS(C$19:C54)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C54,$D$14,$D$16,0)),ROWS(C$19:C54)<=$D$14+1),_xlfn.BINOM.DIST(C54,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C55)<=$D$14+1,ROWS(C$19:C55)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C55,$D$14,$D$16,0)),ROWS(C$19:C55)<=$D$14+1),_xlfn.BINOM.DIST(C55,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C56)<=$D$14+1,ROWS(C$19:C56)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C56,$D$14,$D$16,0)),ROWS(C$19:C56)<=$D$14+1),_xlfn.BINOM.DIST(C56,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C57)<=$D$14+1,ROWS(C$19:C57)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C57,$D$14,$D$16,0)),ROWS(C$19:C57)<=$D$14+1),_xlfn.BINOM.DIST(C57,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C58)<=$D$14+1,ROWS(C$19:C58)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C58,$D$14,$D$16,0)),ROWS(C$19:C58)<=$D$14+1),_xlfn.BINOM.DIST(C58,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C59)<=$D$14+1,ROWS(C$19:C59)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C59,$D$14,$D$16,0)),ROWS(C$19:C59)<=$D$14+1),_xlfn.BINOM.DIST(C59,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C60)<=$D$14+1,ROWS(C$19:C60)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C60,$D$14,$D$16,0)),ROWS(C$19:C60)<=$D$14+1),_xlfn.BINOM.DIST(C60,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C61)<=$D$14+1,ROWS(C$19:C61)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C61,$D$14,$D$16,0)),ROWS(C$19:C61)<=$D$14+1),_xlfn.BINOM.DIST(C61,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C62)<=$D$14+1,ROWS(C$19:C62)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C62,$D$14,$D$16,0)),ROWS(C$19:C62)<=$D$14+1),_xlfn.BINOM.DIST(C62,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C63)<=$D$14+1,ROWS(C$19:C63)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C63,$D$14,$D$16,0)),ROWS(C$19:C63)<=$D$14+1),_xlfn.BINOM.DIST(C63,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C64)<=$D$14+1,ROWS(C$19:C64)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C64,$D$14,$D$16,0)),ROWS(C$19:C64)<=$D$14+1),_xlfn.BINOM.DIST(C64,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C65)<=$D$14+1,ROWS(C$19:C65)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C65,$D$14,$D$16,0)),ROWS(C$19:C65)<=$D$14+1),_xlfn.BINOM.DIST(C65,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C66)<=$D$14+1,ROWS(C$19:C66)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C66,$D$14,$D$16,0)),ROWS(C$19:C66)<=$D$14+1),_xlfn.BINOM.DIST(C66,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C67)<=$D$14+1,ROWS(C$19:C67)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C67,$D$14,$D$16,0)),ROWS(C$19:C67)<=$D$14+1),_xlfn.BINOM.DIST(C67,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C68)<=$D$14+1,ROWS(C$19:C68)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C68,$D$14,$D$16,0)),ROWS(C$19:C68)<=$D$14+1),_xlfn.BINOM.DIST(C68,$D$14,$D$16,0),\"\")","v":""}]
[null,null,{"$f":"IF(ROWS(C$19:C69)<=$D$14+1,ROWS(C$19:C69)-1,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(_xlfn.BINOM.DIST(C69,$D$14,$D$16,0)),ROWS(C$19:C69)<=$D$14+1),_xlfn.BINOM.DIST(C69,$D$14,$D$16,0),\"\")","v":""}]

{"sheet":"(29)","index":19,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Binomial Experiment 4 Requirements:"]
[1,"Experiment consists of a sequence of n identical trials. Random Variable counts the number of successes in a Fixed number of trials, n."]
[null,"Fixed # of Identical Trials = n","Yes"]
[2,"Only 2 outcomes are possible on each identical trial. Success or Failure."]
[null,"Each trial only results in S or F","Yes"]
[3,"Probability of Success = p = (π \"pi\"). Probability of Failure = 1-p. Probability remains the same on each trial."]
[null,"p remains the same for each trial","Yes"]
[4,"The trials are independent (one does not affect the next)"]
[null,"All events are independent","Yes"]
[null,null,null,null,null,null,null,{"$f":"B16&\" = \"&C16&\" = \"&D16&CHAR(10)&B3&\" = \"&D14","v":"Probability of Take Public Transport in SF = p (π) = 0.3\nFixed # of Identical Trials = n = 10"}]
[null,"Variables",null,null,null,null,null,"P(x) = f(x)","P(x) = f(x)","SUM"]
[null,"Take Public Transport in SF","Success",null,null,"a",{"$f":"$D$15","v":3},{"$f":"\"P(x = \"&G12&\")\"","v":"P(x = 3)"},{"$f":"_xlfn.BINOM.DIST(G12,D14,D16,0)","v":0.26682793200000005},{"$f":"SUM(D22)","v":0.26682793200000005}]
[null,{"$f":"\"Not \"&B12","v":"Not Take Public Transport in SF"},"Failure",null,null,"b",{"$f":"$D$15","v":3},{"$f":"\"P(x >= \"&G13&\")\"","v":"P(x >= 3)"},{"$f":"1-_xlfn.BINOM.DIST(G13-1,$D$14,$D$16,1)","v":0.61721721360000026},{"$f":"SUM(D22:D29)","v":0.61721721360000004},"\"at least\""]
[null,"Sample of workers","n",10,null,null,{"$f":"$D$15","v":3},{"$f":"\"P(x > \"&G14&\")\"","v":"P(x > 3)"},{"$f":"1-_xlfn.BINOM.DIST(G14,$D$14,$D$16,1)","v":0.35038928160000005},{"$f":"SUM(D23:D29)","v":0.35038928160000016}]
[null,{"$f":"\"# successes = # that \"&B12","v":"# successes = # that Take Public Transport in SF"},"x",3,null,null,{"$f":"$D$15","v":3},{"$f":"\"P(x < \"&G15&\")\"","v":"P(x < 3)"},{"$f":"_xlfn.BINOM.DIST(G15-1,$D$14,$D$16,1)","v":0.3827827863999998},{"$f":"SUM(D19:D21)","v":0.38278278640000007}]
[null,{"$f":"\"Probability of \"&B12","v":"Probability of Take Public Transport in SF"},"p (π)",0.3,null,null,{"$f":"$D$15","v":3},{"$f":"\"P(x <= \"&G16&\")\"","v":"P(x <= 3)"},{"$f":"_xlfn.BINOM.DIST(G16,$D$14,$D$16,1)","v":0.64961071839999995},{"$f":"SUM(D19:D22)","v":0.64961071840000018}]
[]
[null,null,"X","P(x) = f(x)"]
[null,null,0,{"$f":"_xlfn.BINOM.DIST(C19,$D$14,$D$16,0)","v":2.8247524899999994E-2}]
[null,null,1,0.12106082100000001]
[null,null,2,0.23347444050000005]
[null,null,3,0.26682793200000005]
[null,null,4,0.20012094900000005]
[null,null,5,0.10291934520000003]
[null,null,6,3.6756909000000039E-2]
[null,null,7,9.0016919999999986E-3]
[null,null,8,1.446700500000001E-3]
[null,null,9,1.3778099999999991E-4]
[null,null,10,5.9048999999999949E-6]

{"sheet":"(35)","index":20,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Binomial Experiment 4 Requirements:"]
[1,"Experiment consists of a sequence of n identical trials. Random Variable counts the number of successes in a Fixed number of trials, n."]
[null,"Fixed # of Identical Trials = n","Yes"]
[2,"Only 2 outcomes are possible on each identical trial. Success or Failure."]
[null,"Each trial only results in S or F","Yes"]
[3,"Probability of Success = p = (π \"pi\"). Probability of Failure = 1-p. Probability remains the same on each trial."]
[null,"p remains the same for each trial","Yes"]
[4,"The trials are independent (one does not affect the next)"]
[null,"All events are independent","Yes"]
[]
[null,"Variables"]
[null,"Withdraw without completing Statistics","Success"]
[null,{"$f":"\"Not \"&B12","v":"Not Withdraw without completing Statistics"},"Failure"]
[null,null,"n",20,null,null,"n","x","P(x) = f(x)","P(x) = f(x)"]
[null,{"$f":"\"# successes = # that \"&B12","v":"# successes = # that Withdraw without completing Statistics"},"x",null,null,"a",{"$f":"$D$14","v":20},2,{"$f":"\"P(x <= \"&H15&\")\"","v":"P(x <= 2)"},{"$f":"_xlfn.BINOM.DIST(H15,G15,D16,1)","v":0.20608471894847391},{"$f":"H15&\" or fewer\"","v":"2 or fewer"}]
[null,{"$f":"\"Probability of \"&B12","v":"Probability of Withdraw without completing Statistics"},"p (π)",0.2,null,"b",{"$f":"$D$14","v":20},4,{"$f":"\"P(x = \"&H16&\")\"","v":"P(x = 4)"},{"$f":"_xlfn.BINOM.DIST(H16,G16,D16,0)","v":0.21819940194610055}]
[null,null,null,null,null,"c",{"$f":"$D$14","v":20},3,{"$f":"\"P(x > \"&H17&\")\"","v":"P(x > 3)"},{"$f":"1-_xlfn.BINOM.DIST(H17,G17,D16,1)","v":0.5885511380434314},{"$f":"\"more than \"&H17","v":"more than 3"}]
[null,null,null,null,null,"d",null,null,"Mean = E(x)",{"$f":"D14*D16","v":4}]

{"sheet":"(36)","index":21,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Binomial Experiment 4 Requirements:"]
[1,"Experiment consists of a sequence of n identical trials. Random Variable counts the number of successes in a Fixed number of trials, n."]
[null,"Fixed # of Identical Trials = n"]
[2,"Only 2 outcomes are possible on each identical trial. Success or Failure."]
[null,"Each trial only results in S or F"]
[3,"Probability of Success = p = (π \"pi\"). Probability of Failure = 1-p. Probability remains the same on each trial."]
[null,"p remains the same for each trial"]
[4,"The trials are independent (one does not affect the next)"]
[null,"All events are independent"]
[]
[null,"Variables"]
[null,"Have Exchange Traded Funds","Success"]
[null,{"$f":"\"Not \"&B12","v":"Not Have Exchange Traded Funds"},"Failure"]
[null,null,"n",20,null,null,"P(x) = f(x)","P(x) = f(x)"]
[null,{"$f":"\"# successes = # that \"&B12","v":"# successes = # that Have Exchange Traded Funds"},"x",null,null,4,{"$f":"\"P(x = \"&F15&\")\"","v":"P(x = 4)"},{"$f":"_xlfn.BINOM.DIST(F15,$D$14,$D$16,0)","v":0.18968545486586663}]
[null,{"$f":"\"Probability of \"&B12","v":"Probability of Have Exchange Traded Funds"},"p (π)",0.25,null,2,{"$f":"\"P(x >= \"&F16&\")\"","v":"P(x >= 2)"},{"$f":"1-_xlfn.BINOM.DIST(F16-1,D14,D16,1)","v":0.97568737513483939},"Yes I would doubt the accuracy because it is so improbable"]
[null,null,null,null,null,12,{"$f":"\"P(x >= \"&F17&\")\"","v":"P(x >= 12)"},{"$f":"_xlfn.BINOM.DIST(F17,$D$14,$D$16,0)","v":7.5168752118770586E-4}]
[null,null,null,null,null,null,"E(x)",{"$f":"D14*D16","v":5}]

{"sheet":"(40)","index":22,"n_rows":143,"n_cols":7,"rows_kept":143,"cut":false,"hidden":false,"merged":[]}
[null,"Poisson Probability Distribution can be used to estimate the number of occurrences over a specified interval of time or space"]
[null,"Properties of a Poisson Experiment:"]
[null,"The probability of an occurrence is the same for any two intervals of equal length"]
[null,"The occurrence or nonoccurrence in any interval is independent of the occurrence or nonoccurrence in any other interval"]
[null,"No upper limit for X: 0,1,2,3… , but as x increases past the mean, the probability decreases and gest quite small."]
[null,"Mean = Var"]
[null,"Excel function: POISSON\nPOISSON(x,mean,cumulative (0 = exact, 1 = cumulative))"]
[]
[]
[null,"x = Calls per hour",48]
[null,"Business =","Regional Airways"]
[null,{"$f":"\"Phone calls arrive at a rate of \"&C10&\" per hour at the reservation desk for \"&C11","v":"Phone calls arrive at a rate of 48 per hour at the reservation desk for Regional Airways"}]
[null,"Assumption 1","Probability is the same for any 1 hour interval"]
[null,"Assumption 2","Arrival or nonarrival of a call in a 1 hour period is independent of the arrival or nonarrival in any other 1 hour period"]
[null,"Mean",{"$f":"$C$10","v":48},"calls","per",1,"hour"]
["a","x",3,"calls","per",5,"minutes"]
[null,"Mean",{"$f":"C15/60*F16","v":4}]
[null,{"$f":"\"P(\"&C16&\" \"&D16&\" \"&E16&\" \"&F16&\" \"&G16&\")\"","v":"P(3 calls per 5 minutes)"},{"$f":"_xlfn.POISSON.DIST(C16,C17,0)","v":0.19536681481316462}]
[null,"P(x) = (mu^x*e^-mu)/X!)",{"$f":"(C17^C16*EXP(1)^-C17)/FACT(C16)","v":0.19536681481316462}]
["b","Mean",{"$f":"$C$10","v":48},"calls","per",1,"hour"]
[null,"x",10,"calls","per",15,"minutes"]
[null,"Mean",{"$f":"C20/60*F21","v":12}]
[null,"P(x)",{"$f":"_xlfn.POISSON.DIST(C21,C22,0)","v":0.10483725588365932}]
["c","Mean",{"$f":"$C$10","v":48},"calls","per",1,"hour"]
[null,"x",0,"calls","per",5,"minutes"]
[null,"Mean",{"$f":"C24/60*F25","v":4}]
[null,{"$f":"\"P(\"&C25&\" \"&D25&\" \"&E25&\" \"&F25&\" \"&G25&\")\"","v":"P(0 calls per 5 minutes)"},{"$f":"_xlfn.POISSON.DIST(C25,C26,0)","v":1.8315638888734179E-2}]
["d","Mean",{"$f":"$C$10","v":48},"calls","per",1,"hour"]
[null,"x",0,"calls","per",3,"minutes"]
[null,"Mean",{"$f":"C28/60*F29","v":2.4000000000000004}]
[null,{"$f":"\"P(\"&C29&\" \"&D29&\" \"&E29&\" \"&F29&\" \"&G29&\")\"","v":"P(0 calls per 3 minutes)"},{"$f":"_xlfn.POISSON.DIST(C29,C30,0)","v":9.071795328941247E-2}]
[]
[null,"X","P(x)"]
[null,0,{"$f":"POISSON(B34,$C$15,0)","v":1.4251640827409352E-21}]
[null,1,{"$f":"POISSON(B35,$C$15,0)","v":6.8407875971564902E-20}]
[null,2,1.6417890233175514E-18]
[null,3,2.6268624373080961E-17]
[null,4,3.1522349247697067E-16]
[null,5,3.0261455277789236E-15]
[null,6,2.4209164222231316E-14]
[null,7,1.6600569752387263E-13]
[null,8,9.9603418514323353E-13]
[null,9,5.3121823207639178E-12]
[null,10,2.5498475139666846E-11]
[null,11,1.1126607333672787E-10]
[null,12,4.4506429334690986E-10]
[null,13,1.6433143138962901E-9]
[null,14,5.634220504787279E-9]
[null,15,1.8029505615319254E-8]
[null,16,5.4088516845957924E-8]
[null,17,1.5272051815329214E-7]
[null,18,4.0725471507544703E-7]
[null,19,1.0288540170327105E-6]
[null,20,2.4692496408784986E-6]
[null,21,5.6439991791508457E-6]
[null,22,1.2314180027238233E-5]
[null,23,2.5699158317714559E-5]
[null,24,5.139831663542907E-5]
[null,25,9.8684767940023806E-5]
[null,26,1.8218726388927485E-4]
[null,27,3.2388846913648805E-4]
[null,28,5.5523737566255064E-4]
[null,29,9.1901358730353804E-4]
[null,30,1.4704217396856567E-3]
[null,31,2.2767820485455233E-3]
[null,32,3.415173072818294E-3]
[null,33,4.9675244695538924E-3]
[null,34,7.0129757217231381E-3]
[null,35,9.6177952755060088E-3]
[null,36,1.2823727034008012E-2]
[null,37,1.6636186422496878E-2]
[null,38,2.1014130217890791E-2]
[null,39,2.5863544883557892E-2]
[null,40,3.1036253860269477E-2]
[null,41,3.6335126470559392E-2]
[null,42,4.1525858823496492E-2]
[null,43,4.6354447058786725E-2]
[null,44,5.056848770049463E-2]
[null,45,5.3939720213860912E-2]
[null,46,5.6284925440550554E-2]
[null,47,5.7482477045668647E-2]
[null,48,5.7482477045668653E-2]
[null,49,5.6309365269226426E-2]
[null,50,5.4056990658457385E-2]
[null,51,5.0877167678548101E-2]
[null,52,4.6963539395582905E-2]
[null,53,4.2533016811093914E-2]
[null,54,3.7807126054305695E-2]
[null,55,3.2995310011030399E-2]
[null,56,2.8281694295168986E-2]
[null,57,2.3816163616984378E-2]
[null,58,1.9709928510607749E-2]
[null,59,1.6035196076426627E-2]
[null,60,1.2828156861141322E-2]
[null,61,1.0094287366143989E-2]
[null,62,7.8149321544340733E-3]
[null,63,5.9542340224259483E-3]
[null,64,4.4656755168194662E-3]
[null,65,{"$f":"POISSON(B99,$C$15,0)","v":3.2977296124205259E-3}]
[null,66,2.398348809033112E-3]
[null,67,1.7182200422923785E-3]
[null,68,1.2128612063240321E-3]
[null,69,8.4372953483410613E-4]
[null,70,5.7855739531481999E-4]
[null,71,3.911373940156503E-4]
[null,72,2.6075826267710016E-4]
[null,73,1.7145748778768326E-4]
[null,74,1.1121566775417244E-4]
[null,75,7.1178027362670251E-5]
[null,76,4.4954543597475989E-5]
[null,77,2.8023611593231797E-5]
[null,78,1.7245299441988849E-5]
[null,79,1.0478156622980573E-5]
[null,80,6.2868939737883284E-6]
[null,81,3.7255667992819573E-6]
[null,82,2.1808195898236148E-6]
[null,83,1.2611968712232782E-6]
[null,84,7.206839264133062E-7]
[null,85,4.0697445256280628E-7]
[null,86,2.2714853166296084E-7]
[null,87,1.2532332781404849E-7]
[null,88,6.8358178807662836E-8]
[null,89,3.6867332390649241E-8]
[null,90,1.9662577275013085E-8]
[null,91,1.0371469331875042E-8]
[null,92,5.4112013905434555E-9]
[null,93,2.7928781370547154E-9]
[null,94,1.4261505380705007E-9]
[null,95,7.2058132449876641E-10]
[null,96,3.6029066224938812E-10]
[null,97,1.7828816276258158E-10]
[null,98,8.7324814414327417E-11]
[null,99,4.2339303958461631E-11]
[null,100,2.0322865900061189E-11]
[null,101,9.6583917148808138E-12]
[null,102,4.5451255128849789E-12]
[null,103,2.1181167438687325E-12]
[null,104,9.7759234332404482E-13]
[null,105,4.4689935694812905E-13]
[null,106,2.0236952012745431E-13]
[null,107,9.0782588468391129E-14]
[null,108,4.0347817097062924E-14]
[null,109,1.776784606109159E-14]

{"sheet":"(42)","index":23,"n_rows":69,"n_cols":7,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[null,"Poisson Probability Distribution can be used to estimate the number of occurrences over a specified interval of time or space"]
[null,"Properties of a Poisson Experiment:"]
[null,"The probability of an occurrence is the same for any two intervals of equal length"]
[null,"The occurrence or nonoccurrence in any interval is independent of the occurrence or nonoccurrence in any other interval"]
[null,"No upper limit for X: 0,1,2,3… , but as x increases, the probability decreases"]
[null,"Mean = Var"]
[null,"Excel function: POISSON\nPOISSON(x,mean,cumulative (0 = exact, 1 = cumulative))"]
[]
[]
[null,"x = Web visitors per minute",7]
[null,"Business =","B & B I of NA"]
[null,{"$f":"B10&\" arrive at a rate of \"&C10&\" per hour at the web site for \"&C11","v":"x = Web visitors per minute arrive at a rate of 7 per hour at the web site for B & B I of NA"}]
[null,"Assumption 1","Probability is the same for any 1 minute interval"]
[null,"Assumption 2","Arrival or nonarrival of a web visitor in a 1 minute period is independent of the arrival or nonarrival in any other 1 minute period"]
[null,"Mean",{"$f":"$C$10","v":7},"calls","per",1,"minute"]
["a","x",0,"calls","per",1,"minute"]
[null,"Mean",{"$f":"C15/1*F16","v":7}]
[null,{"$f":"\"P(\"&C16&\" \"&D16&\" \"&E16&\" \"&F16&\" \"&G16&\")\"","v":"P(0 calls per 1 minute)"},{"$f":"_xlfn.POISSON.DIST(C16,C17,0)","v":9.1188196555451624E-4}]
[null,"P(x) = (mu^x*e^-mu)/X!)",{"$f":"(C17^C16*EXP(1)^-C17)/FACT(C16)","v":9.1188196555451646E-4}]
["b","x",2]
[null,"P(2 or more in 1 minute)",{"$f":"1-_xlfn.POISSON.DIST(C20-1,$C$15,1)","v":0.99270494427556388}]
["c","x",1,{"$f":"1/2","v":0.5},"minutes"]
[null,"Mean",{"$f":"C15*D22","v":3.5}]
[null,"P(1 of more in 30 sec.)",{"$f":"1-_xlfn.POISSON.DIST(C22-1,C23,1)","v":0.96980261657768152}]
["d","x",5]
[null,"P(5 or more in 1 minute)",{"$f":"1-_xlfn.POISSON.DIST(C25-1,$C$15,1)","v":0.82700839211792865}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"x","p(x)"]
[null,0,{"$f":"POISSON(B39,$C$10,0)","v":9.1188196555451624E-4}]
[null,1,{"$f":"POISSON(B40,$C$10,0)","v":6.3831737588816127E-3}]
[null,2,2.2341108156085653E-2]
[null,3,5.2129252364199866E-2]
[null,4,9.1226191637349782E-2]
[null,5,0.12771666829228964]
[null,6,0.14900277967433789]
[null,7,0.14900277967433789]
[null,8,0.13037743221504566]
[null,9,0.10140466950059109]
[null,10,7.0983268650413753E-2]
[null,11,4.5171170959354211E-2]
[null,12,2.6349849726289985E-2]
[null,13,1.4188380621848417E-2]
[null,14,7.0941903109242224E-3]
[null,15,3.3106221450979714E-3]
[null,16,1.4483971884803614E-3]
[null,17,5.9639884231544313E-4]
[null,18,2.3193288312267158E-4]
[null,19,8.5448956939931849E-5]
[null,20,2.9907134928976161E-5]
[null,21,9.969044976325377E-6]
[null,22,3.1719688561035243E-6]
[null,23,9.653818257706377E-7]
[null,24,2.8156969918310329E-7]
[null,25,7.883951577126872E-8]
[null,26,2.122602347688008E-8]
[null,27,5.5030431236355447E-9]
[null,28,1.3757607809088994E-9]
[null,29,3.3208018849525003E-10]
[null,30,7.7485377315558659E-11]

{"sheet":"(49)","index":24,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"Cards in deck at start",52]
[null,"# cards worth 11 =",4]
[null,"# cards worth 12 =",16]
[]
["a","sample size =",2]
[null,"# successes we want",2]
[null,"P(both are face or ace)",{"$f":"SUM(C9:C10)/C8*(SUM(C9:C10)-1)/(C8-1)","v":0.14328808446455507}]
[null,"P(both are face or ace)",{"$f":"_xlfn.HYPGEOM.DIST(C13,C12,SUM(C9:C10),C8,0)","v":0.14328808446455507}]
["b","sample size =",2]
[null,"# successes we want",2]
[null,"P(both Ace)",{"$f":"_xlfn.HYPGEOM.DIST(C16,C17,C9,C8,0)","v":4.5248868778280521E-3}]
["c","sample size =",2]
[null,"# successes we want",2]
[null,"P(both 10)",{"$f":"_xlfn.HYPGEOM.DIST(C19,C20,C10,C8,0)","v":9.0497737556561028E-2}]
["d","P(blackjack)",{"$f":"C15-C18-C21","v":4.8265460030165977E-2}]