{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Attributes","Designs for MaxDiff","MaxDiff"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"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":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Attributes"]
[null,"Quality beaches"]
[null,"Cultural activities"]
[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":27,"n_cols":16,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2016.05.12345 - Designs for MaxDiff - Start time: 9/12/2016 at 1:59:21 PM / End time: 9/12/2016 at 1:59:22 PM / End time: 9/12/2016 at 1:59:22 PM"]
[null,"Quality beaches: Workbook = demoMaxDiff_US.xls / Sheet = Attributes / Range = Attributes!$B$2:$B$9 / 7 rows and 1 column"]
[null,"Data format: Combination \\ Respondent"]
[null,"Number of respondents: 5"]
[null,"Maximum number of combinations: 8"]
[null,"Number of attributes per combination: 4"]
[null,"Seed (random numbers): 123456789"]
[null,"Run again:"]
[]
[]
[]
[null,"Design: Hotel MaxDiff:"]
[]
[null,"Combinations","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","R4 Most important","R4 Least important","R5 Most important","R5 Least important"]
[null,"C1","Entertainement","Wildlife around","Quality beaches","Local cuisine",1,2,2,4,4,2,3,4,2,1]
[null,"C2","Cultural activities","Nightlife","Shopping around","Luxury hotel offer",2,1,1,4,4,3,1,3,1,4]
[null,"C3","Wildlife around","Local cuisine","Cultural activities","Quality beaches",1,4,4,3,3,1,4,3,4,3]
[null,"C4","Nightlife","Luxury hotel offer","Entertainement","Shopping around",4,2,2,3,3,2,1,2,1,3]
[null,"C5","Local cuisine","Quality beaches","Nightlife","Cultural activities",3,1,1,2,3,1,4,2,4,2]
[null,"C6","Luxury hotel offer","Shopping around","Wildlife around","Entertainement",3,4,4,1,1,4,3,4,4,3]
[null,"C7","Quality beaches","Cultural activities","Luxury hotel offer","Nightlife",4,3,3,4,4,3,3,4,3,4]
[null,"C8","Shopping around","Entertainement","Local cuisine","Wildlife around",2,4,3,1,1,3,2,1,3,2]
[null,"Enter the code associated to the chosen attribute (from 1 to 4)."]
[]
[]
[]
[null,"Once you filled the MaxDiff design with 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":234,"n_cols":12,"rows_kept":234,"cut":false,"hidden":false,"merged":[]}
[null,"XLSTAT 2016.05.12345 - MaxDiff - Start time: 9/12/2016 at 2:00:05 PM / End time: 9/12/2016 at 2:00:08 PM / End time: 9/12/2016 at 2:00:08 PM"]
[null,"Responses: Workbook = demoMaxDiff_US.xls / Sheet = Designs for MaxDiff / Range = 'Designs for MaxDiff'!$G$14:$P$22 / 8 rows and 10 columns"]
[null,"Method: Hierarchical Bayes"]
[null,"Confidence interval (%): 0.95"]
[null,"Convergence: 0.001"]
[null,"Iterations: 12660"]
[null,"Seed (random numbers): 123456789"]
[null,"Run again:"]
[]
[]
[]
[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",6,4,-2]
[null,"Entertainement",6,7,1]
[null,"Local cuisine",4,5,1]
[null,"Luxury hotel offer",6,8,2]
[null,"Nightlife",7,3,-4]
[null,"Quality beaches",4,4,0]
[null,"Shopping around",2,4,2]
[null,"Wildlife around",5,5,0]
[]
[]
[null,"Counts analysis / Respondent 1:"]
[]
[null,"Attributes","Most important","Least important","Difference"]
[null,"Cultural activities",0,1,1]
[null,"Entertainement",2,1,-1]
[null,"Local cuisine",0,1,1]
[null,"Luxury hotel offer",0,2,2]
[null,"Nightlife",3,0,-3]
[null,"Quality beaches",0,1,1]
[null,"Shopping around",1,0,-1]
[null,"Wildlife around",2,2,0]
[]
[]
[null,"Counts analysis / Respondent 2:"]
[]
[null,"Attributes","Most important","Least important","Difference"]
[null,"Cultural activities",1,1,0]
[null,"Entertainement",1,1,0]
[null,"Local cuisine",2,1,-1]
[null,"Luxury hotel offer",2,2,0]
[null,"Nightlife",0,1,1]
[null,"Quality beaches",1,1,0]
[null,"Shopping around",0,1,1]
[null,"Wildlife around",1,0,-1]
[]
[]
[null,"Counts analysis / Respondent 3:"]
[]
[null,"Attributes","Most important","Least important","Difference"]
[null,"Cultural activities",1,0,-1]
[null,"Entertainement",1,1,0]
[null,"Local cuisine",1,2,1]
[null,"Luxury hotel offer",2,2,0]
[null,"Nightlife",2,0,-2]
[null,"Quality beaches",0,0,0]
[null,"Shopping around",1,1,0]
[null,"Wildlife around",0,2,2]
[]
[]
[null,"Counts analysis / Respondent 4:"]
[]
[null,"Attributes","Most important","Least important","Difference"]
[null,"Cultural activities",2,1,-1]
[null,"Entertainement",1,1,0]
[null,"Local cuisine",0,1,1]
[null,"Luxury hotel offer",1,1,0]
[null,"Nightlife",1,1,0]
[null,"Quality beaches",2,1,-1]
[null,"Shopping around",0,2,2]
[null,"Wildlife around",1,0,-1]
[]
[]
[null,"Counts analysis / Respondent 5:"]
[]
[null,"Attributes","Most important","Least important","Difference"]
[null,"Cultural activities",2,1,-1]
[null,"Entertainement",1,3,2]
[null,"Local cuisine",1,0,-1]
[null,"Luxury hotel offer",1,1,0]
[null,"Nightlife",1,1,0]
[null,"Quality beaches",1,1,0]
[null,"Shopping around",0,0,0]
[null,"Wildlife around",1,1,0]
[]
[]
[null,"MaxDiff scores (Individual data):"]
[]
[null,"Source","Respondent 1","Respondent 2","Respondent 3","Respondent 4","Respondent 5"]
[null,"Cultural activities",5.759042851907286,15.738383734871341,12.895369490140521,24.476032751105599,22.431610395331791]
[null,"Entertainement",23.002089446469522,12.561980008997608,11.916851826468585,9.7184586242806823,11.34021761257943]
[null,"Local cuisine",3.8298122773487937,19.055639869216566,8.2902183972386876,4.4233442761527622,10.31001367091841]
[null,"Luxury hotel offer",7.2208069764964709,19.947725684297328,21.78678740411981,12.917324936096968,13.935613722869773]
[null,"Nightlife",30.567790042986449,6.753555606926537,23.992256874208849,14.758586344745511,15.051864297689008]
[null,"Quality beaches",2.9589061178577776,12.222252567454625,2.8206092292100498,20.865554739457892,13.137019202382264]
[null,"Shopping around",11.864445955653929,1.912044375937489,8.4244158688379009,1.809912004206887,2.2062123199775825]
[null,"Wildlife around",14.797106331279776,11.808418152298508,9.8734909097755956,11.030786323953695,11.587448778251741]
[]
[]
[null,"MaxDiff scores (Descriptive statistics):"]
[]
[null,"Source","Minimum","Maximum","Mean","Std. deviation"]
[null,"Cultural activities",5.759042851907286,24.476032751105599,16.260087844671308,7.5408038699867292]
[null,"Entertainement",9.7184586242806823,23.002089446469522,13.707919503759166,5.3015211503080755]
[null,"Local cuisine",3.8298122773487937,19.055639869216566,9.1818056981750438,6.1409928159789784]
[null,"Luxury hotel offer",7.2208069764964709,21.78678740411981,15.161651744776069,5.8394373433684006]
[null,"Nightlife",6.753555606926537,30.567790042986449,18.224810633311272,9.2098394122406937]
[null,"Quality beaches",2.8206092292100498,20.865554739457892,10.400868371272521,7.6347356435445866]
[null,"Shopping around",1.809912004206887,11.864445955653929,5.2434061049227578,4.6386525688879123]
[null,"Wildlife around",9.8734909097755956,14.797106331279776,11.819450099111863,1.8254540990195254]
[]
[]
[null,"Chart of average MaxDiff scores:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,"Model coefficients (Individual data):"]
[]
[null,"Source","Respondent 1","Respondent 2","Respondent 3","Respondent 4","Respondent 5"]
[null,"Cultural activities",-1.2267326301043762,0.41630398091763032,0.35702424638188512,1.3485660621190201,1.0483123280383022]
[null,"Entertainement",0.7936107455612319,8.5344520410251201E-2,0.24806727618591465,-0.16720968978449377,-2.886837972678662E-2]
[null,"Local cuisine",-1.6859745591483366,0.73113067666025133,-0.2188888907870413,-1.1030444444726153,-0.15397157170370487]
[null,"Luxury hotel offer",-0.95984739558230592,0.81289339779013003,1.2059770582929554,0.21920767206423605,0.25666693273402014]
[null,"Nightlife",1.5716718584788398,-0.70343590949464685,1.4023255566148627,0.4161808366070508,0.36993023229609662]
[null,"Quality beaches",-1.9662881933689411,4.7273139341602738E-2,-1.435971460263612,1.0086273330288256,0.17253004975022676]
[null,"Shopping around",-0.32178889385527037,-2.0866871052657912,-0.19916673309796462,-2.0626347316218907,-1.9039928481781683]
[null,"Wildlife around",0,0,0,0,0]
[]
[]
[null,"Goodness of fit statistics:"]
[]
[null,"Statistic","Independent","Full"]
[null,"Observations",320,320]
[null,"Sum of weights",320,320]
[null,"-2 Log(Likelihood)",1774.45678223346,82.855086349880509]
[null,"rlh",0.25,0.35498186356058936]
[]
[]
[null,"Model coefficients (Respondent 1):"]
[]
[null,"Source","Mean","Standard error","Quantile (2.5%)","Quantile (97.5%)"]
[null,"Cultural activities",-1.2267326301043762,1.8253655755935574,-4.8043834168869735,2.3509181566782211]
[null,"Entertainement",0.7936107455612319,1.0980676716644129,-1.3585623434887701,2.9457838346112339]
[null,"Local cuisine",-1.6859745591483366,1.6392612703782934,-4.898867610341167,1.5269184920444934]
[null,"Luxury hotel offer",-0.95984739558230592,1.7568514217648239,-4.4032129084293485,2.4835181172647367]
[null,"Nightlife",1.5716718584788398,1.3868242782337212,-1.1464537797450083,4.289797496702688]
[null,"Quality beaches",-1.9662881933689411,1.8096785744956934,-5.5131930229742849,1.5806166362364023]
[null,"Shopping around",-0.32178889385527037,1.4258688595331337,-3.1164405052174131,2.4728627175068723]
[null,"Wildlife around",0]
[]
[]
[null,"Model coefficients (Respondent 2):"]
[]
[null,"Source","Mean","Standard error","Quantile (2.5%)","Quantile (97.5%)"]
[null,"Cultural activities",0.41630398091763032,1.3204072175075803,-2.1716466103239718,3.0042545721592324]
[null,"Entertainement",8.5344520410251201E-2,1.1726430062182067,-2.212993538500212,2.3836825793207144]
[null,"Local cuisine",0.73113067666025133,1.2150443877649726,-1.6503125629766142,3.1125739162971171]
[null,"Luxury hotel offer",0.81289339779013003,1.2385566464654572,-1.6146330220948739,3.240419817675134]
[null,"Nightlife",-0.70343590949464685,1.6425363534754249,-3.9227480056042308,2.5158761866149368]
[null,"Quality beaches",4.7273139341602738E-2,1.3571162844307574,-2.6126259009754973,2.7071721796587025]
[null,"Shopping around",-2.0866871052657912,1.9654846944766775,-5.9389663186047903,1.7655921080732075]
[null,"Wildlife around",0]
[]
[]
[null,"Model coefficients (Respondent 3):"]
[]
[null,"Source","Mean","Standard error","Quantile (2.5%)","Quantile (97.5%)"]
[null,"Cultural activities",0.35702424638188512,1.2711781616010625,-2.1344391682900334,2.8484876610538037]
[null,"Entertainement",0.24806727618591465,1.110392840951101,-1.9282627007693554,2.4243972531411848]
[null,"Local cuisine",-0.2188888907870413,1.2238340229462323,-2.6175594988164224,2.1797817172423395]
[null,"Luxury hotel offer",1.2059770582929554,1.2499242712347243,-1.2438294967295775,3.6557836133154882]
[null,"Nightlife",1.4023255566148627,1.2329694651807288,-1.0142501891769775,3.8189013024067027]
[null,"Quality beaches",-1.435971460263612,1.5502582767848587,-4.4744218494970607,1.6024789289698369]
[null,"Shopping around",-0.19916673309796462,1.4367250597139485,-3.0150961058234613,2.6167626396275323]
[null,"Wildlife around",0]
[]
[]
[null,"Model coefficients (Respondent 4):"]
[]
[null,"Source","Mean","Standard error","Quantile (2.5%)","Quantile (97.5%)"]
[null,"Cultural activities",1.3485660621190201,1.2643693207606364,-1.1295522697291978,3.8266843939672381]
[null,"Entertainement",-0.16720968978449377,1.1168355834649906,-2.3561672100286524,2.0217478304596646]
[null,"Local cuisine",-1.1030444444726153,1.6054831514262879,-4.2497335990540046,2.0436447101087745]
[null,"Luxury hotel offer",0.21920767206423605,1.2362653482238826,-2.2038278857894418,2.6422432299179137]
[null,"Nightlife",0.4161808366070508,1.3560452343133551,-2.2416189840543033,3.0739806572684047]
[null,"Quality beaches",1.0086273330288256,1.2502249772588694,-1.441768594970966,3.4590232610286171]
[null,"Shopping around",-2.0626347316218907,1.6813228499199402,-5.3579669638492149,1.2326975006054337]
[null,"Wildlife around",0]
[]
[]
[null,"Model coefficients (Respondent 5):"]
[]
[null,"Source","Mean","Standard error","Quantile (2.5%)","Quantile (97.5%)"]
[null,"Cultural activities",1.0483123280383022,1.1983186540838924,-1.3003490759686376,3.3969737320452422]
[null,"Entertainement",-2.886837972678662E-2,1.1555326149550451,-2.2936706880000646,2.235933928546491]
[null,"Local cuisine",-0.15397157170370487,1.2713086432948446,-2.645690725796078,2.3377475823886686]
[null,"Luxury hotel offer",0.25666693273402014,1.1910192410001916,-2.0776878845205857,2.5910217499886259]
[null,"Nightlife",0.36993023229609662,1.2346907095498634,-2.0500190904678397,2.789879555060033]
[null,"Quality beaches",0.17253004975022676,1.2707972468977144,-2.3181867858219478,2.6632468853224016]
[null,"Shopping around",-1.9039928481781683,1.6082997218931034,-5.0562023794344357,1.2482166830780987]
[null,"Wildlife around",0]