Split the Worksheet Based on the Value of a Variable

Minitab 18

Minitab®  – Procedure

  1. Select Data >> Split Worksheet...
  2. In the box labeled By variables, specify the variable based on which you want the worksheet to be split.
  3. Select OK. The new worksheets, based on the original worksheet, will appear.


A laboratory tested the relationship between operating cost per mile (y = cost) and cruising speed (x = speed) for two different makes (0, 1) of truck tires. The resulting data are stored in tiretesting.txt (Neter, Kutner, et al, 1996, p. 493). Split the worksheet into two worksheets based on the value of the variable make.

Minitab Dialog Box

minitab split worksheet dialog box

Resulting Sample Minitab Output

minitab worksheets for each truck make

Worksheet is split into two worksheets; one for each make of truck.

Video Review