TABLE C6-2: Customer Satisfaction Customer Number Customer Name Satisfaction Lev
ID: 3375772 • Letter: T
Question
TABLE C6-2: Customer Satisfaction
Customer Number
Customer Name
Satisfaction Level
1
Anderson
Very high
2
Angero
high
3
Ball
medium
4
Bobak
low
5
Chontos
high
6
Detley
very low
7
Hetfield
very high
8
Iruja
medium
9
Jamesson
high
10
Kemp
medium
11
Lehmann
high
12
Lee
high
13
Lewins
low
14
Luo
very high
15
Madras
very high
16
Morris
low
17
Mulder
medium
18
Ngozichi
low
19
Nickens
very high
20
Poteau
very high
21
Sakomoto
medium
22
Scully
high
23
Singh
high
24
Skinner
high
25
Suzuki
low
26
Tang
medium
27
Vu'oto
high
28
Walker
medium
29
Yap
high
30
Zindermanelino
very low
b. Create a new column that gives a numerical value to the ordinal data in the category ‘Satisfaction Level’. Then sort the table by Satisfaction Level from highest to lowest.
TABLE C6-2: Customer Satisfaction
Customer Number
Customer Name
Satisfaction Level
1
Anderson
Very high
2
Angero
high
3
Ball
medium
4
Bobak
low
5
Chontos
high
6
Detley
very low
7
Hetfield
very high
8
Iruja
medium
9
Jamesson
high
10
Kemp
medium
11
Lehmann
high
12
Lee
high
13
Lewins
low
14
Luo
very high
15
Madras
very high
16
Morris
low
17
Mulder
medium
18
Ngozichi
low
19
Nickens
very high
20
Poteau
very high
21
Sakomoto
medium
22
Scully
high
23
Singh
high
24
Skinner
high
25
Suzuki
low
26
Tang
medium
27
Vu'oto
high
28
Walker
medium
29
Yap
high
30
Zindermanelino
very low
Explanation / Answer
CustomerNumber
CustomerName
SatisfactionLevel
1
Anderson
4
7
Hetfield
4
14
Luo
4
15
Madras
4
19
Nickens
4
20
Poteau
4
2
Angero
3
5
Chontos
3
9
Jamesson
3
11
Lehmann
3
12
Lee
3
22
Scully
3
23
Singh
3
24
Skinner
3
27
Vu'oto
3
29
Yap
3
3
Ball
2
8
Iruja
2
10
Kemp
2
17
Mulder
2
21
Sakomoto
2
26
Tang
2
28
Walker
2
4
Bobak
1
13
Lewins
1
16
Morris
1
18
Ngozichi
1
25
Suzuki
1
6
Detley
0
30
Zindermanelino
0
0 = very low
1 = low
2 = medium
3 = high
4 = very high
CustomerNumber
CustomerName
SatisfactionLevel
1
Anderson
4
7
Hetfield
4
14
Luo
4
15
Madras
4
19
Nickens
4
20
Poteau
4
2
Angero
3
5
Chontos
3
9
Jamesson
3
11
Lehmann
3
12
Lee
3
22
Scully
3
23
Singh
3
24
Skinner
3
27
Vu'oto
3
29
Yap
3
3
Ball
2
8
Iruja
2
10
Kemp
2
17
Mulder
2
21
Sakomoto
2
26
Tang
2
28
Walker
2
4
Bobak
1
13
Lewins
1
16
Morris
1
18
Ngozichi
1
25
Suzuki
1
6
Detley
0
30
Zindermanelino
0
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.