conjoint (analyze).xlsx

conjoint (analyze).xlsx - XLSTAT 2018.6.53888 Designs for...

This preview shows page 1 - 20 out of 73 pages.

Factors/Categories table: Workbook = brand change conjoint - Editable 1.xlsm / She Repetitions: 10 / Initial partition: Random Maximum number of profiles: 16 Number of respondents: 200 Maximum number of comparisons: 16 Number of profiles per comparison: 3 Initial partition: 951369499 Variable information: Short name Nbr. of categories Category 1 Gambling 3 Grand Casino Onsen 3 Normal Onsen Food 3 Exceptional Food Attractions 3 Large Marina with restaurants Price 3 15000 Profiles (Optimized): Observations Gambling Onsen Profile 1 Small scale gambling Normal Onsen Profile 2 Small scale gambling Normal Onsen Profile 3 Grand Casino Normal Onsen Profile 4 Grand Casino Normal Onsen Profile 5 Grand Casino No Profile 6 No Black sand Spa treatment Profile 7 No Normal Onsen Profile 8 Small scale gambling No Profile 9 No No Profile 10 Small scale gambling No Profile 11 Small scale gambling Black sand Spa treatment Profile 12 No No Profile 13 Small scale gambling Black sand Spa treatment Profile 14 No Normal Onsen Profile 15 Grand Casino Black sand Spa treatment Profile 16 Grand Casino No Designs for conjoint analysis: Comparison Choice 1 Choice 2 Comparison 1 16 1 Comparison 2 3 4 Comparison 3 6 7 Comparison 4 9 10 XLSTAT 2018.6.53888 - Designs for choice-based conjoint analysis - Start time: 21/1
Image of page 1

Subscribe to view the full document.

Comparison 5 12 13 Comparison 6 1 2 Comparison 7 4 5 Comparison 8 7 8 Comparison 9 10 11 Comparison 10 13 14 Comparison 11 2 3 Comparison 12 5 6 Comparison 13 8 9 Comparison 14 11 12 Comparison 15 14 15 Comparison 16 15 16 Enter the code associated to the choice made (from 1 to 3). Enter the 0 value if none of the choices have been selected. Once you filled the conjoint design with individuals responses, you can click the abo Optimization summary Statistics for each iteration: Log(Determinant) 0 8.835 1 9.480 2 9.959 3 10.168 4 10.239 5 10.313 6 10.411 7 10.471 8 10.501 9 10.548 10 10.592 11 10.615 12 10.642 13 10.667 Repetition Number of experiments Iteration 1 16 10 2 16 9 3 16 10 4 16 7 5 16 15 6 16 13 7 16 5 8 16 12 9 16 8 10 16 8
Image of page 2
Image of page 3

Subscribe to view the full document.

Image of page 4
Image of page 5

Subscribe to view the full document.

Image of page 6
Image of page 7

Subscribe to view the full document.

Image of page 8
Image of page 9

Subscribe to view the full document.

Image of page 10
Image of page 11

Subscribe to view the full document.

Image of page 12
Image of page 13

Subscribe to view the full document.

Image of page 14
Image of page 15

Subscribe to view the full document.

Image of page 16
Image of page 17

Subscribe to view the full document.

eet = Sheet1 / Range = Sheet1!$G$1:$K$4 / 3 rows and 5 columns Category 2 Category 3 Small scale gambling No Black sand Spa treatment No Buffee Normal nsive Amusement park (Disney) World Reknown Art Museum 18000 22000 Food Attractions Price Normal Large Marina with restaurants 22000 Exceptional Food World Reknown Art Museum 15000 Normal World Reknown Art Museum 18000 Buffee Extensive Amusement park (Disney) 18000 Exceptional Food Extensive Amusement park (Disney) 22000 Normal Extensive Amusement park (Disney) 22000 Buffee Extensive Amusement park (Disney) 15000 Normal Extensive Amusement park (Disney) 15000 Normal World Reknown Art Museum 18000 Buffee Large Marina with restaurants 18000 Exceptional Food Extensive Amusement park (Disney) 18000 Exceptional Food Large Marina with restaurants 15000 Buffee World Reknown Art Museum 22000 Exceptional Food Large Marina with restaurants 22000 Normal Large Marina with restaurants 15000 Buffee World Reknown Art Museum 22000 Choice 3 Individual 1 Individual 2 15 3 1 2 3 2 5 2 2 8 2 2 12/2018 at 19:02:38 / End time: 21/12/2018 at 19:02:44 / Microsoft Excel 16.011029
Image of page 18
11 1 2 16 2 2 3 1 1 6 1 1 9 1 2 12 3 1 1 1 1 4 3 3 7 3 3 10 2 1 13 2 3 14 1 1
Image of page 19

Subscribe to view the full document.

Image of page 20
  • Fall '19
  • Choice-based conjoint, Large Marina

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern