Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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...

1 answer below »

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 3: Analyze the data. Assignment requirements for data analysis:

  • Descriptive statistics for all questions in the survey

  • Conduct one confidence interval calculation: choose one question to use for this calculation. Think about a question where it would be important to know how accurate the findings are to the population being studied.

  • Conduct two comparison analyses (run two Z-tests): you may choose which questions to use for these two comparisons. To start, think about what might help answer the research problem or objectives. What will give you deeper insight into the results?

  • Conduct two relationship analysis (run correlation and/ or chi-square tests): you may choose which questions to use for these two relationship analyses. You can do two correlations, two chi-squares or one of each). To start, think about what might help answer the research problem or objectives. What will give you deeper insight into the results.


Step 4: Develop your slide presentation (with voiceover) to summarize your findings and insights
(min. 10 slides- max 15. slides):

  • Title/ Cover slide (does not count towards maximum number of slides)

  • Agenda (table of contents, does not count towards maximum number of slides)

  • Research Design: explain our overall approach to this class research project:

    • Research background; research question and objectives

    • Population of study

    • Research methods used

    • Sampling method and sample size


  • Answers to Research Problem & Objectives (based on your analysis)

  • Overview of findings (from Step 3 above): shows actual data (numbers), uses visuals and text

  • Actionable recommendations for Metro Vancouver restaurants: what should they do? Why?

    • You MUST support your recommendations with evidence from your data analysis and research (data, information, trends, feedback, etc.). No OPINIONS without researched evidence. It is expected the recommendations follow DIKWD (Week 9).

  • Limitations to the research: would you do anything differently to improve the research approach based on what we have learned about designing, conducting and reporting on research? Explain.


Answered Same Day Jul 22, 2021

Solution

Biswajit answered on Jul 26 2021
125 Votes
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...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here