Descriptive statistics for sub-groups of a categorical variable against a dependent variable in multiple regression

[jonathan rothwell]

Hello everyone,

The first table below I have tabulated primary attendance rates of 27 CCT progrms by category of enforcement (LCT-Strict), the thing of interest to me is the mean attendance rates by sub-group of enforcement (LCT-Strict). After this table is a multiple regression with covariates included, with regression 4 being the final one of interest. I now want to display the same descriptive statistics table as below, but for the multiple regression in column 4 with the covariates included so I can see how the different categories perform when holding all else constant. Below is the code for regression 4, what should i add to see the means? Stata won't let me use tabulate in conjunction with metareg.

Kind regards,

Jon

Stata command: metareg primaryattendanceef_pp Comp_Cat meets2 pnet yrs_treatment mother national mbimonthly primsub2015 condachiev supply, wsse(primaryattendancese_pp)

Linear descriptive statistics table of regression between enforcement severity (by mechanism) and attendance rates in %.

Mechanism	Mean (%)	Std. Dev.	Freq.
LCT	2.875	3.753	7
Information	7.325	4.419	4
Lenient	5.677	11.186	8
Strict	4.687	5.786	8
Total	4.901	7.100	27

Multiple regression with covariates added - I want to see compliance severity means (4) by sub-group as in above table

VARIABLES	(1)	(2)	(3)	(4)
Compliance Severity	0.280	1.578**	1.661**	1.804***
	(0.709)	(0.670)	(0.574)	(0.510)
LAC dummy		0.794	1.193
		(2.691)	(2.007)
Africa dummy		-0.790
		(3.675)
Meets evidence standards		-2.061	-2.219	-1.925
		(3.625)	(3.307)	(2.596)
Baseline enrolment		-34.305***	-33.674***	-33.039***
		(10.509)	(9.845)	(8.554)
Years of exposure		-0.148	-0.138	-0.104
		(0.468)	(0.442)	(0.296)
Mother dummy		-0.166	-0.152	0.490
		(2.472)	(2.318)	(1.757)
National dummy		-3.320	-3.385*	-3.539*
		(2.008)	(1.903)	(1.734)
Start-up dummy		-0.240	-0.058
		(2.067)	(1.825)
Payment frequency		0.797	0.356	1.339
		(3.231)	(2.482)	(1.790)
Average transfer		0.017	0.018	0.023
		(0.022)	(0.021)	(0.016)
Achievement conditionality		0.093	0.051	-0.066
		(2.266)	(2.116)	(1.880)
Supply component		6.020**	6.105**	7.015***
		(2.309)	(2.194)	(1.676)
Constant	2.755	32.019***	31.206***	29.395***
	(2.089)	(10.029)	(9.314)	(8.695)
Observations	27	27	27	27
Standard errors in parentheses
*** p<0.01, ** p<0.05, * p<0.1

[jonathan rothwell]

*** The first table is simply tabulating attendance rates by the categorical variable of compliance mechanism, I just want to attach this command onto the multiple regression to see all else constant, what the means are by sub-group, and break down the 1.804*** in regression 4 down by subgroup

[jonathan rothwell]

Does anyone have any thoughts on this?

Kind regards,

Jon

[Mike Lacy]

The formatting of your material makes it quite difficult to read, and I at least don't find your description entirely clear. I'd suggest you take at look at the FAQ, which would offer some helpful suggestions on the former. As for clarity, one thing to keep in mind is that quite a variety of discipline and geographic backgrounds are represented here, so people like me won't know what you mean by a "CCT program," which might or might not matter to us as regards understanding your question. More generally, your description depends substantially on knowing the context of your problem (e.g. "attendance rates"-- at what), which we don't, so that's also making it tough for us.

As a last item, "bumping" your question only 3 hr. after your initial post is very quick. No one in this forum is paid to respond, so I'd encourage you to be a bit more patient about how quickly help might arrive.