ggplot: plot mean values instead of counts

Question

I have the following sample data, which describe how long (duration) each respondent in my questionnaire needed to answer each question (question) and in which week the question was answered (there were several waves of the same questionnaire)

n <- 100

data2 <- data.frame(
  question = paste("q", sample(1:3, n, replace = TRUE), sep=""),
  week = sample(1:3, n, replace = TRUE),
  duration = round(rnorm(n, mean = 15, sd = 5), 0)
)

ggplot(aes(x = week, fill=question), data = data2) + geom_bar(position='stack') +
xlab("Week")

But how can I make the same plot with mean durations instead of counts (on the y-axis)?

Andy Baxter · Accepted Answer · 2020-10-09 11:21:02Z

2

stat_summary is the usual function for doing the calculations for you:

  ggplot(aes(x = week, y = duration, fill=question), data = data2) +
    stat_summary(fun=mean, geom="bar", position = "stack") +
    xlab("Week")

Edit: This changed my practice the other week when I found out what stat_ layers can do! Demystifying stat_ layers in ggplot2

edited Oct 9, 2020 at 11:21

answered Oct 9, 2020 at 11:09

Andy Baxter

7,7341 gold badge13 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Magnus Nordmo · Accepted Answer · 2020-10-09 10:27:50Z

1

I would use dplyr::group_bylike so.

data2 %>% 
  group_by(week,question) %>% 
  summarise(mean = mean(duration)) %>% 
  ggplot(aes(week,mean,fill = factor(question))) +
  geom_col()

Good luck!

answered Oct 9, 2020 at 10:27

Magnus Nordmo

9617 silver badges12 bronze badges

Collectives™ on Stack Overflow

ggplot: plot mean values instead of counts

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related