Preparing the Data for Independent Samples Analysis
In order to ensure consistent dataset names to refer to during the following instructions, give the dataset a name.
- From the menus choose:
- Type originalData as the new name of the dataset.
- Click OK.
You will now be able to more easily refer back to this dataset later.
- To aggregate the data, from the menus choose:
Figure 1. Aggregate Data dialog box - Select Customer ID [custid] as a break variable.
- Select Primary credit card [card], Number of items [items], and Amount spent [spent] as variables to aggregate.
- Select card_mean in the Summaries of Variables list and click Function.
- In the Aggregate Functions dialog, in the Summary Statistics group, select First.
- Click Continue.
- In the Aggregate Data dialog in the Summaries of Variables list, select items_mean and spent_mean and click Function.
- Select First in the Summary Statistics group as the function.
The dictionary information for Primary credit card [card] will be passed to the new variable card_first. Note that there is no difference between choosing First, Last, Minimum, or Maximum because the values for Primary card [card] are the same for each customer.
- Click Continue.
- In the Aggregate Data dialog, select items_mean and spent_mean in the Summaries of Variables list and click Function.
- Select Sum in the Summary Statistics group as the function.
- Click Continue.
- In the Save group, select Create new dataset containing only the aggregated variables and type independentSamples as the new dataset name.
- Click OK.
The aggregated dataset is almost ready for analysis.
- In the Variable View In the Data Editor window for the new independentSamples dataset, set the role of items_sum and spent_sum to Target.
These selections will allow you to run the independent samples and one-sample nonparametric tests on "automatic."