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%
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%
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
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.
Transcribed Image Text:Excel
File
Edit
View
Insert Format
Tools
Data
Window
Help
A 80% O
Thu 00:12
!!
X SCC
Qv Search Sheet
Home
Insert
Page Layout
Formulas
Data
Review
View
+ Share
X Cut
2 AutoSum
A- A-
マ。
Arial
- 11
S Wrap Text
General
O Copy
Fill
B I
-
+.0
.00
.00
Paste
A
+ Merge & Center
% )
Conditional Format
Cll
Insert
Delete
Format
Sort &
Filter
Format
Clear
Formatting as Table
Styles
O Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates.
Check for Updates
B1
fx Gender
L
Comp1 Comp2 Comp3 Comp4
A
B
D
F
G
H
J
K
M
N
P
Q
R
S
т
U
Y
AA
1.
Customer
Gender,
Age
Education
SCC_user
Spending (E)
Adv1
Adv2
Adv3
Adv4
Rel1
Rel2
Re13
Rel4
2
1
2
2
2
121
4
4
3
4
3
3
4
2
2
2
3
3
2
2
13
13
2
127
4
2
2
4
4
3
4
4
3
3
3
3
4
3
2
109
2
2
4
4
4
3
2
4
1
3
4
2
13
125
2
1
1
3
1
3
3
4
3
6
5
2
3
106
3
5
4
4
4
4
2
2
to
2
2
6
1
121
3
4
4
4
4
4
3
3
3
4
4
3
2
7
1
5
2
118
3
3
3
1
3
3
9
8
2
3
2
1
138
3
4
3
4
4
3
4
3
3
4
2
10
9
2
13
2
95
3
3
3
2
3
3
3
1
1
1.
1
11
10
2
3
118
4
4
3
3
2
3
3
2
4
2
12
11
3
2
99
2.
2
2
2
3
3
3
2
1
1
13
12
1
4
1
1
120
4
1
4
1
4
2
3
4
2
14
13
2
4
2
116
3
3
3
3
3
3
3
3
3
3
2
3
15
14
2
4
3
2
131
3
2
3
3
4
2
4
3
3
3
2
16
15
2
14
1
2
117
2
2
2
2
4
4
4
4
3
17
16
2
4
3
2
124
4
3
3
4
3
3
3
4
3
3
3
18
17
13
2
117
2
3
2
4
5
3
4
4
4
4
19
18
2
4
2
125
4
4
4
1
3
3
3
3
20
19
1
1
2
1
122
5
3
4
4
5
3
3
21
20
2
3
2
115
4
1
1
3
2
3
4
4
2
22
21
2
2
1
1
107
3
5
3
3
3
2
2
2
3
3
23
22
2
3
1
1
127
3
4
4
2
3
4
4
3
3
3
24
23
4
3
2
103
4
4
3
3
3
2
3
3
2
2
1
25
24
2
3
2
120
2
2
2
2
2
2
3
26
25
4
2
2
102
3
3
1
3
4
3
3
4
1
2
2
2
27
26
1
1
1
1
95
3
4
2.
3
3
1
1
1.
1
28
27
2
3
1
120
4
3
4
4
4
2
3
3
2
29
28
3
2
108
2
2
2
2
3
2
3
2
2
2
2
30
29
1
2
1
98
3
4
3
4
3
3
2
2
1
1
1
31
30
4
2
2
107
4
3
3
4
3
2
3
3
1
3
2.
2
32
31
1
4
13
2
125
2
2
2
2
1
2
3
3
4
3
4
3
33
32
4
12
1
117
3
3
2
2
3
2
34
33
4
3
2
120
3
3
2
3
3
3
3
4
3
2
3
35
34
4
3
2
110
2
3
3
3
2
2
1
2
3
4
3
3
36
14
2
110
2
2
3
3
35
36
2
1
2
3
3
3
2
3
3
37
1
4
2
1
139
4
4
3
5
2
6
3
1
1
1
2
38
37
1
1
2
119
1
1
1
1
4
3
4
3
3
3
3
3
39
38
1
3
2
130
1
1
1
1
3
3
3
2
3
3
4
40
39
1
4
2
2
124
2
3
3
3
3
4
4
3
4
3
41
40
2
14
2
2
127
2
3
2
2
2
2
3
3
2
3
42
41
2
1
2
122
1
1
1
1
3
3
3
2
4
3
3
43
42
4
1
1
97
3
3
4
4
3
2
1
1
44
43
1
3
2
124
2
3
2
3
3
1
1
1
1
1
2
2
45
44
1
4
2
125
1
2
1
2
4
4
3
4
3
4
3
46
45
2
2
2
113
3
3
3
3
3
3
2
3
4
4
3
47
1.
46
47
1
1
3
109
1
3
3
1
2
2
2
3
2
48
1
13
1
1
149
3
2
2
1
4
2
2
4
Questionnaire
Data
+
Ready
曲
+
95%
>
![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)
Transcribed Image Text: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
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 5 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education