Example of subsetting a worksheet based on rows that match a condition

A medical researcher wants to study the effects of various factors on pulse rates. The researcher records the height, weight, gender, smoking preference, and activity level for a group of college students, and then measures their resting pulse rates and pulse rates after running.

The researcher subsets the worksheet to include only the data for Activity levels of A lot and Moderate.

Open the sample data, PulseRates.MTW.
Choose Data > Subset Worksheet.
From How do you want to create a subset?, select Use rows that match a condition.
From Do you want to include or exclude rows?, select Include rows that match the condition.
In Column, enter Activity.
From Condition, select Equals set of values.
From Values, select A lot and Moderate.
Click OK.

Results

Minitab creates a new worksheet that contains only data for Activity levels of A lot and Moderate.

Minitab.com
License Portal
Store
Blog
Contact Us
Cookie Settings