{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Attributes","Designs for MaxDiff","MaxDiff"],"not_rendered":{"charts":1,"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":"Attributes","index":0,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Attributes",null,"Nb respondants","Nb comparisons"]
[null,"Quality beaches",null,2,8]
[null,"Cultural activities",null,3,8]
[null,"Nightlife"]
[null,"Luxury hotel offer"]
[null,"Shopping around"]
[null,"Entertainement"]
[null,"Wildlife around"]
[null,"Local cuisine"]

{"sheet":"Designs for MaxDiff","index":1,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2019.3.1.12345 - Designs for MaxDiff - Start time: 30/08/2019 at 15:20:27 / End time: 30/08/2019 at 15:20:29 / Microsoft Excel 16.011901"]
[null,"Attributes: Workbook = demoMaxDiff_US1 (1).xlsm / Sheet = Attributes / Range = 'Attributes'!$B$1:$B$9 / 8 rows and 1 column"]
[null,"Respondents per design: Workbook = demoMaxDiff_US1 (1).xlsm / Sheet = Attributes / Range = 'Attributes'!$D$2:$D$3 / 2 rows and 1 column"]
[null,"Comparisons by design: Workbook = demoMaxDiff_US1 (1).xlsm / Sheet = Attributes / Range = 'Attributes'!$E$2:$E$3 / 2 rows and 1 column"]
[null,"Number of respondents: 5"]
[null,"Number of comparisons: 16"]
[null,"Profiles per comparison: 4"]
[null,"Initial partition: 123456789"]
[null,":"]
[]
[]
[]
[null,"Design: Hotel MaxDiff:"]
[]
[null,"Combinations\\Attributes","Attribute 1","Attribute 2","Attribute 3","Attribute 4","R1 Most important","R1 Least important","R2 Most important","R2 Least important","R3 Most important","R3 Least important"]
[null,"C1","Local cuisine","Entertainement","Wildlife around","Quality beaches",1,2,4,3,"",""]
[null,"C2","Luxury hotel offer","Cultural activities","Nightlife","Shopping around",4,1,1,4,"",""]
[null,"C3","Quality beaches","Wildlife around","Local cuisine","Cultural activities",1,4,4,3,"",""]
[null,"C4","Shopping around","Nightlife","Luxury hotel offer","Entertainement",3,2,1,2,"",""]
[null,"C5","Cultural activities","Local cuisine","Quality beaches","Nightlife",4,1,1,2,"",""]
[null,"C6","Entertainement","Luxury hotel offer","Shopping around","Wildlife around",1,4,4,1,"",""]
[null,"C7","Nightlife","Quality beaches","Cultural activities","Luxury hotel offer",4,3,3,4,"",""]
[null,"C8","Wildlife around","Shopping around","Entertainement","Local cuisine",2,4,3,1,"",""]
[null,"C1","Local cuisine","Entertainement","Wildlife around","Quality beaches",1,3,4,1,3,2]
[null,"C2","Luxury hotel offer","Cultural activities","Nightlife","Shopping around",4,2,1,3,1,4]
[null,"C3","Quality beaches","Wildlife around","Local cuisine","Cultural activities",3,1,4,3,4,3]
[null,"C4","Shopping around","Nightlife","Luxury hotel offer","Entertainement",3,2,1,2,1,3]
[null,"C5","Cultural activities","Local cuisine","Quality beaches","Nightlife",1,4,4,2,4,2]
[null,"C6","Entertainement","Luxury hotel offer","Shopping around","Wildlife around",4,2,3,4,4,3]
[null,"C7","Nightlife","Quality beaches","Cultural activities","Luxury hotel offer",1,3,3,4,3,4]
[null,"C8","Wildlife around","Shopping around","Entertainement","Local cuisine",4,3,2,1,3,2]
[null,"Enter the code associated to the chosen attribute (from 1 to 4)."]
[]
[]
[]
[null,"Once you have filled in the MaxDiff design with the individuals' responses, you can click the above button to automatically launch the interface that allows running a MaxDiff analysis."]

{"sheet":"MaxDiff","index":2,"n_rows":236,"n_cols":7,"rows_kept":236,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2019.3.1.12345 - MaxDiff - Start time: 02/09/2019 at 11:22:43 / End time: 02/09/2019 at 11:22:50 / Microsoft Excel 16.011929"]
[null,"Responses: Workbook = demoMaxDiff_US1 (1).xlsm / Sheet = Designs for MaxDiff / Range = 'Designs for MaxDiff'!$G$15:$L$31 / 16 rows and 6 columns"]
[null,"Combinations: Workbook = demoMaxDiff_US1 (1).xlsm / Sheet = Designs for MaxDiff / Range = 'Designs for MaxDiff'!$C$15:$F$31 / 16 rows and 4 columns"]
[null,"Method: Hierarchical Bayes"]
[null,"Confidence interval (%): 0,95"]
[null,"Convergence: 0,001"]
[null,"Iterations: 25429"]
[null,"Seed (random numbers): 123456789"]
[null,":"]
[]
[]
[]
[null,"Variable information:"]
[]
[null,"Attributes"]
[null,"Cultural activities"]
[null,"Entertainement"]
[null,"Local cuisine"]
[null,"Luxury hotel offer"]
[null,"Nightlife"]
[null,"Quality beaches"]
[null,"Shopping around"]
[null,"Wildlife around"]
[]
[]
[null,"Counts analysis / All:"]
[]
[null,"Attributes","Most important","Least important","Difference"]
[null,"Cultural activities",8,5,-3]
[null,"Entertainement",3,4,1]
[null,"Local cuisine",4,8,4]
[null,"Luxury hotel offer",6,6,0]
[null,"Nightlife",4,6,2]
[null,"Quality beaches",3,1,-2]
[null,"Shopping around",8,4,-4]
[null,"Wildlife around",4,6,2]
[]
[]
[null,"Counts analysis / Respondent 1:"]
[]
[null,"Attributes","Most important","Least important","Difference"]
[null,"Cultural activities",0,3,3]
[null,"Entertainement",1,1,0]
[null,"Local cuisine",1,1,0]
[null,"Luxury hotel offer",2,1,-1]
[null,"Nightlife",1,1,0]
[null,"Quality beaches",1,0,-1]
[null,"Shopping around",2,0,-2]
[null,"Wildlife around",0,1,1]
[]
[]
[null,"Counts analysis / Respondent 2:"]
[]
[null,"Attributes","Most important","Least important","Difference"]
[null,"Cultural activities",3,0,-3]
[null,"Entertainement",1,1,0]
[null,"Local cuisine",0,2,2]
[null,"Luxury hotel offer",1,1,0]
[null,"Nightlife",0,1,1]
[null,"Quality beaches",1,0,-1]
[null,"Shopping around",1,1,0]
[null,"Wildlife around",1,2,1]
[]
[]
[null,"Counts analysis / Respondent 3:"]
[]
[null,"Attributes","Most important","Least important","Difference"]
[null,"Cultural activities",1,2,1]
[null,"Entertainement",0,1,1]
[null,"Local cuisine",3,0,-3]
[null,"Luxury hotel offer",1,1,0]
[null,"Nightlife",1,2,1]
[null,"Quality beaches",0,1,1]
[null,"Shopping around",1,0,-1]
[null,"Wildlife around",1,1,0]
[]
[]
[null,"Counts analysis / Respondent 4:"]
[]
[null,"Attributes","Most important","Least important","Difference"]
[null,"Cultural activities",2,0,-2]
[null,"Entertainement",0,0,0]
[null,"Local cuisine",0,3,3]
[null,"Luxury hotel offer",1,1,0]
[null,"Nightlife",1,2,1]
[null,"Quality beaches",1,0,-1]
[null,"Shopping around",3,0,-3]
[null,"Wildlife around",0,2,2]
[]
[]
[null,"Counts analysis / Respondent 5:"]
[]
[null,"Attributes","Most important","Least important","Difference"]
[null,"Cultural activities",2,0,-2]
[null,"Entertainement",1,1,0]
[null,"Local cuisine",0,2,2]
[null,"Luxury hotel offer",1,2,1]
[null,"Nightlife",1,0,-1]
[null,"Quality beaches",0,0,0]
[null,"Shopping around",1,3,2]
[null,"Wildlife around",2,0,-2]
[]
[]
[null,"MaxDiff scores (Individual data):"]
[]
[null,"Source","Respondent 1","Respondent 2","Respondent 3","Respondent 4","Respondent 5"]
[null,"Cultural activities",2.8440858310795747,29.888555055367018,15.814454097646705,22.113969027169432,24.210861245642075]
[null,"Entertainement",12.956832510173982,11.299578302102045,1.005021757206608,0.7620604732829569,6.1818768659245977]
[null,"Local cuisine",6.0883730763068256,1.4775677837511123,26.13967563549668,0.88785568631703593,1.8120231693088598]
[null,"Luxury hotel offer",27.205430463641726,17.894080363830941,12.71555688241796,16.175019483951807,15.662113663817269]
[null,"Nightlife",9.1760565773394749,1.9419206792634247,14.677545609792238,16.517806529383169,17.792873880863585]
[null,"Quality beaches",8.9381625572505676,15.276428002451983,1.1256535953222369,5.6209372120284362,1.2118090968337629]
[null,"Shopping around",28.465068337296774,15.831891548075843,14.910744280310247,28.65464837999102,17.386611564428691]
[null,"Wildlife around",4.3259906469110705,6.3899782651576293,13.611348141807341,9.2677032078761439,15.741830513181151]
[]
[]
[null,"MaxDiff scores (Descriptive statistics):"]
[]
[null,null,"Minimum","Maximum","Mean","Std. deviation"]
[null,"Cultural activities",2.8440858310795747,29.888555055367018,18.97438505138096,10.32676732960058]
[null,"Entertainement",0.7620604732829569,12.956832510173982,6.4410739817380378,5.6552898863315546]
[null,"Local cuisine",0.88785568631703593,26.13967563549668,7.2810990702361025,10.741669248000148]
[null,"Luxury hotel offer",12.71555688241796,27.205430463641726,17.930440171531941,5.5101856050729463]
[null,"Nightlife",1.9419206792634247,17.792873880863585,12.021240655328379,6.5244650044748669]
[null,"Quality beaches",1.1256535953222369,15.276428002451983,6.4345980927773967,5.9281163066664657]
[null,"Shopping around",14.910744280310247,28.65464837999102,21.049792822020514,6.9129126758033568]
[null,"Wildlife around",4.3259906469110705,15.741830513181151,9.8673701549866664,4.7876246020657787]
[]
[]
[null,"Chart of average MaxDiff scores:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,"Model coefficients (Individual data):"]
[]
[null,"Respondent 1","Respondent 2","Respondent 3","Respondent 4","Respondent 5"]
[null,-0.4573771753983667,2.7584652132077703,0.24499128814525101,1.5255344264101354,0.88558047070936785]
[null,1.352444521072355,0.7290118555052888,-3.0235666782531476,-2.7747430702702749,-1.2802108999232096]
[null,0.38886727652017111,-1.6015430174913228,1.3766000652068575,-2.6183809440654962,-2.6327324748968497]
[null,2.7491388578652369,1.4519609286046686,-0.10425386931590461,0.8561902358457939,-8.5124214255204184E-3]
[null,0.88741656667996993,-1.31606932996571,0.12025155787486518,0.89462541140143403,0.21519003798195896]
[null,0.85405893445332193,1.1808860081622901,-2.9069395626029304,-0.62803138408975356,-3.0511136781544552]
[null,2.8797070344539666,1.2395194099048041,0.14609525780882796,2.4230730567662455,0.1730327000505418]
[null,0,0,0,0,0]
[]
[]
[null,"Goodness of fit statistics:"]
[]
[null,"Statistic","Independent","Full"]
[null,"Observations",192,192]
[null,"Sum of weights",192,192]
[null,"-2 Log(Likelihood)",1064.6740693400759,45.431235630302538]
[null,"rlh",0.25,0.38810316884011209]
[]
[]
[null,"Model coefficients (Respondent 1):"]
[]
[null,"Source","Mean","Standard error","Quantile (2,5%)","Quantile (97,5%)"]
[null,"Cultural activities",-0.4573771753983667,2.4312163141339203,-5.222473589727068,4.3077192389303347]
[null,"Entertainement",1.352444521072355,1.8295503848899872,-2.2334083412134129,4.9382973833581234]
[null,"Local cuisine",0.38886727652017111,1.8425438845086324,-3.2224523770512765,4.0001869300916182]
[null,"Luxury hotel offer",2.7491388578652369,1.7991977698993564,-0.77722397220228423,6.2755016879327581]
[null,"Nightlife",0.88741656667996993,1.9456966105252178,-2.9260787147911129,4.700911848151053]
[null,"Quality beaches",0.85405893445332193,1.6071168491041521,-2.2958322087383083,4.0039500776449524]
[null,"Shopping around",2.8797070344539666,1.8085512792549341,-0.66498833707954519,6.424402405987478]
[null,"Wildlife around",0]
[]
[]
[null,"Model coefficients (Respondent 2):"]
[]
[null,"Source","Mean","Standard error","Quantile (2,5%)","Quantile (97,5%)"]
[null,"Cultural activities",2.7584652132077703,1.7280470102003223,0,0]
[null,"Entertainement",0.7290118555052888,1.7555260741932508,0,0]
[null,"Local cuisine",-1.6015430174913228,2.6776347968745546,0,0]
[null,"Luxury hotel offer",1.4519609286046686,1.8997703924491562,0,0]
[null,"Nightlife",-1.31606932996571,2.7418313800692191,0,0]
[null,"Quality beaches",1.1808860081622901,1.6832187214741972,0,0]
[null,"Shopping around",1.2395194099048041,1.8210759478386451,0,0]
[null,"Wildlife around",0,null,0,0]
[]
[]
[null,"Model coefficients (Respondent 3):"]
[]
[null,"Source","Mean","Standard error","Quantile (2,5%)","Quantile (97,5%)"]
[null,"Cultural activities",0.24499128814525101,1.5114728215486253,-2.7174410057011902,3.2074235819916921]
[null,"Entertainement",-3.0235666782531476,2.5024121597850209,-7.928204385906878,1.8810710294005832]
[null,"Local cuisine",1.3766000652068575,1.2964417965768307,-1.1643791641361332,3.917579294549848]
[null,"Luxury hotel offer",-0.10425386931590461,1.4896784484358405,-3.0239699767956592,2.8154622381638501]
[null,"Nightlife",0.12025155787486518,1.5911426708139198,-2.9983307711852878,3.2388338869350184]
[null,"Quality beaches",-2.9069395626029304,2.6965532936801671,-8.1920869006089152,2.3782077754030553]
[null,"Shopping around",0.14609525780882796,1.3261356036581917,-2.4530827639775108,2.7452732795951666]
[null,"Wildlife around",0]
[]
[]
[null,"Model coefficients (Respondent 4):"]
[]
[null,"Source","Mean","Standard error","Quantile (2,5%)","Quantile (97,5%)"]
[null,"Cultural activities",1.5255344264101354,1.6149038372572486,-1.6396189331096038,0]
[null,"Entertainement",-2.7747430702702749,2.2904662869420043,-7.2639745004797875,0]
[null,"Local cuisine",-2.6183809440654962,3.0464738200354198,-8.5893599111790753,0]
[null,"Luxury hotel offer",0.8561902358457939,1.7535874801027089,-2.5807780688958633,0]
[null,"Nightlife",0.89462541140143403,1.6650585519251049,-2.3688293825221862,0]
[null,"Quality beaches",-0.62803138408975356,1.7282440075218817,-4.0153273953298108,0]
[null,"Shopping around",2.4230730567662455,1.6938813648221358,-0.896873412368692,0]
[null,"Wildlife around",0,null,null,0]
[]
[]
[null,"Model coefficients (Respondent 5):"]
[]
[null,"Source","Mean","Standard error","Quantile (2,5%)","Quantile (97,5%)"]
[null,"Cultural activities",0.88558047070936785,1.3829602580944491,0,0]
[null,"Entertainement",-1.2802108999232096,1.5967342244575686,0,0]
[null,"Local cuisine",-2.6327324748968497,2.4760858886620825,0,0]
[null,"Luxury hotel offer",-8.5124214255204184E-3,1.4137902368696749,0,0]
[null,"Nightlife",0.21519003798195896,1.453337484985515,0,0]
[null,"Quality beaches",-3.0511136781544552,2.1874422369318238,0,0]
[null,"Shopping around",0.1730327000505418,1.2630758311828603,0,0]
[null,"Wildlife around",0,null,0,0]