Hi everyone,
I'm trying to model the choices among different products from 2000 to 2018 in different areas. I have two ideas of modelling but not sure which one is better and is more achievable in STATA.
The first idea is to model the market share of different brands using panel data with regional variables. The dataset looks like the following.
`````````````````````````````````````````````````` `````````````````````````````````````````````````` `````````````````````````````````````````````````` ````````````````````````
ln(MarketShareOfTheProduct) Product Area AveragePriceOfTheProduct AttributesOfTheProduct Year
xxxx(numeric) A Spain(string) xxxxxx(numeric) sweet(string) 2000(numeric)
xxxx(numeric) A Italy(string) xxxxxx(numeric) sweet(string) 2001(numeric)
xxxx(numeric) A Greece(string) xxxxxx(numeric) sweet(string) 2002(numeric)
xxxx(numeric) A UK(string) xxxxxx(numeric) sweet(string) 2003(numeric)
xxxx(numeric) A Spain(string) xxxxxx(numeric) spicy(string) 2000(numeric)
xxxx(numeric) A Italy(string) xxxxxx(numeric) spicy(string) 2001(numeric)
xxxx(numeric) A Greece(string) xxxxxx(numeric) spicy(string) 2002(numeric)
xxxx(numeric) A UK(string) xxxxxx(numeric) spicy(string) 2003(numeric)
xxxx(numeric) B Spain(string) xxxxxx(numeric) sweet(string) 2000(numeric)
xxxx(numeric) B Italy(string) xxxxxx(numeric) sweet(string) 2001(numeric)
xxxx(numeric) B Greece(string) xxxxxx(numeric) sweet(string) 2002(numeric)
xxxx(numeric) B UK(string) xxxxxx(numeric) sweet(string) 2003(numeric)
xxxx(numeric) B Spain(string) xxxxxx(numeric) spicy(string) 2000(numeric)
xxxx(numeric) B Italy(string) xxxxxx(numeric) spicy(string) 2001(numeric)
xxxx(numeric) B Greece(string) xxxxxx(numeric) spicy(string) 2002(numeric)
xxxx(numeric) B UK(string) xxxxxx(numeric) spicy(string) 2003(numeric)
...... ...... ...... ...... ...... ......
The second idea is to use the multinominal logit model to capture the choice of different products. Each observation represents one purchase decision. As the following.
`````````````````````````````````````````````````` `````````````````````````````````````````````````` `````````````````````````````````````````````````` ````````````````````````
Product Area AveragePriceOfTheProduct AttributesOfTheProduct Year
A Greece(string) xxxxxx(numeric) sour(string) 2000(numeric)
C Italy(string) xxxxxx(numeric) sweet(string) 2000(numeric)
B Greece(string) xxxxxx(numeric) sweet(string) 2002(numeric)
C Italy(string) xxxxxx(numeric) sour(string) 2000(numeric)
B Spain(string) xxxxxx(numeric) spicy(string) 2003(numeric)
C Italy(string) xxxxxx(numeric) spicy(string) 2000(numeric)
A Greece(string) xxxxxx(numeric) spicy(string) 2001(numeric)
A UK(string) xxxxxx(numeric) sour(string) 2001(numeric)
B Spain(string) xxxxxx(numeric) sweet(string) 2003(numeric)
C Italy(string) xxxxxx(numeric) sour(string) 2001(numeric)
B Greece(string) xxxxxx(numeric) sweet(string) 2001(numeric)
A Greece(string) xxxxxx(numeric) sweet(string) 2003(numeric)
C Spain(string) xxxxxx(numeric) sour(string) 2000(numeric)
B Italy(string) xxxxxx(numeric) spicy(string) 2001(numeric)
C Greece(string) xxxxxx(numeric) sour(string) 2002(numeric)
B UK(string) xxxxxx(numeric) spicy(string) 2001(numeric)
...... ...... ...... ...... ...... ......
It will be really appreciated if any suggestions can be provided regarding my question.
Many thanks!!!!
Related Posts with Modelling market share of brands using panel data with cross-sectional variables
By Patient ID subtract dates if observation (admission ID) condition is metHi all, I'm working on a fairly large hospital readmission dataset with 350 vars and 1.5M observati…
xtabond2 command help, PLEASEHi all! I am just getting into GMM (dynamic panel) for the first time, and I'm having much difficult…
Variation within a groupHello To detect if the value of a numeric variable var_num changed within a group var_cat, I do this…
Aggregate individual-level data into household-level dataHi. I am working with a survey that gathers information on an individual level. The survey asks all …
Problem with using margins code and creating a dummy variable on command boxDear statalist I have a problem using margins on stata command. I'm doing some research related to …
Subscribe to:
Post Comments (Atom)
0 Response to Modelling market share of brands using panel data with cross-sectional variables
Post a Comment