{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["dirichlet","Dirichlet regression"],"not_rendered":{"charts":0,"images":7,"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":"dirichlet","index":0,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["sand","silt","clay","depth"]
[0.77500000000000002,0.19500000000000001,0.03,10.4]
[0.71899999999999997,0.249,3.2000000000000001E-2,11.7]
[0.50700000000000001,0.36099999999999999,0.13200000000000001,12.8]
[0.52200000000000002,0.40899999999999997,6.6000000000000003E-2,13]
[0.7,0.26500000000000001,3.5000000000000003E-2,15.7]
[0.66500000000000004,0.32200000000000001,1.2999999999999999E-2,16.3]
[0.43099999999999999,0.55300000000000005,1.6E-2,18]
[0.53400000000000003,0.36799999999999999,9.8000000000000004E-2,18.7]
[0.155,0.54400000000000004,0.30099999999999999,20.7]
[0.317,0.41499999999999998,0.26800000000000002,22.1]
[0.65700000000000003,0.27800000000000002,6.5000000000000002E-2,22.4]
[0.70399999999999996,0.28999999999999998,6.0000000000000001E-3,24.4]
[0.17399999999999999,0.53600000000000003,0.28999999999999998,25.8]
[0.106,0.69799999999999995,0.19600000000000001,32.5]
[0.38200000000000001,0.43099999999999999,0.187,33.6]
[0.108,0.52700000000000002,0.36499999999999999,36.799999999999997]
[0.184,0.50700000000000001,0.309,37.799999999999997]
[4.5999999999999999E-2,0.47399999999999998,0.48,36.9]
[0.156,0.504,0.34,42.2]
[0.31900000000000001,0.45100000000000001,0.23,47]
[9.5000000000000001E-2,0.53500000000000003,0.37,47.1]
[0.17100000000000001,0.48,0.34899999999999998,48.4]
[0.105,0.55400000000000005,0.34100000000000003,49.4]
[4.8000000000000001E-2,0.54700000000000004,0.41,49.5]
[2.5999999999999999E-2,0.45200000000000001,0.52200000000000002,59.2]
[0.114,0.52700000000000002,0.35899999999999999,60.1]
[6.7000000000000004E-2,0.46899999999999997,0.46400000000000002,61.7]
[6.9000000000000006E-2,0.497,0.434,62.4]
[0.04,0.44900000000000001,0.51100000000000001,69.3]
[7.3999999999999996E-2,0.51600000000000001,0.40899999999999997,73.599999999999994]
[4.8000000000000001E-2,0.495,0.45700000000000002,74.400000000000006]
[4.4999999999999998E-2,0.48499999999999999,0.47,78.5]
[6.6000000000000003E-2,0.52100000000000002,0.41299999999999998,82.9]
[6.7000000000000004E-2,0.47299999999999998,0.45900000000000002,87.7]
[7.3999999999999996E-2,0.45600000000000002,0.46899999999999997,88.1]
[0.06,0.48899999999999999,0.45100000000000001,90.4]
[6.3E-2,0.53800000000000003,0.39900000000000002,90.6]
[2.5000000000000001E-2,0.48,0.495,97.7]
[0.02,0.47799999999999998,0.502,103.7]

{"sheet":"Dirichlet regression","index":1,"n_rows":132,"n_cols":9,"rows_kept":132,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2022.2.1.1310 - Dirichlet regression - Début : 20/05/2022 à 10:34:43 / Fin : 20/05/2022 à 10:34:49 / Microsoft Excel 16.015128"]
[null,"Y : Classeur = dirichlet.csv / Feuille = dirichlet / Plage = dirichlet!$A:$C / 39 lignes et 3 colonnes"]
[null,"Variables quantitatives : Classeur = dirichlet.csv / Feuille = dirichlet / Plage = dirichlet!$D:$D / 39 lignes et 1 colonne"]
[null,"R function author : Marco Johannes Maier"]
[null,"Model : Common"]
[null,"Interactions / Niveau : 2"]
[]
[]
[]
[]
[null,"Goodness of fit coefficients :"]
[]
[null,"Observations number",39]
[null,"DF",6]
[null,"Log likelihood",101.36965774277201]
[null,"AIC",-190.73931548554401]
[null,"BIC",-180.75794560876599]
[]
[]
[null,"Coefficients :"]
[]
[null,null,"Estimate","Std. Error","z value","Pr(>|z|)"]
[null,"sand : (Intercept)",0.11662479525816399,0.40929182075506099,0.28494289244044702,0.77568789407629601]
[null,"sand : depth",2.3351142453656899E-2,7.4539152061562997E-3,3.13273518786084,1.7318561602616301E-3]
[null,"silt : (Intercept)",-0.310595910773803,0.34473138108255702,-0.90097950989678199,0.36759921420145097]
[null,"silt : depth",5.5567453798415697E-2,6.3652979978582897E-3,8.7297489948015397,2.5523844185046302E-18]
[null,"clay : (Intercept)",-1.1519564209180899,0.29847277171903402,-3.8595025411647401,1.13618075717055E-4]
[null,"clay : depth",6.4301750772843697E-2,5.7381803776799497E-3,11.205947973152099,3.81250256947058E-29]
[]
[]
[null,"Residuals :"]
[]
[null,"sand","silt","clay"]
[null,1.4688169121421699,-0.83169503269516598,-0.82873942066377204]
[null,1.3125025902268801,-0.63880816342041502,-0.85482619159687501]
[null,0.44507456459874301,-0.17513451040945199,-0.336433137772154]
[null,0.52810020524169499,3.9398977014611099E-2,-0.70457670851222898]
[null,1.4976225218571699,-0.690024576520751,-0.96191388640669295]
[null,1.37454060465022,-0.44149999175670701,-1.1076672016693501]
[null,0.33643278258332798,0.627722163047717,-1.15167364099519]
[null,0.89108987686341201,-0.28446489283285997,-0.69568671999828602]
[null,-0.990310343853396,0.55788451646436599,0.46307691054794098]
[null,-7.4902207941165797E-2,-0.12791938430827399,0.23465582329047199]
[null,1.82205364355569,-0.85287898934732698,-1.02536415239296]
[null,2.2861652113008302,-0.86141002351987594,-1.48113669006393]
[null,-0.78022012098085203,0.465590139463675,0.29450284029306201]
[null,-1.10275619326254,1.4492547705943,-0.54659434601686496]
[null,1.0303318359492699,-0.30313679927611897,-0.65638284626364696]
[null,-1.0123325118914901,0.301252316078025,0.60395952976059197]
[null,-0.32435960510378598,0.14586906526597501,0.135581311912399]
[null,-1.5392566877746701,-7.8314064307644093E-2,1.5081806193909999]
[null,-0.40054184859411801,6.6412681771195997E-2,0.27168418234168701]
[null,1.81567607455507,-0.47681094356609899,-0.94461783062468896]
[null,-0.90584130668007501,0.28971135406117998,0.415057985721903]
[null,0.105223984460002,-0.236203819429704,0.16825324772484301]
[null,-0.70484851210742105,0.46483184789689203,5.2246028000786697E-2]
[null,-1.4655544998269701,0.37037792699039002,0.73807855467434103]
[null,-1.77244915930231,-0.76120075386740305,1.96599998828572]
[null,1.19664001128894E-2,0.181948379509943,-0.19582362926847899]
[null,-0.88224236056358496,-0.591853830738026,1.1735622165381301]
[null,-0.81018332871312004,-0.220554984223328,0.73901578103076104]
[null,-1.31466840815359,-1.0377386126011801,1.8007481424671099]
[null,4.14607753123553E-2,0.13272376995674601,-0.15639419280610001]
[null,-0.85362394167240496,-0.26429077401780299,0.71180795466049396]
[null,-0.74718234021109298,-0.44021113052100103,0.80737041111589503]
[null,0.69472019758186698,0.48212870838891397,-0.79858992761241199]
[null,1.4817134160155501,-0.61340764277153403,-1.15419030529714E-3]
[null,2.0313610520261198,-1.0862588518223599,0.25005334227376003]
[null,1.44630352760053,-8.8061509874217306E-2,-0.48647293623252802]
[null,1.71181193700053,1.40619441691616,-2.0868441873334]
[null,-0.71281705663835104,-4.68132893978946E-2,0.29662279136540398]
[null,-0.78850461861092902,0.28878259453222299,-3.9272005744621301E-2]
[]
[]
[null,"Ternary plot :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null," "]
[]
[]
[null,"Scatter plot :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null," "]