October 2012
Beginner
420 pages
9h 37m
English
A2.4 Coding and Sorting Data
| Column | Label | Content |
| C1 | CUSTOMER | Customer number |
| C2 | JANUARY | Turnover (in thousand euros) in January |
| C3 | FEBRUARY | Turnover (in thousand euros) in February |
| C5 | MARCH | Turnover (in thousand euros) in March |
We want to codify the variable CUSTOMER (customer number) according to the customers first quarter purchases using the following categories: less than 50 000 €: category 3; between 50 000 and 100 000 €: category 2, and more than 100 000 € category 1. In addition we also want to know the order of each customer in the ranking of quarterly turnover.
First, calculate the turnover during the first quarter of the year.
Calc > Row Statistics
Then, the total turnover values are codified according to the previously specified categories: Data > Code > Numeric to Numeric
The customer numbers for each category can be placed in separate columns, doing: Data > Unstack Columns
To find ...
Read now
Unlock full access