Industrial Statistics with Minitab

A2.1 Copy Columns with Restrictions (File: ‘PULSE’)

Consider again the file PULSE.MTW, used in Chapter . Remember that its content is collected in a class with 92 students, where initially each student registers its own height, weight, gender, smoking preference, usual physical activity level and resting pulse rate. Then, each student flips a coin and those who get a face coming up must run in place during one minute. Finally, after that time, all students measure and register their new pulse rates. The following columns of the worksheet will be used:

The aim is to compare the pulse increment between males and females who have run. This can be achieved using some useful data management options.

Calculate first the difference between Pulse1 and Pulse2 using Calculator.

Calc > Calculator

One might think that the comparison of the increments stratified by gender could be done now, but this is not so, because the increment variable includes people who have run and people who have not. To place in a column only the increments of those who have run, a copy of selected values from the column containing the increments is made.

Data > Copy > Columns to Columns

Now, column C10 ...