{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Formula","POWER","VBA","LSI1","LSI 2"],"not_rendered":{"charts":0,"images":0,"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":"Formula","index":0,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,8,1,9],[1,1,1,2]]}
[]
[null,"Using Formula",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"p (percentage)",0.5,null,null,null,null,null,"P (percentage)",0.5]
[null,"n (years)",2,null,null,null,null,null,"n (years)",2]
[null,"1-p",{"$f":"1-C4","v":0.5},null,null,null,null,null,"1-p"]
[null,null,{"$f":"(1-C4)^C5","v":0.25}]
[null,"Probability of Exceedance",null,null,null,null,null,null,"Probability of Exceedance"]

{"sheet":"POWER","index":1,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using POWER Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"p (percentage)",0.5,null,null,null,null,null,"P (percentage)",0.5]
[null,"n (years)",2,null,null,null,null,null,"n (years)",2]
[null,"1-p",{"$f":"1-C4","v":0.5},null,null,null,null,null,"1-p",{"$f":"1-J4","v":0.5}]
[null,null,{"$f":"POWER(C6,C5)","v":0.25},null,null,null,null,null,null,{"$f":"POWER(J6,J5)","v":0.25}]
[null,"Probability of Exceedance",{"$f":"1-C7","v":0.75},null,null,null,null,null,"Probability of Exceedance"]

{"sheet":"VBA","index":2,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using VBA Code",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"p (percentage)",0.5,null,null,null,null,null,"P (percentage)",0.5]
[null,"n (years)",2,null,null,null,null,null,"n (years)",2]
[null,"1-p",0.5,null,null,null,null,null,"1-p"]
[null,null,0.25]
[null,"Probability of Exceedance",0.75,null,null,null,null,null,"Probability of Exceedance"]

{"sheet":"LSI1","index":3,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Calculating Probability with Mean and Standard Deviation",null,null,null,null,"Practice Yourself"]
[]
[null,"Product","Sales (units)",null,null,null,"Product","Sales (units)"]
[null,"Laptop",100,null,null,null,"Laptop",100]
[null,"Mouse",40,null,null,null,"Mouse",40]
[null,"Ram",60,null,null,null,"Ram",60]
[null,"Mean of Sales",66.67,null,null,null,"Mean of Sales",66.67]
[null,"Standard Deviation",10,null,null,null,"Standard Deviation"]
[null,"Probability (x<66.67)",{"$f":"NORMDIST(66.67,C8,C9, TRUE)","v":0.5},null,null,null,"Probability (x<55)"]

{"sheet":"LSI 2","index":4,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8],[7,1,7,2],[8,1,8,2]]}
[]
[null,"Conditional Probability in Excel",null,null,null,null,"Practice Yourself"]
[]
[null,"Data","Football","Cricket",null,null,"Data","Football","Cricket"]
[null,"Male",10,12,null,null,"Male",10,12]
[null,"Female",8,6,null,null,"Female",8,6]
[null,"Total",18,18]
[null,"Probability(Male/Football)",null,{"$f":"C5/C7","v":0.55555555555555558},null,null,"Probability(Male/Football)"]
[null,"Probability(Male/Cricket)",null,{"$f":"D5/D7","v":0.66666666666666663},null,null,"Probability(Male/Cricket)"]