Insert Page Layout Formulas A- A- Home Data Review View + Share A "tent.blae 2 AutoSum 全ア, Calibri 11 5 Wrap Text General O Fill Paste BI U | Merge & Center Conditional Format Formatting as Table Styles Čell Insert Delete Format O Clear Sort & Filter O Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates v fx Q1: Are you: A B D E F G H 3. Prefer not to say e Q.1: Are you: B Q.2: Age Q.2: Education 5 Q.3: Are you a regular user of self-checkout user 1. Male? 2. Female? | 1. Less than 21 | 1. GCSE or below 2. A’ level or Diploma 3. Degree or further 2. 21 to 34 3. 35 to 47 4. 48 to 60 5. 61 and over 1. Yes 2. No Please state the level of agreement towards these aspects of the self-checkout counters: B Please rate as: 1 = Totally disagree 5 = Totally agree o SCC allow me to shop faster [Advantage1] 1 SCC make me a more efficient shopper [Advantage2] 2 SCC reduce the waiting time at payment [Advantage3] 3 SCC make me feel independent [Advantage4] 4 Scanning the items is easy [Complexity1] 5 Weighing my fruits and vegetables is simple [Complexity2] 6 SCC steps are easy to follow [Complexity3] 7 Payment on SCC is straightforward [Complexity4] 8 SCC always work well [Rel1] 9 SCC work in the same way [Rel2] o SCC do not make mistakes [Rel3] 1 SCC always enter the correct price for my items [Rel4] 3 Questionnaire Data + Ready 160%
1. Label the codes for the categories of the following variables: • Gender
• Age
• Education
• Are you a regular user of self-checkou
2. Produce frequency and percentage frequency tables for each of the following variables:
• Gender
• Education
• Age
• SCC user
• Spending (£) For this last quantitative variable, the categories should be as follows:
<100 |
100- 109 |
110- 119 |
120- 129 |
130- 140 |
>140 |
3. Draw the graphical representation for each of the following variables: • Education (Pie chart)
• Age (Bar chart)
• Spending (Histogram) using the following categories:
• Spending (Box and whisker) graph
4. Consider now the variable “Spending (£)”.
• Calculate the minimum, maximum, median, quartiles and the mean average statistics.

![Excel
File
Edit View
Insert
Format
Tools
Data
Window
Help
* 80% O
Thu 00:12
ScC
Q. Search Sheet
Home
Insert
Page Layout
Formulas
Data
Review
View
+ Share
tent.blac. +
2 AutoSum
マ。
Calibri
- 11
A. A-
S Wrap Text
General
Fill
Paste
I
+ Merge & Center
.0
.00
Conditional Format
Cl
Insert
Delete
Format
Sort &
Filter
A
Formatting as Table
Styles
Clear
O Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates.
Check for Updates
A2
fx Q.1: Are you:
A
В
E
F
G
H
1
2 Q.1: Are you:
1. Male?
2. Female?
3. Prefer not to say
3 Q.2: Age
1. Less than 21
2. 21 to 34
3. 35 to 47
4. 48 to 60
5. 61 and over
4 Q.2: Education
1. GCSE or below
2. A' level or Diploma 3. Degree or further
5 Q.3: Are you a regular user of self-checkout user
1. Yes
2. No
6.
7 Please state the level of agreement towards these aspects of the self-checkout counters:
8 Please rate as:
1 = Totally disagree 5 = Totally agree
9
10 SCC allow me to shop faster [Advantage1]
11 SCC make me a more efficient shopper [Advantage2]
12 SCC reduce the waiting time at payment [Advantage3]
13 SCC make me feel independent [Advantage4]
14 Scanning the items is easy [Complexity1]
15 Weighing my fruits and vegetables is simple [Complexity2]
16 SCC steps are easy to follow [Complexity3]
17 Payment on SCC is straightforward [Complexity4]
18 SCC always work well [Rel1]
19 SCC work in the same way [Rel2]
20 SCC do not make mistakes [Rel3]
21 SCC always enter the correct price for my items [Rel4]
22
23
Questionnaire
Data
Ready
+
160%
WALL PAPE RSWI DE.CO M](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F332f99ea-eeb6-4c78-844e-acb7a6e04fc6%2F05f6c4c5-be25-493b-8ca2-982f66ca8acb%2Fqxzkzq_processed.png&w=3840&q=75)

Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 5 images









