Loading Packages

library(readxl)
library("ggplot2")

Reading in Data

data = read_excel("/Users/sumedhasripada/Downloads/PennData.xlsx")

Creating data frames

df1 <- data.frame(rating = c("1", "2", "3", "4"), percentage = c(data$A))
df2 <- data.frame(rating = c("1", "2", "3", "4"), percentage = c(data$B))
df3 <- data.frame(rating = c("1", "2", "3", "4"), percentage = c(data$C))
df4 <- data.frame(rating = c("1", "2", "3", "4"), percentage = c(data$D))
df5 <- data.frame(rating = c("1", "2", "3", "4"), percentage = c(data$E))
df6 <- data.frame(rating = c("1", "2", "3", "4"), percentage = c(data$F))
df7 <- data.frame(rating = c("1", "2", "3", "4"), percentage = c(data$G))
df8 <- data.frame(rating = c("1", "2", "3", "4"), percentage = c(data$H))

Plot 1

plot <- ggplot(df1, aes(rating, percentage)) + geom_bar(stat = "identity")+ geom_text(aes(label = signif(percentage)), nudge_y = .02) + ggtitle("Conduct an Interview")
plot

Plot 2

plot <- ggplot(df2, aes(rating, percentage)) + geom_bar(stat = "identity")+ geom_text(aes(label = signif(percentage)), nudge_y = .02) + ggtitle("Develop Evidence Based Project ")
plot

Plot 3

plot <- ggplot(df3, aes(rating, percentage)) + geom_bar(stat = "identity")+ geom_text(aes(label = signif(percentage)), nudge_y = .02) + ggtitle("Conduct Interview and Physical Assessment")
plot

Plot 4

plot <- ggplot(df4, aes(rating, percentage)) + geom_bar(stat = "identity")+ geom_text(aes(label = signif(percentage)), nudge_y = .02) + ggtitle("Collaborate with Resident and Interdisciplinary Team")
plot

Plot 5

plot <- ggplot(df5, aes(rating, percentage)) + geom_bar(stat = "identity")+ geom_text(aes(label = signif(percentage)), nudge_y = .02) + ggtitle("Gather Essential and Accurate Information")
plot

Plot 6


plot <- ggplot(df6, aes(rating, percentage)) + geom_bar(stat = "identity")+ geom_text(aes(label = signif(percentage)), nudge_y = .02) + ggtitle("Conduct Thorough Medicaton Review")
plot

Plot 7

plot <- ggplot(df7, aes(rating, percentage)) + geom_bar(stat = "identity")+ geom_text(aes(label = signif(percentage)), nudge_y = .02) + ggtitle("Elicit Patient Values")
plot

Plot 8

plot <- ggplot(df8, aes(rating, percentage)) + geom_bar(stat = "identity")+ geom_text(aes(label = signif(percentage)), nudge_y = .02) + ggtitle("Provide Health Promotion Education")
plot

LS0tCnRpdGxlOiAiVVBlbm4gRGF0YSIKb3V0cHV0OiBodG1sX25vdGVib29rCi0tLQoKTG9hZGluZyBQYWNrYWdlcwpgYGB7cn0KbGlicmFyeShyZWFkeGwpCmxpYnJhcnkoImdncGxvdDIiKQpgYGAKClJlYWRpbmcgaW4gRGF0YQpgYGB7cn0KZGF0YSA9IHJlYWRfZXhjZWwoIi9Vc2Vycy9zdW1lZGhhc3JpcGFkYS9Eb3dubG9hZHMvUGVubkRhdGEueGxzeCIpCmBgYAoKQ3JlYXRpbmcgZGF0YSBmcmFtZXMKYGBge3J9CmRmMSA8LSBkYXRhLmZyYW1lKHJhdGluZyA9IGMoIjEiLCAiMiIsICIzIiwgIjQiKSwgcGVyY2VudGFnZSA9IGMoZGF0YSRBKSkKZGYyIDwtIGRhdGEuZnJhbWUocmF0aW5nID0gYygiMSIsICIyIiwgIjMiLCAiNCIpLCBwZXJjZW50YWdlID0gYyhkYXRhJEIpKQpkZjMgPC0gZGF0YS5mcmFtZShyYXRpbmcgPSBjKCIxIiwgIjIiLCAiMyIsICI0IiksIHBlcmNlbnRhZ2UgPSBjKGRhdGEkQykpCmRmNCA8LSBkYXRhLmZyYW1lKHJhdGluZyA9IGMoIjEiLCAiMiIsICIzIiwgIjQiKSwgcGVyY2VudGFnZSA9IGMoZGF0YSREKSkKZGY1IDwtIGRhdGEuZnJhbWUocmF0aW5nID0gYygiMSIsICIyIiwgIjMiLCAiNCIpLCBwZXJjZW50YWdlID0gYyhkYXRhJEUpKQpkZjYgPC0gZGF0YS5mcmFtZShyYXRpbmcgPSBjKCIxIiwgIjIiLCAiMyIsICI0IiksIHBlcmNlbnRhZ2UgPSBjKGRhdGEkRikpCmRmNyA8LSBkYXRhLmZyYW1lKHJhdGluZyA9IGMoIjEiLCAiMiIsICIzIiwgIjQiKSwgcGVyY2VudGFnZSA9IGMoZGF0YSRHKSkKZGY4IDwtIGRhdGEuZnJhbWUocmF0aW5nID0gYygiMSIsICIyIiwgIjMiLCAiNCIpLCBwZXJjZW50YWdlID0gYyhkYXRhJEgpKQoKCgpgYGAKClBsb3QgMQpgYGB7cn0KcGxvdCA8LSBnZ3Bsb3QoZGYxLCBhZXMocmF0aW5nLCBwZXJjZW50YWdlKSkgKyBnZW9tX2JhcihzdGF0ID0gImlkZW50aXR5IikrIGdlb21fdGV4dChhZXMobGFiZWwgPSBzaWduaWYocGVyY2VudGFnZSkpLCBudWRnZV95ID0gLjAyKSArIGdndGl0bGUoIkNvbmR1Y3QgYW4gSW50ZXJ2aWV3IikKcGxvdApgYGAKClBsb3QgMgpgYGB7cn0KcGxvdCA8LSBnZ3Bsb3QoZGYyLCBhZXMocmF0aW5nLCBwZXJjZW50YWdlKSkgKyBnZW9tX2JhcihzdGF0ID0gImlkZW50aXR5IikrIGdlb21fdGV4dChhZXMobGFiZWwgPSBzaWduaWYocGVyY2VudGFnZSkpLCBudWRnZV95ID0gLjAyKSArIGdndGl0bGUoIkRldmVsb3AgRXZpZGVuY2UgQmFzZWQgUHJvamVjdCAiKQpwbG90CgpgYGAKClBsb3QgMwpgYGB7cn0KcGxvdCA8LSBnZ3Bsb3QoZGYzLCBhZXMocmF0aW5nLCBwZXJjZW50YWdlKSkgKyBnZW9tX2JhcihzdGF0ID0gImlkZW50aXR5IikrIGdlb21fdGV4dChhZXMobGFiZWwgPSBzaWduaWYocGVyY2VudGFnZSkpLCBudWRnZV95ID0gLjAyKSArIGdndGl0bGUoIkNvbmR1Y3QgSW50ZXJ2aWV3IGFuZCBQaHlzaWNhbCBBc3Nlc3NtZW50IikKcGxvdApgYGAKClBsb3QgNApgYGB7cn0KcGxvdCA8LSBnZ3Bsb3QoZGY0LCBhZXMocmF0aW5nLCBwZXJjZW50YWdlKSkgKyBnZW9tX2JhcihzdGF0ID0gImlkZW50aXR5IikrIGdlb21fdGV4dChhZXMobGFiZWwgPSBzaWduaWYocGVyY2VudGFnZSkpLCBudWRnZV95ID0gLjAyKSArIGdndGl0bGUoIkNvbGxhYm9yYXRlIHdpdGggUmVzaWRlbnQgYW5kIEludGVyZGlzY2lwbGluYXJ5IFRlYW0iKQpwbG90CmBgYAoKUGxvdCA1CmBgYHtyfQpwbG90IDwtIGdncGxvdChkZjUsIGFlcyhyYXRpbmcsIHBlcmNlbnRhZ2UpKSArIGdlb21fYmFyKHN0YXQgPSAiaWRlbnRpdHkiKSsgZ2VvbV90ZXh0KGFlcyhsYWJlbCA9IHNpZ25pZihwZXJjZW50YWdlKSksIG51ZGdlX3kgPSAuMDIpICsgZ2d0aXRsZSgiR2F0aGVyIEVzc2VudGlhbCBhbmQgQWNjdXJhdGUgSW5mb3JtYXRpb24iKQpwbG90CmBgYAoKUGxvdCA2CmBgYHtyfQoKcGxvdCA8LSBnZ3Bsb3QoZGY2LCBhZXMocmF0aW5nLCBwZXJjZW50YWdlKSkgKyBnZW9tX2JhcihzdGF0ID0gImlkZW50aXR5IikrIGdlb21fdGV4dChhZXMobGFiZWwgPSBzaWduaWYocGVyY2VudGFnZSkpLCBudWRnZV95ID0gLjAyKSArIGdndGl0bGUoIkNvbmR1Y3QgVGhvcm91Z2ggTWVkaWNhdG9uIFJldmlldyIpCnBsb3QKYGBgCgpQbG90IDcKYGBge3J9CnBsb3QgPC0gZ2dwbG90KGRmNywgYWVzKHJhdGluZywgcGVyY2VudGFnZSkpICsgZ2VvbV9iYXIoc3RhdCA9ICJpZGVudGl0eSIpKyBnZW9tX3RleHQoYWVzKGxhYmVsID0gc2lnbmlmKHBlcmNlbnRhZ2UpKSwgbnVkZ2VfeSA9IC4wMikgKyBnZ3RpdGxlKCJFbGljaXQgUGF0aWVudCBWYWx1ZXMiKQpwbG90CmBgYAoKUGxvdCA4CmBgYHtyfQpwbG90IDwtIGdncGxvdChkZjgsIGFlcyhyYXRpbmcsIHBlcmNlbnRhZ2UpKSArIGdlb21fYmFyKHN0YXQgPSAiaWRlbnRpdHkiKSsgZ2VvbV90ZXh0KGFlcyhsYWJlbCA9IHNpZ25pZihwZXJjZW50YWdlKSksIG51ZGdlX3kgPSAuMDIpICsgZ2d0aXRsZSgiUHJvdmlkZSBIZWFsdGggUHJvbW90aW9uIEVkdWNhdGlvbiIpCnBsb3QKYGBgCgoKCg==