{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Basic","Ex","Sheet3"],"not_rendered":{"charts":2,"images":1,"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":"Basic","index":0,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,13,5,16],[27,9,28,10],[9,0,20,0],[7,0,8,0],[7,1,7,10],[25,1,26,2],[25,3,26,4],[25,5,26,6],[25,7,26,8],[25,9,26,10],[17,1,18,2],[17,3,18,4],[17,5,18,6],[17,7,18,8],[17,9,18,10],[19,1,20,2],[19,9,20,10],[13,1,14,2],[13,3,14,4],[13,5,14,6],[13,7,14,8],[13,9,14,10],[15,1,16,2],[15,3,16,4],[15,5,16,6],[15,7,16,8],[15,9,16,10],[8,9,8,10],[9,9,10,10],[11,1,12,2],[11,3,12,4],[11,5,12,6],[11,7,12,8],[11,9,12,10],[9,1,10,2],[9,3,10,4],[9,5,10,6],[9,7,10,8],[30,5,31,6],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[19,7,20,8],[27,1,28,2],[27,3,28,4],[27,5,28,6],[27,7,28,8],[19,5,20,6],[19,3,20,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Free download from http://aksharait.com"]
[null,"Let probability of a basketball player making the basket is",null,null,null,null,null,null,null,null,"p =",0.7]
[]
[null,"Let S stands for success i.e. making the basket",null,null,null,null,null,null,"Let F stands for missing the basket"]
[]
[null,"Let us consider the event where player throws basket-ball 4 times"]
[]
[null,"Possible outcomes of the event"]
[null,"All Failure",null,"1 Success",null,"2 Success",null,"3 Success",null,"All Success"]
["All Possible combinations by which event can took place","FFFF",null,"SFFF",null,"SSFF",null,"SSSF",null,"SSSS"]
[]
[null,null,null,"FSFF",null,"SFSF",null,"SSFS"]
[]
[null,null,null,"FFSF",null,"SFFS",null,"SFSS"]
[]
[null,null,null,"FFFS",null,"FSSF",null,"FSSS"]
[]
[null,null,null,null,null,"FSFS"]
[]
[null,null,null,null,null,"FFSS"]
[]
[]
[]
[null,"Probability calculations for above event"]
[]
[null,"=1*0.3*0.3*0.3*0.3",null,"=4*0.7*0.3*0.3*0.3",null,"=6*0.7*0.7*0.3*0.3",null,"=4*0.7*0.7*0.7*0.3",null,"=0.7*0.7*0.7*0.7"]
[]
[null,{"$f":"0.3*0.3*0.3*0.3","v":8.0999999999999996E-3},null,{"$f":"4*0.7*0.3*0.3*0.3","v":7.5600000000000001E-2},null,{"$f":"6*0.7*0.7*0.3*0.3","v":0.26459999999999995},null,{"$f":"4*0.7*0.7*0.7*0.3","v":0.41159999999999991},null,{"$f":"0.7*0.7*0.7*0.7","v":0.24009999999999992}]
[]
[]
[null,null,null,null,null,{"$f":"B28+D28+F28+H28+J28","v":0.99999999999999978}]
[]
[]
[]
[null,"Obviously whenever we say success probability is 70%  means "]
[null,"3 success out of 4 (75%) is most likely to happen"]

{"sheet":"Ex","index":1,"n_rows":113,"n_cols":14,"rows_kept":113,"cut":false,"hidden":false,"merged":[[7,6,9,8],[0,13,5,16]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Download from http://aksharait.com"]
[]
[null,"Understanding the meaning of 70% probability of a success"]
[null,null,"Binomial Distribution","N C X * p N * q X"," takes the form of normal distribution for very large values of N"]
[null,"Let an event has the success probability of ",null,null,null,70,"%"]
[null,"If 100 trials taken, each trial that the event will have success will be ",null,null,null,null,null,70,"%"]
[]
[null,"Probability of exact 70 success out of 100 is",null,null,null,null,"100 C 70 * 0.7 70 * 0.3 30",null,null,{"$f":"COMBIN(100,70)*0.7^70*0.3^30","v":8.6783864753427586E-2}]
[]
[]
[null,"Number of total trials",100]
[]
[null,"Number of exact successes","Probability"]
[null,1,{"$f":"COMBIN(100,B14)*0.7^B14*0.3^(100-B14)","v":1.2025475483746901E-50}]
[null,2,1.3889424183727668E-48]
[null,3,1.0586827766707977E-46]
[null,4,5.9903800446622644E-45]
[null,5,2.6836902600086947E-43]
[null,6,9.9147445716987882E-42]
[null,7,3.1066199657989526E-40]
[null,8,8.4267066572296599E-39]
[null,9,2.0099255878725558E-37]
[null,10,4.2677419982493959E-36]
[null,11,8.1475074512033899E-35]
[null,12,1.4099714283610304E-33]
[null,13,2.227031794539473E-32]
[null,14,3.2291961020822364E-31]
[null,15,4.3199467854522359E-30]
[null,16,5.3549340361335051E-29]
[null,17,6.1739239475421521E-28]
[null,18,6.6426848398555377E-27]
[null,19,6.6893001720650528E-26]
[null,20,6.3213886626014742E-25]
[null,21,5.6190121445346446E-24]
[null,22,4.7080510847388761E-23]
[null,23,3.7255012931411946E-22]
[null,24,2.7889516625043126E-21]
[null,25,1.9782963792697244E-20]
[null,26,1.3315456398930846E-19]
[null,27,8.5153165612915748E-19]
[null,28,5.1801509081190427E-18]
[null,29,3.000915008841376E-17]
[null,30,1.6571719548824036E-16]
[null,31,8.7313361063696455E-16]
[null,32,4.3929534785172317E-15]
[null,33,{"$f":"COMBIN(100,B46)*0.7^B46*0.3^(100-B46)","v":2.1121675310850552E-14}]
[null,34,9.7118291380283304E-14]
[null,35,4.2732048207324627E-13]
[null,36,1.8002853642900669E-12]
[null,37,7.266016605422979E-12]
[null,38,2.8108011605188842E-11]
[null,39,1.0426390629617068E-10]
[null,40,3.7100573323720736E-10]
[null,41,1.2668488452002194E-9]
[null,42,4.1524489926007195E-9]
[null,43,1.3068947992216223E-8]
[null,44,3.9503865521926291E-8]
[null,45,1.1470752062663048E-7]
[null,46,3.200173582699472E-7]
[null,47,8.5791887536198529E-7]
[null,48,2.2103326580506737E-6]
[null,49,5.4732046770778536E-6]
[null,50,1.3026227131445283E-5]
[null,51,2.9798558797423869E-5]
[null,52,6.5518626073823025E-5]
[null,53,1.3845445509939942E-4]
[null,54,2.8118219585001507E-4]
[null,55,5.4873131553760559E-4]
[null,56,1.0288712166330097E-3]
[null,57,1.8531715480875263E-3]
[null,58,3.2057737699675011E-3]
[null,59,5.324844567064663E-3]
[null,60,8.4901688374864389E-3]
[null,61,1.2990422265006569E-2]
[null,62,1.9066587517993491E-2]
[null,63,2.6834456506805701E-2]
[null,64,3.619856372532642E-2]
[null,65,{"$f":"COMBIN(100,B78)*0.7^B78*0.3^(100-B78)","v":4.6779682352729481E-2}]
[null,66,5.7883950385953183E-2]
[null,67,6.8539204934611284E-2]
[null,68,7.7610570293603867E-2]
[null,69,8.3984385245252452E-2]
[null,70,8.6783864753427586E-2]
[null,71,8.556155679915399E-2]
[null,72,8.041201865846416E-2]
[null,73,7.1966920808488419E-2]
[null,74,6.1269135282902329E-2]
[null,75,4.9559922762169861E-2]
[null,76,3.8039414400788285E-2]
[null,77,2.7665028655118731E-2]
[null,78,1.9034485527667174E-2]
[null,79,1.2368399878737319E-2]
[null,80,7.5756449257266085E-3]
[null,81,4.3645690930112137E-3]
[null,82,2.3597060543515905E-3]
[null,83,1.1940681238887564E-3]
[null,84,5.638655029474687E-4]
[null,85,2.47658573843594E-4]
[null,86,1.0079128005262545E-4]
[null,87,3.784500170558349E-5]
[null,88,1.304505740609128E-5]
[null,89,4.1040630041635496E-6]
[null,90,1.1704179678540497E-6]
[null,91,3.00107171244628E-7]
[null,92,6.8502723871056379E-8]
[null,93,1.3749650669459339E-8]
[null,94,2.3891236978847793E-9]
[null,95,3.5208138705670426E-10]
[null,96,4.2787668565918931E-11]
[null,97,{"$f":"COMBIN(100,B110)*0.7^B110*0.3^(100-B110)","v":4.1170265286794846E-12}]
[null,98,2.94073323477106E-13]
[null,99,1.3862042184106006E-14]
[null,100,3.2344765096247345E-16]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}