{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":25,"n_cols":44,"rows_kept":25,"cut":false,"hidden":false,"merged":[[15,39,15,47],[12,39,12,47],[13,1,14,4],[13,39,14,47],[1,1,11,9],[3,11,4,17],[0,39,3,45],[0,27,4,36],[24,1,25,6],[24,7,25,8],[24,10,25,15],[24,16,25,17],[16,39,16,40],[17,39,17,40],[18,39,18,40],[19,39,19,40],[20,39,20,40],[24,19,25,24],[24,25,25,26],[24,28,25,33],[24,34,25,38],[19,1,21,9],[16,1,17,4],[16,43,16,47],[17,43,17,47],[18,43,18,47],[19,43,19,47],[20,43,20,47],[16,41,16,42],[17,41,17,42],[18,41,18,42],[19,41,19,42],[20,41,20,42]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Understanding the Calculation of Binomial Probability",null,null,null,null,null,null,null,null,null,null,null,"Free download from http://aksharait.com"]
[null,"This expriment take the sample of 24 balls from the population having 192 red and 192 green balls and measures green balls in sample if it is equal to desired balls (Value x) then count that event and updates probability. To start the expriment click on the button. Change the value of x (Cell AP18) and compare the observed probability with calculated probability of Sheet2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Population"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Theory of binomial distribution"]
[null,"Repeat Expriment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P = nCxpxq(n-x)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Where"]
[null,"Break Expriment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n =",null,24,null,"Number of trials"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x =",null,10,null,"Number of success"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"p =",null,0.5,null,"Probability of success"]
[null,"Note:                                                            Best results for X = 9 to 14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"q =",null,0.5,null,"Probability of failure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P =",null,{"$f":"COMBIN(AP17,AP18)*AP19^AP18*AP20^(AP17-AP18)","v":0.11689996719360352},null,"Probability of event"]
[]
[]
[]
[null,"This Event Number     (not trials)",null,null,null,null,null,50,null,null,"Number of green balls in this event",null,null,null,null,null,11,null,null,"Events of drawing x green balls",null,null,null,null,null,5,null,null,"Observed Probability of drawing x green balls",null,null,null,null,null,{"$f":"Z25/H25","v":0.1}]

{"sheet":"Sheet2","index":1,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"N",24]
[]
[]
[]
[null,"x","nCr","pr","q(n-r)","P"]
[null,0,{"$f":"COMBIN($C$3,B8)","v":1},{"$f":"0.5^B8","v":1},{"$f":"0.5^($C$3-B8)","v":5.9604644775390625E-8},{"$f":"C8*D8*E8","v":5.9604644775390625E-8}]
[null,1,{"$f":"COMBIN($C$3,B9)","v":24},{"$f":"0.5^B9","v":0.5},{"$f":"0.5^($C$3-B9)","v":1.1920928955078125E-7},{"$f":"C9*D9*E9","v":1.430511474609375E-6}]
[null,2,276,0.25,2.384185791015625E-7,1.6450881958007813E-5]
[null,3,2024.0000000000002,0.125,4.76837158203125E-7,1.2063980102539064E-4]
[null,4,10626,6.25E-2,9.5367431640625E-7,6.3335895538330078E-4]
[null,5,42503.999999999993,3.125E-2,1.9073486328125E-6,2.5334358215332027E-3]
[null,6,134596.00000000003,1.5625E-2,3.814697265625E-6,8.0225467681884783E-3]
[null,7,346104,7.8125E-3,7.62939453125E-6,2.0629405975341797E-2]
[null,8,735471,3.90625E-3,1.52587890625E-5,4.3837487697601318E-2]
[null,9,1307504,1.953125E-3,3.0517578125E-5,7.7933311462402344E-2]
[null,10,1961256,9.765625E-4,6.103515625E-5,0.11689996719360352]
[null,11,2496144.0000000005,4.8828125E-4,1.220703125E-4,0.14878177642822268]
[null,12,2704156.0000000009,2.44140625E-4,2.44140625E-4,0.16118025779724127]
[null,13,2496144.0000000005,1.220703125E-4,4.8828125E-4,0.14878177642822268]
[null,14,1961256,6.103515625E-5,9.765625E-4,0.11689996719360352]
[null,15,1307504,3.0517578125E-5,1.953125E-3,7.7933311462402344E-2]
[null,16,735471,1.52587890625E-5,3.90625E-3,4.3837487697601318E-2]
[null,17,346104,7.62939453125E-6,7.8125E-3,2.0629405975341797E-2]
[null,18,134596.00000000003,3.814697265625E-6,1.5625E-2,8.0225467681884783E-3]
[null,19,42503.999999999993,1.9073486328125E-6,3.125E-2,2.5334358215332027E-3]
[null,20,10626,9.5367431640625E-7,6.25E-2,6.3335895538330078E-4]
[null,21,2024.0000000000002,4.76837158203125E-7,0.125,1.2063980102539064E-4]
[null,22,276,2.384185791015625E-7,0.25,1.6450881958007813E-5]
[null,23,24,1.1920928955078125E-7,0.5,1.430511474609375E-6]
[null,24,1,5.9604644775390625E-8,1,5.9604644775390625E-8]