Hi,
I conducted a conjoint experiment in Qualtrics. The data that Qualtrics provide is like this:
These are the attributes and levels for the analysis, each respondent choice one profile among the two choices (for 4 questions).
So I want to reshape this dataset to a format that I can run a conjoint analysis like the one below:
I reshaped the dataset first by the questions however, I really cannot figure out how to reshape when the attribute order is random. Is there a way to arrange the dataset like that?
Thank you.
I conducted a conjoint experiment in Qualtrics. The data that Qualtrics provide is like this:
These are the attributes and levels for the analysis, each respondent choice one profile among the two choices (for 4 questions).
| attributes | ||
| Color | red | blue |
| Weight | 35gr | 70gr |
| Height | 5cm | 8cm |
| Shape | round | square |
| Attribute1 | Attribute2 | Attribute3 | Attribute4 | Level1_For profile1 | Level2_For profile 1 | Level3_For profile_1 | Level4_For profile_1 | Level1_for profile2 | Level2_for profile2 | Level3_for profile2 | Level 4 for profile2 | Choice | |
| Respondent 1 | Color | Weight | Height | Shape | Red | 35gr | 5cm | square | red | 70gr | 8cm | square | Profile 1 |
| Respondent2 | Weight | Shape | Color | Height | 35gr | round | Red | 8 cm | 35gr | square | blue | 8cm | Profile 2 |
So I want to reshape this dataset to a format that I can run a conjoint analysis like the one below:
| Color | Weight | Height | Shape | Question | Choice | |
| Respondent1 | Red | 35gr | 5cm | square | 1 | 1 |
| Respondent1 | Red | 70gr | 8cm | square | 1 | 0 |
| Respondent1 | Blue | 70gr | 5cm | round | 2 | 0 |
| Respondent1 | Red | 70gr | 8cm | square | 2 | 1 |
I reshaped the dataset first by the questions however, I really cannot figure out how to reshape when the attribute order is random. Is there a way to arrange the dataset like that?
Thank you.
Comment