1. Home
  2. Select Summary Statistic to Sort Levels on

Select Summary Statistic to Sort Levels on

This is opened from the Sort Label/Level Order within a Factor Column dialog when the By summary statistic option is selected. This allows you to sort a factor’s levels using a variate’s summaries on the factor groups. This may be useful to change the order of the levels in a table or graph so that the groups are displayed in increasing or decreasing order of the selected statistic. You need to select a summary variate and statistic to be used for sorting the levels.

Summarize variate

Specifies a variate within the spreadsheet containing the data used to form the summary statistics.

Summary statistic

Select the summary statistic that you want to sort the factor levels on.

Mean Mean of the variate for each group
Median Median value that divides each group of the variate into two equally sized sets
Minimum Minimum value of the variate for each group
Maximum Maximum value of the variate for each group
Standard deviation Standard deviation of the variate for each group
Variance Variance of the variate for each group
Standard error of the mean Standard error of the mean of the variate for each group
Total Total of the variate within groups
Number of observations Number of observations of the variate within each group
Number of missing values Number of missing values in the variate within each group

Action buttons

OK Sort the factor levels using the calculated summary statistics.
Cancel Close the menu without sorting the factor levels.

See also

Updated on April 1, 2022

Was this article helpful?