{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Mixed Models"],"not_rendered":{"charts":0,"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":"Sheet1","index":0,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["ingot ","metal","pressure"]
[1,"n",67]
[1,"i",71.900000000000006]
[1,"c",72.2]
[2,"n",67.5]
[2,"i",68.8]
[2,"c",66.400000000000006]
[3,"n",76]
[3,"i",82.6]
[3,"c",74.5]
[4,"n",72.7]
[4,"i",78.099999999999994]
[4,"c",67.3]
[5,"n",73.099999999999994]
[5,"i",74.2]
[5,"c",73.2]
[6,"n",65.8]
[6,"i",70.8]
[6,"c",68.7]
[7,"n",75.599999999999994]
[7,"i",84.9]
[7,"c",69]

{"sheet":"Mixed Models","index":1,"n_rows":109,"n_cols":9,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2024.2.2.1423 - Mixed Models - Start time: 12/07/2024 at 08:38:26 / End time: 12/07/2024 at 08:38:29 / Microsoft Excel 16.017726"]
[null,"Y / Quantitative: Workbook = DemoMix.xlsx / Sheet = Sheet1 / Range = 'Sheet1'!$C:$C / 21 rows and 1 column"]
[null,"X / Qualitative: Workbook = DemoMix.xlsx / Sheet = Sheet1 / Range = 'Sheet1'!$A:$B / 21 rows and 2 columns"]
[null,"Random effects:"]
[null,"Covariance structure: Variance components"]
[null,"Estimation method: REML"]
[null,"Constraints: an=0"]
[null,"Confidence interval (%): 95"]
[]
[]
[]
[]
[null,"Summary statistics:"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"pressure",21,0,21,65.8,84.9,72.395238095238113,5.1217649487726566]
[]
[]
[null,"Variable","Categories","Frequencies","%"]
[null,"ingot",1,3,14.285714285714286]
[null,null,2,3,14.285714285714286]
[null,null,3,3,14.285714285714286]
[null,null,4,3,14.285714285714286]
[null,null,5,3,14.285714285714286]
[null,null,6,3,14.285714285714286]
[null,null,7,3,14.285714285714286]
[null,"metal","n",7,33.333333333333336]
[null,null,"i",7,33.333333333333336]
[null,null,"c",7,33.333333333333336]
[]
[]
[null,"Regression of variable pressure:"]
[]
[null,"Goodness of fit statistics:"]
[]
[null,"Observations",21]
[null,"Sum of weights",21]
[null,"-2 Res Log(Likelihood)",107.79020201448462]
[null,"AIC",117.79020201448462]
[null,"AICC",121.79020201448462]
[null,"SBC",123.01281420310174]
[null,"CAIC",128.01281420310173]
[null,"Iterations",7]
[null,"Covariance parameters",2]
[null,"Number of fixed effects",1]
[null,"Number of random effects",1]
[null,"Number of subjects",1]
[null,"Maximum number of observations per subject",21]
[]
[]
[null,"Covariance parameters - Random effects:"]
[]
[null,null,"Variance","Standard error","Z","Pr >  Z"]
[null,"ingot",11.447777777781447,8.7203648909501847,1.3127636195202927,9.463130625574756E-2]
[]
[]
[null,"Covariance parameters - Repeated factor:"]
[]
[null,null,"Variance","Standard error","Z","Pr >  Z"]
[null,"Residual",10.371587301576184,4.234176583421613,2.4494933305769138,7.1528679566711384E-3]
[]
[]
[null,"Null model likelihood ratio test:"]
[]
[null,"DF","Chi-square","Pr > Chi²"]
[null,1,4.6196775018403713,3.160718026452225E-2]
[]
[]
[null,"Type I tests of fixed effects:"]
[]
[null,"Effects","Num DF","Den DF","F","Pr > F"]
[null,"metal",2,12,6.3587640225958815,1.3093497638046637E-2]
[null,"Satterthwaite's approximation method was used to generate the statistical tests in the above table."]
[]
[]
[null,"Type II tests of fixed effects:"]
[]
[null,"Effects","Num DF","Den DF","F","Pr > F"]
[null,"metal",2,12,6.3587640225958815,1.3093497638046637E-2]
[null,"Satterthwaite's approximation method was used to generate the statistical tests in the above table."]
[]
[]
[null,"Type III tests of fixed effects:"]
[]
[null,"Effects","Num DF","Den DF","F","Pr > F"]
[null,"metal",2,12,6.3587640225958815,1.3093497638046637E-2]
[null,"Satterthwaite's approximation method was used to generate the statistical tests in the above table."]
[]
[]
[null,"Model parameters:"]
[]
[null,"Source","Value","Standard error","DF","t","Pr > |t|","Lower bound (95%)","Upper bound (95%)"]
[null,"Intercept",70.185714285714297,1.7655175315453393,11.600000381469727,39.753620698561662,"< 0,0001",66.51411958433907,73.857308987089525]
[null,"metal-n",0.91428571428565419,1.7214269248484526,12,0.53112083997765058,0.6050265467535153,-2.665617550988677,4.4941889795599854]
[null,"metal-i",5.7142857142856442,1.7214269248484526,12,3.319505249860494,6.1157825185513002E-3,2.134382449011313,9.2941889795599764]
[null,"metal-c",0]
[null,"Satterthwaite's approximation method was used to generate the statistical tests in the above table."]
[]
[]
[null,"Random effects coefficients:"]
[]
[null,"Source","Value","Standard error","DF","t","Pr > |t|","Lower bound (95%)","Upper bound (95%)"]
[null,"ingot-1",-1.5580460341355993,1.9777184152535128,12,-0.78779973029471029,0.44609666084569866,-5.6709366310934248,2.5548445628222263]
[null,"ingot-2",-3.7085884474495616,1.9777184152535128,12,-1.8751852735184136,8.5302817188077876E-2,-7.8214790444073872,0.40430214950826393]
[null,"ingot-3",4.0743269531152455,1.9777184152535128,12,2.0601147876721266,6.1758329573522217E-2,-3.8563643842580042E-2,8.1872175500730719]
[null,"ingot-4",0.2340726436260302,1.9777184152535128,12,0.11835488905837271,0.90774457260338193,-3.8788179533317955,4.3469632405838556]
[null,"ingot-5",0.84851333314430599,1.9777184152535128,12,0.42903647283657403,0.6754982047167214,-3.2643772638135196,4.9614039301021311]
[null,"ingot-6",-3.0429443671380989,1.9777184152535128,12,-1.5386135577586968,0.14984061708150437,-7.1558349640959245,1.0699462298197266]
[null,"ingot-7",3.152665918837835,1.9777184152535128,12,1.5940924120048263,0.13689959783356184,-0.96022467811999057,7.2655565157956605]