Split

Sometimes, on only one individual or one home, we will realize several identic measures. We will ask for example for a consumer to evaluate a set of products on the same criteria. In a home, we will save the identic information (age, sex, class, etc.) for several children. We will have then a questionnaire with first, a set of questions concerning the products for baby, then several parts (three in our example), where we ask the same questions, for other types of products.

If we want to obtain certain results like the average number of children per home, the distribution of different socio-professional categories or even the geographic distribution of the families asked, the statistic unity will be the home.

But if then, we wish to know the most bought brands or the distribution of the types of products per home, we should never reason about the home but about the product. We will have to modify the structure of the base of the responses and operate a « changement of the statistic unit ».

Click on the button Split in the tab Data. You reach the following assistant.

In our example, we think about the product (beverages). We select then all the parts to treat (those ones must be built in the same way). Click OK to validate and quit the assistant, you will be asked then if you wish to save and open the survey created.