Thanksgiving Data: Survey Response Analysis

This post is about Survey data analysis based responses of 1000+ respondents on Thanksgiving - Source fivethirtyeight

Posted by Vaibhav Singh on Saturday, November 30, 2019

TOC

Survey response analysis based on Thanksgiving questionnaire from fivethirtyeight

Before getting started

Source of Data :

This data is gathered using a SurveyMonkey poll, they asked 1,058 respondents on Nov. 17, 2015 the following questions about their Thanksgiving

Read more about data set here and another report was done on this dataset by fivethiryeight Here’s What Your Part of America Eats On Thanksgiving.

The questions asked were

  1. Do you celebrate Thanksgiving?
  2. What is typically the main dish at your Thanksgiving dinner? Other (please specify)
  3. How is the main dish typically cooked? other (please specify)
  4. What kind of stuffing/dressing do you typically have? Other (please specify)
  5. What type of cranberry sauce do you typically have? Other (please specify)
  6. Do you typically have gravy?
  7. Which of these side dishes are typically served at your Thanksgiving dinner? Please select all that apply.
    1. Brussel sprouts
    2. Carrots
    3. Cauliflower
    4. Corn
    5. Cornbread
    6. Fruit salad
    7. Green beans/green bean casserole
    8. Macaroni and cheese
    9. Mashed potatoes
    10. Rolls/biscuits
    11. Vegetable salad
    12. Yams/sweet potato casserole
    13. Other (please specify)
  8. Which type of pie is typically served at your Thanksgiving dinner? Please select all that apply.
    Apple
    1. Buttermilk
    2. Cherry
    3. Chocolate
    4. Coconut cream
    5. Key lime
    6. Peach
    7. Pecan
    8. Pumpkin
    9. Sweet Potato
    10. None
    11. Other (please specify)
  9. Which of these desserts do you typically have at Thanksgiving dinner? Please select all that apply.
    1. Apple cobbler
    2. Blondies
    3. Brownies
    4. Carrot cake
    5. Cheesecake
    6. Cookies
    7. Fudge
    8. Ice cream
    9. Peach cobbler
    10. None
    11. Other (please specify)
  10. Do you typically pray before or after the Thanksgiving meal?
  11. How far will you travel for Thanksgiving?
  12. Will you watch any of the following programs on Thanksgiving? Please select all that apply.
    1. Macy’s Parade
  13. What’s the age cutoff at your “kids’ table” at Thanksgiving?
  14. Have you ever tried to meet up with hometown friends on Thanksgiving night?
  15. Have you ever attended a “Friendsgiving?”
  16. Will you shop any Black Friday sales on Thanksgiving Day?
  17. Do you work in retail?
  18. Will your employer make you work on Black Friday?
  19. How would you describe where you live?
  20. What is your Age
  21. What is your gender?
  22. How much total combined money did all members of your HOUSEHOLD earn last year?
  23. Which US Region do you belong to ?

Based on structure of the data, seeking to get answers for below based on dataset:

Based on structure of data, seeking to get answers for below based on dataset:

1. How Many people celebrate Thanksgiving & those who celebrate, what is the main dish ?
2. Difference between Rich & poor in celebrating thanksgiving ?
3. Does the choice of dessert & Pie fillings changes with Age ?
4. Which dishes often gets consumed together ?

Lets get started

1. Importing & Viewing collected Data

a. Viewing Sample Data 

2. Exploratory Data Analysis

a. How Many people celebrate Thanksgiving & those who celebrate, what is the main dish ?

thx %>% count(celebrate)
# A tibble: 2 x 2
  celebrate     n
  <chr>     <int>
1 No           78
2 Yes         980
thx %>% filter(celebrate=="Yes") %>% count(celebrate,main_dish, sort=TRUE)
# A tibble: 9 x 3
  celebrate main_dish                  n
  <chr>     <chr>                  <int>
1 Yes       Turkey                   859
2 Yes       Other (please specify)    35
3 Yes       Ham/Pork                  29
4 Yes       Tofurkey                  20
5 Yes       Chicken                   12
6 Yes       Roast beef                11
7 Yes       <NA>                       6
8 Yes       I don't know               5
9 Yes       Turducken                  3

Clearly 92% of People celebrate Thxgiving so its a popular event, Also Turkey is really common main dish among those who celebrate(Obvsly), followed by Ham/Pork.

b. Is there a way how rich & poor celebrate thanksgiving (Using income from responses & converting to numeric, could be used for future analysis as well)

It can be observed that the category of people who dont celebrate Thanksgiving have more proportion of poor People Vs those who celebrate\n 56.4% Vs 41%

c. Does the choice of dessert & Pie fillings changes with Age

# A tibble: 5 x 2
  age         n
  <chr>   <int>
1 45 - 59   286
2 60+       264
3 30 - 44   259
4 18 - 29   216
5 <NA>       33

Interactive Treemap showcasing Dessert preference across various age groups

inter

Though Ice-cream remains a popular dessert across age group, interesting to see that younger age groups prefer cookie Vs their older counterparts who prefer Cheesecake

d. Which dishes often gets consumed together

<environment: R_GlobalEnv>
<environment: R_GlobalEnv>
Desserts that gets served together

Figure 1: Desserts that gets served together

Pies that gets served together

Figure 2: Pies that gets served together

Sides that gets served together

Figure 3: Sides that gets served together


comments powered by Disqus