Data Preparation $-$ Age, Gender, Own Home, Married, Close, and History are all variables that have been entered into the data set as numeric codes. Create new variables with appropriate names for each category using the IF or & functions. In this case I would rename each of the existing variables as Age code, Gender code, etc. and name the new variables Age, Gender, etc.

Ex$.)$ to "recode" Home you could use a function like $=$IF$($cell reference $=1,$"Owner","Renter"$)$

Re$-$order your file to put the variables in the following order. The easiest way to do this is to left$-$click the column header to select the whole column, then "grab" the box outlining the selection to drag it to the intended location. You may have to insert a column or two to give yourself room. Use the variables you created in Step $1,$ not the original coded versions.

Customer ID

Qualitative, nominal variables

Qualitative, ordinal variables

Quantitative, discrete variables

Quantitative, continuous variables

Location variables

Date variables