Include mean of dependent variable as a row in "etable"

[bgchamps]

Hi Laurent,

In my regression tables, I'd like to have a row at the bottom indicating the mean of the dependent variable (along with the currently supported number of observations and r squared). Is there a way etable could support this feature?

[lrberge]

It is supported, there's the argument extraline doing that. Of course, you have to compute the means on your own.

Here's an example:

base = iris
names(base) = c("y", "x1", "x2", "x3", "species")
s = base$species

library(fixest)
est_setosa = feols(y ~ x1 + x2, base[s == "setosa",])
est_versicolor = feols(y ~ x1 + x2, base[s == "versicolor",])
est_virginica = feols(y ~ x1 + x2, base[s == "virginica",])

all_means = sapply(c("setosa", "versicolor", "virginica"),
                   function(v) mean(base[s == v, "y"]))

etable(est_setosa, est_versicolor, est_virginica, extraline = list("$\\bar{y}$"=all_means), tex = TRUE)

This leads to:

To place the line after the statistics you need to add a special markup in curly brackets (where:stat) at the beginning of the row name:

etable(est_setosa, est_versicolor, est_virginica, extraline = list("{where:stat}$\\bar{y}$"=all_means), tex = TRUE)

Which leads to:

You can add as many lines as you wish. For more customization of the table, there's this vignette.

[bgchamps]

Many thanks Laurent! I was able to implement this procedure after updating R to the latest version, followed by updating fixest to the latest version. Regards, Bhargav

…

On Aug 26, 2020, at 3:43 AM, Laurent Bergé ***@***.***> wrote:  It is supported, there's the argument extraline doing that. Of course, you have to compute the means on your own. Here's an example: base = iris names(base) = c("y", "x1", "x2", "x3", "species") s = base$species library(fixest) est_setosa = feols(y ~ x1 + x2, base[s == "setosa",]) est_versicolor = feols(y ~ x1 + x2, base[s == "versicolor",]) est_virginica = feols(y ~ x1 + x2, base[s == "virginica",]) all_means = sapply(c("setosa", "versicolor", "virginica"), function(v) mean(base[s == v, "y"])) etable(est_setosa, est_versicolor, est_virginica, extraline = list("$\\bar{y}$"=all_means), tex = TRUE) This leads to: To place the line after the statistics you need to add a special markup in curly brackets (where:stat) at the beginning of the row name: etable(est_setosa, est_versicolor, est_virginica, extraline = list("{where:stat}$\\bar{y}$"=all_means), tex = TRUE) Which leads to: You can add as many lines as you wish. For more customization of the table, there's this vignette. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.

[lrberge]

Super :-), I'm closing then.