Hi,
I would like to go from that shape (first example) of the Likert data:
df_likert <- structure(list(Sex = c(1L, 2L, 1L, 2L), `Age Group` = structure(c(1L,
1L, 2L, 2L),
.Label = c("30-39", "40-49"), class = "factor"),
Q1 = c(1L, 3L, 4L, 2L), Q2 = c(7L, 5L, 6L, 2L), Q3 = 1:4,
Q4 = c(5L, 6L, 2L, 2L)), class = "data.frame", row.names = c(NA,
-4L))
and that form (second example):
q1<-c(2,2,3,3,3,4,4,4,5,5)
q2<-c(2,3,3,4,4,4,4,5,5,5)
q3<-c(2,2,2,3,4,4,4,5,5,5)
q4<-c(2,2,2,3,4,4,4,5,5,5)
q5<-c(2,2,2,3,4,4,4,5,5,5)
df_likert2 <-data.frame(q1,q2,q3, q4, q5)
into that form (final form):
Year1_likert_exhibits <- structure(list(Item = c("Were informative and educational", "Were easy to read",
"Covered topics I liked", "Were introduced in an informative way by staff",
"Were informative and educational", "Were easy to read", "Covered topics I liked",
"Were introduced in an informative way by staff", "Were informative and educational",
"Were easy to read", "Covered topics I liked", "Were introduced in an informative way by staff",
"Were informative and educational", "Were easy to read", "Covered topics I liked",
"Were introduced in an informative way by staff", "Were informative and educational",
"Were easy to read", "Covered topics I liked", "Were introduced in an informative way by staff"
), Evaluation = c("Strongly agree", "Strongly agree", "Strongly agree",
"Strongly agree", "Somewhat agree", "Somewhat agree", "Somewhat agree",
"Somewhat agree", "Neither agree nor disagree", "Neither agree nor disagree",
"Neither agree nor disagree", "Neither agree nor disagree", "Somewhat disagree",
"Somewhat disagree", "Somewhat disagree", "Somewhat disagree",
"Strongly disagree", "Strongly disagree", "Strongly disagree",
"Strongly disagree"), Value = c(135, 136, 134, 122, 24, 21, 24,
21, 3, 2, 4, 16, 2, 3, 1, 2, 4, 4, 4, 4), percent = c(20, 20,
20, 18, 4, 3, 4, 3, 0, 0, 1, 2, 0, 0, 0, 0, 1, 1, 1, 1), level = c("5",
"5", "5", "5", "4", "4", "4", "4", "3", "3", "3", "3", "2", "2",
"2", "2", "1", "1", "1", "1")), row.names = c(NA, -20L), class = c("tbl_df",
"tbl", "data.frame"))
The level of coding is as usual with Likert scale and presented below as follows:
5 - Strongly agree, 4 - Somewhat agree, 3 - Neither agree nor disagree,
2 - Somewhat disagree, 1 - Strongly disagree
Obviously "Year1_likert_exhibits " is a different data and I have included it in here as an example to which I would like to get at the end. I am trying and struggle a bit so I returned here for help regarding that task. Thank you in advance for any guidance.