{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["n variable","p variable"],"not_rendered":{"charts":2,"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":"n variable","index":0,"n_rows":104,"n_cols":12,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
[50,null,null,null,null,null,null,null,null,null,"p=",0.12]
[]
["k","P(X=k)"]
[0,{"$f":"IF(A4<=$A$1,_xlfn.BINOM.DIST(A4,$A$1,$L$1,0),0)","v":1.6754582391733E-3}]
[1,{"$f":"IF(A5<=$A$1,_xlfn.BINOM.DIST(A5,$A$1,$L$1,0),0)","v":1.1423578903454319E-2}]
[2,3.8165138609267832E-2]
[3,8.3269393329311617E-2]
[4,0.13342027794810155]
[5,0.16738180324398197]
[6,0.17118593513589064]
[7,0.14673080154504914]
[8,0.1075470079506326]
[9,6.8439005059493449E-2]
[10,3.8263625555989528E-2]
[11,1.8973698622804729E-2]
[12,8.4087982532884652E-3]
[13,3.3517587443177769E-3]
[14,1.2079390279846514E-3]
[15,3.9532550006770461E-4]
[16,1.1792379973610517E-4]
[17,3.2161036291664951E-5]
[18,8.0402590729162547E-6]
[19,1.8465666770334057E-6]
[20,3.9029704764569478E-7]
[21,7.6031892398512042E-8]
[22,1.3666889749319326E-8]
[23,2.2688117370411531E-9]
[24,3.4805634602335992E-10]
[25,4.9360718163312529E-11]
[26,6.4721221367979819E-12]
[27,7.8449965294521427E-13]
[28,8.7874149437044491E-14]
[29,9.0904292521081099E-15]
[30,8.6772279224667943E-16]
[31,7.6339248584751771E-17]
[32,6.1808766609813549E-18]
[33,4.5973462767629921E-19]
[34,3.1345542796111099E-20]
[35,1.9540078626147388E-21]
[36,1.1102317401220125E-22]
[37,5.7284684379759164E-24]
[38,2.6723716397256431E-25]
[39,1.1212748138708816E-26]
[40,4.2047805520158424E-28]
[41,1.398485771180435E-29]
[42,4.0864843963064671E-31]
[43,1.0367402273927547E-32]
[44,2.2491265263686016E-34]
[45,4.0893209570338361E-36]
[46,6.0612464778168695E-38]
[47,7.0343286009480757E-40]
[48,5.9951664212626257E-42]
[49,3.3368273216674779E-44]
[50,9.1004381500021583E-47]
[51,0]
[52,0]
[53,0]
[54,0]
[55,0]
[56,0]
[57,0]
[58,0]
[59,0]
[60,0]
[61,0]
[62,0]
[63,0]
[64,0]
[65,{"$f":"IF(A69<=$A$1,_xlfn.BINOM.DIST(A69,$A$1,$L$1,0),0)","v":0}]
[66,0]
[67,0]
[68,0]
[69,0]
[70,0]
[71,0]
[72,0]
[73,0]
[74,0]
[75,0]
[76,0]
[77,0]
[78,0]
[79,0]
[80,0]
[81,0]
[82,0]
[83,0]
[84,0]
[85,0]
[86,0]
[87,0]
[88,0]
[89,0]
[90,0]
[91,0]
[92,0]
[93,0]
[94,0]
[95,0]
[96,0]
[97,0]
[98,0]
[99,0]
[100,0]

{"sheet":"p variable","index":1,"n_rows":104,"n_cols":12,"rows_kept":104,"cut":false,"hidden":false,"merged":[[1,10,2,11]]}
[{"$f":"A2/100","v":0.12},null,null,null,null,null,null,null,null,null,"n=",50]
[12,null,null,null,null,null,null,null,null,null,"(maximum 100 dans cet exemple)"]
["k","P(X=k)"]
[0,{"$f":"IF(A4<=$L$1,_xlfn.BINOM.DIST(A4,$L$1,$A$2/100,0),0)","v":1.6754582391733E-3}]
[1,1.1423578903454319E-2]
[2,3.8165138609267832E-2]
[3,8.3269393329311617E-2]
[4,0.13342027794810155]
[5,0.16738180324398197]
[6,0.17118593513589064]
[7,0.14673080154504914]
[8,0.1075470079506326]
[9,6.8439005059493449E-2]
[10,3.8263625555989528E-2]
[11,1.8973698622804729E-2]
[12,8.4087982532884652E-3]
[13,3.3517587443177769E-3]
[14,1.2079390279846514E-3]
[15,3.9532550006770461E-4]
[16,1.1792379973610517E-4]
[17,3.2161036291664951E-5]
[18,8.0402590729162547E-6]
[19,1.8465666770334057E-6]
[20,3.9029704764569478E-7]
[21,7.6031892398512042E-8]
[22,1.3666889749319326E-8]
[23,2.2688117370411531E-9]
[24,3.4805634602335992E-10]
[25,4.9360718163312529E-11]
[26,6.4721221367979819E-12]
[27,7.8449965294521427E-13]
[28,8.7874149437044491E-14]
[29,9.0904292521081099E-15]
[30,8.6772279224667943E-16]
[31,7.6339248584751771E-17]
[32,{"$f":"IF(A36<=$L$1,_xlfn.BINOM.DIST(A36,$L$1,$A$2/100,0),0)","v":6.1808766609813549E-18}]
[33,4.5973462767629921E-19]
[34,3.1345542796111099E-20]
[35,1.9540078626147388E-21]
[36,1.1102317401220125E-22]
[37,5.7284684379759164E-24]
[38,2.6723716397256431E-25]
[39,1.1212748138708816E-26]
[40,4.2047805520158424E-28]
[41,1.398485771180435E-29]
[42,4.0864843963064671E-31]
[43,1.0367402273927547E-32]
[44,2.2491265263686016E-34]
[45,4.0893209570338361E-36]
[46,6.0612464778168695E-38]
[47,7.0343286009480757E-40]
[48,5.9951664212626257E-42]
[49,3.3368273216674779E-44]
[50,9.1004381500021583E-47]
[51,0]
[52,0]
[53,0]
[54,0]
[55,0]
[56,0]
[57,0]
[58,0]
[59,0]
[60,0]
[61,0]
[62,0]
[63,0]
[64,{"$f":"IF(A68<=$L$1,_xlfn.BINOM.DIST(A68,$L$1,$A$2/100,0),0)","v":0}]
[65,0]
[66,0]
[67,0]
[68,0]
[69,0]
[70,0]
[71,0]
[72,0]
[73,0]
[74,0]
[75,0]
[76,0]
[77,0]
[78,0]
[79,0]
[80,0]
[81,0]
[82,0]
[83,0]
[84,0]
[85,0]
[86,0]
[87,0]
[88,0]
[89,0]
[90,0]
[91,0]
[92,0]
[93,0]
[94,0]
[95,0]
[96,{"$f":"IF(A100<=$L$1,_xlfn.BINOM.DIST(A100,$L$1,$A$2/100,0),0)","v":0}]
[97,0]
[98,0]
[99,0]
[100,0]