Sort data to new column

Menu location: Data_Sort_Create Sorted Columns.

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