{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data","ANOVA-v1","XLSTAT_20230912_183151_1_HID","ANOVA-v2","XLSTAT_20230912_182916_1_HID"],"not_rendered":{"charts":10,"images":5,"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":"Data","index":0,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Kernels popped (%)","Brand","Power of Microwave","Time",null,null,null,null,"Power",500,500,500,500,600,600,600,600]
[70.3,1,500,8,null,null,null,null,"Time",8,8,4,4,8,8,4,4]
[91,1,500,8,null,null,null,"Brand",1,70.3,91,72.7,81.900000000000006,78.7,88.7,74.099999999999994,72.099999999999994]
[72.7,1,500,4,null,null,null,null,2,93.4,76.3,45.3,47.6,92.2,84.7,66.3,45.7]
[81.900000000000006,1,500,4,null,null,null,null,3,50.1,81.5,51.4,67.7,71.5,80,64,77]
[78.7,1,600,8]
[88.7,1,600,8]
[74.099999999999994,1,600,4]
[72.099999999999994,1,600,4]
[93.4,2,500,8]
[76.3,2,500,8]
[45.3,2,500,4]
[47.6,2,500,4]
[92.2,2,600,8]
[84.7,2,600,8]
[66.3,2,600,4]
[45.7,2,600,4]
[50.1,3,500,8]
[81.5,3,500,8]
[51.4,3,500,4]
[67.7,3,500,4]
[71.5,3,600,8]
[80,3,600,8]
[64,3,600,4]
[77,3,600,4]

{"sheet":"ANOVA-v1","index":1,"n_rows":410,"n_cols":26,"rows_kept":410,"cut":false,"hidden":false,"merged":[[277,1,278,8],[280,1,282,8],[284,1,286,8],[287,1,290,8],[291,1,292,8]]}
[null,"XLSTAT 2023.2.0.1411 - ANOVA - Start time: 12/09/2023 at 18:31:53 / End time: 12/09/2023 at 18:31:57 / Microsoft Excel 16.016731"]
[null,"Y / Dependent variables: Workbook = demoANO3 (1).xls / Sheet = Data / Range = 'Data'!$A:$A / 24 rows and 1 column"]
[null,"X / Qualitative: Workbook = demoANO3 (1).xls / Sheet = Data / Range = 'Data'!$B:$D / 24 rows and 3 columns"]
[null,"Constraints: a1=0"]
[null,"Interactions / Level: 2"]
[null,"Confidence interval (%): 95"]
[null,"Tolerance: 0,0001"]
[null,"Use least squares means: Yes"]
[]
[]
[]
[]
[null,"Summary statistics (Quantitative data):"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"Kernels popped (%)",24,0,24,45.3,93.4,71.841666666666654,14.794473605889539]
[]
[]
[null,"Summary statistics (Qualitative data):"]
[]
[null,"Variable","Categories","Counts","Frequencies","%"]
[null,"Brand","1",8,8,33.333333333333336]
[null,"","2",8,8,33.333333333333336]
[null,"","3",8,8,33.333333333333336]
[null,"Power of Microwave","500",12,12,50]
[null,"","600",12,12,50]
[null,"Time","4",12,12,50]
[null,"","8",12,12,50]
[]
[]
[null,"Correlation matrix:"]
[]
[null,null,"Brand-1","Brand-2","Brand-3","Power of Microwave-500","Power of Microwave-600","Time-4","Time-8","Brand-1*Power of Microwave-500","Brand-1*Power of Microwave-600","Brand-2*Power of Microwave-500","Brand-2*Power of Microwave-600","Brand-3*Power of Microwave-500","Brand-3*Power of Microwave-600","Brand-1*Time-4","Brand-1*Time-8","Brand-2*Time-4","Brand-2*Time-8","Brand-3*Time-4","Brand-3*Time-8","Power of Microwave-500*Time-4","Power of Microwave-500*Time-8","Power of Microwave-600*Time-4","Power of Microwave-600*Time-8","Kernels popped (%)"]
[null,"Brand-1",1,-0.49999999999999994,-0.49999999999999994,0,0,0,0,0.63245553203367588,0.63245553203367588,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0.63245553203367588,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,0,0,0,0,0.33423621868705511]
[null,"Brand-2",-0.49999999999999994,1,-0.49999999999999994,0,0,0,0,-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0.63245553203367588,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0.63245553203367588,-0.31622776601683789,-0.31622776601683789,0,0,0,0,-0.14179101912652203]
[null,"Brand-3",-0.49999999999999994,-0.49999999999999994,1,0,0,0,0,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0.63245553203367588,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0.63245553203367588,0,0,0,0,-0.19244519956053083]
[null,"Power of Microwave-500",0,0,0,1,-0.99999999999999989,0,0,0.44721359549995782,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0,0,0,0,0,0,0.57735026918962562,0.57735026918962562,-0.57735026918962562,-0.57735026918962562,-0.18930271267518198]
[null,"Power of Microwave-600",0,0,0,-0.99999999999999989,1,0,0,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0.44721359549995782,0,0,0,0,0,0,-0.57735026918962562,-0.57735026918962562,0.57735026918962562,0.57735026918962562,0.18930271267518328]
[null,"Time-4",0,0,0,0,0,1,-0.99999999999999989,0,0,0,0,0,0,0.44721359549995782,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0.57735026918962562,-0.57735026918962562,0.57735026918962562,-0.57735026918962562,-0.55409882159939416]
[null,"Time-8",0,0,0,0,0,-0.99999999999999989,1,0,0,0,0,0,0,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0.44721359549995782,-0.57735026918962562,0.57735026918962562,-0.57735026918962562,0.57735026918962562,0.55409882159939616]
[null,"Brand-1*Power of Microwave-500",0.63245553203367588,-0.31622776601683789,-0.31622776601683789,0.44721359549995782,-0.44721359549995782,0,0,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.2581988897471611,0.2581988897471611,-0.2581988897471611,-0.2581988897471611,0.22026713446200533]
[null,"Brand-1*Power of Microwave-600",0.63245553203367588,-0.31622776601683789,-0.31622776601683789,-0.44721359549995782,0.44721359549995782,0,0,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.2581988897471611,-0.2581988897471611,0.2581988897471611,0.2581988897471611,0.20251195656728799]
[null,"Brand-2*Power of Microwave-500",-0.31622776601683789,0.63245553203367588,-0.31622776601683789,0.44721359549995782,-0.44721359549995782,0,0,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,0.2581988897471611,0.2581988897471611,-0.2581988897471611,-0.2581988897471611,-0.19118981414166894]
[null,"Brand-2*Power of Microwave-600",-0.31622776601683789,0.63245553203367588,-0.31622776601683789,-0.44721359549995782,0.44721359549995782,0,0,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.2581988897471611,-0.2581988897471611,0.2581988897471611,0.2581988897471611,1.1836785263145754E-2]
[null,"Brand-3*Power of Microwave-500",-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0.44721359549995782,-0.44721359549995782,0,0,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,0.2581988897471611,0.2581988897471611,-0.2581988897471611,-0.2581988897471611,-0.28305356064042581]
[null,"Brand-3*Power of Microwave-600",-0.31622776601683789,-0.31622776601683789,0.63245553203367588,-0.44721359549995782,0.44721359549995782,0,0,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.2581988897471611,-0.2581988897471611,0.2581988897471611,0.2581988897471611,3.9627498489660538E-2]
[null,"Brand-1*Time-4",0.63245553203367588,-0.31622776601683789,-0.31622776601683789,0,0,0.44721359549995782,-0.44721359549995782,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.10370053176190264]
[null,"Brand-1*Time-8",0.63245553203367588,-0.31622776601683789,-0.31622776601683789,0,0,-0.44721359549995782,0.44721359549995782,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,0.31907855926739065]
[null,"Brand-2*Time-4",-0.31622776601683789,0.63245553203367588,-0.31622776601683789,0,0,0.44721359549995782,-0.44721359549995782,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,-0.63661319002219507]
[null,"Brand-2*Time-8",-0.31622776601683789,0.63245553203367588,-0.31622776601683789,0,0,-0.44721359549995782,0.44721359549995782,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,0.45726016114367146]
[null,"Brand-3*Time-4",-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0,0,0.44721359549995782,-0.44721359549995782,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,-0.21048892054897075]
[null,"Brand-3*Time-8",-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0,0,-0.44721359549995782,0.44721359549995782,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-3.2937141601794097E-2]
[null,"Power of Microwave-500*Time-4",0,0,0,0.57735026918962562,-0.57735026918962562,0.57735026918962562,-0.57735026918962562,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,1,-0.33333333333333331,-0.33333333333333331,-0.33333333333333331,-0.42820647435991238]
[null,"Power of Microwave-500*Time-8",0,0,0,0.57735026918962562,-0.57735026918962562,-0.57735026918962562,0.57735026918962562,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.33333333333333331,1,-0.33333333333333331,-0.33333333333333331,0.209618530117227]
[null,"Power of Microwave-600*Time-4",0,0,0,-0.57735026918962562,0.57735026918962562,0.57735026918962562,-0.57735026918962562,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,-0.33333333333333331,-0.33333333333333331,1,-0.33333333333333331,-0.21161173325621738]
[null,"Power of Microwave-600*Time-8",0,0,0,-0.57735026918962562,0.57735026918962562,-0.57735026918962562,0.57735026918962562,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.33333333333333331,-0.33333333333333331,-0.33333333333333331,1,0.43019967749890431]
[null,"Kernels popped (%)",0.33423621868705511,-0.14179101912652203,-0.19244519956053083,-0.18930271267518198,0.18930271267518328,-0.55409882159939416,0.55409882159939616,0.22026713446200533,0.20251195656728799,-0.19118981414166894,1.1836785263145754E-2,-0.28305356064042581,3.9627498489660538E-2,0.10370053176190264,0.31907855926739065,-0.63661319002219507,0.45726016114367146,-0.21048892054897075,-3.2937141601794097E-2,-0.42820647435991238,0.209618530117227,-0.21161173325621738,0.43019967749890431,1]
[]
[]
[null,"Regression of variable Kernels popped (%):"]
[]
[null,"Goodness of fit statistics (Kernels popped (%)):"]
[]
[null,"Observations",24]
[null,"Sum of weights",24]
[null,"DF",14]
[null,"R²",0.70429267388292138]
[null,"Adjusted R²",0.5141951070933708]
[null,"MSE",106.33125000000062]
[null,"RMSE",10.31170451477352]
[null,"MAPE",9.8151009820582402]
[null,"DW",3.0545155595301043]
[null,"Cp",10]
[null,"AIC",119.0615052971751]
[null,"AICC",135.98458222025204]
[null,"SBC",130.84204360065456]
[null,"PC",0.71814636342719107]
[]
[]
[null,"Analysis of variance (Kernels popped (%)):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F","p-values signification codes"]
[null,"Model",9,3545.5208333333221,393.94675925925799,3.7049010451702173,1.4195317549933334E-2,"*"]
[null,"Error",14,1488.6375000000087,106.33125000000062,null,null,""]
[null,"Corrected Total",23,5034.158333333331,null,null,null,""]
[null,"Computed against model Y=Mean(Y)"]
[null,"Signification codes: 0 < *** < 0.001 < ** < 0.01 < * < 0.05 < . < 0.1 < ° < 1"]
[]
[]
[null,"Type I Sum of Squares analysis (Kernels popped (%)):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F","p-values signification codes"]
[null,"Brand",2,566.69083333332401,283.345416666662,2.6647426477790899,0.1045572665815753,"°"]
[null,"Power of Microwave",1,180.40166666666721,180.40166666666721,1.696600638727243,0.21375331725616711,"°"]
[null,"Time",1,1545.6150000000048,1545.6150000000048,14.535849056603734,1.9029165023294401E-3,"**"]
[null,"Brand*Power of Microwave",2,125.12583333333214,62.562916666666069,0.58837751523343984,0.5683865342033747,"°"]
[null,"Brand*Time",2,1127.6724999999947,563.83624999999734,5.3026391582906625,1.930626562155564E-2,"*"]
[null,"Power of Microwave*Time",1,1.5000000000327418E-2,1.5000000000327418E-2,1.4106859460720465E-4,0.99069115953367959,"°"]
[null,"Signification codes: 0 < *** < 0.001 < ** < 0.01 < * < 0.05 < . < 0.1 < ° < 1"]
[]
[]
[null,"Type II Sum of Squares analysis (Kernels popped (%)):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F","p-values signification codes"]
[null,"Brand",2,566.69083333332401,283.345416666662,2.6647426477790899,0.1045572665815753,"°"]
[null,"Power of Microwave",1,180.40166666666721,180.40166666666721,1.696600638727243,0.21375331725616711,"°"]
[null,"Time",1,1545.6150000000048,1545.6150000000048,14.535849056603734,1.9029165023294401E-3,"**"]
[null,"Brand*Power of Microwave",2,125.12583333333214,62.562916666666069,0.58837751523343984,0.5683865342033747,"°"]
[null,"Brand*Time",2,1127.6724999999947,563.83624999999734,5.3026391582906625,1.930626562155564E-2,"*"]
[null,"Power of Microwave*Time",1,1.5000000000327418E-2,1.5000000000327418E-2,1.4106859460720465E-4,0.99069115953367959,"°"]
[null,"Signification codes: 0 < *** < 0.001 < ** < 0.01 < * < 0.05 < . < 0.1 < ° < 1"]
[]
[]
[null,"Type III Sum of Squares analysis (Kernels popped (%)):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F","p-values signification codes"]
[null,"Brand",2,566.69083333332401,283.345416666662,2.6647426477790899,0.1045572665815753,"°"]
[null,"Power of Microwave",1,180.40166666666721,180.40166666666721,1.696600638727243,0.21375331725616711,"°"]
[null,"Time",1,1545.6150000000048,1545.6150000000048,14.535849056603734,1.9029165023294401E-3,"**"]
[null,"Brand*Power of Microwave",2,125.12583333333214,62.562916666666069,0.58837751523343984,0.5683865342033747,"°"]
[null,"Brand*Time",2,1127.6724999999947,563.83624999999734,5.3026391582906625,1.930626562155564E-2,"*"]
[null,"Power of Microwave*Time",1,1.5000000000327418E-2,1.5000000000327418E-2,1.4106859460720465E-4,0.99069115953367959,"°"]
[null,"Signification codes: 0 < *** < 0.001 < ** < 0.01 < * < 0.05 < . < 0.1 < ° < 1"]
[]
[]
[null,"Model parameters (Kernels popped (%)):"]
[]
[null,"Source","Value","Standard error","t","Pr > |t|","Lower bound (95%)","Upper bound (95%)","p-values signification codes"]
[null,"Intercept",75.512499999999832,6.6561766427882736,11.344725966943034,1.9164964379668114E-8,61.236420953655305,89.788579046344353,"***"]
[null,"Brand-1",0,0,null,null,null,null,""]
[null,"Brand-2",-27.549999999999809,8.9301980661125526,-3.0850379572815827,8.0686217201919597E-3,-46.703369919871854,-8.396630080127764,"**"]
[null,"Brand-3",-15.687499999999815,8.9301980661125526,-1.7566799620636875,0.10081172655664306,-34.840869919871864,3.4658699198722296,"°"]
[null,"Power of Microwave-500",0,0,null,null,null,null,""]
[null,"Power of Microwave-600",-0.62499999999992695,8.4194714798495678,-7.4232688060734894E-2,0.94187547583281717,-18.682970337221203,17.432970337221352,"°"]
[null,"Time-4",0,0,null,null,null,null,""]
[null,"Time-8",6.9250000000001117,8.4194714798495678,0.82249818371305206,0.42458139936685946,-11.132970337221167,24.982970337221388,"°"]
[null,"Brand-1*Power of Microwave-500",0,0,null,null,null,null,""]
[null,"Brand-1*Power of Microwave-600",0,0,null,null,null,null,""]
[null,"Brand-2*Power of Microwave-500",0,0,null,null,null,null,""]
[null,"Brand-2*Power of Microwave-600",7.1499999999999195,10.311704514773512,0.69338681977903471,0.4994097692344146,-14.966406558253283,29.266406558253124,"°"]
[null,"Brand-3*Power of Microwave-500",0,0,null,null,null,null,""]
[null,"Brand-3*Power of Microwave-600",11.02499999999992,10.311704514773512,1.0691733829459984,0.30308017437241963,-11.091406558253283,33.141406558253124,"°"]
[null,"Brand-1*Time-4",0,0,null,null,null,null,""]
[null,"Brand-1*Time-8",0,0,null,null,null,null,""]
[null,"Brand-2*Time-4",0,0,null,null,null,null,""]
[null,"Brand-2*Time-8",28.449999999999864,10.311704514773512,2.7590007024774357,1.5370857785689473E-2,6.3335934417466611,50.566406558253064,"*"]
[null,"Brand-3*Time-4",0,0,null,null,null,null,""]
[null,"Brand-3*Time-8",-1.2250000000001013,10.311704514773512,-0.11879704254956606,0.90712390649213415,-23.341406558253304,20.891406558253102,"°"]
[null,"Power of Microwave-500*Time-4",0,0,null,null,null,null,""]
[null,"Power of Microwave-500*Time-8",0,0,null,null,null,null,""]
[null,"Power of Microwave-600*Time-4",0,0,null,null,null,null,""]
[null,"Power of Microwave-600*Time-8",9.9999999999990499E-2,8.4194714798495713,1.1877230089717838E-2,0.99069115953373066,-17.957970337221294,18.157970337221276,"°"]
[null,"Signification codes: 0 < *** < 0.001 < ** < 0.01 < * < 0.05 < . < 0.1 < ° < 1"]
[]
[]
[null,"Equation of the model (Kernels popped (%)):"]
[]
[null,"Kernels popped (%) = 75,5124999999998-27,5499999999998*Brand-2-15,6874999999998*Brand-3-0,624999999999927*Power of Microwave-600+6,92500000000011*Time-8+7,14999999999992*Brand-2*Power of Microwave-600+11,0249999999999*Brand-3*Power of Microwave-600+28,4499999999999*Brand-2*Time-8-1,2250000000001*Brand-3*Time-8+9,99999999999905E-02*Power of Microwave-600*Time-8"]
[]
[]
[null,"Standardized coefficients (Kernels popped (%)):"]
[]
[null,"Source","Value","Standard error","t","Pr > |t|","Lower bound (95%)","Upper bound (95%)","p-values signification codes"]
[null,"Brand-1",0,0,null,null,null,null,""]
[null,"Brand-2",-0.89672139499241121,0.29066786451553672,-3.0850379572815827,8.0686217201919597E-3,-1.5201419609943518,-0.27330082899047048,"**"]
[null,"Brand-3",-0.51061041321028611,0.29066786451553672,-1.7566799620636875,0.10081172655664306,-1.134030979212227,0.11281015279165463,"°"]
[null,"Power of Microwave-500",0,0,null,null,null,null,""]
[null,"Power of Microwave-600",-2.1577056915861779E-2,0.29066786451553656,-7.4232688060734894E-2,0.94187547583281717,-0.64499762291780216,0.60184350908607864,"°"]
[null,"Time-4",0,0,null,null,null,null,""]
[null,"Time-8",0.23907379062778034,0.29066786451553656,0.82249818371305217,0.42458139936685946,-0.38434677537416007,0.86249435662972074,"°"]
[null,"Brand-1*Power of Microwave-500",0,0,null,null,null,null,""]
[null,"Brand-1*Power of Microwave-600",0,0,null,null,null,null,""]
[null,"Brand-2*Power of Microwave-500",0,0,null,null,null,null,""]
[null,"Brand-2*Power of Microwave-600",0.18398481441627523,0.26534224356169134,0.69338681977903482,0.4994097692344146,-0.38511769693689313,0.75308732576944359,"°"]
[null,"Brand-3*Power of Microwave-500",0,0,null,null,null,null,""]
[null,"Brand-3*Power of Microwave-600",0.28369686418733464,0.26534224356169139,1.0691733829459984,0.30308017437241963,-0.28540564716583383,0.85279937554050311,"°"]
[null,"Brand-1*Time-4",0,0,null,null,null,null,""]
[null,"Brand-1*Time-8",0,0,null,null,null,null,""]
[null,"Brand-2*Time-4",0,0,null,null,null,null,""]
[null,"Brand-2*Time-8",0.73207943638364537,0.26534224356169134,2.7590007024774361,1.5370857785689473E-2,0.162976925030477,1.3011819477368136,"*"]
[null,"Brand-3*Time-4",0,0,null,null,null,null,""]
[null,"Brand-3*Time-8",-3.152187379859557E-2,0.26534224356169139,-0.11879704254956605,0.90712390649213415,-0.60062438515176408,0.53758063755457286,"°"]
[null,"Power of Microwave-500*Time-4",0,0,null,null,null,null,""]
[null,"Power of Microwave-500*Time-8",0,0,null,null,null,null,""]
[null,"Power of Microwave-600*Time-4",0,0,null,null,null,null,""]
[null,"Power of Microwave-600*Time-8",2.9898047084863069E-3,0.25172575473422815,1.1877230089717838E-2,0.99069115953373066,-0.53690824269086757,0.54288785210784019,"°"]
[null,"Signification codes: 0 < *** < 0.001 < ** < 0.01 < * < 0.05 < . < 0.1 < ° < 1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Predictions and residuals (Kernels popped (%)):"]
[]
[null,"Observation","Weight","Kernels popped (%)","Pred(Kernels popped (%))","Residual","Std. residual","Std. dev. on pred. (Mean)","Lower bound 95% (Mean)","Upper bound 95% (Mean)","Std. dev. on pred. (Observation)","Lower bound 95% (Observation)","Upper bound 95% (Observation)"]
[null,"Obs1",1,70.3,82.437499999999943,-12.137499999999946,-1.1770604930165152,6.6561766427882745,68.161420953655409,96.713579046344478,12.27338329475621,56.113710911279767,108.76128908872012]
[null,"Obs2",1,91,82.437499999999943,8.5625000000000568,0.83036708312700502,6.6561766427882745,68.161420953655409,96.713579046344478,12.27338329475621,56.113710911279767,108.76128908872012]
[null,"Obs3",1,72.7,75.512499999999832,-2.8124999999998295,-0.27274831197600519,6.6561766427882763,61.236420953655298,89.788579046344367,12.273383294756211,49.188710911279657,101.83628908872001]
[null,"Obs4",1,81.900000000000006,75.512499999999832,6.3875000000001734,0.61944172186555946,6.6561766427882763,61.236420953655298,89.788579046344367,12.273383294756211,49.188710911279657,101.83628908872001]
[null,"Obs5",1,78.7,81.912500000000009,-3.2125000000000057,-0.31153918301261202,6.6561766427882754,67.636420953655474,96.188579046344543,12.27338329475621,55.588710911279833,108.23628908872018]
[null,"Obs6",1,88.7,81.912500000000009,6.7874999999999943,0.65823259290213187,6.6561766427882754,67.636420953655474,96.188579046344543,12.27338329475621,55.588710911279833,108.23628908872018]
[null,"Obs7",1,74.099999999999994,74.887499999999903,-0.78749999999990905,-7.6369527353277261E-2,6.6561766427882754,60.611420953655376,89.163579046344438,12.27338329475621,48.563710911279728,101.21128908872008]
[null,"Obs8",1,72.099999999999994,74.887499999999903,-2.7874999999999091,-0.27032388253622608,6.6561766427882754,60.611420953655376,89.163579046344438,12.27338329475621,48.563710911279728,101.21128908872008]
[null,"Obs9",1,93.4,83.337499999999991,10.062500000000014,0.97583284951421245,6.6561766427882789,69.061420953655457,97.613579046344526,12.273383294756213,57.013710911279802,109.66128908872018]
[null,"Obs10",1,76.3,83.337499999999991,-7.0374999999999943,-0.68247688730000056,6.6561766427882789,69.061420953655457,97.613579046344526,12.273383294756213,57.013710911279802,109.66128908872018]
[null,"Obs11",1,45.3,47.96250000000002,-2.6625000000000227,-0.25820173533730278,6.6561766427882798,33.686420953655485,62.238579046344555,12.273383294756213,21.638710911279833,74.28628908872021]
[null,"Obs12",1,47.6,47.96250000000002,-0.36250000000001847,-3.5154226876911263E-2,6.6561766427882798,33.686420953655485,62.238579046344555,12.273383294756213,21.638710911279833,74.28628908872021]
[null,"Obs13",1,92.2,89.962499999999977,2.2375000000000256,0.21698643486092645,6.656176642788278,75.686420953655443,104.23857904634451,12.273383294756213,63.638710911279787,116.28628908872017]
[null,"Obs14",1,84.7,89.962499999999977,-5.2624999999999744,-0.51034239707513152,6.656176642788278,75.686420953655443,104.23857904634451,12.273383294756213,63.638710911279787,116.28628908872017]
[null,"Obs15",1,66.3,54.487500000000011,11.812499999999986,1.14554291029929,6.6561766427882789,40.211420953655477,68.763579046344546,12.273383294756213,28.163710911279825,80.811289088720201]
[null,"Obs16",1,45.7,54.487500000000011,-8.7875000000000085,-0.85218694808508211,6.6561766427882789,40.211420953655477,68.763579046344546,12.273383294756213,28.163710911279825,80.811289088720201]
[null,"Obs17",1,50.1,65.52500000000002,-15.425000000000018,-1.4958729643484943,6.6561766427882798,51.248920953655485,79.801079046344555,12.273383294756213,39.20121091127983,91.84878908872021]
[null,"Obs18",1,81.5,65.52500000000002,15.97499999999998,1.5492104120238015,6.6561766427882798,51.248920953655485,79.801079046344555,12.273383294756213,39.20121091127983,91.84878908872021]
[null,"Obs19",1,51.4,59.825000000000017,-8.4250000000000185,-0.81703272120817361,6.6561766427882807,45.548920953655475,74.101079046344552,12.273383294756213,33.501210911279827,86.148789088720207]
[null,"Obs20",1,67.7,59.825000000000017,7.8749999999999858,0.76369527353285949,6.6561766427882807,45.548920953655475,74.101079046344552,12.273383294756213,33.501210911279827,86.148789088720207]
[null,"Obs21",1,71.5,76.025000000000006,-4.5250000000000057,-0.43882172860142221,6.6561766427882816,61.748920953655464,90.30107904634454,12.273383294756213,49.701210911279816,102.3487890887202]
[null,"Obs22",1,80,76.025000000000006,3.9749999999999943,0.38548428092611015,6.6561766427882816,61.748920953655464,90.30107904634454,12.273383294756213,49.701210911279816,102.3487890887202]
[null,"Obs23",1,64,70.225000000000009,-6.2250000000000085,-0.60368293050692889,6.6561766427882807,55.948920953655467,84.501079046344543,12.273383294756213,43.901210911279819,96.548789088720198]
[null,"Obs24",1,77,70.225000000000009,6.7749999999999915,0.65702037818223824,6.6561766427882807,55.948920953655467,84.501079046344543,12.273383294756213,43.901210911279819,96.548789088720198]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Interpretation (Kernels popped (%)):"]
[]
[null,"Given the R2, 70% of the variability of the dependent variable Kernels popped (%) is explained by the 6 explanatory variables."]
[]
[]
[null,"Given the p-value of the F statistic computed in the ANOVA table, and given the significance level of 5%, the information brought by the explanatory variables is significantly better than what a basic mean would bring."]
[]
[]
[]
[null,"Based on the Type III sum of squares, the following variables bring significant information to explain the variability of the dependent variable Kernels popped (%): Time,Brand*Time."]
[]
[]
[null,"Based on the Type III sum of squares, the following variables do not bring significant information to explain the variability of the dependent variable Kernels popped (%): Brand,Power of Microwave,Brand*Power of Microwave,Power of Microwave*Time. You might want to remove them from the model."]
[]
[]
[]
[null,"Among the explanatory variables, based on the Type III sum of squares, variable Time is the most influential."]
[]
[]
[]
[]
[null,"LS Means for factor Brand:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"1",78.687499999999929,3.6457380939941455,70.868169473590186,86.506830526409672]
[null,"2",68.9375,3.6457380939941486,61.118169473590257,76.756830526409743]
[null,"3",67.900000000000006,3.6457380939941464,60.080669473590262,75.719330526409749]
[]
[]
[null,"Brand*Power of Microwave:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"Brand-1*Power of Microwave-500",78.974999999999895,5.1558522573867567,67.916796720873293,90.033203279126496]
[null,"Brand-1*Power of Microwave-600",78.399999999999963,5.1558522573867576,67.341796720873361,89.458203279126565]
[null,"Brand-2*Power of Microwave-500",65.650000000000006,5.155852257386762,54.59179672087339,76.708203279126622]
[null,"Brand-2*Power of Microwave-600",72.224999999999994,5.155852257386762,61.166796720873378,83.28320327912661]
[null,"Brand-3*Power of Microwave-500",62.675000000000018,5.1558522573867611,51.616796720873403,73.733203279126627]
[null,"Brand-3*Power of Microwave-600",73.125,5.155852257386762,62.066796720873384,84.183203279126616]
[]
[]
[null,"Brand\\Power of Microwave","500","600"]
[null,"1",78.974999999999895,78.399999999999963]
[null,"2",65.650000000000006,72.224999999999994]
[null,"3",62.675000000000018,73.125]
[]
[]
[null,"Brand*Time:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"Brand-1*Time-4",75.199999999999875,5.1558522573867567,64.141796720873273,86.258203279126477]
[null,"Brand-1*Time-8",82.174999999999983,5.1558522573867576,71.116796720873381,93.233203279126585]
[null,"Brand-2*Time-4",51.225000000000016,5.155852257386762,40.1667967208734,62.283203279126631]
[null,"Brand-2*Time-8",86.649999999999991,5.1558522573867549,75.59179672087339,97.708203279126593]
[null,"Brand-3*Time-4",65.025000000000006,5.1558522573867611,53.96679672087339,76.083203279126622]
[null,"Brand-3*Time-8",70.77500000000002,5.1558522573867576,59.716796720873418,81.833203279126622]
[]
[]
[null,"Brand\\Time","4","8"]
[null,"1",75.199999999999875,82.174999999999983]
[null,"2",51.225000000000016,86.649999999999991]
[null,"3",65.025000000000006,70.77500000000002]
[]
[]
[null,"LS Means for factor Power of Microwave:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"500",69.09999999999998,2.9767326887041858,62.715543360042631,75.48445663995733]
[null,"600",74.583333333333329,2.9767326887041867,68.198876693375979,80.967789973290678]
[]
[]
[null,"Power of Microwave*Brand:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"Brand-1*Power of Microwave-500",78.974999999999895,5.1558522573867567,67.916796720873293,90.033203279126496]
[null,"Brand-1*Power of Microwave-600",78.399999999999963,5.1558522573867576,67.341796720873361,89.458203279126565]
[null,"Brand-2*Power of Microwave-500",65.650000000000006,5.155852257386762,54.59179672087339,76.708203279126622]
[null,"Brand-2*Power of Microwave-600",72.224999999999994,5.155852257386762,61.166796720873378,83.28320327912661]
[null,"Brand-3*Power of Microwave-500",62.675000000000018,5.1558522573867611,51.616796720873403,73.733203279126627]
[null,"Brand-3*Power of Microwave-600",73.125,5.155852257386762,62.066796720873384,84.183203279126616]
[]
[]
[null,"Power of Microwave\\Brand","1","2","3"]
[null,"500",78.974999999999895,65.650000000000006,62.675000000000018]
[null,"600",78.399999999999963,72.224999999999994,73.125]
[]
[]
[null,"Power of Microwave*Time:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"Power of Microwave-500*Time-4",61.099999999999959,4.2097357399247866,52.071014831389313,70.128985168610598]
[null,"Power of Microwave-500*Time-8",77.099999999999994,4.2097357399247848,68.071014831389348,86.12898516861064]
[null,"Power of Microwave-600*Time-4",66.533333333333303,4.2097357399247848,57.504348164722664,75.562318501943949]
[null,"Power of Microwave-600*Time-8",82.63333333333334,4.2097357399247892,73.604348164722694,91.662318501943986]
[]
[]
[null,"Power of Microwave\\Time","4","8"]
[null,"500",61.099999999999959,77.099999999999994]
[null,"600",66.533333333333303,82.63333333333334]
[]
[]
[null,"LS Means for factor Time:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"4",63.816666666666634,2.9767326887041858,57.432210026709285,70.201123306623984]
[null,"8",79.86666666666666,2.9767326887041876,73.482210026709311,86.25112330662401]
[]
[]
[null,"Time*Brand:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"Brand-1*Time-4",75.199999999999875,5.1558522573867567,64.141796720873273,86.258203279126477]
[null,"Brand-1*Time-8",82.174999999999983,5.1558522573867576,71.116796720873381,93.233203279126585]
[null,"Brand-2*Time-4",51.225000000000016,5.155852257386762,40.1667967208734,62.283203279126631]
[null,"Brand-2*Time-8",86.649999999999991,5.1558522573867549,75.59179672087339,97.708203279126593]
[null,"Brand-3*Time-4",65.025000000000006,5.1558522573867611,53.96679672087339,76.083203279126622]
[null,"Brand-3*Time-8",70.77500000000002,5.1558522573867576,59.716796720873418,81.833203279126622]
[]
[]
[null,"Time\\Brand","1","2","3"]
[null,"4",75.199999999999875,51.225000000000016,65.025000000000006]
[null,"8",82.174999999999983,86.649999999999991,70.77500000000002]
[]
[]
[null,"Time*Power of Microwave:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"Power of Microwave-500*Time-4",61.099999999999959,4.2097357399247866,52.071014831389313,70.128985168610598]
[null,"Power of Microwave-500*Time-8",77.099999999999994,4.2097357399247848,68.071014831389348,86.12898516861064]
[null,"Power of Microwave-600*Time-4",66.533333333333303,4.2097357399247848,57.504348164722664,75.562318501943949]
[null,"Power of Microwave-600*Time-8",82.63333333333334,4.2097357399247892,73.604348164722694,91.662318501943986]
[]
[]
[null,"Time\\Power of Microwave","500","600"]
[null,"4",61.099999999999959,66.533333333333303]
[null,"8",77.099999999999994,82.63333333333334]

{"sheet":"XLSTAT_20230912_183151_1_HID","index":2,"n_rows":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
[1,null,{"$f":"46.2825+(A1-1)*0.8938043478","v":46.282499999999999},{"$f":"0+1*C1-22.1164065582532*(1.04166666666667+(C1-71.8416666666667)^2/3545.52083333333)^0.5","v":21.794941949985979},1,null,{"$f":"38.37+(E1-1)*1.0084782609","v":38.369999999999997},{"$f":"0+1*G1+22.1164065582532*(1.04166666666667+(G1-71.8416666666667)^2/3545.52083333333)^0.5","v":64.139719647158913}]
[2,null,47.176304347799999,22.815528317575961,2,null,39.378478260899996,64.969590843603441]
[3,null,48.070108695599998,23.832230386215233,3,null,40.386956521799995,65.803727590864412]
[4,null,48.963913043399998,24.844988778619335,4,null,41.395434782700001,66.642218256304147]
[5,null,49.857717391199998,25.85374486489134,5,null,42.403913043599999,67.485151365861256]
[6,null,50.751521738999998,26.858440878608409,6,null,43.412391304499998,68.332615453216548]
[7,null,51.645326086799997,27.859020035575579,7,null,44.420869565399997,69.184698899646307]
[8,null,52.539130434599997,28.855426654834165,8,null,45.429347826299995,70.041489764747254]
[9,null,53.432934782399997,29.847606281470696,9,null,46.437826087199994,70.903075608307773]
[10,null,54.326739130199996,30.835505810732155,10,null,47.4463043481,71.769543303696523]
[11,null,55.220543477999996,31.819073612915052,11,null,48.454782608999999,72.640978843241257]
[12,null,56.114347825799996,32.798259658460353,12,null,49.463260869899997,73.517467136176947]
[13,null,57.008152173599996,33.773015642653846,13,null,50.471739130799996,74.399091799851433]
[14,null,57.901956521399995,34.743295109303347,14,null,51.480217391699995,75.285934944987943]
[15,null,58.795760869199995,35.709053572739656,15,null,52.488695652600001,76.178076955915515]
[16,null,59.689565216999995,36.670248637470294,16,null,53.497173913499999,77.075596266787784]
[17,null,60.583369564799995,37.626840114801226,17,null,54.505652174399998,77.978569134917734]
[18,null,61.477173912599994,38.57879013573519,18,null,55.514130435299997,78.887069412456782]
[19,null,62.370978260399994,39.52606325945537,19,null,56.522608696199995,79.801168317740647]
[20,null,63.264782608199994,40.468626576709539,20,null,57.531086957100001,80.720934207708268]
[21,null,64.158586955999994,41.40644980742411,21,null,58.539565218,81.646432352872694]
[22,null,65.052391303799993,42.339505391899024,22,null,59.548043478899999,82.577724716380658]
[23,null,65.946195651599993,43.267768574963334,23,null,60.556521739799997,83.514869738740842]
[24,null,66.839999999399993,44.191217482507419,24,null,61.565000000699996,84.457922129824709]
[25,null,67.733804347199992,45.109833189851301,25,null,62.573478261600002,85.406932669749864]
[26,null,68.627608694999992,46.023599781458437,26,null,63.581956522499993,86.361948020240774]
[27,null,69.521413042799992,46.93250440156055,27,null,64.590434783399999,87.323010548025081]
[28,null,70.415217390599992,47.836537295321349,28,null,65.598913044299991,88.290158161765262]
[29,null,71.309021738399991,48.735691840233073,29,null,66.607391305199997,89.26342416394553]
[30,null,72.202826086199991,49.629964567511323,30,null,67.615869566100002,90.24283711903152]
[31,null,73.096630433999991,50.519355173327156,31,null,68.624347826999994,91.228420739098567]
[32,null,73.990434781799991,51.403866519791748,32,null,69.6328260879,92.220193787982168]
[33,null,{"$f":"46.2825+(A33-1)*0.8938043478","v":74.88423912959999},{"$f":"0+1*C33-22.1164065582532*(1.04166666666667+(C33-71.8416666666667)^2/3545.52083333333)^0.5","v":52.283504625686163},33,null,{"$f":"38.37+(E33-1)*1.0084782609","v":70.641304348799991},{"$f":"0+1*G33+22.1164065582532*(1.04166666666667+(G33-71.8416666666667)^2/3545.52083333333)^0.5","v":93.218170004846129}]
[34,null,75.77804347739999,53.158278647006227,34,null,71.649782609699997,94.222358047890253]
[35,null,76.67184782519999,54.028200847468895,35,null,72.658260870600003,95.232761458733009]
[36,null,77.565652172999989,54.893286559200952,36,null,73.666739131500009,96.249378647810744]
[37,null,78.459456520799989,55.753554133902483,37,null,74.6752173924,97.272202900933095]
[38,null,79.353260868599989,56.609024884845041,38,null,75.683695653299992,98.301222406932084]
[39,null,80.247065216399989,57.459723020127427,39,null,76.692173914199998,99.33642030613953]
[40,null,81.140869564199988,58.305675567669354,40,null,77.700652175100004,100.37777475923011]
[41,null,82.034673911999988,59.146912292474411,41,null,78.709130436000009,101.42525903577804]
[42,null,82.928478259799988,59.983465606738719,42,null,79.717608696900001,102.47884162169645]
[43,null,83.822282607599988,60.815370473418866,43,null,80.726086957799993,103.53848634456367]
[44,null,84.716086955399987,61.642664303903459,44,null,81.734565218699998,104.60415251569309]
[45,null,85.609891303199987,62.465386850455033,45,null,82.743043479600004,105.67579508767253]
[46,null,86.503695650999987,63.28358009410529,46,null,83.751521740499996,106.75336482599016]
[47,null,87.397499998799987,64.097288128693961,47,null,84.760000001400002,107.83680849327482]
[48,null,88.291304346599986,64.90655704174354,48,null,85.768478262299993,108.92606904461178]
[49,null,89.1851086944,65.711434792856025,49,null,86.776956523199999,110.02108583235142]
[50,null,90.0789130422,66.511971090306105,50,null,87.785434784100005,111.12179481880307]
[51,null,90.97271739,67.308217266487532,51,null,88.793913044999996,112.22812879520623]
[52,null,91.866521737799999,68.100226152846474,52,null,89.802391305900002,113.34001760538773]
[53,null,92.760326085599999,68.888051954907823,53,null,90.810869566799994,114.45738837254922]
[54,null,93.654130433399999,69.67175012796902,54,null,91.8193478277,115.58016572768318]
[55,null,94.547934781199999,70.451377254001088,55,null,92.827826088600006,116.70827203818109]
[56,null,95.441739128999998,71.226990920258203,56,null,93.836304349499997,117.84162763527894]
[57,null,96.335543476799998,71.998649600058116,57,null,94.844782610399989,118.98015103907434]
[58,null,97.229347824599998,72.766412536153865,58,null,95.853260871299995,120.12375917994902]
[59,null,98.123152172399998,73.530339627075207,59,null,96.8617391322,121.27236761533442]
[60,null,99.016956520199997,74.290491316775942,60,null,97.870217393100006,122.42589074086804]
[61,null,99.910760867999997,75.046928487880663,61,null,98.878695653999998,123.58424199509821]
[62,null,100.8045652158,75.799712358782898,62,null,99.887173914899989,124.74733405700708]
[63,null,101.6983695636,76.54890438480632,63,null,100.8956521758,125.91507903573152]
[64,null,102.5921739114,77.29456616360082,64,null,101.9041304367,127.08738865196894]
[65,null,{"$f":"46.2825+(A65-1)*0.8938043478","v":103.4859782592},{"$f":"0+1*C65-22.1164065582532*(1.04166666666667+(C65-71.8416666666667)^2/3545.52083333333)^0.5","v":78.036759344908376},65,null,{"$f":"38.37+(E65-1)*1.0084782609","v":102.91260869760001},{"$f":"0+1*G65+22.1164065582532*(1.04166666666667+(G65-71.8416666666667)^2/3545.52083333333)^0.5","v":128.26417441065905}]
[66,null,104.379782607,78.77554554479795,66,null,103.92108695850001,129.44534776463081]
[67,null,105.2735869548,79.510986264434536,67,null,104.92956521939999,130.63082026899656]
[68,null,106.1673913026,80.243142813417691,68,null,105.9380434803,131.82050372616214]
[69,null,107.06119565039999,80.972076237694665,69,null,106.9465217412,133.01431032140087]
[70,null,107.95499999819999,81.697847252028154,70,null,107.95500000210001,134.21215274901186]

{"sheet":"ANOVA-v2","index":3,"n_rows":409,"n_cols":26,"rows_kept":409,"cut":false,"hidden":false,"merged":[[276,1,277,8],[279,1,281,8],[283,1,285,8],[286,1,289,8],[290,1,291,8]]}
[null,"XLSTAT 2023.2.0.1411 - ANOVA - Start time: 12/09/2023 at 18:29:19 / End time: 12/09/2023 at 18:29:23 / Microsoft Excel 16.016731"]
[null,"Data table: Workbook = demoANO3 (1).xls / Sheet = Data / Range = 'Data'!$H$1:$Q$5 / 5 rows and 10 columns"]
[null,"Constraints: a1=0"]
[null,"Interactions / Level: 2"]
[null,"Confidence interval (%): 95"]
[null,"Tolerance: 0,0001"]
[null,"Use least squares means: Yes"]
[]
[]
[]
[]
[null,"Summary statistics (Quantitative data):"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"Y",24,0,24,45.3,93.4,71.841666666666654,14.794473605889539]
[]
[]
[null,"Summary statistics (Qualitative data):"]
[]
[null,"Variable","Categories","Counts","Frequencies","%"]
[null,"Brand","1",8,8,33.333333333333336]
[null,"","2",8,8,33.333333333333336]
[null,"","3",8,8,33.333333333333336]
[null,"Power","500",12,12,50]
[null,"","600",12,12,50]
[null,"Time","4",12,12,50]
[null,"","8",12,12,50]
[]
[]
[null,"Correlation matrix:"]
[]
[null,null,"Brand-1","Brand-2","Brand-3","Power-500","Power-600","Time-4","Time-8","Brand-1*Power-500","Brand-1*Power-600","Brand-2*Power-500","Brand-2*Power-600","Brand-3*Power-500","Brand-3*Power-600","Brand-1*Time-4","Brand-1*Time-8","Brand-2*Time-4","Brand-2*Time-8","Brand-3*Time-4","Brand-3*Time-8","Power-500*Time-4","Power-500*Time-8","Power-600*Time-4","Power-600*Time-8","Y"]
[null,"Brand-1",1,-0.49999999999999994,-0.49999999999999994,0,0,0,0,0.63245553203367588,0.63245553203367588,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0.63245553203367588,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,0,0,0,0,0.33423621868705511]
[null,"Brand-2",-0.49999999999999994,1,-0.49999999999999994,0,0,0,0,-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0.63245553203367588,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0.63245553203367588,-0.31622776601683789,-0.31622776601683789,0,0,0,0,-0.14179101912652203]
[null,"Brand-3",-0.49999999999999994,-0.49999999999999994,1,0,0,0,0,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0.63245553203367588,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0.63245553203367588,0,0,0,0,-0.19244519956053083]
[null,"Power-500",0,0,0,1,-0.99999999999999989,0,0,0.44721359549995782,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0,0,0,0,0,0,0.57735026918962562,0.57735026918962562,-0.57735026918962562,-0.57735026918962562,-0.18930271267518198]
[null,"Power-600",0,0,0,-0.99999999999999989,1,0,0,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0.44721359549995782,0,0,0,0,0,0,-0.57735026918962562,-0.57735026918962562,0.57735026918962562,0.57735026918962562,0.18930271267518328]
[null,"Time-4",0,0,0,0,0,1,-0.99999999999999989,0,0,0,0,0,0,0.44721359549995782,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0.57735026918962562,-0.57735026918962562,0.57735026918962562,-0.57735026918962562,-0.55409882159939416]
[null,"Time-8",0,0,0,0,0,-0.99999999999999989,1,0,0,0,0,0,0,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0.44721359549995782,-0.44721359549995782,0.44721359549995782,-0.57735026918962562,0.57735026918962562,-0.57735026918962562,0.57735026918962562,0.55409882159939616]
[null,"Brand-1*Power-500",0.63245553203367588,-0.31622776601683789,-0.31622776601683789,0.44721359549995782,-0.44721359549995782,0,0,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.2581988897471611,0.2581988897471611,-0.2581988897471611,-0.2581988897471611,0.22026713446200533]
[null,"Brand-1*Power-600",0.63245553203367588,-0.31622776601683789,-0.31622776601683789,-0.44721359549995782,0.44721359549995782,0,0,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.2581988897471611,-0.2581988897471611,0.2581988897471611,0.2581988897471611,0.20251195656728799]
[null,"Brand-2*Power-500",-0.31622776601683789,0.63245553203367588,-0.31622776601683789,0.44721359549995782,-0.44721359549995782,0,0,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,0.2581988897471611,0.2581988897471611,-0.2581988897471611,-0.2581988897471611,-0.19118981414166894]
[null,"Brand-2*Power-600",-0.31622776601683789,0.63245553203367588,-0.31622776601683789,-0.44721359549995782,0.44721359549995782,0,0,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.2581988897471611,-0.2581988897471611,0.2581988897471611,0.2581988897471611,1.1836785263145754E-2]
[null,"Brand-3*Power-500",-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0.44721359549995782,-0.44721359549995782,0,0,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,0.2581988897471611,0.2581988897471611,-0.2581988897471611,-0.2581988897471611,-0.28305356064042581]
[null,"Brand-3*Power-600",-0.31622776601683789,-0.31622776601683789,0.63245553203367588,-0.44721359549995782,0.44721359549995782,0,0,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.2581988897471611,-0.2581988897471611,0.2581988897471611,0.2581988897471611,3.9627498489660538E-2]
[null,"Brand-1*Time-4",0.63245553203367588,-0.31622776601683789,-0.31622776601683789,0,0,0.44721359549995782,-0.44721359549995782,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.10370053176190264]
[null,"Brand-1*Time-8",0.63245553203367588,-0.31622776601683789,-0.31622776601683789,0,0,-0.44721359549995782,0.44721359549995782,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,0.31907855926739065]
[null,"Brand-2*Time-4",-0.31622776601683789,0.63245553203367588,-0.31622776601683789,0,0,0.44721359549995782,-0.44721359549995782,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,-0.63661319002219507]
[null,"Brand-2*Time-8",-0.31622776601683789,0.63245553203367588,-0.31622776601683789,0,0,-0.44721359549995782,0.44721359549995782,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,-0.19999999999999996,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,0.45726016114367146]
[null,"Brand-3*Time-4",-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0,0,0.44721359549995782,-0.44721359549995782,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.19999999999999996,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,-0.21048892054897075]
[null,"Brand-3*Time-8",-0.31622776601683789,-0.31622776601683789,0.63245553203367588,0,0,-0.44721359549995782,0.44721359549995782,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,0.39999999999999997,0.39999999999999997,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,-0.19999999999999996,1,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-3.2937141601794097E-2]
[null,"Power-500*Time-4",0,0,0,0.57735026918962562,-0.57735026918962562,0.57735026918962562,-0.57735026918962562,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,1,-0.33333333333333331,-0.33333333333333331,-0.33333333333333331,-0.42820647435991238]
[null,"Power-500*Time-8",0,0,0,0.57735026918962562,-0.57735026918962562,-0.57735026918962562,0.57735026918962562,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.33333333333333331,1,-0.33333333333333331,-0.33333333333333331,0.209618530117227]
[null,"Power-600*Time-4",0,0,0,-0.57735026918962562,0.57735026918962562,0.57735026918962562,-0.57735026918962562,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,-0.33333333333333331,-0.33333333333333331,1,-0.33333333333333331,-0.21161173325621738]
[null,"Power-600*Time-8",0,0,0,-0.57735026918962562,0.57735026918962562,-0.57735026918962562,0.57735026918962562,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.2581988897471611,0.2581988897471611,-0.33333333333333331,-0.33333333333333331,-0.33333333333333331,1,0.43019967749890431]
[null,"Y",0.33423621868705511,-0.14179101912652203,-0.19244519956053083,-0.18930271267518198,0.18930271267518328,-0.55409882159939416,0.55409882159939616,0.22026713446200533,0.20251195656728799,-0.19118981414166894,1.1836785263145754E-2,-0.28305356064042581,3.9627498489660538E-2,0.10370053176190264,0.31907855926739065,-0.63661319002219507,0.45726016114367146,-0.21048892054897075,-3.2937141601794097E-2,-0.42820647435991238,0.209618530117227,-0.21161173325621738,0.43019967749890431,1]
[]
[]
[null,"Regression of variable Y:"]
[]
[null,"Goodness of fit statistics (Y):"]
[]
[null,"Observations",24]
[null,"Sum of weights",24]
[null,"DF",14]
[null,"R²",0.70429267388292138]
[null,"Adjusted R²",0.5141951070933708]
[null,"MSE",106.33125000000062]
[null,"RMSE",10.31170451477352]
[null,"MAPE",9.8151009820582402]
[null,"DW",3.0545155595301043]
[null,"Cp",10]
[null,"AIC",119.0615052971751]
[null,"AICC",135.98458222025204]
[null,"SBC",130.84204360065456]
[null,"PC",0.71814636342719107]
[]
[]
[null,"Analysis of variance (Y):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F","p-values signification codes"]
[null,"Model",9,3545.5208333333221,393.94675925925799,3.7049010451702173,1.4195317549933334E-2,"*"]
[null,"Error",14,1488.6375000000087,106.33125000000062,null,null,""]
[null,"Corrected Total",23,5034.158333333331,null,null,null,""]
[null,"Computed against model Y=Mean(Y)"]
[null,"Signification codes: 0 < *** < 0.001 < ** < 0.01 < * < 0.05 < . < 0.1 < ° < 1"]
[]
[]
[null,"Type I Sum of Squares analysis (Y):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F","p-values signification codes"]
[null,"Brand",2,566.69083333332401,283.345416666662,2.6647426477790899,0.1045572665815753,"°"]
[null,"Power",1,180.40166666666721,180.40166666666721,1.696600638727243,0.21375331725616711,"°"]
[null,"Time",1,1545.6150000000048,1545.6150000000048,14.535849056603734,1.9029165023294401E-3,"**"]
[null,"Brand*Power",2,125.12583333333214,62.562916666666069,0.58837751523343984,0.5683865342033747,"°"]
[null,"Brand*Time",2,1127.6724999999947,563.83624999999734,5.3026391582906625,1.930626562155564E-2,"*"]
[null,"Power*Time",1,1.5000000000327418E-2,1.5000000000327418E-2,1.4106859460720465E-4,0.99069115953367959,"°"]
[null,"Signification codes: 0 < *** < 0.001 < ** < 0.01 < * < 0.05 < . < 0.1 < ° < 1"]
[]
[]
[null,"Type II Sum of Squares analysis (Y):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F","p-values signification codes"]
[null,"Brand",2,566.69083333332401,283.345416666662,2.6647426477790899,0.1045572665815753,"°"]
[null,"Power",1,180.40166666666721,180.40166666666721,1.696600638727243,0.21375331725616711,"°"]
[null,"Time",1,1545.6150000000048,1545.6150000000048,14.535849056603734,1.9029165023294401E-3,"**"]
[null,"Brand*Power",2,125.12583333333214,62.562916666666069,0.58837751523343984,0.5683865342033747,"°"]
[null,"Brand*Time",2,1127.6724999999947,563.83624999999734,5.3026391582906625,1.930626562155564E-2,"*"]
[null,"Power*Time",1,1.5000000000327418E-2,1.5000000000327418E-2,1.4106859460720465E-4,0.99069115953367959,"°"]
[null,"Signification codes: 0 < *** < 0.001 < ** < 0.01 < * < 0.05 < . < 0.1 < ° < 1"]
[]
[]
[null,"Type III Sum of Squares analysis (Y):"]
[]
[null,"Source","DF","Sum of squares","Mean squares","F","Pr > F","p-values signification codes"]
[null,"Brand",2,566.69083333332401,283.345416666662,2.6647426477790899,0.1045572665815753,"°"]
[null,"Power",1,180.40166666666721,180.40166666666721,1.696600638727243,0.21375331725616711,"°"]
[null,"Time",1,1545.6150000000048,1545.6150000000048,14.535849056603734,1.9029165023294401E-3,"**"]
[null,"Brand*Power",2,125.12583333333214,62.562916666666069,0.58837751523343984,0.5683865342033747,"°"]
[null,"Brand*Time",2,1127.6724999999947,563.83624999999734,5.3026391582906625,1.930626562155564E-2,"*"]
[null,"Power*Time",1,1.5000000000327418E-2,1.5000000000327418E-2,1.4106859460720465E-4,0.99069115953367959,"°"]
[null,"Signification codes: 0 < *** < 0.001 < ** < 0.01 < * < 0.05 < . < 0.1 < ° < 1"]
[]
[]
[null,"Model parameters (Y):"]
[]
[null,"Source","Value","Standard error","t","Pr > |t|","Lower bound (95%)","Upper bound (95%)","p-values signification codes"]
[null,"Intercept",75.512499999999832,6.6561766427882736,11.344725966943034,1.9164964379668114E-8,61.236420953655305,89.788579046344353,"***"]
[null,"Brand-1",0,0,null,null,null,null,""]
[null,"Brand-2",-27.549999999999809,8.9301980661125526,-3.0850379572815827,8.0686217201919597E-3,-46.703369919871854,-8.396630080127764,"**"]
[null,"Brand-3",-15.687499999999815,8.9301980661125526,-1.7566799620636875,0.10081172655664306,-34.840869919871864,3.4658699198722296,"°"]
[null,"Power-500",0,0,null,null,null,null,""]
[null,"Power-600",-0.62499999999992695,8.4194714798495678,-7.4232688060734894E-2,0.94187547583281717,-18.682970337221203,17.432970337221352,"°"]
[null,"Time-4",0,0,null,null,null,null,""]
[null,"Time-8",6.9250000000001117,8.4194714798495678,0.82249818371305206,0.42458139936685946,-11.132970337221167,24.982970337221388,"°"]
[null,"Brand-1*Power-500",0,0,null,null,null,null,""]
[null,"Brand-1*Power-600",0,0,null,null,null,null,""]
[null,"Brand-2*Power-500",0,0,null,null,null,null,""]
[null,"Brand-2*Power-600",7.1499999999999195,10.311704514773512,0.69338681977903471,0.4994097692344146,-14.966406558253283,29.266406558253124,"°"]
[null,"Brand-3*Power-500",0,0,null,null,null,null,""]
[null,"Brand-3*Power-600",11.02499999999992,10.311704514773512,1.0691733829459984,0.30308017437241963,-11.091406558253283,33.141406558253124,"°"]
[null,"Brand-1*Time-4",0,0,null,null,null,null,""]
[null,"Brand-1*Time-8",0,0,null,null,null,null,""]
[null,"Brand-2*Time-4",0,0,null,null,null,null,""]
[null,"Brand-2*Time-8",28.449999999999864,10.311704514773512,2.7590007024774357,1.5370857785689473E-2,6.3335934417466611,50.566406558253064,"*"]
[null,"Brand-3*Time-4",0,0,null,null,null,null,""]
[null,"Brand-3*Time-8",-1.2250000000001013,10.311704514773512,-0.11879704254956606,0.90712390649213415,-23.341406558253304,20.891406558253102,"°"]
[null,"Power-500*Time-4",0,0,null,null,null,null,""]
[null,"Power-500*Time-8",0,0,null,null,null,null,""]
[null,"Power-600*Time-4",0,0,null,null,null,null,""]
[null,"Power-600*Time-8",9.9999999999990499E-2,8.4194714798495713,1.1877230089717838E-2,0.99069115953373066,-17.957970337221294,18.157970337221276,"°"]
[null,"Signification codes: 0 < *** < 0.001 < ** < 0.01 < * < 0.05 < . < 0.1 < ° < 1"]
[]
[]
[null,"Equation of the model (Y):"]
[]
[null,"Y = 75,5124999999998-27,5499999999998*Brand-2-15,6874999999998*Brand-3-0,624999999999927*Power-600+6,92500000000011*Time-8+7,14999999999992*Brand-2*Power-600+11,0249999999999*Brand-3*Power-600+28,4499999999999*Brand-2*Time-8-1,2250000000001*Brand-3*Time-8+9,99999999999905E-02*Power-600*Time-8"]
[]
[]
[null,"Standardized coefficients (Y):"]
[]
[null,"Source","Value","Standard error","t","Pr > |t|","Lower bound (95%)","Upper bound (95%)","p-values signification codes"]
[null,"Brand-1",0,0,null,null,null,null,""]
[null,"Brand-2",-0.89672139499241121,0.29066786451553672,-3.0850379572815827,8.0686217201919597E-3,-1.5201419609943518,-0.27330082899047048,"**"]
[null,"Brand-3",-0.51061041321028611,0.29066786451553672,-1.7566799620636875,0.10081172655664306,-1.134030979212227,0.11281015279165463,"°"]
[null,"Power-500",0,0,null,null,null,null,""]
[null,"Power-600",-2.1577056915861779E-2,0.29066786451553656,-7.4232688060734894E-2,0.94187547583281717,-0.64499762291780216,0.60184350908607864,"°"]
[null,"Time-4",0,0,null,null,null,null,""]
[null,"Time-8",0.23907379062778034,0.29066786451553656,0.82249818371305217,0.42458139936685946,-0.38434677537416007,0.86249435662972074,"°"]
[null,"Brand-1*Power-500",0,0,null,null,null,null,""]
[null,"Brand-1*Power-600",0,0,null,null,null,null,""]
[null,"Brand-2*Power-500",0,0,null,null,null,null,""]
[null,"Brand-2*Power-600",0.18398481441627523,0.26534224356169134,0.69338681977903482,0.4994097692344146,-0.38511769693689313,0.75308732576944359,"°"]
[null,"Brand-3*Power-500",0,0,null,null,null,null,""]
[null,"Brand-3*Power-600",0.28369686418733464,0.26534224356169139,1.0691733829459984,0.30308017437241963,-0.28540564716583383,0.85279937554050311,"°"]
[null,"Brand-1*Time-4",0,0,null,null,null,null,""]
[null,"Brand-1*Time-8",0,0,null,null,null,null,""]
[null,"Brand-2*Time-4",0,0,null,null,null,null,""]
[null,"Brand-2*Time-8",0.73207943638364537,0.26534224356169134,2.7590007024774361,1.5370857785689473E-2,0.162976925030477,1.3011819477368136,"*"]
[null,"Brand-3*Time-4",0,0,null,null,null,null,""]
[null,"Brand-3*Time-8",-3.152187379859557E-2,0.26534224356169139,-0.11879704254956605,0.90712390649213415,-0.60062438515176408,0.53758063755457286,"°"]
[null,"Power-500*Time-4",0,0,null,null,null,null,""]
[null,"Power-500*Time-8",0,0,null,null,null,null,""]
[null,"Power-600*Time-4",0,0,null,null,null,null,""]
[null,"Power-600*Time-8",2.9898047084863069E-3,0.25172575473422815,1.1877230089717838E-2,0.99069115953373066,-0.53690824269086757,0.54288785210784019,"°"]
[null,"Signification codes: 0 < *** < 0.001 < ** < 0.01 < * < 0.05 < . < 0.1 < ° < 1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Predictions and residuals (Y):"]
[]
[null,"Observation","Weight","Y","Pred(Y)","Residual","Std. residual","Std. dev. on pred. (Mean)","Lower bound 95% (Mean)","Upper bound 95% (Mean)","Std. dev. on pred. (Observation)","Lower bound 95% (Observation)","Upper bound 95% (Observation)"]
[null,"Obs1",1,70.3,82.437499999999943,-12.137499999999946,-1.1770604930165152,6.6561766427882745,68.161420953655409,96.713579046344478,12.27338329475621,56.113710911279767,108.76128908872012]
[null,"Obs2",1,91,82.437499999999943,8.5625000000000568,0.83036708312700502,6.6561766427882745,68.161420953655409,96.713579046344478,12.27338329475621,56.113710911279767,108.76128908872012]
[null,"Obs3",1,72.7,75.512499999999832,-2.8124999999998295,-0.27274831197600519,6.6561766427882763,61.236420953655298,89.788579046344367,12.273383294756211,49.188710911279657,101.83628908872001]
[null,"Obs4",1,81.900000000000006,75.512499999999832,6.3875000000001734,0.61944172186555946,6.6561766427882763,61.236420953655298,89.788579046344367,12.273383294756211,49.188710911279657,101.83628908872001]
[null,"Obs5",1,78.7,81.912500000000009,-3.2125000000000057,-0.31153918301261202,6.6561766427882754,67.636420953655474,96.188579046344543,12.27338329475621,55.588710911279833,108.23628908872018]
[null,"Obs6",1,88.7,81.912500000000009,6.7874999999999943,0.65823259290213187,6.6561766427882754,67.636420953655474,96.188579046344543,12.27338329475621,55.588710911279833,108.23628908872018]
[null,"Obs7",1,74.099999999999994,74.887499999999903,-0.78749999999990905,-7.6369527353277261E-2,6.6561766427882754,60.611420953655376,89.163579046344438,12.27338329475621,48.563710911279728,101.21128908872008]
[null,"Obs8",1,72.099999999999994,74.887499999999903,-2.7874999999999091,-0.27032388253622608,6.6561766427882754,60.611420953655376,89.163579046344438,12.27338329475621,48.563710911279728,101.21128908872008]
[null,"Obs9",1,93.4,83.337499999999991,10.062500000000014,0.97583284951421245,6.6561766427882789,69.061420953655457,97.613579046344526,12.273383294756213,57.013710911279802,109.66128908872018]
[null,"Obs10",1,76.3,83.337499999999991,-7.0374999999999943,-0.68247688730000056,6.6561766427882789,69.061420953655457,97.613579046344526,12.273383294756213,57.013710911279802,109.66128908872018]
[null,"Obs11",1,45.3,47.96250000000002,-2.6625000000000227,-0.25820173533730278,6.6561766427882798,33.686420953655485,62.238579046344555,12.273383294756213,21.638710911279833,74.28628908872021]
[null,"Obs12",1,47.6,47.96250000000002,-0.36250000000001847,-3.5154226876911263E-2,6.6561766427882798,33.686420953655485,62.238579046344555,12.273383294756213,21.638710911279833,74.28628908872021]
[null,"Obs13",1,92.2,89.962499999999977,2.2375000000000256,0.21698643486092645,6.656176642788278,75.686420953655443,104.23857904634451,12.273383294756213,63.638710911279787,116.28628908872017]
[null,"Obs14",1,84.7,89.962499999999977,-5.2624999999999744,-0.51034239707513152,6.656176642788278,75.686420953655443,104.23857904634451,12.273383294756213,63.638710911279787,116.28628908872017]
[null,"Obs15",1,66.3,54.487500000000011,11.812499999999986,1.14554291029929,6.6561766427882789,40.211420953655477,68.763579046344546,12.273383294756213,28.163710911279825,80.811289088720201]
[null,"Obs16",1,45.7,54.487500000000011,-8.7875000000000085,-0.85218694808508211,6.6561766427882789,40.211420953655477,68.763579046344546,12.273383294756213,28.163710911279825,80.811289088720201]
[null,"Obs17",1,50.1,65.52500000000002,-15.425000000000018,-1.4958729643484943,6.6561766427882798,51.248920953655485,79.801079046344555,12.273383294756213,39.20121091127983,91.84878908872021]
[null,"Obs18",1,81.5,65.52500000000002,15.97499999999998,1.5492104120238015,6.6561766427882798,51.248920953655485,79.801079046344555,12.273383294756213,39.20121091127983,91.84878908872021]
[null,"Obs19",1,51.4,59.825000000000017,-8.4250000000000185,-0.81703272120817361,6.6561766427882807,45.548920953655475,74.101079046344552,12.273383294756213,33.501210911279827,86.148789088720207]
[null,"Obs20",1,67.7,59.825000000000017,7.8749999999999858,0.76369527353285949,6.6561766427882807,45.548920953655475,74.101079046344552,12.273383294756213,33.501210911279827,86.148789088720207]
[null,"Obs21",1,71.5,76.025000000000006,-4.5250000000000057,-0.43882172860142221,6.6561766427882816,61.748920953655464,90.30107904634454,12.273383294756213,49.701210911279816,102.3487890887202]
[null,"Obs22",1,80,76.025000000000006,3.9749999999999943,0.38548428092611015,6.6561766427882816,61.748920953655464,90.30107904634454,12.273383294756213,49.701210911279816,102.3487890887202]
[null,"Obs23",1,64,70.225000000000009,-6.2250000000000085,-0.60368293050692889,6.6561766427882807,55.948920953655467,84.501079046344543,12.273383294756213,43.901210911279819,96.548789088720198]
[null,"Obs24",1,77,70.225000000000009,6.7749999999999915,0.65702037818223824,6.6561766427882807,55.948920953655467,84.501079046344543,12.273383294756213,43.901210911279819,96.548789088720198]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Interpretation (Y):"]
[]
[null,"Given the R2, 70% of the variability of the dependent variable Y is explained by the 6 explanatory variables."]
[]
[]
[null,"Given the p-value of the F statistic computed in the ANOVA table, and given the significance level of 5%, the information brought by the explanatory variables is significantly better than what a basic mean would bring."]
[]
[]
[]
[null,"Based on the Type III sum of squares, the following variables bring significant information to explain the variability of the dependent variable Y: Time,Brand*Time."]
[]
[]
[null,"Based on the Type III sum of squares, the following variables do not bring significant information to explain the variability of the dependent variable Y: Brand,Power,Brand*Power,Power*Time. You might want to remove them from the model."]
[]
[]
[]
[null,"Among the explanatory variables, based on the Type III sum of squares, variable Time is the most influential."]
[]
[]
[]
[]
[null,"LS Means for factor Brand:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"1",78.687499999999929,3.6457380939941455,70.868169473590186,86.506830526409672]
[null,"2",68.9375,3.6457380939941486,61.118169473590257,76.756830526409743]
[null,"3",67.900000000000006,3.6457380939941464,60.080669473590262,75.719330526409749]
[]
[]
[null,"Brand*Power:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"Brand-1*Power-500",78.974999999999895,5.1558522573867567,67.916796720873293,90.033203279126496]
[null,"Brand-1*Power-600",78.399999999999963,5.1558522573867576,67.341796720873361,89.458203279126565]
[null,"Brand-2*Power-500",65.650000000000006,5.155852257386762,54.59179672087339,76.708203279126622]
[null,"Brand-2*Power-600",72.224999999999994,5.155852257386762,61.166796720873378,83.28320327912661]
[null,"Brand-3*Power-500",62.675000000000018,5.1558522573867611,51.616796720873403,73.733203279126627]
[null,"Brand-3*Power-600",73.125,5.155852257386762,62.066796720873384,84.183203279126616]
[]
[]
[null,"Brand\\Power","500","600"]
[null,"1",78.974999999999895,78.399999999999963]
[null,"2",65.650000000000006,72.224999999999994]
[null,"3",62.675000000000018,73.125]
[]
[]
[null,"Brand*Time:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"Brand-1*Time-4",75.199999999999875,5.1558522573867567,64.141796720873273,86.258203279126477]
[null,"Brand-1*Time-8",82.174999999999983,5.1558522573867576,71.116796720873381,93.233203279126585]
[null,"Brand-2*Time-4",51.225000000000016,5.155852257386762,40.1667967208734,62.283203279126631]
[null,"Brand-2*Time-8",86.649999999999991,5.1558522573867549,75.59179672087339,97.708203279126593]
[null,"Brand-3*Time-4",65.025000000000006,5.1558522573867611,53.96679672087339,76.083203279126622]
[null,"Brand-3*Time-8",70.77500000000002,5.1558522573867576,59.716796720873418,81.833203279126622]
[]
[]
[null,"Brand\\Time","4","8"]
[null,"1",75.199999999999875,82.174999999999983]
[null,"2",51.225000000000016,86.649999999999991]
[null,"3",65.025000000000006,70.77500000000002]
[]
[]
[null,"LS Means for factor Power:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"500",69.09999999999998,2.9767326887041858,62.715543360042631,75.48445663995733]
[null,"600",74.583333333333329,2.9767326887041867,68.198876693375979,80.967789973290678]
[]
[]
[null,"Power*Brand:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"Brand-1*Power-500",78.974999999999895,5.1558522573867567,67.916796720873293,90.033203279126496]
[null,"Brand-1*Power-600",78.399999999999963,5.1558522573867576,67.341796720873361,89.458203279126565]
[null,"Brand-2*Power-500",65.650000000000006,5.155852257386762,54.59179672087339,76.708203279126622]
[null,"Brand-2*Power-600",72.224999999999994,5.155852257386762,61.166796720873378,83.28320327912661]
[null,"Brand-3*Power-500",62.675000000000018,5.1558522573867611,51.616796720873403,73.733203279126627]
[null,"Brand-3*Power-600",73.125,5.155852257386762,62.066796720873384,84.183203279126616]
[]
[]
[null,"Power\\Brand","1","2","3"]
[null,"500",78.974999999999895,65.650000000000006,62.675000000000018]
[null,"600",78.399999999999963,72.224999999999994,73.125]
[]
[]
[null,"Power*Time:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"Power-500*Time-4",61.099999999999959,4.2097357399247866,52.071014831389313,70.128985168610598]
[null,"Power-500*Time-8",77.099999999999994,4.2097357399247848,68.071014831389348,86.12898516861064]
[null,"Power-600*Time-4",66.533333333333303,4.2097357399247848,57.504348164722664,75.562318501943949]
[null,"Power-600*Time-8",82.63333333333334,4.2097357399247892,73.604348164722694,91.662318501943986]
[]
[]
[null,"Power\\Time","4","8"]
[null,"500",61.099999999999959,77.099999999999994]
[null,"600",66.533333333333303,82.63333333333334]
[]
[]
[null,"LS Means for factor Time:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"4",63.816666666666634,2.9767326887041858,57.432210026709285,70.201123306623984]
[null,"8",79.86666666666666,2.9767326887041876,73.482210026709311,86.25112330662401]
[]
[]
[null,"Time*Brand:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"Brand-1*Time-4",75.199999999999875,5.1558522573867567,64.141796720873273,86.258203279126477]
[null,"Brand-1*Time-8",82.174999999999983,5.1558522573867576,71.116796720873381,93.233203279126585]
[null,"Brand-2*Time-4",51.225000000000016,5.155852257386762,40.1667967208734,62.283203279126631]
[null,"Brand-2*Time-8",86.649999999999991,5.1558522573867549,75.59179672087339,97.708203279126593]
[null,"Brand-3*Time-4",65.025000000000006,5.1558522573867611,53.96679672087339,76.083203279126622]
[null,"Brand-3*Time-8",70.77500000000002,5.1558522573867576,59.716796720873418,81.833203279126622]
[]
[]
[null,"Time\\Brand","1","2","3"]
[null,"4",75.199999999999875,51.225000000000016,65.025000000000006]
[null,"8",82.174999999999983,86.649999999999991,70.77500000000002]
[]
[]
[null,"Time*Power:"]
[]
[null,"Category","LS mean","Standard error","Lower bound (95%)","Upper bound (95%)"]
[null,"Power-500*Time-4",61.099999999999959,4.2097357399247866,52.071014831389313,70.128985168610598]
[null,"Power-500*Time-8",77.099999999999994,4.2097357399247848,68.071014831389348,86.12898516861064]
[null,"Power-600*Time-4",66.533333333333303,4.2097357399247848,57.504348164722664,75.562318501943949]
[null,"Power-600*Time-8",82.63333333333334,4.2097357399247892,73.604348164722694,91.662318501943986]
[]
[]
[null,"Time\\Power","500","600"]
[null,"4",61.099999999999959,66.533333333333303]
[null,"8",77.099999999999994,82.63333333333334]

{"sheet":"XLSTAT_20230912_182916_1_HID","index":4,"n_rows":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
[1,null,{"$f":"46.2825+(A1-1)*0.8938043478","v":46.282499999999999},{"$f":"0+1*C1-22.1164065582532*(1.04166666666667+(C1-71.8416666666667)^2/3545.52083333333)^0.5","v":21.794941949985979},1,null,{"$f":"38.37+(E1-1)*1.0084782609","v":38.369999999999997},{"$f":"0+1*G1+22.1164065582532*(1.04166666666667+(G1-71.8416666666667)^2/3545.52083333333)^0.5","v":64.139719647158913}]
[2,null,47.176304347799999,22.815528317575961,2,null,39.378478260899996,64.969590843603441]
[3,null,48.070108695599998,23.832230386215233,3,null,40.386956521799995,65.803727590864412]
[4,null,48.963913043399998,24.844988778619335,4,null,41.395434782700001,66.642218256304147]
[5,null,49.857717391199998,25.85374486489134,5,null,42.403913043599999,67.485151365861256]
[6,null,50.751521738999998,26.858440878608409,6,null,43.412391304499998,68.332615453216548]
[7,null,51.645326086799997,27.859020035575579,7,null,44.420869565399997,69.184698899646307]
[8,null,52.539130434599997,28.855426654834165,8,null,45.429347826299995,70.041489764747254]
[9,null,53.432934782399997,29.847606281470696,9,null,46.437826087199994,70.903075608307773]
[10,null,54.326739130199996,30.835505810732155,10,null,47.4463043481,71.769543303696523]
[11,null,55.220543477999996,31.819073612915052,11,null,48.454782608999999,72.640978843241257]
[12,null,56.114347825799996,32.798259658460353,12,null,49.463260869899997,73.517467136176947]
[13,null,57.008152173599996,33.773015642653846,13,null,50.471739130799996,74.399091799851433]
[14,null,57.901956521399995,34.743295109303347,14,null,51.480217391699995,75.285934944987943]
[15,null,58.795760869199995,35.709053572739656,15,null,52.488695652600001,76.178076955915515]
[16,null,59.689565216999995,36.670248637470294,16,null,53.497173913499999,77.075596266787784]
[17,null,60.583369564799995,37.626840114801226,17,null,54.505652174399998,77.978569134917734]
[18,null,61.477173912599994,38.57879013573519,18,null,55.514130435299997,78.887069412456782]
[19,null,62.370978260399994,39.52606325945537,19,null,56.522608696199995,79.801168317740647]
[20,null,63.264782608199994,40.468626576709539,20,null,57.531086957100001,80.720934207708268]
[21,null,64.158586955999994,41.40644980742411,21,null,58.539565218,81.646432352872694]
[22,null,65.052391303799993,42.339505391899024,22,null,59.548043478899999,82.577724716380658]
[23,null,65.946195651599993,43.267768574963334,23,null,60.556521739799997,83.514869738740842]
[24,null,66.839999999399993,44.191217482507419,24,null,61.565000000699996,84.457922129824709]
[25,null,67.733804347199992,45.109833189851301,25,null,62.573478261600002,85.406932669749864]
[26,null,68.627608694999992,46.023599781458437,26,null,63.581956522499993,86.361948020240774]
[27,null,69.521413042799992,46.93250440156055,27,null,64.590434783399999,87.323010548025081]
[28,null,70.415217390599992,47.836537295321349,28,null,65.598913044299991,88.290158161765262]
[29,null,71.309021738399991,48.735691840233073,29,null,66.607391305199997,89.26342416394553]
[30,null,72.202826086199991,49.629964567511323,30,null,67.615869566100002,90.24283711903152]
[31,null,73.096630433999991,50.519355173327156,31,null,68.624347826999994,91.228420739098567]
[32,null,73.990434781799991,51.403866519791748,32,null,69.6328260879,92.220193787982168]
[33,null,{"$f":"46.2825+(A33-1)*0.8938043478","v":74.88423912959999},{"$f":"0+1*C33-22.1164065582532*(1.04166666666667+(C33-71.8416666666667)^2/3545.52083333333)^0.5","v":52.283504625686163},33,null,{"$f":"38.37+(E33-1)*1.0084782609","v":70.641304348799991},{"$f":"0+1*G33+22.1164065582532*(1.04166666666667+(G33-71.8416666666667)^2/3545.52083333333)^0.5","v":93.218170004846129}]
[34,null,75.77804347739999,53.158278647006227,34,null,71.649782609699997,94.222358047890253]
[35,null,76.67184782519999,54.028200847468895,35,null,72.658260870600003,95.232761458733009]
[36,null,77.565652172999989,54.893286559200952,36,null,73.666739131500009,96.249378647810744]
[37,null,78.459456520799989,55.753554133902483,37,null,74.6752173924,97.272202900933095]
[38,null,79.353260868599989,56.609024884845041,38,null,75.683695653299992,98.301222406932084]
[39,null,80.247065216399989,57.459723020127427,39,null,76.692173914199998,99.33642030613953]
[40,null,81.140869564199988,58.305675567669354,40,null,77.700652175100004,100.37777475923011]
[41,null,82.034673911999988,59.146912292474411,41,null,78.709130436000009,101.42525903577804]
[42,null,82.928478259799988,59.983465606738719,42,null,79.717608696900001,102.47884162169645]
[43,null,83.822282607599988,60.815370473418866,43,null,80.726086957799993,103.53848634456367]
[44,null,84.716086955399987,61.642664303903459,44,null,81.734565218699998,104.60415251569309]
[45,null,85.609891303199987,62.465386850455033,45,null,82.743043479600004,105.67579508767253]
[46,null,86.503695650999987,63.28358009410529,46,null,83.751521740499996,106.75336482599016]
[47,null,87.397499998799987,64.097288128693961,47,null,84.760000001400002,107.83680849327482]
[48,null,88.291304346599986,64.90655704174354,48,null,85.768478262299993,108.92606904461178]
[49,null,89.1851086944,65.711434792856025,49,null,86.776956523199999,110.02108583235142]
[50,null,90.0789130422,66.511971090306105,50,null,87.785434784100005,111.12179481880307]
[51,null,90.97271739,67.308217266487532,51,null,88.793913044999996,112.22812879520623]
[52,null,91.866521737799999,68.100226152846474,52,null,89.802391305900002,113.34001760538773]
[53,null,92.760326085599999,68.888051954907823,53,null,90.810869566799994,114.45738837254922]
[54,null,93.654130433399999,69.67175012796902,54,null,91.8193478277,115.58016572768318]
[55,null,94.547934781199999,70.451377254001088,55,null,92.827826088600006,116.70827203818109]
[56,null,95.441739128999998,71.226990920258203,56,null,93.836304349499997,117.84162763527894]
[57,null,96.335543476799998,71.998649600058116,57,null,94.844782610399989,118.98015103907434]
[58,null,97.229347824599998,72.766412536153865,58,null,95.853260871299995,120.12375917994902]
[59,null,98.123152172399998,73.530339627075207,59,null,96.8617391322,121.27236761533442]
[60,null,99.016956520199997,74.290491316775942,60,null,97.870217393100006,122.42589074086804]
[61,null,99.910760867999997,75.046928487880663,61,null,98.878695653999998,123.58424199509821]
[62,null,100.8045652158,75.799712358782898,62,null,99.887173914899989,124.74733405700708]
[63,null,101.6983695636,76.54890438480632,63,null,100.8956521758,125.91507903573152]
[64,null,102.5921739114,77.29456616360082,64,null,101.9041304367,127.08738865196894]
[65,null,{"$f":"46.2825+(A65-1)*0.8938043478","v":103.4859782592},{"$f":"0+1*C65-22.1164065582532*(1.04166666666667+(C65-71.8416666666667)^2/3545.52083333333)^0.5","v":78.036759344908376},65,null,{"$f":"38.37+(E65-1)*1.0084782609","v":102.91260869760001},{"$f":"0+1*G65+22.1164065582532*(1.04166666666667+(G65-71.8416666666667)^2/3545.52083333333)^0.5","v":128.26417441065905}]
[66,null,104.379782607,78.77554554479795,66,null,103.92108695850001,129.44534776463081]
[67,null,105.2735869548,79.510986264434536,67,null,104.92956521939999,130.63082026899656]
[68,null,106.1673913026,80.243142813417691,68,null,105.9380434803,131.82050372616214]
[69,null,107.06119565039999,80.972076237694665,69,null,106.9465217412,133.01431032140087]
[70,null,107.95499999819999,81.697847252028154,70,null,107.95500000210001,134.21215274901186]