I want to create a table looking at the conditional mean of a survey variable by a range…
- User
I want to create a table looking at the conditional mean of a survey variable by a range of demographic measures. What is the best way to do this in R in the most efficient code? Ideally I want one big plot with the conditional mean of a single "trust" variable and all of the y-values on the plot be different demographic variables to see them altogether
- Assistant
Below is a step-by-step recipe for computing and plotting the conditional means of one trust variable (
trust_people) by a handful of demographic groupings (e.g. gender, age‐group, education, income), all in one “big plot.”1. Define your demographic variables
demo_vars <- c("gender", "age_group", "education_level", "income_quartile")These should be the names of the columns in your
simple_design$variables(or in your original data) that define the groups you care about.2. Compute weighted means + CIs for each demo var
We’ll loop over
demo_vars, callsvyby()once per variable, stash the results in a single data frame, and tag each row with the variable name and the level name.library(survey) library(purrr) library(dplyr) all_trust_summary <- map_dfr(demo_vars, function(dv) { # 1) build a one‐sided formula for svyby: ~gender, ~age_group, etc. by_fml <- as.formula(paste0("~", dv)) # 2) call svyby() for trust_people tmp <- svyby( formula = ~trust_people, by = by_fml, design = simple_design, FUN = svymean, vartype = c("ci","se"), ci.level = 0.95, na.rm = TRUE ) # 3) Tidy column names & capture the “level” for this dv tmp %>% rename( mean = trust_people, se = trust_people_se, ci_low = trust_people_ci_l, ci_high = trust_people_ci_u ) %>% mutate( demo_var = dv, level = as.character(.data[[dv]]) ) %>% select(demo_var, level, mean, se, ci_low, ci_high) })At the end of that you’ll have a tibble with columns
demo_var– which demographic variable (e.g. “gender”)level– the factor‐level (e.g. “Male”, “Female”)mean,se,ci_low,ci_high– your weighted estimates
3. (Optional) Order the factor–levels
If you want your age groups or income quartiles to appear in a sensible order, do something like:
all_trust_summary <- all_trust_summary %>% mutate( demo_var = factor(demo_var, levels = demo_vars), level = case_when( demo_var == "age_group" ~ factor(level, levels = c("18-29","30-44","45-59","60+")), demo_var == "income_quartile" ~ factor(level, levels = paste0("Q",1:4)), TRUE ~ factor(level) ) )4. Plot everything in one “lollipop” style graphic
Here we put all
demo_var×levelcombinations on the y–axis, andmeanon the x–axis, with horizontal error bars for the 95% CI. We facet bydemo_varto keep each demographic type on its own strip:library(ggplot2) library(forcats) ggplot(all_trust_summary, aes(x = mean, y = fct_reorder(paste0(demo_var, ": ", level), mean))) + geom_point(size = 2, colour = "steelblue") + geom_errorbarh(aes(xmin = ci_low, xmax = ci_high), height = 0, colour = "gray50") + facet_grid(demo_var ~ ., scales = "free_y", space = "free_y") + labs( x = "Weighted mean of Trust in People", y = NULL, title = "Conditional Mean of Trust by Demographic Groups", subtitle = "Point estimates ± 95% CI" ) + theme_minimal() + theme( strip.text.y = element_text(angle = 0, face = "bold"), axis.text.y = element_text(size = 10), panel.spacing.y = unit(0.5, "lines") )What this gives you is a single plot with separate strips for
- gender (Male vs Female)
- age_group (18–29, 30–44, …)
- education_level (e.g. “High school”, “Bachelor”, …)
- income_quartile (Q1–Q4)
and for each category a dot (the mean) and horizontal whiskers (the 95 % CI).
A few tuning tips
- If you have many levels (e.g. 10 income bins), consider shrinking text or using fewer bins.
- You can swap facets for colour: map
colour = demo_varand drop the facet if you prefer an overlaid dot‐plot. - Feel free to reorder the y–axis differently by tweaking the
fct_reorder()call.
This pattern—
map_dfr()→svyby()→bind_rows()→ singleggplot()—is both concise and highly flexible for any set of grouping variables.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.