Menu location: Data_Organizing_Sort_Create Sorted Variables.
StatsDirect enables you to create sorted copies of workbook columns or to manipulate data within a selected data range of a workbook. This section deals with creating new sorted workbook columns based on existing ones. See also workbook sort.
This function sorts workbook data you select and saves the sorted data into a new workbook column marked Sort: Name, where Name is the column label of the original data. Sorting may be ascending or descending. The sort may also be tied to other data, i.e. the data in column b may be sorted in the in the order of sorting the data in column a. Tied sorting can be repeated for any number of columns.
Example 1
Test workbook (Nonparametric worksheet: First Born).
Sorting the following agressivity scores for a sample of firstborn twins in ascending order gives.
First Born -----> | Sort: First Born |
86 | 68 |
71 | 70 |
77 | 71 |
68 | 71 |
91 | 72 |
72 | 77 |
77 | 77 |
91 | 86 |
70 | 87 |
71 | 88 |
88 | 91 |
87 | 91 |
Example 2
Test workbook (Nonparametric worksheet: First Born, Second Born).
Sorting the following agressivity scores for a sample of second born twins by the ascending order of the scores for firstborn twins gives.
First Born | Second Born -----> | Sr~Second Born~First Born |
86 | 88 | 64 |
71 | 77 | 65 |
77 | 76 | 80 |
68 | 64 | 77 |
91 | 96 | 72 |
72 | 72 | 76 |
77 | 65 | 65 |
91 | 90 | 88 |
70 | 65 | 72 |
71 | 80 | 81 |
88 | 81 | 96 |
87 | 72 | 90 |
Copyright © 2000-2019 StatsDirect Limited, all rights reserved. Download a free trial here.