An exploratory analysis of quick service restaurants using tidyverse tools in R

  • 975 Views
  • 363 Downloads

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License

This study presents an exploratory analysis of Quick Service Restaurants (QSR) industry in the US during 2015 by using publicly available data and open-source R software. The data analysis framework and tools utilized here were developed primarily by Hadley Wickham and are included in his tidyverse package in R. This data analysis framework consists of data import, data wrangeling, data exploration (tranformation, visualization, and modeling), and communication of results (Wickham & Grolemund, 2016). These steps are illustrated by exploring the relationship between sales, customer satisfaction, and other characteristics of 65 QSR restaurants in the US. In order to facilitate reproduction and replication of this study, the dataset as well as the R code are included in this study.

view full abstract hide full abstract
    • Fig. 1. The tidyverse packages
    • Fig. 2. QSR characteristics by segment
    • Fig. 3. QSR boxplots and violin plots by segment
    • Fig. 4. QSR sales by ACSI and unit average sales by ACSI
    • Fig. 5. QSR best-in-segment sales and by segment relationships
    • Fig. 6. QSR best-in-segment unit average sales and by segment relationships
    • Fig. 7. Scatterplots, histograms, and correlations
    • Fig. 8. Diagnostic plots (log-log OLS model)
    • Table 1. Quick service restaurants (USA, 2015)
    • Table 2. Quick service restaurants sales by segment
    • Table 3. Quick service restaurants average unit sales by segment
    • Table 4. Quick service restaurants ACSI index by segment
    • Table 5. Descriptive Statistics
    • Table 6. QSR Mean Values by Segment: Sales ($ millions), Average Sales per Unit (thousands), and ACSI (0 – 100)
    • Table 7. QSR (Sales > 1500): Sales (millions), Average Sales per Unit (thousands), and ACSI (0 – 100)
    • Table 8. OLS and log-log OLS models: 2015 dataset
    • Table 9. Global test of log-log OLS regression model’s assumptions
    • Table 10. Quick service restaurants (segment = sandwich)
    • Table 11. Quick service restaurants (segment = chicken)
    • Table 12. Quick service restaurants (segment = burger)
    • Table 13. Quick service restaurants (segment = seafood)
    • Table 14. Quick service restaurants (segment = ethnic)
    • Table 15. Quick service restaurants (segment = pizza)
    • Table 16. Quality measures of regression models
    • Table 17. Coefficients of regression models