# Load the data
data <- read.csv("diabetes_012_health_indicators_BRFSS2015.csv")
data <- data %>%
select(c("HighBP", "BMI", "DiffWalk", "HighChol", "GenHlth", "Diabetes_012")) %>%
mutate(across(!c(BMI), factor))
levels(data$Diabetes_012) <- c("Normal", "Prediabetes", "Diabetes")
(omit some codes)
# Display the summary table
kable(summary_data, digits = 2,
col.names = c("Diabetes Status", "Count", "High BP", "High Cholesterol", "Avg BMI", "Avg Gen. Health"),
caption = "Summary of Key Health Indicators by Diabetes Status (20% Sample)")
Summary of Key Health Indicators by Diabetes Status (20% Sample)
| Normal |
42741 |
15740 |
16015 |
27.75 |
2.37 |
| Prediabetes |
927 |
589 |
567 |
30.51 |
2.99 |
| Diabetes |
7070 |
5352 |
4761 |
31.97 |
3.29 |