Preparing the Data for Related Samples Analysis

  1. Activate the originalData dataset and recall the Aggregate Data dialog.
    Figure 1. Aggregate Data dialog
    Aggregate Data dialog
  2. Select Type of transaction [type] as a break variable so that both it and Customer ID [custid] are used as break variables.
  3. Leave card_first, items_mean, and spent_mean in the Summaries of Variables list.
  4. In the Save group, leave Create new dataset containing only the aggregated variables selected and type relatedSamples as the new dataset name.
  5. Click OK.

    The new dataset is now ready to be restructured from cases to variables.

  6. Activate the relatedSamples dataset.
  7. To restructure from cases to variables, from the menus choose:

    Data > Restructure...

  8. Click No in the alert asking whether to save changes to the relatedSamples dataset.
  9. In the Welcome step of the Restructure Data Wizard, select Restructure selected cases into variables.
  10. Click Next.
    Figure 2. Restructure Data Wizard, Select Variables Step
    Restructure Data Wizard, Select Variables Step
  11. In the Select Variables step, select Customer ID [custid] as an identifier variable.
  12. Select Type of transformation [type] as an index variable.
  13. Click Next, then click Finish in the following step.

The aggregated and restructured data are now ready for analysis. For now, you won't prepare the data to run the related samples test completely on "automatic."

Next