This report explores the relationship between muenster cheese consumption and suffocation deaths in the United States. We will use two datasets: one detailing various types of cheese consumption per capita, and another providing data on causes of death, including suffocation.
First, we load the necessary libraries and import the datasets.
library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.4 ✔ readr 2.1.5
## ✔ forcats 1.0.0 ✔ stringr 1.5.1
## ✔ ggplot2 3.4.4 ✔ tibble 3.2.1
## ✔ lubridate 1.9.3 ✔ tidyr 1.3.1
## ✔ purrr 1.0.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
# Loading cheese consumption data
cheese <- read_csv(url("http://jamessuleiman.com/teaching/datasets/cheese.csv"))
## Rows: 24 Columns: 9
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## dbl (9): year, cheddar, mozzarella, swiss, blue, brick, muenster, neufchatel...
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
glimpse(cheese)
## Rows: 24
## Columns: 9
## $ year <dbl> 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004,…
## $ cheddar <dbl> 9.04, 9.19, 9.51, 9.60, 10.01, 9.87, 9.89, 9.76, 9.38, 10.2…
## $ mozzarella <dbl> 7.89, 8.22, 8.16, 8.33, 8.74, 9.05, 9.35, 9.38, 9.45, 9.68,…
## $ swiss <dbl> 1.09, 1.07, 0.99, 1.01, 1.09, 1.02, 1.12, 1.09, 1.13, 1.20,…
## $ blue <dbl> 0.16, 0.17, 0.18, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ brick <dbl> 0.04, 0.04, 0.03, 0.03, 0.03, 0.03, 0.03, 0.03, 0.03, 0.03,…
## $ muenster <dbl> 0.41, 0.39, 0.37, 0.34, 0.28, 0.30, 0.28, 0.28, 0.27, 0.25,…
## $ neufchatel <dbl> 2.04, 2.11, 2.25, 2.20, 2.26, 2.39, 2.21, 2.33, 2.30, 2.34,…
## $ hispanic <dbl> NA, 0.25, 0.25, 0.27, 0.30, 0.33, 0.37, 0.42, 0.45, 0.48, 0…
# Loading mortality data
deaths <- read_csv(url("http://jamessuleiman.com/teaching/datasets/Injury_Mortality__United_States.csv"))
## Rows: 98280 Columns: 17
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (6): Sex, Age group (years), Race, Injury mechanism, Injury intent, Unit
## dbl (9): Year, Age Specific Rate, Age Specific Rate Standard Error, Age Spec...
## num (2): Deaths, Population
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
glimpse(deaths)
## Rows: 98,280
## Columns: 17
## $ Year <dbl> 2016, 2015, 2014, 2013, 201…
## $ Sex <chr> "Both sexes", "Both sexes",…
## $ `Age group (years)` <chr> "All Ages", "All Ages", "Al…
## $ Race <chr> "All races", "All races", "…
## $ `Injury mechanism` <chr> "All Mechanisms", "All Mech…
## $ `Injury intent` <chr> "All Intentions", "All Inte…
## $ Deaths <dbl> 231991, 214008, 199752, 192…
## $ Population <dbl> 323127513, 321418820, 31885…
## $ `Age Specific Rate` <dbl> 71.795496, 66.582287, 62.64…
## $ `Age Specific Rate Standard Error` <dbl> 0.1490602, 0.1439275, 0.140…
## $ `Age Specific Rate Lower Confidence Limit` <dbl> 71.503338, 66.300189, 62.37…
## $ `Age Specific Rate Upper Confidence Limit` <dbl> 72.087654, 66.864384, 62.92…
## $ `Age Adjusted Rate` <dbl> 68.98224, 63.86611, 60.1272…
## $ `Age Adjusted Rate Standard Error` <dbl> 0.1460097, 0.1405070, 0.136…
## $ `Age Adjusted Rate Lower Confidence Limit` <dbl> 68.69606, 63.59072, 59.8592…
## $ `Age Adjusted Rate Upper Confidence Limit` <dbl> 69.26842, 64.14151, 60.3952…
## $ Unit <chr> "per 100,000 population", "…
We transform the deaths dataset to filter and pivot the data for our analysis, focusing on suffocation deaths and merging this with the cheese consumption data.
# Transforming the deaths data
deaths_2 <- deaths %>%
filter(`Injury mechanism` != "All Mechanisms" &
`Age group (years)` == "All Ages" &
Race == "All races" &
`Injury intent` == "All Intentions" &
Sex == "Both sexes") %>%
select(Year, `Injury mechanism`, Deaths) %>%
rename(year = Year, death_type = `Injury mechanism`, death_count = Deaths) %>%
pivot_wider(names_from = death_type, values_from = death_count)
# Merging cheese consumption data with deaths data
death_by_cheese <- cheese %>%
select(year, muenster) %>%
inner_join(deaths_2, by = "year")
We calculate the correlation between Muenster cheese consumption and suffocation deaths.
# Calculating correlation
correlation_results <- death_by_cheese %>% select(-year) %>% cor()
correlation_results
## muenster Cut/pierce Drowning Fall
## muenster 1.00000000 -0.04990773 0.51393834 0.9356425
## Cut/pierce -0.04990773 1.00000000 0.17063452 0.2206411
## Drowning 0.51393834 0.17063452 1.00000000 0.5567061
## Fall 0.93564250 0.22064112 0.55670608 1.0000000
## Fire/hot object or substance -0.83707186 -0.09090047 -0.53402721 -0.8667681
## Firearm 0.90453644 0.22761514 0.64881514 0.9257407
## Motor vehicle traffic -0.78593273 0.22880203 -0.36438044 -0.7506909
## All Other Transport -0.50103136 -0.31775277 -0.44540194 -0.6067667
## Poisoning 0.90497837 0.30911141 0.63334924 0.9791790
## Suffocation 0.93041389 0.17177657 0.54091944 0.9938990
## All Other Specified -0.37671471 -0.16056723 -0.01576699 -0.4647084
## Unspecified -0.30377829 -0.14550347 0.05042755 -0.3734979
## Fire/hot object or substance Firearm
## muenster -0.83707186 0.9045364
## Cut/pierce -0.09090047 0.2276151
## Drowning -0.53402721 0.6488151
## Fall -0.86676812 0.9257407
## Fire/hot object or substance 1.00000000 -0.7172177
## Firearm -0.71721766 1.0000000
## Motor vehicle traffic 0.88872560 -0.5418749
## All Other Transport 0.57250666 -0.4904084
## Poisoning -0.78997216 0.9589757
## Suffocation -0.86387501 0.9113808
## All Other Specified 0.52456683 -0.3167888
## Unspecified 0.52310835 -0.1104524
## Motor vehicle traffic All Other Transport
## muenster -0.7859327 -0.5010314
## Cut/pierce 0.2288020 -0.3177528
## Drowning -0.3643804 -0.4454019
## Fall -0.7506909 -0.6067667
## Fire/hot object or substance 0.8887256 0.5725067
## Firearm -0.5418749 -0.4904084
## Motor vehicle traffic 1.0000000 0.4476599
## All Other Transport 0.4476599 1.0000000
## Poisoning -0.6450346 -0.5999390
## Suffocation -0.7582158 -0.5886872
## All Other Specified 0.4785087 0.3578379
## Unspecified 0.5946724 0.5042059
## Poisoning Suffocation All Other Specified
## muenster 0.9049784 0.9304139 -0.37671471
## Cut/pierce 0.3091114 0.1717766 -0.16056723
## Drowning 0.6333492 0.5409194 -0.01576699
## Fall 0.9791790 0.9938990 -0.46470837
## Fire/hot object or substance -0.7899722 -0.8638750 0.52456683
## Firearm 0.9589757 0.9113808 -0.31678878
## Motor vehicle traffic -0.6450346 -0.7582158 0.47850867
## All Other Transport -0.5999390 -0.5886872 0.35783788
## Poisoning 1.0000000 0.9654581 -0.40415779
## Suffocation 0.9654581 1.0000000 -0.47571858
## All Other Specified -0.4041578 -0.4757186 1.00000000
## Unspecified -0.2982013 -0.3468012 0.52552447
## Unspecified
## muenster -0.30377829
## Cut/pierce -0.14550347
## Drowning 0.05042755
## Fall -0.37349794
## Fire/hot object or substance 0.52310835
## Firearm -0.11045238
## Motor vehicle traffic 0.59467240
## All Other Transport 0.50420589
## Poisoning -0.29820134
## Suffocation -0.34680116
## All Other Specified 0.52552447
## Unspecified 1.00000000
Finally, we create a scatter plot to visually explore the relationship between annual suffocation deaths and per capita Muenster cheese consumption.
# Scatter plot of suffocation deaths versus Muenster cheese consumption
death_by_cheese %>%
ggplot(aes(x = Suffocation, y = muenster)) +
geom_point() +
geom_smooth(method = "lm", se = FALSE) +
xlab("Annual Deaths by Suffocation in the US") +
ylab("Per Capita Muenster Consumption in Pounds") +
ggtitle("Suffocated by Muenster!") +
theme_minimal()
## `geom_smooth()` using formula = 'y ~ x'
The report provides an initial examination of the intriguing correlation between muenster cheese consumption and suffocation deaths.