Question 1 (a) Recode respondents based on the following: (i) Q2 into "unlikely" (1), "perhaps" (2) and "likely" (3) using the following classification:
Old and New Values
|
Old Value
|
New Value
|
|
1 to 2
|
1
|
|
3
|
2
|
|
4 to 5
|
3
|
(ii) Each of the 13 customer's rating attributes (Q6A to Q6M) on their primary financial provider into "low favourable" (1), "medium favourable" (2) and "high favourable" (3) groups based on the following groupings.
Old and New Values
|
Old Value
|
New Value
|
|
1 to 2
|
1
|
|
3 to 4
|
2
|
|
5 to 6
|
3
|
(iii) Number of dependent children, two or more should be classified into a single category labelled "2+". Rename each variable name with a suffix "_Recoded" and variable label with "Recoded ".
(b) Run two-way cross-tabulations of recoded likelihood to recommend with each of the 13 recoded customers rating attributes. Interpret and discuss the results and implications for management.