I am little confused about how to structure my specific data for multilevel analysis.
I have 10 categories and each category has some items in them.
The dataset is available for 117 weeks. There is quantity share and price index available on all of them.
My usual regression takes place with predicting the quantity mix by using the price indices for items within a category. This gives me regression coefficients for items but by treating every category separately.
I aim to use the multi level modeling approach to see the regression coefficients effects between items and categories.
This makes the model quite complicated and I’m not sure how to structure the data.