Question
A supermarket manager wanted to investigate the profile of shoppers resistant to the use of self-checkout counters available at the store he manages and to
A supermarket manager wanted to investigate the profile of shoppers resistant
to the use of self-checkout counters available at the store he manages and to
find out the reasons behind their resistance. He asks three of his staff to
conduct a survey among customers using the store in Sheffield Hallam area
during a quiet working day in October of 2019 as they exited the store.
The short questionnaire used for the survey as well as the data collected can
be found on an Excel file named "SCC". There are two worksheets, one for
the questionnaire used and the other worksheet for the raw data collected
from the customers. The data worksheet has 18 columns. Column A
"Customer" is simply a column to identify the customer surveyed - Customer
1, Customer 2 etc... Each of the other 17 columns refer to a question -
Column B refers to the gender question, Column C refers to the age question
etc...
The manager has employed you as data analyst to conduct this investigation.
Your analysis should use the statistical facilities on Excel as required below.
Required:
1. Label the codes for the categories of the following variables:
Gender
Age
Education
Are you a regular user of self-checkout
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started