Hi everyone,
I am looking for some advice on which model specification to use for the analysis of choice experiment data.
I have choice experiment data on fertilizer preferences. The design included two fertilizer alternatives as well as an opt-out alternative.
When one of the two fertilizer alternatives was chosen, the respondent was asked to indicate whether they would use that fertilizer as a complement (C) or as a substitute (S) to their current fertilizers.
I have previously used the Apollo package to estimate MNL (and MMNL) models to estimate fertilizer preferences. To do this, I used the following (simplified) utility functions:
V[["alt1"]] = b_price * price.1 + b_npk * npk.1
V[["alt2"]] = b_price * price.2 + b_npk * npk.2
V[["alt3"]] = asc
with the values 1,2,3 being the values of choice variable 'choice', corresponding to the respective alternatives.
Now, I'd like to know how the fertilizer attributes influence whether they are used as C or as S. I have tried to analyze this by creating a new variable called "use", equal to 1 when the fertilizer was chosen as a complement, 2 when the fertilizer was chosen as a substitute and 3 when the opt-out was chosen. Then, I estimated a similar MNL-model with the following utility functions:
V[["use1.1"]] = b_price_c * price.1 + b_npk_c * npk.1
V[["use1.2"]] = b_price_c * price.2 + b_npk_c * npk.2
V[["use2.1"]] = b_price_s * price.1 + b_npk_s * npk.1
V[["use2.2"]] = b_price_s * price.2 + b_npk_s * npk.2
V[["use3"]] = asc
with the values 1.1, 1.2, 2.1, 2.2 and 3 being the values of the new choice variable 'use', corresponding to the respective use options: 1.1 if alternative 1 was chosen as a complement, 1.2 if alternative 2 was chosen as a complement, 2.1 if alternative 1 was chosen as a substitute, 2.2 if alternative 2 was chosen as a substitute and 3 if the opt-out was chosen.
I am wondering if this is the correct approach, or if I need some kind of 2-step procedure.
Any help is greatly appreciated!
Best,
Erika
Important: Read this before posting to this forum
- This forum is for questions related to the use of Apollo. We will answer some general choice modelling questions too, where appropriate, and time permitting. We cannot answer questions about how to estimate choice models with other software packages.
- There is a very detailed manual for Apollo available at http://www.ApolloChoiceModelling.com/manual.html. This contains detailed descriptions of the various Apollo functions, and numerous examples are available at http://www.ApolloChoiceModelling.com/examples.html. In addition, help files are available for all functions, using e.g. ?apollo_mnl
- Before asking a question on the forum, users are kindly requested to follow these steps:
- Check that the same issue has not already been addressed in the forum - there is a search tool.
- Ensure that the correct syntax has been used. For any function, detailed instructions are available directly in Apollo, e.g. by using ?apollo_mnl for apollo_mnl
- Check the frequently asked questions section on the Apollo website, which discusses some common issues/failures. Please see http://www.apollochoicemodelling.com/faq.html
- Make sure that R is using the latest official release of Apollo.
- Users can check which version they are running by entering packageVersion("apollo").
- Then check what is the latest full release (not development version) at http://www.ApolloChoiceModelling.com/code.html.
- To update to the latest official version, just enter install.packages("apollo"). To update to a development version, download the appropriate binary file from http://www.ApolloChoiceModelling.com/code.html, and install the package from file
- If the above steps do not resolve the issue, then users should follow these steps when posting a question:
- provide full details on the issue, including the entire code and output, including any error messages
- posts will not immediately appear on the forum, but will be checked by a moderator first. We check the forum at least twice a week. It may thus take a couple of days for your post to appear and before we reply. There is no need to submit the post multiple times.
Two-step analysis
-
stephanehess
- Site Admin
- Posts: 1367
- Joined: 24 Apr 2020, 16:29
Re: Two-step analysis
Erika
so the second question is only asked if they choose one of the fertiliser options. In that case, you would need to only use those rows of the data where that happens (you can use the rows setting for that). Also, your current code assumes that both fertilisers are available in that second choice, but I understand it is only for the chosen one. So you would also need to set availabilities, e.g.
avail=list(use1.1=(choice_stage1==1),
...)
so the second question is only asked if they choose one of the fertiliser options. In that case, you would need to only use those rows of the data where that happens (you can use the rows setting for that). Also, your current code assumes that both fertilisers are available in that second choice, but I understand it is only for the chosen one. So you would also need to set availabilities, e.g.
avail=list(use1.1=(choice_stage1==1),
...)
Re: Two-step analysis
Thanks a lot for your response, I really appreciate the help.
If I understand correctly, the idea is (1) to only use the rows where respondents chose one of the two fertilizer alternatives (excluding those who selected the opt-out), and (2) to only account for the attributes of the fertilizer they selected in the first stage of the experiment. This makes sense, as we are narrowing the analysis to just the chosen alternative.
However, by focusing on just the chosen fertilizer and excluding the alternative, there is no trade-off between the attributes anymore.
Would it then be valid to use a simple binary logit model, where the comparison is only between using the chosen fertilizer as a complement or a substitute?
Looking forward to your thoughts!
If I understand correctly, the idea is (1) to only use the rows where respondents chose one of the two fertilizer alternatives (excluding those who selected the opt-out), and (2) to only account for the attributes of the fertilizer they selected in the first stage of the experiment. This makes sense, as we are narrowing the analysis to just the chosen alternative.
However, by focusing on just the chosen fertilizer and excluding the alternative, there is no trade-off between the attributes anymore.
Would it then be valid to use a simple binary logit model, where the comparison is only between using the chosen fertilizer as a complement or a substitute?
Looking forward to your thoughts!
-
stephanehess
- Site Admin
- Posts: 1367
- Joined: 24 Apr 2020, 16:29
Re: Two-step analysis
Hi
well, if the question they are being asked is for the chosen alternative only, then there would be no trade-off. But of course the attributes of the chosen alternative would still influence the choice between C and S.
Does that make sense?
Stephane
well, if the question they are being asked is for the chosen alternative only, then there would be no trade-off. But of course the attributes of the chosen alternative would still influence the choice between C and S.
Does that make sense?
Stephane