{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","MDS"],"not_rendered":{"charts":5,"images":10,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,"P1","P2","P3","P4","P5"]
["Ind1",2,1,4,5,3]
["Ind2",3,1,2,5,4]
["Ind3",1,2,4,3,5]
["Ind4",3,2,4,5,1]
["Ind5",3,2,4,5,1]
["Ind6",2,1,3,5,4]
["Ind7",1,3,4,2,5]
["Ind8",3,1,2,4,5]
["Ind9",3,1,2,5,4]
["Ind10",1,4,5,2,1]
["Average",{"$f":"AVERAGE(B2:B11)","v":2.2000000000000002},{"$f":"AVERAGE(C2:C11)","v":1.8},{"$f":"AVERAGE(D2:D11)","v":3.4},{"$f":"AVERAGE(E2:E11)","v":4.0999999999999996},{"$f":"AVERAGE(F2:F11)","v":3.3}]
[]
[]
[]
["XLSTAT 2023.2.1414.1414 - Similarity/Dissimilarity matrices (correlation...) - Start time: 07/12/2023 at 16:50:43 / End time: 07/12/2023 at 16:50:45 / Microsoft Excel 16.017029"]
["Data: Workbook = NEW_demo01MDS.xlsx / Sheet = Data / Range = Data!$B$1:$F$11 / 10 rows and 5 columns"]
["Row labels: Workbook = NEW_demo01MDS.xlsx / Sheet = Data / Range = Data!$A$1:$A$11 / 10 rows and 1 column"]
["Dissimilarity: Euclidean distance"]
["Compute proximities for the: Columns"]
[]
[]
[]
[]
["Proximity matrix (Euclidean distance):"]
[]
[null,"P1","P2","P3","P4","P5"]
["P1",0,5.4772255750516612,6.6332495807107996,6.4031242374328485,7.1414284285428504]
["P2",5.4772255750516612,0,5.4772255750516612,9.8488578017961039,8.426149773176359]
["P3",6.6332495807107996,5.4772255750516612,0,6.5574385243020004,7.416198487095663]
["P4",6.4031242374328485,9.8488578017961039,6.5574385243020004,0,7.3484692283495345]
["P5",7.1414284285428504,8.426149773176359,7.416198487095663,7.3484692283495345,0]

{"sheet":"MDS","index":1,"n_rows":296,"n_cols":8,"rows_kept":296,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2023.2.1414.1414 - Multidimensional Scaling (MDS) - Start time: 07/12/2023 at 17:33:21 / End time: 07/12/2023 at 17:33:23 / Microsoft Excel 16.017029"]
[null,"Proximity matrix: Workbook = NEW_demo01MDS.xlsx / Sheet = Data / Range = Data!$A$27:$F$32 / 5 rows and 5 columns"]
[null,"Model: Absolute"]
[null,"Stress: Kruskal's stress (1)"]
[null,"Dimensions: from 2 to 4"]
[null,"Initial configuration: random"]
[null,"Repetitions: 100"]
[null,"Stop conditions: Convergence = 0,00001 / Iterations = 500"]
[null,"Seed (random numbers): 4689119"]
[]
[]
[]
[]
[null,"Best stress obtained for each dimension:"]
[]
[null,"Dimensions",2,3,4]
[null,"Kruskal's stress (1)",0.15135953252041362,1.8004149967076023E-3,1.1875870186109107E-4]
[null,"Iterations",28,38,74]
[null,"Convergence",7.5226214513446354E-6,9.0051487818393599E-6,8.6332110021445865E-6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Results for a 2-dimensional representation space:"]
[]
[null,"Configuration:"]
[]
[null,null,"Dim1","Dim2"]
[null,"P1",-1.9755369141107302,2.1268073567841235]
[null,"P2",-5.0752415703385791,-1.0623116231345169]
[null,"P3",-0.53939967004276834,-3.6365515245257889]
[null,"P4",4.7580945225999391,-1.7216767380867979]
[null,"P5",2.8320836318921385,4.2937325289629804]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Distances measured in the representation space:"]
[]
[null,null,"P1","P2","P3","P4","P5"]
[null,"P1",0,4.4473192851332266,5.9395955904903968,7.7558121530844621,5.2734030773468561]
[null,"P2",4.4473192851332266,0,5.2154168399461662,9.8554178537240826,9.55054976496384]
[null,"P3",5.9395955904903968,5.2154168399461662,0,5.6329557222494646,8.6172098050496704]
[null,"P4",7.7558121530844621,9.8554178537240826,5.6329557222494646,0,6.3162224945954373]
[null,"P5",5.2734030773468561,9.55054976496384,8.6172098050496704,6.3162224945954373,0]
[]
[]
[null,"Disparities computed using the model:"]
[]
[null,null,"P1","P2","P3","P4","P5"]
[null,"P1",0,5.4772255750516612,6.6332495807107996,6.4031242374328485,7.1414284285428504]
[null,"P2",5.4772255750516612,0,5.4772255750516612,9.8488578017961039,8.426149773176359]
[null,"P3",6.6332495807107996,5.4772255750516612,0,6.5574385243020004,7.416198487095663]
[null,"P4",6.4031242374328485,9.8488578017961039,6.5574385243020004,0,7.3484692283495345]
[null,"P5",7.1414284285428504,8.426149773176359,7.416198487095663,7.3484692283495345,0]
[]
[]
[null,"Residual distances:"]
[]
[null,null,"P1","P2","P3","P4","P5"]
[null,"P1",0,-1.0299062899184346,-0.69365399022040286,1.3526879156516136,-1.8680253511959943]
[null,"P2",-1.0299062899184346,0,-0.26180873510549496,6.5600519279787051E-3,1.124399991787481]
[null,"P3",-0.69365399022040286,-0.26180873510549496,0,-0.92448280205253575,1.2010113179540074]
[null,"P4",1.3526879156516136,6.5600519279787051E-3,-0.92448280205253575,0,-1.0322467337540973]
[null,"P5",-1.8680253511959943,1.124399991787481,1.2010113179540074,-1.0322467337540973,0]
[]
[]
[null,"Comparative table:"]
[]
[null,"Pair","Dissimilarity","Disparity","Distance","Rank (Dissimilarity)","Rank (Disparity)","Rank (Distance)"]
[null,"P1 - P2",5.4772255750516612,5.4772255750516612,4.4473192851332266,1,1,1]
[null,"P2 - P3",5.4772255750516612,5.4772255750516612,5.2154168399461662,1,1,2]
[null,"P1 - P4",6.4031242374328485,6.4031242374328485,7.7558121530844621,2,2,7]
[null,"P3 - P4",6.5574385243020004,6.5574385243020004,5.6329557222494646,3,3,4]
[null,"P1 - P3",6.6332495807107996,6.6332495807107996,5.9395955904903968,4,4,5]
[null,"P1 - P5",7.1414284285428504,7.1414284285428504,5.2734030773468561,5,5,3]
[null,"P4 - P5",7.3484692283495345,7.3484692283495345,6.3162224945954373,6,6,6]
[null,"P3 - P5",7.416198487095663,7.416198487095663,8.6172098050496704,7,7,8]
[null,"P2 - P5",8.426149773176359,8.426149773176359,9.55054976496384,8,8,9]
[null,"P2 - P4",9.8488578017961039,9.8488578017961039,9.8554178537240826,9,9,10]
[]
[]
[null,"Shepard diagram:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Results for a 3-dimensional representation space:"]
[]
[null,"Configuration:"]
[]
[null,null,"Dim1","Dim2","Dim3"]
[null,"P1",-2.1910341639648476,1.9454574365667108,1.986956982808771]
[null,"P2",3.129773077389074,3.1250894877399489,2.3291712922125138]
[null,"P3",2.9360108041587218,-2.1171591167440749,0.79851320647298885]
[null,"P4",-3.2667182777331383,-3.9586579585715009,-0.19756311141452787]
[null,"P5",-0.60803143984980901,1.0052701510089155,-4.9170783700797465]
[]
[]
[null,"Distances measured in the representation space:"]
[]
[null,null,"P1","P2","P3","P4","P5"]
[null,"P1",0,5.4607354916128461,6.6485969928931086,6.3865329368748176,7.1453169216217862]
[null,"P2",5.4607354916128461,0,5.4645794371737217,9.8731436880939647,8.4245445454185166]
[null,"P3",6.6485969928931086,5.4645794371737217,0,6.5465360366269385,7.4147007376830842]
[null,"P4",6.3865329368748176,9.8731436880939647,6.5465360366269385,0,7.3473139483617063]
[null,"P5",7.1453169216217862,8.4245445454185166,7.4147007376830842,7.3473139483617063,0]
[]
[]
[null,"Disparities computed using the model:"]
[]
[null,null,"P1","P2","P3","P4","P5"]
[null,"P1",0,5.4772255750516612,6.6332495807107996,6.4031242374328485,7.1414284285428504]
[null,"P2",5.4772255750516612,0,5.4772255750516612,9.8488578017961039,8.426149773176359]
[null,"P3",6.6332495807107996,5.4772255750516612,0,6.5574385243020004,7.416198487095663]
[null,"P4",6.4031242374328485,9.8488578017961039,6.5574385243020004,0,7.3484692283495345]
[null,"P5",7.1414284285428504,8.426149773176359,7.416198487095663,7.3484692283495345,0]
[]
[]
[null,"Residual distances:"]
[]
[null,null,"P1","P2","P3","P4","P5"]
[null,"P1",0,-1.6490083438815084E-2,1.534741218230895E-2,-1.659130055803093E-2,3.8884930789357952E-3]
[null,"P2",-1.6490083438815084E-2,0,-1.2646137877939445E-2,2.428588629786077E-2,-1.6052277578424423E-3]
[null,"P3",1.534741218230895E-2,-1.2646137877939445E-2,0,-1.0902487675061856E-2,-1.4977494125787416E-3]
[null,"P4",-1.659130055803093E-2,2.428588629786077E-2,-1.0902487675061856E-2,0,-1.1552799878282727E-3]
[null,"P5",3.8884930789357952E-3,-1.6052277578424423E-3,-1.4977494125787416E-3,-1.1552799878282727E-3,0]
[]
[]
[null,"Comparative table:"]
[]
[null,"Pair","Dissimilarity","Disparity","Distance","Rank (Dissimilarity)","Rank (Disparity)","Rank (Distance)"]
[null,"P1 - P2",5.4772255750516612,5.4772255750516612,5.4607354916128461,1,1,1]
[null,"P2 - P3",5.4772255750516612,5.4772255750516612,5.4645794371737217,1,1,2]
[null,"P1 - P4",6.4031242374328485,6.4031242374328485,6.3865329368748176,2,2,3]
[null,"P3 - P4",6.5574385243020004,6.5574385243020004,6.5465360366269385,3,3,4]
[null,"P1 - P3",6.6332495807107996,6.6332495807107996,6.6485969928931086,4,4,5]
[null,"P1 - P5",7.1414284285428504,7.1414284285428504,7.1453169216217862,5,5,6]
[null,"P4 - P5",7.3484692283495345,7.3484692283495345,7.3473139483617063,6,6,7]
[null,"P3 - P5",7.416198487095663,7.416198487095663,7.4147007376830842,7,7,8]
[null,"P2 - P5",8.426149773176359,8.426149773176359,8.4245445454185166,8,8,9]
[null,"P2 - P4",9.8488578017961039,9.8488578017961039,9.8731436880939647,9,9,10]
[]
[]
[null,"Shepard diagram:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Results for a 4-dimensional representation space:"]
[]
[null,"Configuration:"]
[]
[null,null,"Dim1","Dim2","Dim3","Dim4"]
[null,"P1",-3.1016582062327269,0.99846081313635349,-1.3470888533635064,-0.36078459032699856]
[null,"P2",1.3523667749897819,1.8724248946006763,-4.4143747047070381,-0.36964953309359855]
[null,"P3",3.1366051542351472,1.1581693062664917,0.59069722661730606,-1.4944467724970927]
[null,"P4",-1.7048141584855536,-1.2530263913191639,4.2778983611778605,-1.8926831624684202]
[null,"P5",0.3175004354933515,-2.7760286226843576,0.89286797027537845,4.1175640583861099]
[]
[]
[null,"Distances measured in the representation space:"]
[]
[null,null,"P1","P2","P3","P4","P5"]
[null,"P1",0,5.4781815258447226,6.6318656042160482,6.4037147285490787,7.1421586029441544]
[null,"P2",5.4781815258447226,0,5.4781001731384267,9.8483523235502588,8.4250210130121985]
[null,"P3",6.6318656042160482,5.4781001731384267,0,6.5579913146208568,7.4169560793944749]
[null,"P4",6.4037147285490787,9.8483523235502588,6.5579913146208568,0,7.3478428478626592]
[null,"P5",7.1421586029441544,8.4250210130121985,7.4169560793944749,7.3478428478626592,0]
[]
[]
[null,"Disparities computed using the model:"]
[]
[null,null,"P1","P2","P3","P4","P5"]
[null,"P1",0,5.4772255750516612,6.6332495807107996,6.4031242374328485,7.1414284285428504]
[null,"P2",5.4772255750516612,0,5.4772255750516612,9.8488578017961039,8.426149773176359]
[null,"P3",6.6332495807107996,5.4772255750516612,0,6.5574385243020004,7.416198487095663]
[null,"P4",6.4031242374328485,9.8488578017961039,6.5574385243020004,0,7.3484692283495345]
[null,"P5",7.1414284285428504,8.426149773176359,7.416198487095663,7.3484692283495345,0]
[]
[]
[null,"Residual distances:"]
[]
[null,null,"P1","P2","P3","P4","P5"]
[null,"P1",0,9.5595079306143305E-4,-1.3839764947514155E-3,5.9049111623021844E-4,7.3017440130396238E-4]
[null,"P2",9.5595079306143305E-4,0,8.7459808676548789E-4,-5.0547824584512568E-4,-1.1287601641605249E-3]
[null,"P3",-1.3839764947514155E-3,8.7459808676548789E-4,0,5.5279031885646646E-4,7.5759229881189327E-4]
[null,"P4",5.9049111623021844E-4,-5.0547824584512568E-4,5.5279031885646646E-4,0,-6.263804868753553E-4]
[null,"P5",7.3017440130396238E-4,-1.1287601641605249E-3,7.5759229881189327E-4,-6.263804868753553E-4,0]
[]
[]
[null,"Comparative table:"]
[]
[null,"Pair","Dissimilarity","Disparity","Distance","Rank (Dissimilarity)","Rank (Disparity)","Rank (Distance)"]
[null,"P1 - P2",5.4772255750516612,5.4772255750516612,5.4781815258447226,1,1,2]
[null,"P2 - P3",5.4772255750516612,5.4772255750516612,5.4781001731384267,1,1,1]
[null,"P1 - P4",6.4031242374328485,6.4031242374328485,6.4037147285490787,2,2,3]
[null,"P3 - P4",6.5574385243020004,6.5574385243020004,6.5579913146208568,3,3,4]
[null,"P1 - P3",6.6332495807107996,6.6332495807107996,6.6318656042160482,4,4,5]
[null,"P1 - P5",7.1414284285428504,7.1414284285428504,7.1421586029441544,5,5,6]
[null,"P4 - P5",7.3484692283495345,7.3484692283495345,7.3478428478626592,6,6,7]
[null,"P3 - P5",7.416198487095663,7.416198487095663,7.4169560793944749,7,7,8]
[null,"P2 - P5",8.426149773176359,8.426149773176359,8.4250210130121985,8,8,9]
[null,"P2 - P4",9.8488578017961039,9.8488578017961039,9.8483523235502588,9,9,10]
[]
[]
[null,"Shepard diagram:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]