Hello all,
I need your help regarding rangestat command. I have a panel dataset with the panel dimensions as stores and weeks. I have the sales price of 11 products in each combination of stores and weeks.
I want to create an average price for each product across the other stores but within the same week. For instance, for product 1, I want the average price of product 1 sold at all the stores in a given week, etc.
I am using the command
rangestat (mean) average_price = price, interval(store 1 137) excludeself by (product week)
I am not sure if I am using the command correctly. I tried to compute the values of a couple of observations manually to validate te results and I think they are not the same. For instance, I filtered my data to only include product 1 and week 1. I then calculated the average price of product 1 sold in week 1 at all the stores. I got a different result.
Would you please help? Am I defining the command correctly? the interval should include the stores, am I right?
Related Posts with rangestat command
Commands to get the graph between cumulative distribution function of years of schooling and birth orderDear stat specialists, I am working with cross-sectional data obtained from Pakistan Bureau of stati…
Downloading data from internetHello, I need to download data from this website. Technically, to download data one is supposed to c…
Summary statistics over two groupsI want to have the mean and sd of a variable separated by two grouping variables, like below but in …
Finding the maximum value for a subset of observationsHi everyone, I have a panel dataset with 148 countries and 70 years and I am trying to identify epi…
Pooled regression with interaction term for time?Dear All! I have panel data (time: 2 periods; N: 2,093) and because the Breusch and Pagan Lagrange …
Subscribe to:
Post Comments (Atom)
0 Response to rangestat command
Post a Comment