{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["<=","<= (an)","> (an)","Between","Between (an)"],"not_rendered":{"charts":4,"images":0,"macros":0,"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":"<=","index":0,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"The probability of getting stuck in traffic on Hwy 99 in the morning is \"&E10&\".\"","v":"The probability of getting stuck in traffic on Hwy 99 in the morning is 0.25."}]
[{"$f":"\"Over the next three weeks (\"&E9&\" workdays), what is probability that you will get stuck in traffic for various x values\"","v":"Over the next three weeks (15 workdays), what is probability that you will get stuck in traffic for various x values"}]
["Binomial Experiment?"]
[1,"Fixed # of Identical Trials = n",null,null,"Yes",null,{"$f":"\"Binomial Distribution, n = \"&E9&\", p = \"&E10","v":"Binomial Distribution, n = 15, p = 0.25"}]
[2,"Each trial only results in S or F",null,null,"Yes"]
[3,"p remains the same for each trial",null,null,"Yes"]
[4,"All events are independent",null,null,"Yes"]
[]
["n = # of Fixed Trials = # drive on bridge",null,null,null,15]
["p = Prob of Success =",null,null,null,0.25]
[{"$f":"\"Random Discrete Variable = x = Stuck In Traffic in \"&E9&\" Tries\"","v":"Random Discrete Variable = x = Stuck In Traffic in 15 Tries"},null,null,null,3]
[{"$f":"C14","v":0}]
[]
["X","P(x) = f(x)"]
[0]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
["Total",{"$f":"SUM(B15:B30)","v":0}]

{"sheet":"<= (an)","index":1,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"The probability of getting stuck in traffic on Hwy 99 in the morning is \"&E10&\".\"","v":"The probability of getting stuck in traffic on Hwy 99 in the morning is 0.25."}]
[{"$f":"\"Over the next three weeks (\"&E9&\" workdays), what is probability that you will get stuck in traffic for various x values\"","v":"Over the next three weeks (15 workdays), what is probability that you will get stuck in traffic for various x values"}]
["Binomial Experiment?"]
[1,"Fixed # of Identical Trials = n",null,null,"Yes",null,{"$f":"\"Binomial Distribution, n = \"&E9&\", p = \"&E10","v":"Binomial Distribution, n = 15, p = 0.25"}]
[2,"Each trial only results in S or F",null,null,"Yes"]
[3,"p remains the same for each trial",null,null,"Yes"]
[4,"All events are independent",null,null,"Yes"]
[]
["n = # of Fixed Trials = # drive on bridge",null,null,null,15]
["p = Prob of Success =",null,null,null,0.25]
[{"$f":"\"Random Discrete Variable = x = Stuck In Traffic in \"&E9&\" Tries\"","v":"Random Discrete Variable = x = Stuck In Traffic in 15 Tries"},null,null,null,4]
[{"$f":"C14","v":"P(x<=4) = 0.6865"},null,null,null,{"$f":"_xlfn.BINOM.DIST(E11,E9,E10,1)","v":0.68648594152182341}]
[]
["X","P(x) = f(x)",{"$f":"\"P(x<=\"&E11&\") = \"&ROUND(E12,4)","v":"P(x<=4) = 0.6865"}]
[0,{"$f":"_xlfn.BINOM.DIST(A15,$E$9,$E$10,0)","v":1.3363461010158065E-2},{"$f":"IF(A15<=$E$11,B15,\"\")","v":1.3363461010158065E-2}]
[1,{"$f":"_xlfn.BINOM.DIST(A16,$E$9,$E$10,0)","v":6.6817305050790338E-2},{"$f":"IF(A16<=$E$11,B16,\"\")","v":6.6817305050790338E-2}]
[2,0.15590704511851075,0.15590704511851075]
[3,0.22519906517118218,0.22519906517118218]
[4,0.22519906517118218,0.22519906517118218]
[5,0.16514598112553358,""]
[6,9.1747767291963059E-2,""]
[7,3.9320471696555608E-2,""]
[8,1.3106823898851871E-2,""]
[9,3.398065455257893E-3,""]
[10,6.7961309105157863E-4,""]
[11,1.0297168046236046E-4,""]
[12,1.1441297829151157E-5,""]
[13,8.8009983301163059E-7,""]
[14,4.1909515857696467E-8,""]
[15,9.3132257461547934E-10,""]
["Total",{"$f":"SUM(B15:B30)","v":1}]

{"sheet":"> (an)","index":2,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"The probability of getting stuck in traffic on Hwy 99 in the morning is \"&E10&\".\"","v":"The probability of getting stuck in traffic on Hwy 99 in the morning is 0.25."}]
[{"$f":"\"Over the next three weeks (\"&E9&\" workdays), what is probability that you will get stuck in traffic for various x values\"","v":"Over the next three weeks (15 workdays), what is probability that you will get stuck in traffic for various x values"}]
["Binomial Experiment?"]
[1,"Fixed # of Identical Trials = n",null,null,"Yes",null,{"$f":"\"Binomial Distribution, n = \"&E9&\", p = \"&E10","v":"Binomial Distribution, n = 15, p = 0.25"}]
[2,"Each trial only results in S or F",null,null,"Yes"]
[3,"p remains the same for each trial",null,null,"Yes"]
[4,"All events are independent",null,null,"Yes"]
[]
["n = # of Fixed Trials = # drive on bridge",null,null,null,15]
["p = Prob of Success =",null,null,null,0.25]
[{"$f":"\"Random Discrete Variable = x = Stuck In Traffic in \"&E9&\" Tries\"","v":"Random Discrete Variable = x = Stuck In Traffic in 15 Tries"},null,null,null,6]
[{"$f":"C14","v":"P(x>6) = 0.0566"},null,null,null,{"$f":"1-_xlfn.BINOM.DIST(E11,E9,E10,1)","v":5.6620310060679913E-2}]
[]
["X","P(x) = f(x)",{"$f":"\"P(x>\"&E11&\") = \"&ROUND(E12,4)","v":"P(x>6) = 0.0566"}]
[0,{"$f":"_xlfn.BINOM.DIST(A15,$E$9,$E$10,0)","v":1.3363461010158065E-2},{"$f":"IF(A15>$E$11,B15,\"\")","v":""}]
[1,{"$f":"_xlfn.BINOM.DIST(A16,$E$9,$E$10,0)","v":6.6817305050790338E-2},{"$f":"IF(A16>$E$11,B16,\"\")","v":""}]
[2,0.15590704511851075,""]
[3,0.22519906517118218,""]
[4,0.22519906517118218,""]
[5,0.16514598112553358,""]
[6,9.1747767291963059E-2,""]
[7,3.9320471696555608E-2,3.9320471696555608E-2]
[8,1.3106823898851871E-2,1.3106823898851871E-2]
[9,3.398065455257893E-3,3.398065455257893E-3]
[10,6.7961309105157863E-4,6.7961309105157863E-4]
[11,1.0297168046236046E-4,1.0297168046236046E-4]
[12,1.1441297829151157E-5,1.1441297829151157E-5]
[13,8.8009983301163059E-7,8.8009983301163059E-7]
[14,4.1909515857696467E-8,4.1909515857696467E-8]
[15,9.3132257461547934E-10,9.3132257461547934E-10]
["Total",{"$f":"SUM(B15:B30)","v":1}]

{"sheet":"Between","index":3,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"The probability of getting stuck in traffic on Hwy 99 in the morning is \"&E10&\".\"","v":"The probability of getting stuck in traffic on Hwy 99 in the morning is 0.25."}]
[{"$f":"\"Over the next three weeks (\"&E9&\" workdays), what is probability that you will get stuck in traffic for various x values/\"","v":"Over the next three weeks (15 workdays), what is probability that you will get stuck in traffic for various x values/"}]
["Binomial Experiment?"]
[1,"Fixed # of Identical Trials = n",null,null,"Yes",null,{"$f":"\"Binomial Distribution, n = \"&E9&\", p = \"&E10","v":"Binomial Distribution, n = 15, p = 0.25"}]
[2,"Each trial only results in S or F",null,null,"Yes",null,{"$f":"\"Random Discrete Variable = x = Stuck In Traffic in \"&E9&\" Tries\"","v":"Random Discrete Variable = x = Stuck In Traffic in 15 Tries"}]
[3,"p remains the same for each trial",null,null,"Yes"]
[4,"All events are independent",null,null,"Yes"]
[]
["n = # of Fixed Trials = # drive on bridge",null,null,null,15]
["p = Prob of Success =",null,null,null,0.25]
["X - Lower",null,null,null,2]
["X - Upper",null,null,null,5]
[]
[]
["X","P(x) = f(x)"]
[0,{"$f":"_xlfn.BINOM.DIST(A16,$E$9,$E$10,0)","v":1.3363461010158065E-2}]
[1,{"$f":"_xlfn.BINOM.DIST(A17,$E$9,$E$10,0)","v":6.6817305050790338E-2}]
[2,0.15590704511851075]
[3,0.22519906517118218]
[4,0.22519906517118218]
[5,0.16514598112553358]
[6,9.1747767291963059E-2]
[7,3.9320471696555608E-2]
[8,1.3106823898851871E-2]
[9,3.398065455257893E-3]
[10,6.7961309105157863E-4]
[11,1.0297168046236046E-4]
[12,1.1441297829151157E-5]
[13,8.8009983301163059E-7]
[14,4.1909515857696467E-8]
[15,9.3132257461547934E-10]
["Total",{"$f":"SUM(B16:B31)","v":1}]

{"sheet":"Between (an)","index":4,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"The probability of getting stuck in traffic on Hwy 99 in the morning is \"&E10&\".\"","v":"The probability of getting stuck in traffic on Hwy 99 in the morning is 0.25."}]
[{"$f":"\"Over the next three weeks (\"&E9&\" workdays), what is probability that you will get stuck in traffic for various x values/\"","v":"Over the next three weeks (15 workdays), what is probability that you will get stuck in traffic for various x values/"}]
["Binomial Experiment?"]
[1,"Fixed # of Identical Trials = n",null,null,"Yes",null,{"$f":"\"Binomial Distribution, n = \"&E9&\", p = \"&E10","v":"Binomial Distribution, n = 15, p = 0.25"}]
[2,"Each trial only results in S or F",null,null,"Yes",null,{"$f":"\"Random Discrete Variable = x = Stuck In Traffic in \"&E9&\" Tries\"","v":"Random Discrete Variable = x = Stuck In Traffic in 15 Tries"}]
[3,"p remains the same for each trial",null,null,"Yes"]
[4,"All events are independent",null,null,"Yes"]
[]
["n = # of Fixed Trials = # drive on bridge",null,null,null,15]
["p = Prob of Success =",null,null,null,0.25]
["X - Lower",null,null,null,2]
["X - Upper",null,null,null,5]
[null,null,null,null,{"$f":"_xlfn.BINOM.DIST(E12,E9,E10,1)-_xlfn.BINOM.DIST(E11-1,E9,E10,1)","v":0.77145115658640862}]
[]
["X","P(x) = f(x)",{"$f":"\"P(\"&E11&\"<=X<=\"&E12&\") = \"&ROUND(E13,4)","v":"P(2<=X<=5) = 0.7715"}]
[0,{"$f":"_xlfn.BINOM.DIST(A16,$E$9,$E$10,0)","v":1.3363461010158065E-2},{"$f":"IF(AND(A16>=$E$11,A16<=$E$12),B16,\"\")","v":""}]
[1,{"$f":"_xlfn.BINOM.DIST(A17,$E$9,$E$10,0)","v":6.6817305050790338E-2},{"$f":"IF(AND(A17>=$E$11,A17<=$E$12),B17,\"\")","v":""}]
[2,0.15590704511851075,0.15590704511851075]
[3,0.22519906517118218,0.22519906517118218]
[4,0.22519906517118218,0.22519906517118218]
[5,0.16514598112553358,0.16514598112553358]
[6,9.1747767291963059E-2,""]
[7,3.9320471696555608E-2,""]
[8,1.3106823898851871E-2,""]
[9,3.398065455257893E-3,""]
[10,6.7961309105157863E-4,""]
[11,1.0297168046236046E-4,""]
[12,1.1441297829151157E-5,""]
[13,8.8009983301163059E-7,""]
[14,4.1909515857696467E-8,""]
[15,9.3132257461547934E-10,""]
["Total",{"$f":"SUM(B16:B31)","v":1}]