A chemical engineer wants to compare the hardness of four blends of paint. The paint samples were cured at different temperatures by different operators. The engineer wants to sort the data so that it is easier to see which blend and operator are associated with each observation.

  1. Open the sample data, PaintHardness.MTW.
  2. Open the Sort dialog box.
    • Mac: Data > Sort
    • PC: DATA > Sort
  3. In Columns to sort, enter PaintOperatorHardness.
  4. In the first Columns to sort by, enter Paint.
  5. In the second Columns to sort by, enter Operator.
  6. Click OK.

Results

Columns C5–C7 contain the sorted data. Because column C1 was the first sort column, all observations for Blend 1 are at the top of the worksheet, followed by all observations for Blend 2, and so on.

C4 was the second sort column, so, within the rows for each blend, the data are sorted by operator. Within the rows for Blend 1, the data for operator 1 is at the top, followed by the data for operator 2, and then operator 3. This pattern repeats for each blend.

C1 C2 ... C4 C5 C6 C7
Paint Hardness ... Operator By Paint By Operator Sorted Hardness
Blend 2 14.9 ... 1 Blend 1 1 19.3
Blend 3 13.0 ... 2 Blend 1 2 10.4
Blend 4 15.0 ... 2 Blend 1 3 17.0
Blend 1 17.0 ... 3 Blend 1 3 13.9
Blend 1 13.9 ... 3 Blend 1 3 16.1
Blend 3 16.4 ... 1 Blend 1 3 11.7
Blend 1 10.4 ... 2 Blend 2 1 14.9
Blend 2 3.2 ... 2 Blend 2 1 7.3
... ... ... ... ... ... ...
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy