{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["calc","noncentralt"],"not_rendered":{"charts":1,"images":1,"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":"calc","index":0,"n_rows":439,"n_cols":9,"rows_kept":439,"cut":false,"hidden":false,"merged":[]}
["Standard Deviation on One Obs.",2,null,null,null,null,"2017-02-11","*"]
["Degrees of Freedom",8,null,null,null,null,"(M. Casquilho) Jesper FRICKMANN","*"]
["Replicates, A ------ rA =",5,null,null,"Standard Deviation on A - B",{"$f":"SQRT(1/B3+1/B4)*B1","v":1.2649110640673518},null,"*"]
["Replicates, B ------ rB =",5,null,null,"Critical t-value",{"$f":"TINV(5%,B2)","v":2.3060041352041671},null,"*"]
["True Difference Between A and B",4,null,null,"Probability of significant t-test",{"$f":"nctdist(-$F$4,$B$2,B5/$F$3)+1-nctdist($F$4,$B$2,B5/$F$3)","v":0.79054254829299386},null,"*"]
[null,null,"tnc = crit_t_val =",{"$f":"$F$4","v":2.3060041352041671},"Prob = nctdist(-tnc) + 1 - nctdist(tnc)"]
[null,null,"idf =",{"$f":"$B$2","v":8},null,"nctdist(-tnc) =",{"$f":"nctdist(-$D$6,$D$7,$D$8)","v":7.9769084915248811E-7},"*"]
["N =",30,"delta =",{"$f":"$B$5/$F$3","v":3.1622776601683791},null,"nctdist(+tnc) =",{"$f":"nctdist($D$6,$D$7,$D$8)","v":0.20945824939785532}]
["True Difference","d = TD / sAB","Probability",null,null,"Prob =",{"$f":"$G$7+1-$G$8","v":0.79054254829299386},"*"]
[0,{"$f":"$A10/$F$3","v":0},{"$f":"nctdist(-$F$4,$B$2,$B10)+1-nctdist($F$4,$B$2,$B10)","v":4.9999999999999822E-2},null,null,null,null,"*"]
[{"$f":"A10+2*$B$5/$B$8","v":0.26666666666666666},{"$f":"$A11/$F$3","v":0.21081851067789195},5.4009066338785217E-2,null,null,null,null,"*"]
[0.53333333333333333,0.4216370213557839,6.6133029026781309E-2,null,null,null,null,"*"]
[0.8,0.63245553203367588,8.6630317941656432E-2,null,null,null,null,"*"]
[1.0666666666666667,0.84327404271156781,0.11580930483277962,null,null,null,null,"*"]
[1.3333333333333333,1.0540925533894596,0.15387160608273542,null,null,null,null,"*"]
[1.5999999999999999,1.2649110640673515,0.20074023715134848,null,null,null,null,"*"]
[1.8666666666666665,1.4757295747452435,0.25590443081055947,null,null,null,null,"*"]
[2.1333333333333333,1.6865480854231356,0.31832953615914161,null,null,null,null,"*"]
[2.4,1.8973665961010275,0.38643735730678597,null,null,null,null,"*"]
[2.6666666666666665,2.1081851067789192,0.45818397167799552,null,null,null,null,"*"]
[2.9333333333333331,2.3190036174568114,0.53121524748771964,null,null,null,null,"*"]
[3.1999999999999997,2.5298221281347031,0.60308447471085702,null,null,null,null,"*"]
[3.4666666666666663,2.7406406388125952,0.67148314793445829,null,null,null,null,"*"]
[3.7333333333333329,2.9514591494904869,0.73445202410923394,null,null,null,null,"*"]
[3.9999999999999996,3.1622776601683791,0.79054254829299386,null,null,null,null,"*"]
[4.2666666666666666,3.3730961708462712,0.83889581088715093,null,null,null,null,"*"]
[4.5333333333333332,3.5839146815241629,0.87924225869914674,null,null,null,null,"*"]
[4.8,3.7947331922020551,0.91183540837401011,null,null,null,null,"*"]
[5.0666666666666664,4.0055517028799468,0.9373310232876757,null,null,null,null,"*"]
[5.333333333333333,4.2163702135578385,0.95664537204529865,null,null,null,null,"*"]
[5.6,4.4271887242357311,0.97081891988867741,null,null,null,null,"*"]
[5.8666666666666663,4.6380072349136228,0.9808948292141968,null,null,null,null,"*"]
[6.1333333333333329,4.8488257455915145,0.9878360550172065,null,null,null,null,"*"]
[6.3999999999999995,5.0596442562694062,0.99246952010689249,null,null,null,null,"*"]
[6.6666666666666661,5.2704627669472979,0.99546794168027297,null,null,null,null,"*"]
[6.9333333333333327,5.4812812776251905,0.99734845733207589,null,null,null,null,"*"]
[7.1999999999999993,5.6920997883030822,0.9984923081768291,null,null,null,null,"*"]
[7.4666666666666659,5.9029182989809739,0.99916689256921676,null,null,null,null,"*"]
[7.7333333333333325,6.1137368096588656,0.99955246025136091,null,null,null,null,"*"]
[null,null,null,null,null,null,null,"*"]
[{"$f":"A39+2*$B$5/30","v":7.9999999999999991},{"$f":"nctdist(-$F$4,$B$2,A41/$F$3)+1-nctdist($F$4,$B$2,A41/$F$3)","v":0.99976647329934243}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"\f"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"\f"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"\f"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"\f"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"\f"]

{"sheet":"noncentralt","index":1,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["2017-02-13",null,"Table of noncentral t distribution"]
[null,null,null,null,-21,-1]
["n =",5,null,"tmin, tmax =",-13,-3,"Pmin, Pmax =",0.02,0.98]
["idf =",{"$f":"$B3-1","v":4},null,"k =",10]
[null,null,-18.73,-17.62,-16.600000000000001,-15.58,-14.2,-12.86,"Max(Min)"]
[null,null,{"$f":"nctdist(C5,$B$4,C$12)","v":2.0015616602998443E-2},{"$f":"nctdist(D5,$B$4,D$12)","v":2.0019359085813315E-2},{"$f":"nctdist(E5,$B$4,E$12)","v":1.9961815883835277E-2},{"$f":"nctdist(F5,$B$4,F$12)","v":1.995627244762832E-2},{"$f":"nctdist(G5,$B$4,G$12)","v":2.0038935658994839E-2},{"$f":"nctdist(H5,$B$4,H$12)","v":2.0017519006117035E-2}]
[null,null,-3.04,-2.79,-2.552,-2.31,-1.9770000000000001,-1.6319999999999999,"Min(Max)"]
[null,null,{"$f":"nctdist(C7,$B$4,C$12)","v":0.97997630192752905},{"$f":"nctdist(D7,$B$4,D$12)","v":0.97996704676798729},{"$f":"nctdist(E7,$B$4,E$12)","v":0.97996880234122541},{"$f":"nctdist(F7,$B$4,F$12)","v":0.98003096086717179},{"$f":"nctdist(G7,$B$4,G$12)","v":0.98004134255584363},{"$f":"nctdist(H7,$B$4,H$12)","v":0.98004548668008618}]
[]
[null,"min",{"$f":"MIN(C15:C25)","v":7.2790030496877378E-2},{"$f":"MIN(D15:D25)","v":5.9057491723911615E-2},4.7866389698392298E-2,3.826940276126245E-2,2.7584634142916342E-2,1.9243732264522584E-2]
[null,"max",{"$f":"MAX(C15:C25)","v":0.9817778578222679},{"$f":"MAX(D15:D25)","v":0.96789929584817558},0.94774577887738365,0.91860618002278427,0.86135115913554838,0.78059994937552024]
[null,"d =",{"$f":"SQRT($B$3)*NORMSINV(C$13)","v":-5.9302083715441185},{"$f":"SQRT($B$3)*NORMSINV(D$13)","v":-5.5538769801347989},{"$f":"SQRT($B$3)*NORMSINV(E$13)","v":-5.2018719856674389},{"$f":"SQRT($B$3)*NORMSINV(F$13)","v":-4.8524696015972628},{"$f":"SQRT($B$3)*NORMSINV(G$13)","v":-4.3826127028829074},{"$f":"SQRT($B$3)*NORMSINV(H$13)","v":-3.9146530625818916}]
[null,"AQL:",4.0000000000000001E-3,6.4999999999999997E-3,0.01,1.4999999999999999E-2,2.5000000000000001E-2,0.04]
["i","t",null,"Probability --- T_nc(t; idf, delta)"]
[0,{"$f":"$E$3+$A15*($F$3-$E$3)/$E$4","v":-13},{"$f":"nctdist($B15,$B$4,C$12)","v":7.2790030496877378E-2},{"$f":"nctdist($B15,$B$4,D$12)","v":5.9057491723911615E-2},{"$f":"nctdist($B15,$B$4,E$12)","v":4.7866389698392298E-2},{"$f":"nctdist($B15,$B$4,F$12)","v":3.826940276126245E-2},{"$f":"nctdist($B15,$B$4,G$12)","v":2.7584634142916342E-2},{"$f":"nctdist($B15,$B$4,H$12)","v":1.9243732264522584E-2},"MIN",{"$f":"MIN(C15:H25)","v":1.9243732264522584E-2}]
[{"$f":"$A15+1","v":1},{"$f":"$E$3+$A16*($F$3-$E$3)/$E$4","v":-12},{"$f":"nctdist($B16,$B$4,C$12)","v":9.4858777942228412E-2},{"$f":"nctdist($B16,$B$4,D$12)","v":7.7366626899821211E-2},{"$f":"nctdist($B16,$B$4,E$12)","v":6.2997676781911593E-2},{"$f":"nctdist($B16,$B$4,F$12)","v":5.0586764435314624E-2},{"$f":"nctdist($B16,$B$4,G$12)","v":3.6662335735061058E-2},{"$f":"nctdist($B16,$B$4,H$12)","v":2.5703908589280067E-2},"MAX",{"$f":"MAX(C15:H25)","v":0.9817778578222679}]
[{"$f":"$A16+1","v":2},-11,{"$f":"nctdist($B17,$B$4,C$12)","v":0.1252556576695788},{"$f":"nctdist($B17,$B$4,D$12)","v":0.10283062924667397},{"$f":"nctdist($B17,$B$4,E$12)","v":8.4221819623928718E-2},{"$f":"nctdist($B17,$B$4,F$12)","v":6.8001289777163576E-2},{"$f":"nctdist($B17,$B$4,G$12)","v":4.9623347503500059E-2},{"$f":"nctdist($B17,$B$4,H$12)","v":3.5009778794139357E-2}]
[3,-10,{"$f":"nctdist($B18,$B$4,C$12)","v":0.16754277618697455},{"$f":"nctdist($B18,$B$4,D$12)","v":0.13869987148112251},{"$f":"nctdist($B18,$B$4,E$12)","v":0.11444803155543359},{"$f":"nctdist($B18,$B$4,F$12)","v":9.3056298550372674E-2},{"$f":"nctdist($B18,$B$4,G$12)","v":6.8508485880376613E-2},{"$f":"nctdist($B18,$B$4,H$12)","v":4.872482870940642E-2}]
[4,-9,{"$f":"nctdist($B19,$B$4,C$12)","v":0.22671400101147676},{"$f":"nctdist($B19,$B$4,D$12)","v":0.1897211989862635},{"$f":"nctdist($B19,$B$4,E$12)","v":0.15806701365292419},{"$f":"nctdist($B19,$B$4,F$12)","v":0.12970152145531655},{"$f":"nctdist($B19,$B$4,G$12)","v":9.6594049464872822E-2},{"$f":"nctdist($B19,$B$4,H$12)","v":6.9430649562293723E-2}]
[5,-8,{"$f":"nctdist($B20,$B$4,C$12)","v":0.30930032247465933},{"$f":"nctdist($B20,$B$4,D$12)","v":0.2625276455308605},{"$f":"nctdist($B20,$B$4,E$12)","v":0.22153440781751355},{"$f":"nctdist($B20,$B$4,F$12)","v":0.18399788696931352},{"$f":"nctdist($B20,$B$4,G$12)","v":0.13915556434923382},{"$f":"nctdist($B20,$B$4,H$12)","v":0.10145335899356289}]
[6,-7,{"$f":"nctdist($B21,$B$4,C$12)","v":0.42240759050426224},{"$f":"nctdist($B21,$B$4,D$12)","v":0.36536069109252411},{"$f":"nctdist($B21,$B$4,E$12)","v":0.31363905166449269},{"$f":"nctdist($B21,$B$4,F$12)","v":0.26480856175473944},{"$f":"nctdist($B21,$B$4,G$12)","v":0.20452184929157491},{"$f":"nctdist($B21,$B$4,H$12)","v":0.15204906187642897}]
[7,-6,{"$f":"nctdist($B22,$B$4,C$12)","v":0.56962734662779591},{"$f":"nctdist($B22,$B$4,D$12)","v":0.50527842035800519},{"$f":"nctdist($B22,$B$4,E$12)","v":0.44395118156402569},{"$f":"nctdist($B22,$B$4,F$12)","v":0.38338459050412976},{"$f":"nctdist($B22,$B$4,G$12)","v":0.30488563641578281},{"$f":"nctdist($B22,$B$4,H$12)","v":0.23298527674663971}]
[8,-5,{"$f":"nctdist($B23,$B$4,C$12)","v":0.7405129313715032},{"$f":"nctdist($B23,$B$4,D$12)","v":0.67883655439248158},{"$f":"nctdist($B23,$B$4,E$12)","v":0.61534599265346035},{"$f":"nctdist($B23,$B$4,F$12)","v":0.54812164567369048},{"$f":"nctdist($B23,$B$4,G$12)","v":0.45417320947754747},{"$f":"nctdist($B23,$B$4,H$12)","v":0.36106297758908845}]
[9,-4,{"$f":"nctdist($B24,$B$4,C$12)","v":0.89605654162377402},{"$f":"nctdist($B24,$B$4,D$12)","v":0.85401115771909619},{"$f":"nctdist($B24,$B$4,E$12)","v":0.80491805667113359},{"$f":"nctdist($B24,$B$4,F$12)","v":0.74666673570998099},{"$f":"nctdist($B24,$B$4,G$12)","v":0.65451922012413821},{"$f":"nctdist($B24,$B$4,H$12)","v":0.55062181186473946}]
[10,-3,{"$f":"nctdist($B25,$B$4,C$12)","v":0.9817778578222679},{"$f":"nctdist($B25,$B$4,D$12)","v":0.96789929584817558},{"$f":"nctdist($B25,$B$4,E$12)","v":0.94774577887738365},{"$f":"nctdist($B25,$B$4,F$12)","v":0.91860618002278427},{"$f":"nctdist($B25,$B$4,G$12)","v":0.86135115913554838},{"$f":"nctdist($B25,$B$4,H$12)","v":0.78059994937552024}]