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. |