Splitting a worksheet by categorical column
In this recipe, we will create several new worksheets from a grouping column. Split worksheet is a great way of quickly separating data out into separate worksheets.
Getting ready
We will use the file pulse.mtw from the sample Minitab data folder. Here, we will split the worksheet into two new worksheets: one for those who ran and the other for those who didn't run.
To open the pulse file, go to File and then click on Open Worksheet. Click on the button Look in Minitab Sample Data folder. Then find the file pulse.mtw. If the file does not show up, make sure the file type is set to Minitab (*.mtw; *.mpj).
How to do it…
The following instructions will split a worksheet by a categorical column:
- Go to the Data ...
Get Minitab Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
