Step 1: Download/save copy of class survey results posted by your instructor (Excel file) in Week 10. Step 2: Organize the survey results Excel file like the Donut Shoppe example from Week 6 & 7 Step...

PowerPoint Presentation
METRO VANCOVOUR RESTAURANT CUSTOMER RESEARCH DURING COVID19
AGENDA (To be done by student)
RESEARCH DESIGN
(To be updated & cross checked by student as no info available with me)
Research background; research question and objectives
Population of study-KPU students
Research methods used-Online survey
Sampling method –Simple Random Sampling
sample size-223
RESEARCH BACKGROUND
To be filled by student as no info available with me
    ANSWER: SUMMARY DESCRIPTIVE STATISTICS (METRIC VARIABLE) IMPORTANCE OF VARIABLES FOR RETURN TO RESTAURANT                            
    Question    Central Tendancy    Variability    Range Min    Range Max    Comments for central tendency    comments for variability    Additional comments
    Q2a    3.71    1.21    1.00    5.00    Average importance level to employees wearing facemasks    Standard Deviation    68% of responses would rate importance between appx. 2.5 and 4.92 on average
    Q2b    2.45    1.38    1.00    5.00    Average importance level to employees wearing faceshields    Standard Deviation    68% of responses would rate importance between appx. 1.07 and 3.83 on average
    Q2c    3.01    1.43    1.00    5.00    Average importance level to employees wearing gloves    Standard Deviation    68% of responses would rate importance between appx. 1.07 and 3.83 on average
    Q2d    3.15    1.29    1.00    5.00    Average importance level to single use or digital menus    Standard Deviation    68% of responses would rate importance between appx. 1.86 and 4.44 on average
    Q2e    3.53    1.21    1.00    5.00    Average importance level of 50 % limited sitting capacity    Standard Deviation    68% of responses would rate importance between appx. 2.32 and 4.74 on average
    Q2f    3.68    1.20    1.00    5.00    Average importance level of 2 meter distance between tables    Standard Deviation    68% of responses would rate importance between appx. 2.48 and 4.88 on average
    Q2g    4.03    1.08    1.00    5.00    Average importance level of frequent cleaning/sanitising of high touch surfaces    Standard Deviation    68% of responses would rate importance between appx. 2.15 and 5.11 on average
    Q2h    3.49    1.24    1.00    5.00    Average importance level to available safety policies at restaurant    Standard Deviation    68% of responses would rate importance between appx. 2.25 and 4.73 on average
Customers give most importance to frequent cleaning of high touch areas followed by employees wearing masks
This is the summary statistics of Question 2 regarding importance rating of different parameters to customer.Each sub question/parameter has been marked as Q2a,Q2b etc.For each subquestion,the mean ,standard deviation,minimum value of rating & maximum value of ratings have been calculated.For example,for Q2g,we see that average importance given to the parameter of frequent cleaning/sanitising of high touch surfaces is 4.03.standard deviation of rating is 1.08 & range varies from 1 to 5.the average importance given to this parameter is highest among all ,standard deviation is also lowest.It shows it is the most important paramete
criterion for customers.similarly,you can see the values for other parameters/criteria.
5
    ANSWER: SUMMARY DESCRIPTIVE STATISTICS (METRIC VARIABLE) TYPE OF RESTAUTANT LIKELY TO VISIT                            
         Q4a    Q4b    Q4c    Q4d    Q4e    Q4f    Q4g
    Mean    2.75    3.29    2.29    3.29    2.83    1.50    2.07
    Standard E
or    0.07    0.07    0.08    0.07    0.07    0.06    0.07
    Median    3.00    3.00    2.00    3.00    3.00    1.00    2.00
    Mode    3.00    3.00    1.00    3.00    3.00    1.00    1.00
    Standard Deviation    1.12    1.12    1.22    1.03    1.12    0.84    1.02
    Sample Variance    1.25    1.26    1.49    1.05    1.25    0.71    1.04
    Kurtosis    -0.70    -0.55    -0.56    -0.51    -0.64    3.35    -0.22
    Skewness    0.15    -0.21    0.63    -0.04    0.20    1.88    0.68
    Range    4.00    4.00    4.00    4.00    4.00    4.00    4.00
    Minimum    1.00    1.00    1.00    1.00    1.00    1.00    1.00
    Maximum    5.00    5.00    5.00    5.00    5.00    5.00    5.00
    Sum    615.00    737.00    512.00    738.00    634.00    337.00    463.00
    Count    224.00    224.00    224.00    224.00    224.00    224.00    224.00
People are most likely to visit coffee shop/café & casual dining (Q4b & Q4d)
Here we are trying to find out which type of restaurant will be preferable to customer if he wants to return after Covid19.We have calculated the descriptive statistics for each type of restaurant from the survey data such as Mean,standard deviation,range,mode,median etc etc.Here we find that the customers will prefer coffee shops and casual dining restaurants as its mean score is highest at 3.29.of course both are associated with high standard deviation.
6
    At this time, if you were to return for DINE-IN services at a local restaurant, where would you prefer to dine?        
         Frequencies    %'s
    Indoor sitting (1)    24    10.71%
    Outdoor sitting (2)    103    45.98%
    No preference (3)    97    43.30%
               
 
While majority (46 %) prefer outdoor sitting,conclusion is not quite robust because 43.3 % are also indifferent 
 
              
    Total (n):    224    
              
    ANSWER: SUMMARY DESCRIPTIVE STATISTICS (CATEGORICAL VARIABLE)          
    Central Tendancy:    Outdoor sitting    (most typical response)
    Variability:    medium    As next highest preference is 43.3 % close to outdoor sitting,so we can say most people prefer outdoo
indifferent
This is a non metric variable,so we have found out the frequencies & % for each category of sitting a
angement.we find that around 46% prefer outdoor setting but also almost equal no of participants (43.3%) also are indifferent.so while the data has medium variability,we can say better strategy will be to provide outdooe setting for returning customers.
7
    At this time, how soon are you willing to resume DINING IN in at restaurants?        
         Frequencies    %'s
    Immediately if they are open(1)    65    29.02%
    Prefer to...