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.

Answer 1

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