{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Original Data","Logistic","Logistic Math"],"not_rendered":{"charts":4,"images":4,"macros":1,"external_links":0,"defined_names":30,"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":"Original Data","index":0,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[22,1,22,6]]}
["ID","Education","Age-Years","Age","Income-K","Income","Gender","Purchased"]
[1,"College",21,"Young",30,"Low","Male","No"]
[2,"HighSchool",23,"Young",35,"Low","Male","No"]
[3,"College",25,"Young",40,"Low","Female","No"]
[4,"HighSchool",29,"Young",51,"High","Male","No"]
[5,"HighSchool",29,"Young",50,"High","Male","No"]
[6,"College",43,"Old",55,"High","Female","No"]
[7,"College",50,"Old",45,"Low","Male","No"]
[8,"College",40,"Old",49,"Low","Female","No"]
[9,"College",45,"Old",55,"High","Male","No"]
[10,"College",45,"Old",60,"High","Male","No"]
[11,"College",39,"Young",40,"High","Female","Yes"]
[12,"HighSchool",25,"Young",49,"Low","Male","Yes"]
[13,"College",40,"Old",45,"High","Male","Yes"]
[14,"College",39,"Young",90,"High","Female","Yes"]
[15,"College",39,"Young",40,"Low","Female","Yes"]
[16,"HighSchool",58,"Old",100,"High","Female","Yes"]
[17,"College",50,"Old",60,"High","Male","Yes"]
[18,"College",63,"Old",110,"High","Female","Yes"]
[19,"HighSchool",64,"Old",90,"High","Male","Yes"]
[20,"HighSchool",45,"Old",100,"High","Female","Yes"]
[]
[null,"Test Observations to Demo that each model works"]
[null,"Education","Age-Years","Age","Income","College","Gender"]
[null,"College",45,"Old",40,1,1]
[null,"HighSchool",45,"Old",70,0,0]

{"sheet":"Logistic","index":1,"n_rows":109,"n_cols":20,"rows_kept":109,"cut":false,"hidden":false,"merged":[[8,0,8,5],[8,7,8,12],[0,15,0,19],[8,14,8,18],[1,3,5,4]]}
["Coefficients",null,null,"Constant constraint",null,0,null,null,null,null,null,null,null,null,null,"Diagnostics"]
["Constant",0,null,"Original coefficient values to allow model to run. At the start the macro button will reset the coefficients.",null,0,null,null,null,null,null,null,null,null,null,"Concordant",{"$f":"COUNTIF(T10:T109, P2)","v":62},null,"Concordant %",{"$f":"Q2/(Q2+Q3+Q4)","v":0.80519480519480524}]
["Age",2.8797666274903103E-2,null,null,null,0,null,null,null,null,null,null,null,null,null,"Discordant",{"$f":"COUNTIF(T10:T109, P3)","v":15},null,"Discordant %",{"$f":"Q3/(Q2+Q3+Q4)","v":0.19480519480519481}]
["Gender",-1.8644870630932868,null,null,null,0,null,null,null,null,null,null,null,null,null,"Tied",{"$f":"COUNTIF(T10:T109, P4)","v":0},null,"Tied %",{"$f":"Q4/(Q2+Q3+Q4)","v":0}]
["Income",1.9277365241452279E-2,null,null,null,0,null,null,null,null,null,null,null,null,null,"Total Pairs",{"$f":"COUNTA(T10:T109)","v":77},null,"C Statistic",{"$f":"(Q2+0.5*Q4)/(Q2+Q3+Q4)","v":0.80519480519480524}]
["College",-1.5741297227450528,null,null,null,0," ",null," ",null,null,null,null,null,null,null,null,null,"Sommers D",{"$f":"(Q2-Q3)/(Q2+Q3+Q4)","v":0.61038961038961037}]
[null,null,null,null,null,null," "," ",null,null,null,null,null,null,null,null,null,null,"Gamma",{"$f":"(Q2-Q3)/(Q2+Q3)","v":0.61038961038961037}]
[null,"Purchase = 1/No Purchse = 0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tau-a",{"$f":"(Q2-Q3)/Q5","v":0.61038961038961037}]
["Original Data",null,null,null,null,null,null,"Calculation of Logit, Odds and Probability",null,null,null,null,null,"Sigmoid ","The values below are rounded to two decimals to force a \"Tied\" set"]
["Index","Response","Age","Gender","Income","College",null,"Logit","Odds Y","Probability Y = 1","Probability Y = 0","Deviation","Value to Max","Function",1,11,{"$f":"INDEX($J$11:$J$30,P10,1)","v":0.5793422551265961},{"$f":"INDEX($J$11:$J$30,O10,1)","v":9.4872250631025751E-2},{"$f":"IF(ROUND(Q10, 2)>ROUND(R10,2), \"Concordant\", IF(ROUND(Q10,2)=ROUND(R10,2), \"Tied\", \"Discordant\"))","v":"Concordant"}]
[1,0,21,1,30,1,null,{"$f":"$B$2+(C11*$B$3)+(D11*$B$4)+(E11*$B$5)+(F11*$B$6)","v":-2.2555448368218061},{"$f":"EXP(H11)","v":0.10481642033090646},{"$f":"I11/(1+I11)","v":9.4872250631025751E-2},{"$f":"1-J11","v":0.90512774936897422},{"$f":"IFERROR(-2*((B11*LN(J11))+(1-B11)*(LN(K11))),0)","v":0.19935837144110119},{"$f":"ABS((1-J11)^1-B11)","v":0.90512774936897422},{"$f":"1/(1+(2.718281828)^(H11*-1))","v":9.4872250663734364E-2},2,11,{"$f":"INDEX($J$11:$J$30,P11,1)","v":0.5793422551265961},{"$f":"INDEX($J$11:$J$30,O11,1)","v":0.37111580919502923},{"$f":"IF(ROUND(Q11, 2)>ROUND(R11,2), \"Concordant\", IF(ROUND(Q11,2)=ROUND(R11,2), \"Tied\", \"Discordant\"))","v":"Concordant"}]
[2,0,23,1,35,0,null,-0.52743295531968559,0.59011788596562054,{"$f":"I12/(1+I12)","v":0.37111580919502923},{"$f":"1-J12","v":0.62888419080497071},{"$f":"IFERROR(-2*((B12*LN(J12))+(1-B12)*(LN(K12))),0)","v":0.92761631120098353},0.62888419080497071,{"$f":"1/(1+(2.718281828)^(H12*-1))","v":0.37111580921581705},3,11,0.5793422551265961,0.47923858021275917,"Concordant"]
[3,0,25,0,40,1,null,-8.3093456214383909E-2,0.92026513870507931,0.47923858021275917,0.52076141978724078,1.3049265391625626,0.52076141978724078,0.4792385802162612,4,11,0.5793422551265961,0.45961980860505414,"Concordant"]
[4,0,29,1,45,0,null,-0.16187330525574428,0.85054895779688822,0.45961980860505414,0.54038019139494586,1.2309646580353755,0.54038019139494586,0.45961980861184359,5,11,0.5793422551265961,0.48363422850875121,"Concordant"]
[5,0,29,1,50,0,null,-6.5486479048482815E-2,0.93661171055554326,0.48363422850875121,0.51636577149124885,1.3218798102872478,0.51636577149124885,0.483634228511513,6,11,0.5793422551265961,0.67358069034790025,"Discordant"]
[6,0,43,0,55,1,null,0.72442501535565595,2.0635442525315297,0.67358069034790025,0.32641930965209975,2.239144996337386,0.32641930965209975,0.67358069032100221,7,11,0.5793422551265961,0.24393011607356824,"Concordant"]
[7,0,50,1,45,1,null,-1.1312520362278318,0.32262906016939502,0.24393011607356824,0.75606988392643171,0.55924293603740749,0.75606988392643171,0.24393011610880105,8,11,0.5793422551265961,0.63219504787344261,"Discordant"]
[8,0,40,0,50,1,null,0.54164519032368519,1.7188323436599944,0.63219504787344261,0.36780495212655739,2.0004050054388434,0.36780495212655739,0.63219504785217373,9,11,0.5793422551265961,0.25303949760792932,"Concordant"]
[9,0,45,1,55,1,null,-1.0824667151878247,0.33875887252082831,0.25303949760792932,0.74696050239207068,0.58348594044879665,0.74696050239207068,0.2530394976424804,10,11,0.5793422551265961,0.27168706796420194,"Concordant"]
[10,0,45,1,60,1,null,-0.98607988898056331,0.37303617169720665,0.27168706796420194,{"$f":"1-J20","v":0.72831293203579806},0.6340489428954017,0.72831293203579806,0.27168706799715231,1,12,{"$f":"INDEX($J$11:$J$30,P20,1)","v":0.47893988813001859},9.4872250631025751E-2,"Concordant"]
[11,1,39,0,40,1,null,0.32007387163425927,1.3772294987720906,0.5793422551265961,0.4206577448734039,1.0917237236800885,0.5793422551265961,0.5793422551134233,2,12,0.47893988813001859,0.37111580919502923,"Concordant"]
[12,1,25,1,55,0,null,-8.4290317940833859E-2,0.91916436744927243,0.47893988813001859,0.52106011186998136,1.4723603679113448,0.47893988813001864,0.47893988813357091,3,12,0.47893988813001859,0.47923858021275917,"Tied"]
[13,1,40,1,45,1,null,-1.419228698976863,0.2419005230825354,0.19478252773588611,0.80521747226411389,3.2717431702879969,0.19478252773588611,0.19478252777347646,4,12,0.47893988813001859,0.45961980860505414,"Concordant"]
[14,1,39,0,90,1,null,1.2839421337068733,3.6108461436649404,0.78312006758803976,0.21687993241196024,0.4889385034457146,0.78312006758803976,0.78312006755121366,5,12,0.47893988813001859,0.48363422850875121,"Tied"]
[15,1,39,0,40,1,null,0.32007387163425927,1.3772294987720906,0.5793422551265961,0.4206577448734039,1.0917237236800885,0.5793422551265961,0.5793422551134233,6,12,0.47893988813001859,0.67358069034790025,"Discordant"]
[16,1,58,0,100,0,null,3.598001168089608,36.525153787113915,0.97335120848076584,{"$f":"1-J26","v":2.6648791519234161E-2},5.4020615358104922E-2,0.97335120848076584,0.97335120846500534,7,12,0.47893988813001859,0.24393011607356824,"Concordant"]
[17,1,50,1,60,1,null,-0.8420915576060477,0.43080851962547528,0.30109446073066615,0.69890553926933385,2.4006624808798764,0.30109446073066615,0.30109446076059165,8,12,0.47893988813001859,0.63219504787344261,"Discordant"]
[18,1,63,0,110,1,null,2.3606334291335931,10.597662194801703,0.91377572624522385,8.6224273754776148E-2,0.18034022747389022,0.91377572624522385,0.91377572621381442,9,12,0.47893988813001859,0.25303949760792932,"Concordant"]
[19,1,64,1,90,0,null,1.7135264502312169,5.5484935042235755,0.84729312179128968,0.15270687820871032,0.33141714721371279,0.84729312179128968,0.84729312175384885,10,12,0.47893988813001859,0.27168706796420194,"Concordant"]
[20,1,45,0,100,0,null,3.2236315065158676,25.119175196227971,0.96171395181941211,3.8286048180587895E-2,7.8076439827993796E-2,0.96171395181941211,0.96171395179936769,1,13,0.19478252773588611,9.4872250631025751E-2,"Concordant"]
[null,null,null,null," ",null,null,null,null,null,null,null,null,null,2,13,{"$f":"INDEX($J$11:$J$30,P31,1)","v":0.19478252773588611},0.37111580919502923,"Discordant"]
[null,null,null,null," ",null,null,null,null," ",null,{"$f":"SUM(L11:L30)","v":21.462079911043922},{"$f":"SUM(M11:M30)","v":12.649842365754834}," ",3,13,0.19478252773588611,0.47923858021275917,"Discordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,13,0.19478252773588611,0.45961980860505414,"Discordant"]
[null,null,null,"N","Deviance","Parameters","Values",null,null,null,null,null,null,null,null,5,13,0.19478252773588611,0.48363422850875121,"Discordant"]
[null,"AIC Intercept and Covariates",null," ",{"$f":"$L$32","v":21.462079911043922},5,{"$f":"F35*F35+(E35)","v":46.462079911043922}," ",null,null,null,null,null,null,null,6,13,0.19478252773588611,0.67358069034790025,"Discordant"]
[null,"-2 Log L Intercept and Covariates",null," ",{"$f":"$L$32","v":21.462079911043922}," ",{"$f":"L32","v":21.462079911043922}," ",null,null,null,null,null,null,null,7,13,0.19478252773588611,0.24393011607356824,"Discordant"]
[null,"SB Intercept and Covariates",null,20,{"$f":"$L$32","v":21.462079911043922},5,{"$f":"F37*(LN(D37))+E37","v":36.440741278813874}," ",null,null,null,null,null,null,null,8,13,0.19478252773588611,0.63219504787344261,"Discordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,13,0.19478252773588611,0.25303949760792932,"Discordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,13,0.19478252773588611,0.27168706796420194,"Discordant"]
[null,null,null,null,null," ",null,null,null,"Prediction",null,null,null,null,null,1,14,0.78312006758803976,9.4872250631025751E-2,"Concordant"]
[null,null,"Age","Gender","Income","College",null,"Logit","Odds Y","Probability Y = 1"," ",null,null,null,null,2,14,{"$f":"INDEX($J$11:$J$30,Q41,1)","v":0.78312006758803976},0.37111580919502923,"Concordant"]
[null,"Observation 1",45,1,40,1,null,{"$f":"$B$2+(C42*$B$3)+(D42*$B$4)+(E42*$B$5)+(F42*$B$6)","v":-1.371627193809609},{"$f":"EXP(H42)","v":0.25369381450592787},{"$f":"I42/(1+I42)","v":0.20235707600256997}," "," ",null,null," ",3,14,0.78312006758803976,0.47923858021275917,"Concordant"]
[null,"Observation 2",45,0,70,0,null,{"$f":"$B$2+(C43*$B$3)+(D43*$B$4)+(E43*$B$5)+(F43*$B$6)","v":2.645310549272299},{"$f":"EXP(H43)","v":14.087819365926455},{"$f":"I43/(1+I43)","v":0.93372136981846776}," "," ",null,null," ",4,14,0.78312006758803976,0.45961980860505414,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,14,0.78312006758803976,0.48363422850875121,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,14,0.78312006758803976,0.67358069034790025,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,14,0.78312006758803976,0.24393011607356824,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,14,0.78312006758803976,0.63219504787344261,"Concordant"]
[1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,9,14,0.78312006758803976,0.25303949760792932,"Concordant"]
[2,5.0000000000000001E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,10,14,0.78312006758803976,0.27168706796420194,"Concordant"]
[3,0.01,null,null,null,null,null,null,null,null,null,null,null,null,null,1,15,0.5793422551265961,9.4872250631025751E-2,"Concordant"]
[4,0.02,null,null,null,null,null,null,null,null,null,null,null,null,null,2,15,{"$f":"INDEX($J$11:$J$30,Q51,1)","v":0.5793422551265961},0.37111580919502923,"Concordant"]
[5,0.04,null,null,null,null,null,null,null,null,null,null,null,null,null,3,15,0.5793422551265961,0.47923858021275917,"Concordant"]
[6,7.0000000000000007E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,4,15,0.5793422551265961,0.45961980860505414,"Concordant"]
[7,0.11,null,null,null,null,null,null,null,null,null,null,null,null,null,5,15,0.5793422551265961,0.48363422850875121,"Concordant"]
[8,0.16,null,null,null,null,null,null,null,null,null,null,null,null,null,6,15,0.5793422551265961,0.67358069034790025,"Discordant"]
[9,0.22,null,null,null,null,null,null,null,null,null,null,null,null,null,7,15,0.5793422551265961,0.24393011607356824,"Concordant"]
[10,0.28999999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,8,15,0.5793422551265961,0.63219504787344261,"Discordant"]
[11,0.37,null,null,null,null,null,null,null,null,null,null,null,null,null,9,15,0.5793422551265961,0.25303949760792932,"Concordant"]
[12,0.44,null,null,null,null,null,null,null,null,null,null,null,null,null,10,15,0.5793422551265961,0.27168706796420194,"Concordant"]
[13,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,1,16,0.97335120848076584,9.4872250631025751E-2,"Concordant"]
[14,0.56000000000000005,null,null,null,null,null,null,null,null,null,null,null,null,null,2,16,{"$f":"INDEX($J$11:$J$30,Q61,1)","v":0.97335120848076584},0.37111580919502923,"Concordant"]
[15,0.63,null,null,null,null,null,null,null,null,null,null,null,null,null,3,16,0.97335120848076584,0.47923858021275917,"Concordant"]
[16,0.71,null,null,null,null,null,null,null,null,null,null,null,null,null,4,16,0.97335120848076584,0.45961980860505414,"Concordant"]
[17,0.78,null,null,null,null,null,null,null,null,null,null,null,null,null,5,16,0.97335120848076584,0.48363422850875121,"Concordant"]
[18,0.84,null,null,null,null,null,null,null,null,null,null,null,null,null,6,16,0.97335120848076584,0.67358069034790025,"Concordant"]
[19,0.89,null,null,null,null,null,null,null,null,null,null,null,null,null,7,16,0.97335120848076584,0.24393011607356824,"Concordant"]
[20,0.93,null,null,null,null,null,null,null,null,null,null,null,null,null,8,16,0.97335120848076584,0.63219504787344261,"Concordant"]
[21,0.96,null,null,null,null,null,null,null,null,null,null,null,null,null,9,16,0.97335120848076584,0.25303949760792932,"Concordant"]
[22,0.98,null,null,null,null,null,null,null,null,null,null,null,null,null,10,16,0.97335120848076584,0.27168706796420194,"Concordant"]
[23,0.99,null,null,null,null,null,null,null,null,null,null,null,null,null,1,17,0.30109446073066615,9.4872250631025751E-2,"Concordant"]
[24,0.995,null,null,null,null,null,null,null,null,null,null,null,null,null,2,17,{"$f":"INDEX($J$11:$J$30,Q71,1)","v":0.30109446073066615},0.37111580919502923,"Discordant"]
[25,1,null,null,null,null,null,null,null,null,null,null,null,null,null,3,17,0.30109446073066615,0.47923858021275917,"Discordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,17,0.30109446073066615,0.45961980860505414,"Discordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,17,{"$f":"INDEX($J$11:$J$30,Q74,1)","v":0.30109446073066615},0.48363422850875121,"Discordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,17,0.30109446073066615,{"$f":"INDEX($J$11:$J$30,P75,1)","v":0.67358069034790025},{"$f":"IF(ROUND(R75, 2)>ROUND(S75,2), \"Concordant\", IF(ROUND(R75,2)=ROUND(S75,2), \"Tied\", \"Discordant\"))","v":"Discordant"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,17,0.30109446073066615,0.24393011607356824,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,17,0.30109446073066615,0.63219504787344261,"Discordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,17,0.30109446073066615,0.25303949760792932,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,17,0.30109446073066615,0.27168706796420194,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,18,0.91377572624522385,9.4872250631025751E-2,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,18,{"$f":"INDEX($J$11:$J$30,Q81,1)","v":0.91377572624522385},0.37111580919502923,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,18,0.91377572624522385,0.47923858021275917,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,18,0.91377572624522385,0.45961980860505414,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,18,0.91377572624522385,0.48363422850875121,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,18,0.91377572624522385,0.67358069034790025,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,18,0.91377572624522385,0.24393011607356824,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,18,0.91377572624522385,0.63219504787344261,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,18,0.91377572624522385,0.25303949760792932,"Concordant"]
["This model was adapted from a video at this site:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,18,0.91377572624522385,0.27168706796420194,"Concordant"]
["http://www.excelmasterseries.com/Excel_Statistical_Master/Excel-Logistic-Regression.php",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,19,0.84729312179128968,9.4872250631025751E-2,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,19,{"$f":"INDEX($J$11:$J$30,Q91,1)","v":0.84729312179128968},0.37111580919502923,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,19,0.84729312179128968,0.47923858021275917,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,19,0.84729312179128968,0.45961980860505414,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,19,0.84729312179128968,0.48363422850875121,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,19,0.84729312179128968,0.67358069034790025,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,19,0.84729312179128968,0.24393011607356824,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,19,0.84729312179128968,0.63219504787344261,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,19,0.84729312179128968,0.25303949760792932,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,19,0.84729312179128968,0.27168706796420194,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,20,0.96171395181941211,9.4872250631025751E-2,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,20,{"$f":"INDEX($J$11:$J$30,Q101,1)","v":0.96171395181941211},0.37111580919502923,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,20,0.96171395181941211,0.47923858021275917,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,20,0.96171395181941211,0.45961980860505414,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,20,0.96171395181941211,0.48363422850875121,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,20,0.96171395181941211,0.67358069034790025,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,20,0.96171395181941211,0.24393011607356824,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,20,0.96171395181941211,0.63219504787344261,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,20,0.96171395181941211,0.25303949760792932,"Concordant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,20,0.96171395181941211,0.27168706796420194,"Concordant"]

{"sheet":"Logistic Math","index":2,"n_rows":52,"n_cols":4,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Observation","Logit","Odds","Probability"]
[1,{"$f":"INDEX(Logistic!$H$11:$H$30,A2,1)","v":-2.2555448368218061},{"$f":"EXP(B2)","v":0.10481642033090646},{"$f":"C2/(1+C2)","v":9.4872250631025751E-2}]
[13,{"$f":"INDEX(Logistic!$H$11:$H$30,A3,1)","v":-1.419228698976863},{"$f":"EXP(B3)","v":0.2419005230825354},{"$f":"C3/(1+C3)","v":0.19478252773588611}]
[7,{"$f":"INDEX(Logistic!$H$11:$H$30,A4,1)","v":-1.1312520362278318},{"$f":"EXP(B4)","v":0.32262906016939502},{"$f":"C4/(1+C4)","v":0.24393011607356824}]
[9,{"$f":"INDEX(Logistic!$H$11:$H$30,A5,1)","v":-1.0824667151878247},{"$f":"EXP(B5)","v":0.33875887252082831},{"$f":"C5/(1+C5)","v":0.25303949760792932}]
[10,{"$f":"INDEX(Logistic!$H$11:$H$30,A6,1)","v":-0.98607988898056331},{"$f":"EXP(B6)","v":0.37303617169720665},{"$f":"C6/(1+C6)","v":0.27168706796420194}]
[17,{"$f":"INDEX(Logistic!$H$11:$H$30,A7,1)","v":-0.8420915576060477},{"$f":"EXP(B7)","v":0.43080851962547528},{"$f":"C7/(1+C7)","v":0.30109446073066615}]
[2,{"$f":"INDEX(Logistic!$H$11:$H$30,A8,1)","v":-0.52743295531968559},{"$f":"EXP(B8)","v":0.59011788596562054},{"$f":"C8/(1+C8)","v":0.37111580919502923}]
[4,{"$f":"INDEX(Logistic!$H$11:$H$30,A9,1)","v":-0.16187330525574428},{"$f":"EXP(B9)","v":0.85054895779688822},{"$f":"C9/(1+C9)","v":0.45961980860505414}]
[12,{"$f":"INDEX(Logistic!$H$11:$H$30,A10,1)","v":-8.4290317940833859E-2},{"$f":"EXP(B10)","v":0.91916436744927243},{"$f":"C10/(1+C10)","v":0.47893988813001859}]
[3,{"$f":"INDEX(Logistic!$H$11:$H$30,A11,1)","v":-8.3093456214383909E-2},{"$f":"EXP(B11)","v":0.92026513870507931},{"$f":"C11/(1+C11)","v":0.47923858021275917}]
[5,{"$f":"INDEX(Logistic!$H$11:$H$30,A12,1)","v":-6.5486479048482815E-2},{"$f":"EXP(B12)","v":0.93661171055554326},{"$f":"C12/(1+C12)","v":0.48363422850875121}]
[11,{"$f":"INDEX(Logistic!$H$11:$H$30,A13,1)","v":0.32007387163425927},{"$f":"EXP(B13)","v":1.3772294987720906},{"$f":"C13/(1+C13)","v":0.5793422551265961}]
[15,{"$f":"INDEX(Logistic!$H$11:$H$30,A14,1)","v":0.32007387163425927},{"$f":"EXP(B14)","v":1.3772294987720906},{"$f":"C14/(1+C14)","v":0.5793422551265961}]
[8,{"$f":"INDEX(Logistic!$H$11:$H$30,A15,1)","v":0.54164519032368519},{"$f":"EXP(B15)","v":1.7188323436599944},{"$f":"C15/(1+C15)","v":0.63219504787344261}]
[6,{"$f":"INDEX(Logistic!$H$11:$H$30,A16,1)","v":0.72442501535565595},{"$f":"EXP(B16)","v":2.0635442525315297},{"$f":"C16/(1+C16)","v":0.67358069034790025}]
[14,{"$f":"INDEX(Logistic!$H$11:$H$30,A17,1)","v":1.2839421337068733},{"$f":"EXP(B17)","v":3.6108461436649404},{"$f":"C17/(1+C17)","v":0.78312006758803976}]
[19,{"$f":"INDEX(Logistic!$H$11:$H$30,A18,1)","v":1.7135264502312169},{"$f":"EXP(B18)","v":5.5484935042235755},{"$f":"C18/(1+C18)","v":0.84729312179128968}]
[18,{"$f":"INDEX(Logistic!$H$11:$H$30,A19,1)","v":2.3606334291335931},{"$f":"EXP(B19)","v":10.597662194801703},{"$f":"C19/(1+C19)","v":0.91377572624522385}]
[20,{"$f":"INDEX(Logistic!$H$11:$H$30,A20,1)","v":3.2236315065158676},{"$f":"EXP(B20)","v":25.119175196227971},{"$f":"C20/(1+C20)","v":0.96171395181941211}]
[16,{"$f":"INDEX(Logistic!$H$11:$H$30,A21,1)","v":3.598001168089608},{"$f":"EXP(B21)","v":36.525153787113915},{"$f":"C21/(1+C21)","v":0.97335120848076584}]
[]
[]
[]
[]
[]
[]
[]
["Sigmoid Fundion"]
[]
[]
["X","Sigmoid"]
[-6,{"$f":"1/(1+(2.718281828)^(A33*-1))","v":2.4726231591339401E-3}]
[-5,{"$f":"1/(1+(2.718281828)^(A34*-1))","v":6.6928509298982532E-3}]
[-4,1.7986209974022598E-2]
[-3,4.7425873200454181E-2]
[-2.5,7.5858180050840163E-2]
[-2,0.11920292205757881]
[-1.5,0.18242552384413663]
[-1,0.26894142140319766]
[-0.5,0.37754066881798837]
[0,0.5]
[0.5,0.62245933118201158]
[1,0.73105857859680234]
[1.5,0.81757447615586343]
[2,0.88079707794242112]
[2.5,0.92414181994915989]
[3,0.95257412679954589]
[4,0.98201379002597733]
[5,0.99330714907010165]
[6,0.99752737684086601]
[6,0.99752737684086601]