Hello,
I aim to evaluate a policy that was implemented in several districts of India. The policy was implemented in different phases. Phase 1 covered 86 districts, phase 2 covered 42 districts, and Phase 3 covered 429 districts. Before performing the actual analysis, I want to show some summary statistics describing the districts by each phase. I have been able to create a table that looks like this (please see below). Now, to this, I want to add a 4th column that gives me ANOVA results of the difference between each district characteristic by phase. To get ANOVA, I have used the command:
foreach var of varlist v1-v27 {
oneway `var; phase
}
This command gives me ANOVA results, but separately, for each variable. I have 2 questions:
1). Is there a way I can generate a table that contains ANOVA results of all the variables together?
2). Is there a way, I can automatically merge the table generated in q1. with the summary stats table, I have displayed below?
Thank you very much, in advance,
Kanika
I aim to evaluate a policy that was implemented in several districts of India. The policy was implemented in different phases. Phase 1 covered 86 districts, phase 2 covered 42 districts, and Phase 3 covered 429 districts. Before performing the actual analysis, I want to show some summary statistics describing the districts by each phase. I have been able to create a table that looks like this (please see below). Now, to this, I want to add a 4th column that gives me ANOVA results of the difference between each district characteristic by phase. To get ANOVA, I have used the command:
foreach var of varlist v1-v27 {
oneway `var; phase
}
This command gives me ANOVA results, but separately, for each variable. I have 2 questions:
1). Is there a way I can generate a table that contains ANOVA results of all the variables together?
2). Is there a way, I can automatically merge the table generated in q1. with the summary stats table, I have displayed below?
| Phase 1 (mean) |
Phase 2 (mean) |
Phase 3 (mean) |
ANOVA | |
| v1 | 939.6207 | 954.3217 | 1015.133 | |
| v2 | 886.7803 | 902.9455 | 949.7363 | |
| v3 | 96.02942 | 93.72 | 86.05513 |
Thank you very much, in advance,
Kanika
