Create Sorted Variables

 

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.