{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Taguchi designs","Taguchi analysis"],"not_rendered":{"charts":3,"images":5,"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":"Data","index":0,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Temperature","Time","Catalysis"]
[null,18,50,94]
[null,24,70,102]

{"sheet":"Taguchi designs","index":1,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2019.3.2.12345 - Taguchi designs - Start time: 31/10/2019 at 11:12:01 / End time: 31/10/2019 at 11:12:03 / Microsoft Excel 16.012026"]
[null,"Factors/Categories table: Workbook = Demo_Taguchi.xls / Sheet = Data / Range = 'Data'!$B$1:$D$3 / 2 rows and 3 columns"]
[null,"Number of factors with 2 levels: 3"]
[null,"Number of experiences: 8"]
[null,"Number of respondents: 2"]
[null,":"]
[]
[]
[]
[null,"Variable information:"]
[]
[null,"Short name","Nbr. of categories","Category 1","Category 2"]
[null,"Temperature",2,"18","24"]
[null,"Time",2,"50","70"]
[null,"Catalysis",2,"94","102"]
[]
[]
[null,"Experimental design:"]
[]
[null,"Observations","Temperature","Time","Catalysis","Response 1","Response 2"]
[null,"Obs1","18","50","94",77,79]
[null,"Obs2","18","50","102",70,70]
[null,"Obs3","18","70","94",84,87]
[null,"Obs4","18","70","102",80,82]
[null,"Obs5","24","50","94",88,88]
[null,"Obs6","24","50","102",85,84]
[null,"Obs7","24","70","94",92,94]
[null,"Obs8","24","70","102",86,86]
[]
[]
[]
[null,"Once you filled in the Taguchi design with individuals responses, you can click on the button above to automatically launch the interface and run the analysis."]
[]
[]
[null,"Encoded design:"]
[]
[null,"Observations","Temperature","Time","Catalysis"]
[null,"Obs1",1,1,1]
[null,"Obs2",1,1,2]
[null,"Obs3",1,2,1]
[null,"Obs4",1,2,2]
[null,"Obs5",2,1,1]
[null,"Obs6",2,1,2]
[null,"Obs7",2,2,1]
[null,"Obs8",2,2,2]

{"sheet":"Taguchi analysis","index":2,"n_rows":303,"n_cols":8,"rows_kept":303,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2019.3.2.12345 - Analysis of a Taguchi design - Start time: 31/10/2019 at 11:14:51 / End time: 31/10/2019 at 11:14:54 / Microsoft Excel 16.012026"]
[null,"Responses: Workbook = Demo_Taguchi.xls / Sheet = Taguchi designs / Range = 'Taguchi designs'!$F$20:$G$28 / 8 rows and 2 columns"]
[null,"Taguchi designs: Workbook = Demo_Taguchi.xls / Sheet = Taguchi designs / Range = 'Taguchi designs'!$C$20:$E$28 / 8 rows and 3 columns"]
[null,"Signal to Noise ratios: Larger is better"]
[null,"Fit the linear model: True"]
[null,":"]
[]
[]
[]
[null,"Variable information:"]
[]
[null,"Short name","Nbr. of categories","Category 1","Category 2"]
[null,"Temperature",2,"18","24"]
[null,"Time",2,"50","70"]
[null,"Catalysis",2,"94","102"]
[]
[]
[null,"Signal to Noise ratios:"]
[]
[null,null,"Temperature","Time","Catalysis"]
[null,"Category 1",37.88618445340083,38.042010686876921,38.68321711839139]
[null,"Category 2",38.871113253188298,38.715287019712207,38.074080588197738]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Means:"]
[]
[null,null,"Temperature","Time","Catalysis"]
[null,"Category 1",78.625,80.125,86.125]
[null,"Category 2",87.875,86.375,80.375]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Standard deviations:"]
[]
[null,null,"Temperature","Time","Catalysis"]
[null,"Category 1",1.6499158227686108,1.0606601717798214,1.6499158227686108]
[null,"Category 2",1.0606601717798214,1.6499158227686108,1.0606601717798214]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Regression of variable Signal to Noise ratios:"]
[]
[null,"Goodness of fit statistics (Signal to Noise ratios):"]
[]
[null,"Observations",8]
[null,"Sum of weights",8]
[null,"DF",4]
[null,"R²",0.91006552549228481]
[null,"Adjusted R²",0.84261466961149845]
[null,"MSE",8.866471203284608E-2]
[null,"RMSE",0.29776620364448025]
[null,"MAPE"]
[null,"DW"]
[null,"Cp",4]
[null,"AIC",-16.928323875310554]
[null,"SBC",-16.610557708591209]
[null,"PC",0.26980342352314557]
[]
[]
[null,"Analysis of variance  (Signal to Noise ratios):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F"]
[null,"Model",3,3.5888661468465903,1.1962887156155302,13.49227542939926,1.470280689077594E-2]
[null,"Error",4,0.35465884813138432,8.866471203284608E-2]
[null,"Corrected Total",7,3.9435249949779747]
[null,"Computed against model Y=Mean(Y)"]
[]
[]
[null,"Type I Sum of Squares analysis (Signal to Noise ratios):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F"]
[null,"Temperature",1,1.9401694813015762,1.9401694813015762,21.882093076474835,9.4629805261052524E-3]
[null,"Time",1,0.90660204071227679,0.90660204071227679,10.225060454450285,3.2974147425320594E-2]
[null,"Catalysis",1,0.74209462483273736,0.74209462483273736,8.3696727572726619,4.4427151282777161E-2]
[]
[]
[null,"Type II Sum of Squares analysis (Signal to Noise ratios):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F"]
[null,"Temperature",1,1.9401694813015768,1.9401694813015768,21.882093076474842,9.462980526105242E-3]
[null,"Time",1,0.90660204071227657,0.90660204071227657,10.225060454450283,3.2974147425320607E-2]
[null,"Catalysis",1,0.74209462483273736,0.74209462483273736,8.3696727572726619,4.4427151282777161E-2]
[]
[]
[null,"Type III Sum of Squares analysis (Signal to Noise ratios):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F"]
[null,"Temperature",1,1.9401694813015768,1.9401694813015768,21.882093076474842,9.462980526105242E-3]
[null,"Time",1,0.90660204071227657,0.90660204071227657,10.225060454450283,3.2974147425320607E-2]
[null,"Catalysis",1,0.74209462483273736,0.74209462483273736,8.3696727572726619,4.4427151282777161E-2]
[]
[]
[null,"Model parameters (Signal to Noise ratios):"]
[]
[null,"Source","Value","Standard error","t","Pr > |t|","Lower bound (95%)","Upper bound (95%)"]
[null,"Intercept",38.903183154509115,0.21055250180518645,184.7671379868203,"< 0,0001",38.318595706620357,39.487770602397873]
[null,"Temperature-18",-0.98492879978747094,0.21055250180518642,-4.6778299537792991,9.4629805261052455E-3,-1.5695162476762254,-0.40034135189871656]
[null,"Temperature-24",0,0]
[null,"Time-50",-0.67327633283529165,0.21055250180518642,-3.1976648439838544,3.297414742532058E-2,-1.257863780724046,-8.8688884946537261E-2]
[null,"Time-70",0,0]
[null,"Catalysis-94",0.60913653019365765,0.21055250180518642,2.8930386719283008,4.4427151282777189E-2,2.4549082304903269E-2,1.193723978082412]
[null,"Catalysis-102",0,0]
[]
[]
[null,"Equation of the model (Signal to Noise ratios):"]
[]
[null,"Signal to Noise ratios = 38,9031831545091-0,984928799787471*Temperature-18-0,673276332835292*Time-50+0,609136530193658*Catalysis-94"]
[]
[]
[null,"Regression of variable Means:"]
[]
[null,"Goodness of fit statistics (Means):"]
[]
[null,"Observations",8]
[null,"Sum of weights",8]
[null,"DF",4]
[null,"R²",0.92757352941176463]
[null,"Adjusted R²",0.87325367647058805]
[null,"MSE",6.1562500000000053]
[null,"RMSE",2.4811791551599018]
[null,"MAPE"]
[null,"DW"]
[null,"Cp",4]
[null,"AIC",16.99456516302654]
[null,"SBC",17.312331329745881]
[null,"PC",0.21727941176470611]
[]
[]
[null,"Analysis of variance  (Means):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F"]
[null,"Model",3,315.37499999999994,105.12499999999999,17.07614213197968,9.5947165195027408E-3]
[null,"Error",4,24.625000000000021,6.1562500000000053]
[null,"Corrected Total",7,339.99999999999994]
[null,"Computed against model Y=Mean(Y)"]
[]
[]
[null,"Type I Sum of Squares analysis (Means):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F"]
[null,"Temperature",1,171.12499999999997,171.12499999999997,27.796954314720782,6.2025295684943879E-3]
[null,"Time",1,78.124999999999972,78.124999999999972,12.690355329949224,2.3536362598614871E-2]
[null,"Catalysis",1,66.124999999999943,66.124999999999943,10.741116751269017,3.0576451764154067E-2]
[]
[]
[null,"Type II Sum of Squares analysis (Means):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F"]
[null,"Temperature",1,171.12499999999994,171.12499999999994,27.796954314720779,6.2025295684943879E-3]
[null,"Time",1,78.124999999999915,78.124999999999915,12.690355329949213,2.3536362598614909E-2]
[null,"Catalysis",1,66.124999999999943,66.124999999999943,10.741116751269017,3.0576451764154067E-2]
[]
[]
[null,"Type III Sum of Squares analysis (Means):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F"]
[null,"Temperature",1,171.12499999999994,171.12499999999994,27.796954314720779,6.2025295684943879E-3]
[null,"Time",1,78.124999999999915,78.124999999999915,12.690355329949213,2.3536362598614909E-2]
[null,"Catalysis",1,66.124999999999943,66.124999999999943,10.741116751269017,3.0576451764154067E-2]
[]
[]
[null,"Model parameters (Means):"]
[]
[null,"Source","Value","Standard error","t","Pr > |t|","Lower bound (95%)","Upper bound (95%)"]
[null,"Intercept",88.125,1.7544586059522758,50.229170241476275,"< 0,0001",83.253842117349564,92.996157882650436]
[null,"Temperature-18",-9.2499999999999982,1.7544586059522755,-5.272281699105311,6.2025295684943827E-3,-14.121157882650428,-4.3788421173495689]
[null,"Temperature-24",0,0]
[null,"Time-50",-6.2499999999999982,1.7544586059522755,-3.5623524993954798,2.3536362598614878E-2,-11.121157882650428,-1.3788421173495689]
[null,"Time-70",0,0]
[null,"Catalysis-94",5.7499999999999991,1.7544586059522755,3.2773642994438421,3.0576451764154022E-2,0.87884211734956974,10.621157882650429]
[null,"Catalysis-102",0,0]
[]
[]
[null,"Equation of the model (Means):"]
[]
[null,"Means = 88,125-9,25*Temperature-18-6,25*Time-50+5,75*Catalysis-94"]
[]
[]
[null,"Regression of variable Standard deviations:"]
[]
[null,"Goodness of fit statistics (Standard deviations):"]
[]
[null,"Observations",5]
[null,"Sum of weights",5]
[null,"DF",1]
[null,"R²",0.93750000000000022]
[null,"Adjusted R²",0.75000000000000078]
[null,"MSE",6.2499999999999792E-2]
[null,"RMSE",0.24999999999999958]
[null,"MAPE"]
[null,"DW"]
[null,"Cp",4]
[null,"AIC",-13.910133173369424]
[null,"SBC",-15.472381523633022]
[null,"PC",0.56249999999999822]
[]
[]
[null,"Analysis of variance  (Standard deviations):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F"]
[null,"Model",3,0.9375,0.3125,5.0000000000000169,0.31496235752570689]
[null,"Error",1,6.2499999999999792E-2,6.2499999999999792E-2]
[null,"Corrected Total",4,0.99999999999999978]
[null,"Computed against model Y=Mean(Y)"]
[]
[]
[null,"Type I Sum of Squares analysis (Standard deviations):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F"]
[null,"Temperature",1,0.41666666666666674,0.41666666666666674,6.6666666666666901,0.23523669695670618]
[null,"Time",1,0.29761904761904745,0.29761904761904745,4.7619047619047752,0.27355530365174524]
[null,"Catalysis",1,0.22321428571428581,0.22321428571428581,3.5714285714285849,0.30983963151215188]
[]
[]
[null,"Type II Sum of Squares analysis (Standard deviations):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F"]
[null,"Temperature",1,0.22321428571428581,0.22321428571428581,3.5714285714285849,0.30983963151215188]
[null,"Time",1,0.22321428571428559,0.22321428571428559,3.5714285714285814,0.30983963151215194]
[null,"Catalysis",1,0.22321428571428592,0.22321428571428592,3.5714285714285867,0.30983963151215177]
[]
[]
[null,"Type III Sum of Squares analysis (Standard deviations):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F"]
[null,"Temperature",1,0.22321428571428581,0.22321428571428581,3.5714285714285849,0.30983963151215188]
[null,"Time",1,0.22321428571428559,0.22321428571428559,3.5714285714285814,0.30983963151215194]
[null,"Catalysis",1,0.22321428571428592,0.22321428571428592,3.5714285714285867,0.30983963151215177]
[]
[]
[null,"Model parameters (Standard deviations):"]
[]
[null,"Source","Value","Standard error","t","Pr > |t|","Lower bound (95%)","Upper bound (95%)"]
[null,"Intercept",1.0606601717798212,0.24999999999999961,4.242640687119291,0.14736306675894253,-2.1158910122638508,4.2372113558234927]
[null,"Temperature-18",0.44194173824159227,0.23385358667337094,1.8898223650461397,0.30983963151215188,-2.5294498123190361,3.4133332888022205]
[null,"Temperature-24",0,0]
[null,"Time-50",-0.44194173824159211,0.23385358667337097,-1.8898223650461388,0.30983963151215194,-3.4133332888022205,2.5294498123190361]
[null,"Time-70",0,0]
[null,"Catalysis-94",0.44194173824159239,0.23385358667337097,1.8898223650461399,0.30983963151215188,-2.5294498123190361,3.4133332888022205]
[null,"Catalysis-102",0,0]
[]
[]
[null,"Equation of the model (Standard deviations):"]
[]
[null,"Standard deviations = 1,06066017177982+0,441941738241592*Temperature-18-0,441941738241592*Time-50+0,441941738241592*Catalysis-94"]