This survey was placed to graph the military versus non-military alcohol use. I surmised that military members would be more apt to drink more than their civilian counterparts. I utilized google forms and facebook to distribute this survey.

library(tidyverse)
library(readxl)
alcohol <- read_excel("alcohols.xlsx")
glimpse(alcohol)
Observations: 57
Variables: 10
$ Timestamp                                                                                    <dttm> …
$ military                                                                                     <chr> …
$ `What is your gender?`                                                                       <chr> …
$ `What is your age range?`                                                                    <chr> …
$ `How often do you drink a week?`                                                             <chr> …
$ `When you drink, how many drinks do you USUALLY consume`                                     <dbl> …
$ `How many times a month do you binge drink (5 drinks in one sitting)`                        <chr> …
$ `If you drink, how long ago has it been since you blacked out (drinking until unconscious)?` <chr> …
$ `Do you feel like you have a drinking problem?`                                              <chr> …
$ `Is alcohol a factor in having fun in social settings?`                                      <chr> …
alcohol <-alcohol %>% 
  rename (age = "What is your age range?") %>% 
  rename (gender = "What is your gender?") %>% 
  rename (party = "Is alcohol a factor in having fun in social settings?") %>% 
  rename (frequency = "How often do you drink a week?")
alcohol <- alcohol %>% 
  mutate(military = fct_recode(military, "Military" = "1", "No military" = "2"))
Unknown levels in `f`: 1, 2
alcohol %>% 
  count(military)
alcohol <- alcohol %>% 
  mutate(frequency = fct_recode(frequency, "never" = "0", " to 2 times a week" = "1", "3 to 5 times a week" = "2", "6 to 7 times a week" = "3"))
Unknown levels in `f`: 0, 1, 2, 3
alcohol %>% 
  count(frequency)

This chart shows the frequency of Military and no military members

alcohol %>% 
  drop_na(frequency) %>% 
  ggplot(aes(x = military, fill = frequency)) +
  geom_bar(position = "dodge")+
  scale_fill_viridis_d()+
  coord_flip()+
  theme_minimal()

This graph represents the frequency use of alcohol based on the ages of participants.

alcohol %>% 
  drop_na(frequency) %>% 
  ggplot(aes(x = age, fill = frequency)) +
  geom_bar(position = "dodge")+
  scale_fill_viridis_d()+
  coord_flip()+
  theme_minimal()+
  labs(y = "Age", 
       x = "Number of participants", 
       title = "Age vs. Alcohol use")

This graph shows the thoughts on alcohol during social settings.

alcohol %>% 
  drop_na(party) %>% 
  ggplot(aes(x = military, fill = party)) +
  geom_bar(position = "dodge")+
  scale_fill_viridis_d()+
  coord_flip()+
  theme_minimal()+
  labs(y = "military", 
       x = "alcohol at social events", 
       title = "military vs. non-military alcohol in social settings")

This graph shows the gender differences in uses

alcohol %>% 
  drop_na(gender) %>% 
  ggplot(aes(x = frequency, fill = gender)) +
  geom_bar(position = "dodge")+
  scale_fill_viridis_d()+
  coord_flip()+
  theme_minimal()+
  labs(y = "gender", 
       x = "frequency", 
       title = "gender frequency uses")

LS0tCnRpdGxlOiAic3VydmV5IHJlc3VsdHMgLSBDaGFkIFJhbmRhbGwiCm91dHB1dDogaHRtbF9ub3RlYm9vawotLS0KClRoaXMgc3VydmV5IHdhcyBwbGFjZWQgdG8gZ3JhcGggdGhlIG1pbGl0YXJ5IHZlcnN1cyBub24tbWlsaXRhcnkgYWxjb2hvbCB1c2UuIEkgc3VybWlzZWQgdGhhdCBtaWxpdGFyeSBtZW1iZXJzIHdvdWxkIGJlIG1vcmUgYXB0IHRvIGRyaW5rIG1vcmUgdGhhbiB0aGVpciBjaXZpbGlhbiBjb3VudGVycGFydHMuIEkgdXRpbGl6ZWQgZ29vZ2xlIGZvcm1zIGFuZCBmYWNlYm9vayB0byBkaXN0cmlidXRlIHRoaXMgc3VydmV5LgoKYGBge3J9CmxpYnJhcnkodGlkeXZlcnNlKQoKYGBgCgpgYGB7cn0KbGlicmFyeShyZWFkeGwpCmFsY29ob2wgPC0gcmVhZF9leGNlbCgiYWxjb2hvbHMueGxzeCIpCmdsaW1wc2UoYWxjb2hvbCkKYGBgCgpgYGB7cn0KYWxjb2hvbCA8LWFsY29ob2wgJT4lIAogIHJlbmFtZSAoYWdlID0gIldoYXQgaXMgeW91ciBhZ2UgcmFuZ2U/IikgJT4lIAogIHJlbmFtZSAoZ2VuZGVyID0gIldoYXQgaXMgeW91ciBnZW5kZXI/IikgJT4lIAogIHJlbmFtZSAocGFydHkgPSAiSXMgYWxjb2hvbCBhIGZhY3RvciBpbiBoYXZpbmcgZnVuIGluIHNvY2lhbCBzZXR0aW5ncz8iKSAlPiUgCiAgcmVuYW1lIChmcmVxdWVuY3kgPSAiSG93IG9mdGVuIGRvIHlvdSBkcmluayBhIHdlZWs/IikKYGBgCgpgYGB7cn0KYWxjb2hvbCA8LSBhbGNvaG9sICU+JSAKICBtdXRhdGUobWlsaXRhcnkgPSBmY3RfcmVjb2RlKG1pbGl0YXJ5LCAiTWlsaXRhcnkiID0gIjEiLCAiTm8gbWlsaXRhcnkiID0gIjIiKSkKCmFsY29ob2wgJT4lIAogIGNvdW50KG1pbGl0YXJ5KQpgYGAKCmBgYHtyfQphbGNvaG9sIDwtIGFsY29ob2wgJT4lIAogIG11dGF0ZShmcmVxdWVuY3kgPSBmY3RfcmVjb2RlKGZyZXF1ZW5jeSwgIm5ldmVyIiA9ICIwIiwgIiB0byAyIHRpbWVzIGEgd2VlayIgPSAiMSIsICIzIHRvIDUgdGltZXMgYSB3ZWVrIiA9ICIyIiwgIjYgdG8gNyB0aW1lcyBhIHdlZWsiID0gIjMiKSkKCmFsY29ob2wgJT4lIAogIGNvdW50KGZyZXF1ZW5jeSkKYGBgClRoaXMgY2hhcnQgc2hvd3MgdGhlIGZyZXF1ZW5jeSBvZiBNaWxpdGFyeSBhbmQgbm8gbWlsaXRhcnkgbWVtYmVycyAKYGBge3J9CmFsY29ob2wgJT4lIAogIGRyb3BfbmEoZnJlcXVlbmN5KSAlPiUgCiAgZ2dwbG90KGFlcyh4ID0gbWlsaXRhcnksIGZpbGwgPSBmcmVxdWVuY3kpKSArCiAgZ2VvbV9iYXIocG9zaXRpb24gPSAiZG9kZ2UiKSsKICBzY2FsZV9maWxsX3ZpcmlkaXNfZCgpKwogIGNvb3JkX2ZsaXAoKSsKICB0aGVtZV9taW5pbWFsKCkKYGBgClRoaXMgZ3JhcGggcmVwcmVzZW50cyB0aGUgZnJlcXVlbmN5IHVzZSBvZiBhbGNvaG9sIGJhc2VkIG9uIHRoZSBhZ2VzIG9mIHBhcnRpY2lwYW50cy4KYGBge3J9CmFsY29ob2wgJT4lIAogIGRyb3BfbmEoZnJlcXVlbmN5KSAlPiUgCiAgZ2dwbG90KGFlcyh4ID0gYWdlLCBmaWxsID0gZnJlcXVlbmN5KSkgKwogIGdlb21fYmFyKHBvc2l0aW9uID0gImRvZGdlIikrCiAgc2NhbGVfZmlsbF92aXJpZGlzX2QoKSsKICBjb29yZF9mbGlwKCkrCiAgdGhlbWVfbWluaW1hbCgpKwogIGxhYnMoeSA9ICJBZ2UiLCAKICAgICAgIHggPSAiTnVtYmVyIG9mIHBhcnRpY2lwYW50cyIsIAogICAgICAgdGl0bGUgPSAiQWdlIHZzLiBBbGNvaG9sIHVzZSIpCmBgYApUaGlzIGdyYXBoIHNob3dzIHRoZSB0aG91Z2h0cyBvbiBhbGNvaG9sIGR1cmluZyBzb2NpYWwgc2V0dGluZ3MuCmBgYHtyfQphbGNvaG9sICU+JSAKICBkcm9wX25hKHBhcnR5KSAlPiUgCiAgZ2dwbG90KGFlcyh4ID0gbWlsaXRhcnksIGZpbGwgPSBwYXJ0eSkpICsKICBnZW9tX2Jhcihwb3NpdGlvbiA9ICJkb2RnZSIpKwogIHNjYWxlX2ZpbGxfdmlyaWRpc19kKCkrCiAgY29vcmRfZmxpcCgpKwogIHRoZW1lX21pbmltYWwoKSsKICBsYWJzKHkgPSAibWlsaXRhcnkiLCAKICAgICAgIHggPSAiYWxjb2hvbCBhdCBzb2NpYWwgZXZlbnRzIiwgCiAgICAgICB0aXRsZSA9ICJtaWxpdGFyeSB2cy4gbm9uLW1pbGl0YXJ5IGFsY29ob2wgaW4gc29jaWFsIHNldHRpbmdzIikKYGBgClRoaXMgZ3JhcGggc2hvd3MgdGhlIGdlbmRlciBkaWZmZXJlbmNlcyBpbiB1c2VzCmBgYHtyfQphbGNvaG9sICU+JSAKICBkcm9wX25hKGdlbmRlcikgJT4lIAogIGdncGxvdChhZXMoeCA9IGZyZXF1ZW5jeSwgZmlsbCA9IGdlbmRlcikpICsKICBnZW9tX2Jhcihwb3NpdGlvbiA9ICJkb2RnZSIpKwogIHNjYWxlX2ZpbGxfdmlyaWRpc19kKCkrCiAgY29vcmRfZmxpcCgpKwogIHRoZW1lX21pbmltYWwoKSsKICBsYWJzKHkgPSAiZ2VuZGVyIiwgCiAgICAgICB4ID0gImZyZXF1ZW5jeSIsIAogICAgICAgdGl0bGUgPSAiZ2VuZGVyIGZyZXF1ZW5jeSB1c2VzIikKYGBg