Creating a new column

You can calculate new columns based on old ones in Minitab. The LET command in Minitab is used to calculate a column. The syntax is this:

MTB> LET column= arithmetic expression

The following example calculates the improvement from TEST1 to TEST4.

MTB> LET C6=C5-C2

Since C5 and C2 are named, we could have also done this:

MTB> NAME C6= 'IMPROV' MTB> LET 'IMPROV'='TEST4' -'TEST1'

Arithmetic operators include +, -, * (for multiply), / (for divide), and ** (for exponentiation). Also parenthesis can be used to clarify complex operations. The following example calculates column 7 as the square of column 6.

MTB> LET C7= C6**2

Rowwise statistical functions can also be used to compute a statistic across a series of columns, and to put the result in the corresponding locations of the new column. The following example computes C8 as the mean of C2 to C5.

MTB> RMEAN C2-C5 C8

More complex operations are possible. The following example would compute a weighted mean if the first three tests were worth 50% of the grade and the final test were worth 50% of the grade.

MTB> LET C8=(.50*((C2+C3+C4)/3))+(.50*C5)

The following are MINITAB rowwise statistics.

RCOUNT col-col resultcol -- gives the count of values in the row.
RN col-col resultcol -- gives the number of non-missing values across the row.
RNMISS col-col resultcol -- gives the number of missing values across the row.
RSUM col-col resultcol -- gives the sum of the values across the row.
RMEAN col-col resultcol -- gives the mean of the values across the row.
RSTDEV col-col resultcol -- gives the standard deviation of the values across the row.
RMEDIAN col-col resultcol -- gives the median of the values.
RMINIMUM col-col resultcol -- gives the minimum value across the row.
RMAXIMUM col-col resultcol -- gives the maximum value across the row.
RSSQ col-col resultcol -- gives the uncorrected sum of squares.

Your rating: None Average: 2.7 (3 votes)