Hi, I have a large set of data sets and multiple variables. I want to do the following:
1. First I want to divide my variables into three groups (pre, post and between) based on year. For example, If the year is less than in 1990 it is pre_period. If the year is more than in 1995 it is post_period and if the year is between 1990 and 1995 then this group is "between". I don't know how to do that in STATA.
2. I want to find mean difference of many variables such as ROA, ROE, TA, CASH, R&D, CAPX and many others variables between pre and post period. I can do ttest for each variable separately but is there any way I can do them all together and find the mean difference in one table? There is another problem. Since I have three groups of data in my data set how can I do that pre post difference?
3. I want to get the output of mean difference in an excel table with significant result. Can I do that with Outreg2? if so,
how is that?
Can anyone please help me?
Related Posts with Group mean and separating data into 3 groups
Using predicted variables from principal component analysis (PCA) for an exploratory factor analysis (EFA)- In a fixed effects logit regression does Stata only drop observations that have no variation in the outcome variable? Or also the controls?
- -xtlogit- Four-Way Dummy Variable Interaction Term Interpretation
- Order of lincom output within a regression results table
- Having Variables in X-Axis side by side, rather than in different groups..
Subscribe to:
Post Comments (Atom)
0 Response to Group mean and separating data into 3 groups
Post a Comment