{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet1 (2)","PDFandCDF"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":0,"defined_names":10,"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":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Mean_",0,null,"x","G","Gprime"]
["Std_",1,null,-3.5,{"$f":"NORMDIST(D2,Mean_,Std_,TRUE)","v":2.3262907903420782E-4},{"$f":"BETADIST(E2,k_,n_+1-k_)","v":2.9285726715893939E-15}]
["k_",4,null,-3.25,5.7702504239076635E-4,1.108609628726175E-13]
["n_",4,null,-3,1.3498980316301035E-3,3.3205028420536982E-12]
[null,null,null,-2.75,2.9797632350545555E-3,7.8836444544833029E-11]
[null,null,null,-2.5,6.2096653257759371E-3,1.4868692395286549E-9]
[null,null,null,-2.25,1.2224472655044671E-2,2.2331635654330037E-8]
[null,null,null,-2,2.275013194817932E-2,2.6787715598642068E-7]
[null,null,null,-1.75,4.0059156863817114E-2,2.5751777858622394E-6]
[null,null,null,-1.5,6.6807201268858085E-2,1.9920173355245919E-5]
[null,null,null,-1.25,0.10564977366685535,1.245874462823525E-4]
[null,null,null,-1,0.15865525393145707,6.336038886999107E-4]
[null,null,null,-0.75,0.22662735237686826,2.6378451672153698E-3]
[null,null,null,-0.5,0.30853753872598688,9.0621666189541778E-3]
[null,null,null,-0.25,0.4012936743170763,2.5932790742199254E-2]
[null,null,null,0,0.5,6.2500000001403475E-2]
[null,null,null,0.25,0.5987063256829237,0.12848587516092469]
[null,null,null,0.5,0.69146246127401312,0.22859905508139711]
[null,null,null,0.75,0.77337264762313174,0.35772989256514875]
[null,null,null,1,0.84134474606854293,0.50106716945466512]
[null,null,null,1.25,0.89435022633314465,0.63977974269310689]
[null,null,null,1.5,0.93319279873114191,0.75837763176571238]
[null,null,null,1.75,0.95994084313618289,0.84913722651857904]
[null,null,null,2,0.97724986805182068,0.91205805209724844]
[null,null,null,2.25,0.98777552734495533,0.95199145091068149]
[null,null,null,2.5,0.99379033467422406,0.9753917420665863]
[null,null,null,2.75,0.99702023676494544,0.98813411524283445]
[null,null,null,3,0.9986501019683699,0.99461133138558377]
[null,null,null,3.25,0.99942297495760923,0.99769389680939313]
[null,null,null,3.5,0.99976737092096579,0.99906980833121961]

{"sheet":"Sheet1 (2)","index":1,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Mean_",0,null,null,"x","G","Gprime"]
["Std_",1,null,1,{"$f":"(D2-1)/($D$30-1)","v":0},{"$f":"E2","v":0},{"$f":"NA()","v":{"$error":"#N/A"}}]
["k_",2,null,2,{"$f":"(D3-1)/($D$30-1)","v":3.5714285714285712E-2},{"$f":"E3","v":3.5714285714285712E-2},{"$f":"BETADIST(F3,k_,n_+1-k_)","v":1.2755102040910265E-3}]
["n_",2,null,3,7.1428571428571425E-2,7.1428571428571425E-2,5.1020408163641043E-3]
[null,null,null,4,0.10714285714285714,0.10714285714285714,1.1479591836819238E-2]
[null,null,null,5,0.14285714285714285,0.14285714285714285,2.0408163265456424E-2]
[null,null,null,6,0.17857142857142858,0.17857142857142858,3.1887755102275671E-2]
[null,null,null,7,0.21428571428571427,0.21428571428571427,4.5918367347276938E-2]
[null,null,null,8,0.25,0.25,6.2500000000460326E-2]
[null,null,null,9,0.2857142857142857,0.2857142857142857,8.1632653061825683E-2]
[null,null,null,10,0.32142857142857145,0.32142857142857145,0.10331632653137318]
[null,null,null,11,0.35714285714285715,0.35714285714285715,0.12755102040910266]
[null,null,null,12,0.39285714285714285,0.39285714285714285,0.15433673469501424]
[null,null,null,13,0.42857142857142855,0.42857142857142855,0.18367346938910784]
[null,null,null,14,0.4642857142857143,0.4642857142857143,0.21556122449138346]
[null,null,null,15,0.5,0.5,0.25000000000184125]
[null,null,null,16,0.5357142857142857,0.5357142857142857,0.28698979592048102]
[null,null,null,17,0.5714285714285714,0.5714285714285714,0.32653061224730262]
[null,null,null,18,0.6071428571428571,0.6071428571428571,0.36862244897494167]
[null,null,null,19,0.6428571428571429,0.6428571428571429,0.41326530611812784]
[null,null,null,20,0.6785714285714286,0.6785714285714286,0.4604591836694959]
[null,null,null,21,0.7142857142857143,0.7142857142857143,0.51020408162904574]
[null,null,null,22,0.75,0.75,0.56249999999677769]
[null,null,null,23,0.7857142857142857,0.7857142857142857,0.61734693877269198]
[null,null,null,24,0.8214285714285714,0.8214285714285714,0.67474489795678827]
[null,null,null,25,0.8571428571428571,0.8571428571428571,0.73469387754906645]
[null,null,null,26,0.8928571428571429,0.8928571428571429,0.79719387754952686]
[null,null,null,27,0.9285714285714286,0.9285714285714286,0.86224489795816917]
[null,null,null,28,0.9642857142857143,0.9642857142857143,0.92984693877499358]
[null,null,null,29,1,1,{"$f":"NA()","v":{"$error":"#N/A"}}]

{"sheet":"PDFandCDF","index":2,"n_rows":102,"n_cols":6,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["x","BetaPDF","BetaCDF",null,"kk_",2]
[0,{"$f":"dbetapdf(A2,kk_,nn_+1-kk_)","v":0},{"$f":"NA()","v":{"$error":"#N/A"}},null,"nn_",2]
[0.01,2.0000000000147296E-2,{"$f":"BETADIST(A3,kk_,nn_+1-kk_)","v":1.000000000007366E-4}]
[0.02,4.0000000000294592E-2,4.0000000000294596E-4]
[0.03,6.0000000000441887E-2,9.0000000000662792E-4]
[0.04,8.0000000000589183E-2,1.6000000000117847E-3]
[0.05,0.10000000000073649,2.5000000000184137E-3]
[0.06,0.12000000000088377,3.6000000000265147E-3]
[7.0000000000000007E-2,0.14000000000103108,4.900000000036089E-3]
[0.08,0.16000000000117837,6.4000000000471301E-3]
[0.09,0.18000000000132566,8.1000000000596498E-3]
[0.1,0.20000000000147297,1.0000000000073658E-2]
[0.11,0.22000000000162026,1.2100000000089119E-2]
[0.12,0.24000000000176755,1.4400000000106061E-2]
[0.13,0.26000000000191487,1.6900000000124461E-2]
[0.14000000000000001,0.28000000000206215,1.9600000000144346E-2]
[0.15,0.30000000000220944,2.2500000000165707E-2]
[0.16,0.32000000000235673,2.5600000000188534E-2]
[0.17,0.34000000000250402,2.8900000000212842E-2]
[0.18,0.36000000000265131,3.2400000000238634E-2]
[0.19,0.3800000000027986,3.6100000000265878E-2]
[0.2,0.40000000000294594,4.0000000000294592E-2]
[0.21,0.42000000000309318,4.4100000000324782E-2]
[0.22,0.44000000000324052,4.840000000035647E-2]
[0.23,0.46000000000338781,5.2900000000389594E-2]
[0.24,0.4800000000035351,5.7600000000424201E-2]
[0.25,0.50000000000368239,6.2500000000460326E-2]
[0.26,0.52000000000382973,6.7600000000497887E-2]
[0.27,0.54000000000397697,7.2900000000536896E-2]
[0.28000000000000003,0.56000000000412431,7.8400000000577424E-2]
[0.28999999999999998,0.58000000000427154,8.4100000000619374E-2]
[0.3,0.60000000000441889,9.0000000000662814E-2]
[0.31,0.62000000000456612,9.61000000007078E-2]
[0.32,{"$f":"dbetapdf(A34,kk_,nn_+1-kk_)","v":0.64000000000471347},0.10240000000075418]
[0.33,0.66000000000486081,{"$f":"BETADIST(A35,kk_,nn_+1-kk_)","v":0.10890000000080206}]
[0.34,0.68000000000500804,0.11560000000085142]
[0.35,0.70000000000515528,0.12250000000090215]
[0.36,0.72000000000530262,0.12960000000095448]
[0.37,0.74000000000544996,0.13690000000100827]
[0.38,0.7600000000055972,0.14440000000106354]
[0.39,0.78000000000574454,0.15210000000112012]
[0.4,0.80000000000589189,0.16000000000117842]
[0.41,0.82000000000603912,0.16810000000123804]
[0.42,0.84000000000618635,0.17640000000129913]
[0.43,0.8600000000063337,0.18490000000136181]
[0.44,0.88000000000648104,0.19360000000142585]
[0.45,0.90000000000662828,0.20250000000149138]
[0.46,0.92000000000677562,0.21160000000155846]
[0.47,0.94000000000692285,0.22090000000162688]
[0.48,0.9600000000070702,0.23040000000169689]
[0.49,0.98000000000721743,0.2401000000017682]
[0.5,1.0000000000073648,0.25000000000184125]
[0.51,1.020000000007512,0.26010000000191552]
[0.52,1.0400000000076595,0.27040000000199155]
[0.53,1.0600000000078067,0.28090000000206877]
[0.54,1.0800000000079539,0.29160000000214753]
[0.55000000000000004,1.1000000000081014,0.30250000000222788]
[0.56000000000000005,1.1200000000082486,0.31360000000230959]
[0.56999999999999995,1.1400000000083959,0.32490000000239272]
[0.57999999999999996,1.1600000000085431,0.3364000000024775]
[0.59,1.1800000000086903,0.34810000000256364]
[0.6,1.2000000000088378,0.36000000000265131]
[0.61,1.220000000008985,0.37209999999537569]
[0.62,1.2400000000091322,0.38439999999546626]
[0.63,1.2600000000092797,0.39689999999555814]
[0.64,{"$f":"dbetapdf(A66,kk_,nn_+1-kk_)","v":1.2800000000094269},0.40959999999565178]
[0.65,1.3000000000095742,{"$f":"BETADIST(A67,kk_,nn_+1-kk_)","v":0.42249999999574694}]
[0.66,1.3200000000097216,0.43559999999584331]
[0.67,1.3400000000098689,0.44889999999594132]
[0.68,1.3600000000100161,0.46239999999604076]
[0.69,1.3800000000101633,0.47609999999614117]
[0.7,1.4000000000103106,0.48999999999624388]
[0.71,1.420000000010458,0.5040999999963478]
[0.72,1.4400000000106052,0.51839999999645303]
[0.73,1.4600000000107525,0.5328999999965599]
[0.74,1.4800000000108999,0.54759999999666786]
[0.75,1.5000000000110472,0.56249999999677769]
[0.76,1.5200000000111944,0.57759999999688905]
[0.77,1.5400000000113419,0.59289999999700171]
[0.78,1.5600000000114891,0.60839999999711603]
[0.79,1.5800000000116363,0.62409999999723165]
[0.8,1.6000000000117838,0.6399999999973488]
[0.81,1.620000000011931,0.65609999999746704]
[0.82,1.6400000000120782,0.67239999999758715]
[0.83,1.6600000000122255,0.68889999999770857]
[0.84,1.6800000000123727,0.70559999999783174]
[0.85,1.7000000000125202,0.72249999999795622]
[0.86,1.7200000000126674,0.73959999999808212]
[0.87,1.7400000000128146,0.75689999999820956]
[0.88,1.7600000000129621,0.77439999999833853]
[0.89,1.7800000000131093,0.79209999999846892]
[0.9,1.8000000000132566,0.80999999999860084]
[0.91,1.820000000013404,0.82809999999873407]
[0.92,1.8400000000135512,0.84639999999886895]
[0.93,1.8600000000136985,0.86489999999900502]
[0.94,1.8800000000138457,0.88359999999914263]
[0.95,1.9000000000139929,0.90249999999928188]
[0.96,{"$f":"dbetapdf(A98,kk_,nn_+1-kk_)","v":1.9200000000141404},0.92159999999942255]
[0.97,1.9400000000142876,0.94089999999956464]
[0.98,1.9600000000144349,0.96039999999970826]
[0.99,1.9800000000145823,0.98009999999985342]
[1,2.0000000000147296,1]