What is a subset?

A subset is a portion of the data in the worksheet. Some Minitab functions, including many graphs and charts, let you define a subset of data in order to work with it in isolation without changing the data in the worksheet itself. For example, your worksheet may contain data for the entire year, but you want to create a time series plot of only the previous six months. Using the subset option lets you graph only those data points that came after your specified date.

Graph a subset of the data

When you create a graph, you can specify a subset of data to graph.

  1. In the dialog box for the graph you are creating, click Data Options, then click the Subset tab.
  2. Specify whether to include or exclude rows from the graph.
  3. Specify which rows to include or exclude:
    • Rows that match a calculator-defined condition; for example, Sum > 5, 'Color' = 'Red', or 'Incident' >= DATE("1/1/13"). Click Condition, and then enter the condition.
    • Rows that are brushed in another graph.
    • Specific row numbers. Enter the row numbers.
  4. Click OK.

Example of graphing a subset of data on a time series plot

You have the following data in a worksheet and you would like to create a time series plot that includes only the data from 1/2/2014 to 1/7/2014 on the time series plot.

C1 C2
Date Data
1/1/2014 5
1/2/2014 6
1/3/2014 9
1/4/2014 8
1/5/2014 7
1/6/2014 8
1/7/2014 9
1/8/2014 10
1/9/2014 11

  1. Choose Graph > Time Series Plot > Simple.
  2. In Series, enter C2.
  3. Click Data Options.
  4. Under Include or Exclude, choose Specify which rows to include.
  5. Under Specify Which Rows to Include, choose Rows that match and click Condition.
  6. In Condition, enter C1>=Date("1/2/2014") and C1<=Date("1/7/2014").
  7. Click OK in each dialog box.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy