{"text_format":"3","workbook":"xlsb","n_sheets":1,"sheets":["2 Proportions Test Example"],"not_rendered":{"defined_names":11,"comments":1},"read":"bin_skipped_in_rows","date_system":"1900","formulas":"cached_only","passed_over":{"ids":[37,38,1024],"n":126}}

{"sheet":"2 Proportions Test Example","index":0,"n_rows":48,"n_cols":14,"rows_kept":48,"merged":[[0,0,0,3],[1,0,1,3],[13,0,13,4],[13,7,13,10],[14,0,14,4],[14,7,14,13],[16,7,17,7],[16,8,16,9],[16,10,16,11],[16,12,17,12],[16,13,17,13]],"read":"bin_skipped_in_rows","flags":["formulas_cached_only","records_skipped"],"rows_in_doubt":{"n":0,"rows":[]},"rows_in_doubt_other":2}
["Simple 2 Proportions Test"]
["Use this for a quick check between two values."]
[null,"Sample 1","Sample 2"]
["Trials",231066,196695]
["Events",170903.348258207,145987.17170495767]
[]
[null,"Pc =",0.7408120889075084]
[null,"z = ",-1.91230182147702,-1.91230182147702]
[null,"p =",0.05583749234205193,0.05583749234205193]
[]
[]
[]
[]
["Dynamic 2 Proportions Test (Different Row)",{"$nulls":6},"Dynamic 2 Proportions Test (Same Row)"]
["Use this for a quick check between many listed values where each value is compared with the value on the next row.",{"$nulls":6},"Use this for a quick check between many listed values where the \"Group 1\" value is compared with the \"Group 2\" value next to it on the same row."]
[]
["Date","Volume","Metric %","Abs Diff","P-Value",null,null,"Date","Group 1",null,"Group 2",null,"Abs Diff","P-Value"]
["2010-01-01",{"v":2329.4716205666327,"d":"2329"},0.867332035053554,"","",{"$nulls":3},"Volume","Metric","Volume","Metric"]
["2010-01-02",3503,0.8487766788131181,{"v":-0.018555356240435916,"d":"-1.86%"},{"v":0.047937503700504314,"d":"0.048"},null,null,"2010-01-01",139,{"v":0.7942857142857143,"d":"79.4%"},32,{"v":0.7619047619047619,"d":"76.2%"},{"v":-0.0323809523809524,"d":"-3.24%"},{"v":0.686054679698465,"d":"0.686"}]
["2010-01-03",{"v":994.7788531648075,"d":"995"},0.859254498714653,{"v":0.010477819901534846,"d":"1.05%"},{"v":0.41265025776048403,"d":"0.413"},null,null,"2010-01-02",347,{"v":0.8920308483290489,"d":"89.2%"},116,{"v":0.90625,"d":"90.6%"},{"v":0.014219151670951113,"d":"1.42%"},{"v":0.6646020856312798,"d":"0.665"}]
["2010-01-04",{"v":780.6374158600863,"d":"781"},0.8612539467749211,{"v":0.001999448060268083,"d":"0.20%"},{"v":0.9040384222617801,"d":"0.904"},null,null,"2010-01-03",76,{"v":0.8837209302325582,"d":"88.4%"},24,{"v":0.96,"d":"96.0%"},{"v":0.07627906976744181,"d":"7.63%"},{"v":0.273138334397693,"d":"0.273"}]
["2010-01-05",{"v":17393.84753850981,"d":"17394"},0.868360044350368,{"v":0.00710609757544689,"d":"0.71%"},{"v":0.5660211142638691,"d":"0.566"},null,null,"2010-01-04",3854,{"v":0.8666516752867102,"d":"86.7%"},1251,{"v":0.8395973154362416,"d":"84.0%"},{"v":-0.027054359850468557,"d":"-2.71%"},{"v":0.0165620504321613,"d":"0.017"}]
["2010-01-06",{"v":3746.1572153088514,"d":"3746"},0.8620791060138215,{"v":-0.0062809383365464155,"d":"-0.63%"},{"v":0.3040877255519443,"d":"0.304"},null,null,"2010-01-05",8918,{"v":0.8688620420888542,"d":"86.9%"},3256,{"v":0.8419963796224463,"d":"84.2%"},{"v":-0.02686566246640787,"d":"-2.69%"},{"v":0.0001444236519110298,"d":"0.000"}]
["2010-01-07",{"v":1505.910498864363,"d":"1506"},0.8638401434609966,{"v":0.00176103744717504,"d":"0.18%"},{"v":0.8668667841136102,"d":"0.867"},null,null,"2010-01-06",898,{"v":0.7076438140267928,"d":"70.8%"},317,{"v":0.6817204301075269,"d":"68.2%"},{"v":-0.025923383919265852,"d":"-2.59%"},{"v":0.3861522257127903,"d":"0.386"}]
["2010-01-08",{"v":2792.9823487922718,"d":"2793"},0.8620406824146981,{"v":-0.0017994610462984673,"d":"-0.18%"},{"v":0.8701021327331337,"d":"0.870"},null,null,"2010-01-07",1327,{"v":0.9101508916323731,"d":"91.0%"},538,{"v":0.8819672131147541,"d":"88.2%"},{"v":-0.028183678517618937,"d":"-2.82%"},{"v":0.06361726376524457,"d":"0.064"}]
["2010-01-09",4403,0.8579905063291139,{"v":-0.004050176085584223,"d":"-0.41%"},{"v":0.629876904989501,"d":"0.630"},null,null,"2010-01-08",382,{"v":0.8822170900692841,"d":"88.2%"},181,{"v":0.8916256157635468,"d":"89.2%"},{"v":0.00940852569426276,"d":"0.94%"},{"v":0.7435722711280157,"d":"0.744"}]
["2010-01-10",{"v":1442.0312416051713,"d":"1442"},0.8507824553669826,{"v":-0.007208050962131285,"d":"-0.72%"},{"v":0.4983607353815933,"d":"0.498"},null,null,"2010-01-09",1918,{"v":0.88837424733673,"d":"88.8%"},799,{"v":0.860064585575888,"d":"86.0%"},{"v":-0.02830966176084193,"d":"-2.83%"},{"v":0.03851397098507703,"d":"0.039"}]
["2010-01-11",8482,0.8699219136107542,{"v":0.019139458243771612,"d":"1.91%"},{"v":0.04774644342765222,"d":"0.048"},null,null,"2010-01-10",18,{"v":0.8571428571428571,"d":"85.7%"},15,{"v":1,"d":"100.0%"},{"v":0.1428571428571429,"d":"14.29%"},{"v":0.12739667702108992,"d":"0.127"}]
["2010-01-12",{"v":3775.539295962019,"d":"3776"},0.8598944591029024,{"v":-0.010027454507851807,"d":"-1.00%"},{"v":0.13141174521574062,"d":"0.131"},null,null,"2010-01-11",75,{"v":0.9375,"d":"93.8%"},33,{"v":0.8048780487804879,"d":"80.5%"},{"v":-0.13262195121951215,"d":"-13.26%"},{"v":0.03675353104429013,"d":"0.037"}]
["2010-01-13",{"v":361.8290608538631,"d":"362"},0.8715212847871522,{"v":0.011626825684249775,"d":"1.16%"},{"v":0.5415032256741761,"d":"0.542"},null,null,"2010-01-12",10,{"v":0.9090909090909091,"d":"90.9%"},8,{"v":0.8888888888888888,"d":"88.9%"},{"v":-0.02020202020202022,"d":"-2.02%"},{"v":0.8870514085132206,"d":"0.887"}]
["2010-01-14",{"v":2581.4471185692573,"d":"2581"},0.862697774202199,{"v":-0.008823510584953231,"d":"-0.88%"},{"v":0.646781865521687,"d":"0.647"},null,null,"2010-01-13",173,{"v":0.8009259259259259,"d":"80.1%"},66,{"v":0.7586206896551724,"d":"75.9%"},{"v":-0.042305236270753555,"d":"-4.23%"},{"v":0.47339966785859255,"d":"0.473"}]
["2010-01-15",{"v":1020.6613949229645,"d":"1021"},0.8665908352291193,{"v":0.0038930610269203303,"d":"0.39%"},{"v":0.7588686997153189,"d":"0.759"},null,null,"2010-01-14",7,{"v":1,"d":"100.0%"},2,{"v":1,"d":"100.0%"},{"v":0,"d":"0.00%"},""]
["2010-01-16",{"v":3176.3290188760125,"d":"3176"},0.8467432950191571,{"v":-0.019847540209962156,"d":"-1.98%"},{"v":0.12076609694451768,"d":"0.121"},null,null,"2010-01-15",576,{"v":0.8458149779735683,"d":"84.6%"},222,{"v":0.8072727272727273,"d":"80.7%"},{"v":-0.03854225070084105,"d":"-3.85%"},{"v":0.18860117367727525,"d":"0.189"}]
["2010-01-17",{"v":1344.967287806318,"d":"1345"},0.8251107828655835,{"v":-0.021632512153573646,"d":"-2.16%"},{"v":0.06948742065250091,"d":"0.069"},null,null,"2010-01-16",377,{"v":0.9019138755980861,"d":"90.2%"},105,{"v":0.84,"d":"84.0%"},{"v":-0.06191387559808614,"d":"-6.19%"},{"v":0.07472871288239191,"d":"0.075"}]
["2010-01-18",{"v":842.6183470985275,"d":"843"},0.8641808144984897,{"v":0.03907003163290623,"d":"3.91%"},{"v":0.01523859582326792,"d":"0.015"},null,null,"2010-01-17",1674,{"v":0.8416289592760181,"d":"84.2%"},575,{"v":0.7876712328767124,"d":"78.8%"},{"v":-0.05395772639930574,"d":"-5.40%"},{"v":0.0031082962805157877,"d":"0.003"}]
["2010-01-19",{"v":3489.2255545385938,"d":"3489"},0.8720167607943159,{"v":0.00783594629582618,"d":"0.78%"},{"v":0.5431860605661822,"d":"0.543"},null,null,"2010-01-18",621,{"v":0.8460490463215259,"d":"84.6%"},255,{"v":0.8333333333333334,"d":"83.3%"},{"v":-0.012715712988192518,"d":"-1.27%"},{"v":0.6389648789349576,"d":"0.639"}]
["2010-01-20",{"v":1906.83380007713,"d":"1907"},0.860280658938377,{"v":-0.011736101855938874,"d":"-1.17%"},{"v":0.22361792541195502,"d":"0.224"},null,null,"2010-01-19",285,{"v":0.8689024390243902,"d":"86.9%"},99,{"v":0.8181818181818182,"d":"81.8%"},{"v":-0.050720620842572006,"d":"-5.07%"},{"v":0.21581948669394113,"d":"0.216"}]
["2010-01-21",{"v":193.2607474298209,"d":"193"},0.8593127857248194,{"v":-0.000967873213557624,"d":"-0.10%"},{"v":0.9705080027349133,"d":"0.971"},null,null,"2010-01-20",188,{"v":0.8995215311004785,"d":"90.0%"},70,{"v":0.8974358974358975,"d":"89.7%"},{"v":-0.0020856336645810325,"d":"-0.21%"},{"v":0.9605820280162785,"d":"0.961"}]
["2010-01-22",{"v":10258.080764937065,"d":"10258"},0.8592095451155853,{"v":-0.00010324060923405654,"d":"-0.01%"},{"v":0.9967380703927229,"d":"0.997"},null,null,"2010-01-21",1557,{"v":0.7478386167146974,"d":"74.8%"},511,{"v":0.7217514124293786,"d":"72.2%"},{"v":-0.026087204285318855,"d":"-2.61%"},{"v":0.24256862851484584,"d":"0.243"}]
["2010-01-23",{"v":85.35250096534625,"d":"85"},0.8401769911504425,{"v":-0.019032553965142807,"d":"-1.90%"},{"v":0.6148019089291141,"d":"0.615"},null,null,"2010-01-22",1175,{"v":0.8165392633773454,"d":"81.7%"},400,{"v":0.7504690431519699,"d":"75.0%"},{"v":-0.06607022022537545,"d":"-6.61%"},{"v":0.004343680888433843,"d":"0.004"}]
["2010-01-24",{"v":374.0981377400181,"d":"374"},0.8377563329312424,{"v":-0.0024206582192001225,"d":"-0.24%"},{"v":0.9563000302219531,"d":"0.956"},null,null,"2010-01-23",2336,{"v":0.8269026548672567,"d":"82.7%"},764,{"v":0.7647647647647647,"d":"76.5%"},{"v":-0.06213789010249193,"d":"-6.21%"},{"v":0.0001374343271995926,"d":"0.000"}]
["2010-01-25",{"v":6638.396429883871,"d":"6638"},0.8689142391525769,{"v":0.03115790622133452,"d":"3.12%"},{"v":0.08396964962206788,"d":"0.084"},null,null,"2010-01-24",38,{"v":0.9047619047619048,"d":"90.5%"},15,{"v":1,"d":"100.0%"},{"v":0.09523809523809523,"d":"9.52%"},{"v":0.21562248161462372,"d":"0.216"}]
["2010-01-26",{"v":6463.012771606172,"d":"6463"},0.8655326768128917,{"v":-0.003381562339685229,"d":"-0.34%"},{"v":0.5684659711374267,"d":"0.568"},null,null,"2010-01-25",524,{"v":0.7380281690140845,"d":"73.8%"},168,{"v":0.717948717948718,"d":"71.8%"},{"v":-0.02007945106536657,"d":"-2.01%"},{"v":0.6086338119039505,"d":"0.609"}]
["2010-01-27",{"v":943.2944919581563,"d":"943"},0.8492006680983059,{"v":-0.016332008714585844,"d":"-1.63%"},{"v":0.17236544177241298,"d":"0.172"},null,null,"2010-01-26",558,{"v":0.6642857142857143,"d":"66.4%"},169,{"v":0.6079136690647482,"d":"60.8%"},{"v":-0.05637204522096606,"d":"-5.64%"},{"v":0.1779416600978716,"d":"0.178"}]
["2010-01-28",{"v":1559.4026731352037,"d":"1559"},0.8555012927319736,{"v":0.006300624633667762,"d":"0.63%"},{"v":0.6660882218320148,"d":"0.666"},null,null,"2010-01-27",421,{"v":0.5249376558603491,"d":"52.5%"},141,{"v":0.41964285714285715,"d":"42.0%"},{"v":-0.10529479871749198,"d":"-10.53%"},{"v":0.030439879081410215,"d":"0.030"}]
["2010-01-29",{"v":3180.490693234601,"d":"3180"},0.836417157275021,{"v":-0.019084135456952644,"d":"-1.91%"},{"v":0.08997248524822599,"d":"0.090"},null,null,"2010-01-28",1086,{"v":0.9187817258883249,"d":"91.9%"},411,{"v":0.8838709677419355,"d":"88.4%"},{"v":-0.03491075814638933,"d":"-3.49%"},{"v":0.03590529770486417,"d":"0.036"}]
["2010-01-30",{"v":1404.9788704094642,"d":"1405"},0.8358800226372383,{"v":-0.0005371346377827102,"d":"-0.05%"},{"v":0.9638582889165768,"d":"0.964"},null,null,"2010-01-29",729,{"v":0.81,"d":"81.0%"},206,{"v":0.762962962962963,"d":"76.3%"},{"v":-0.0470370370370371,"d":"-4.70%"},{"v":0.1364138597462068,"d":"0.136"}]
["2010-01-31",{"v":1164.8222843028514,"d":"1165"},0.8211284513805522,{"v":-0.014751571256686025,"d":"-1.48%"},{"v":0.3225775171111429,"d":"0.323"},null,null,"2010-01-30",798,{"v":0.8408851422550052,"d":"84.1%"},266,{"v":0.806060606060606,"d":"80.6%"},{"v":-0.03482453619439918,"d":"-3.48%"},{"v":0.18810348172109093,"d":"0.188"}]