251y0332T 12/02/03
Means, variances, covariances etc. from question 1 of Take-home.
The program used is a Minitab ‘exec’ called ‘cov5.’ The ‘echo’ instruction below has it print out Minitab commands as well as the output. All worksheets were made up before I started recording results.
MTB > echoThe worksheet ‘sec9’ is already in the computer on a so-called portable file. The portable filedoesn’tseem to be any different from a regular Minitab file.
x is in c1 and y in c2.
MTB > exec 'cov5'It is now executing my canned program.
Executing from file: cov5.MTB
MTB > let c3=c1*c1It is creating the x-squared, xy and y-squared columns.
MTB > let c4=c1*c2
MTB > sum c1
SUM = 0.25000Sum of x
MTB > sum c2
SUM = -0.23000Sum of y
MTB > sum c3
SUM = 0.037500Sum of x-sq
MTB > sum c4
SUM = -0.031000Sum of xy
MTB > let c5=c2*c2
MTB > sum c5
SUM = 0.084700Sum of y-sq
MTB > print c1-c5What your table should look like.
ROW x y xsq xy ysq
1 0.10 -0.19 0.0100 -0.0190 0.0361
2 -0.05 0.05 0.0025 -0.0025 0.0025
3 0.15 0.00 0.0225 0.0000 0.0000
4 0.05 -0.19 0.0025 -0.0095 0.0361
5 0.00 0.10 0.0000 0.0000 0.0100
MTB > covariance c1 c2Computes covariance and variances.
x y
x 0.00625000
y -0.00487500 0.01853000
MTB > correlation c1 c2
Correlation of x and y = -0.453Computes correlation
MTB > describe c1 c2Computes mean, median and std deviation.
N MEAN MEDIAN TRMEAN STDEV SEMEAN
x 5 0.0500 0.0500 0.0500 0.0791 0.0354
y 5 -0.0460 0.0000 -0.0460 0.1361 0.0609
MIN MAX Q1 Q3
x -0.0500 0.1500 -0.0250 0.1250
y -0.1900 0.1000 -0.1900 0.0750
MTB > end
If your SS number contains 0.
Worksheet size: 3500 cells
MTB > Retrieve 'C:\DOCUME~1\RBOVE~1.WCU\MYDOCU~1\DRIVED~1\MINITAB\SEC0.MTP';
SUBC> Portable.
Retrieving worksheet from file: C:\DOCUME~1\RBOVE~1.WCU\MYDOCU~1\DRIVED~1\MINITAB\SEC0.MTP
Worksheet was saved on 12/ 1/2003
MTB > Execute 'C:\DOCUME~1\RBOVE~1.WCU\MYDOCU~1\DRIVED~1\MINITAB\COV5.MTB' 1.
Executing from file: C:\DOCUME~1\RBOVE~1.WCU\MYDOCU~1\DRIVED~1\MINITAB\COV5.MTB
SUM = 0.25000
SUM = -0.050000
SUM = 0.037500
SUM = -0.017500
SUM = 0.032500
ROW x y xsq xy ysq
1 0.10 -0.10 0.0100 -0.0100 0.0100
2 -0.05 0.05 0.0025 -0.0025 0.0025
3 0.15 0.00 0.0225 0.0000 0.0000
4 0.05 -0.10 0.0025 -0.0050 0.0100
5 0.00 0.10 0.0000 0.0000 0.0100
x y
x 0.00625000
y -0.00375000 0.00800000
Correlation of x and y = -0.530
N MEAN MEDIAN TRMEAN STDEV SEMEAN
x 5 0.0500 0.0500 0.0500 0.0791 0.0354
y 5 -0.0100 0.0000 -0.0100 0.0894 0.0400
MIN MAX Q1 Q3
x -0.0500 0.1500 -0.0250 0.1250
y -0.1000 0.1000 -0.1000 0.0750
If your SS number contains 1.
MTB > Retrieve 'C:\DOCUME~1\RBOVE~1.WCU\MYDOCU~1\DRIVED~1\MINITAB\SEC1.MTP';
SUBC> Portable.
Retrieving worksheet from file: C:\DOCUME~1\RBOVE~1.WCU\MYDOCU~1\DRIVED~1\MINITAB\SEC1.MTP
Worksheet was saved on 12/ 1/2003
MTB > exec'cov5'
Executing from file: cov5.MTB
SUM = 0.25000
SUM = -0.070000
SUM = 0.037500
SUM = -0.019000
SUM = 0.036700
ROW x y xsq xy ysq
1 0.10 -0.11 0.0100 -0.0110 0.0121
2 -0.05 0.05 0.0025 -0.0025 0.0025
3 0.15 0.00 0.0225 0.0000 0.0000
4 0.05 -0.11 0.0025 -0.0055 0.0121
5 0.00 0.10 0.0000 0.0000 0.0100
x y
x 0.00625000
y -0.00387500 0.00893000
Correlation of x and y = -0.519
N MEAN MEDIAN TRMEAN STDEV SEMEAN
x 5 0.0500 0.0500 0.0500 0.0791 0.0354
y 5 -0.0140 0.0000 -0.0140 0.0945 0.0423
MIN MAX Q1 Q3
x -0.0500 0.1500 -0.0250 0.1250
y -0.1100 0.1000 -0.1100 0.0750
MTB > Save 'C:\DOCUME~1\RBOVE~1.WCU\MYDOCU~1\DRIVED~1\MINITAB\SEC1.MTP';
SUBC> Portable;
SUBC> Replace.
Saving worksheet in file: C:\DOCUME~1\RBOVE~1.WCU\MYDOCU~1\DRIVED~1\MINITAB\SEC1.MTP
* NOTE * Existing file replaced.
If your SS number contains 2.
MTB > Retrieve 'C:\DOCUME~1\RBOVE~1.WCU\MYDOCU~1\DRIVED~1\MINITAB\SEC2.MTP';
SUBC> Portable.
MTB > retrieve 'sec2.mtp';
SUBC> port.
Retrieving worksheet from file: sec2.mtp
Worksheet was saved on 12/ 1/2003
MTB > exec 'cov5'
Executing from file: cov5.MTB
SUM = 0.25000
SUM = -0.090000
SUM = 0.037500
SUM = -0.020500
SUM = 0.041300
ROW x y xsq xy ysq
1 0.10 -0.12 0.0100 -0.0120 0.0144
2 -0.05 0.05 0.0025 -0.0025 0.0025
3 0.15 0.00 0.0225 0.0000 0.0000
4 0.05 -0.12 0.0025 -0.0060 0.0144
5 0.00 0.10 0.0000 0.0000 0.0100
x y
x 0.00625000
y -0.00400000 0.00992000
Correlation of x and y = -0.508
N MEAN MEDIAN TRMEAN STDEV SEMEAN
x 5 0.0500 0.0500 0.0500 0.0791 0.0354
y 5 -0.0180 0.0000 -0.0180 0.0996 0.0445
MIN MAX Q1 Q3
x -0.0500 0.1500 -0.0250 0.1250
y -0.1200 0.1000 -0.1200 0.0750
MTB > save 'sec2.mtp';
SUBC> port.
Saving worksheet in file: sec2.mtp
If your SS number contains 3.
MTB > retr 'sec3.mtp';
SUBC> port.
Retrieving worksheet from file: sec3.mtp
Worksheet was saved on 12/ 1/2003
MTB > exec 'cov5'
Executing from file: cov5.MTB
SUM = 0.25000
SUM = -0.11000
SUM = 0.037500
SUM = -0.022000
SUM = 0.046300
ROW x y xsq xy ysq
1 0.10 -0.13 0.0100 -0.0130 0.0169
2 -0.05 0.05 0.0025 -0.0025 0.0025
3 0.15 0.00 0.0225 0.0000 0.0000
4 0.05 -0.13 0.0025 -0.0065 0.0169
5 0.00 0.10 0.0000 0.0000 0.0100
x y
x 0.00625000
y -0.00412500 0.01097000
Correlation of x and y = -0.498
N MEAN MEDIAN TRMEAN STDEV SEMEAN
x 5 0.0500 0.0500 0.0500 0.0791 0.0354
y 5 -0.0220 0.0000 -0.0220 0.1047 0.0468
MIN MAX Q1 Q3
x -0.0500 0.1500 -0.0250 0.1250
y -0.1300 0.1000 -0.1300 0.0750
MTB > save 'sec3';
SUBC> port.
Saving worksheet in file: sec3.MTP
If your SS number contains 4.
MTB > retr 'sec4';
SUBC> port.
Retrieving worksheet from file: sec4.MTP
Worksheet was saved on 12/ 1/2003
MTB > exec 'cov5'
Executing from file: cov5.MTB
SUM = 0.25000
SUM = -0.13000
SUM = 0.037500
SUM = -0.023500
SUM = 0.051700
ROW x y xsq xy ysq
1 0.10 -0.14 0.0100 -0.0140 0.0196
2 -0.05 0.05 0.0025 -0.0025 0.0025
3 0.15 0.00 0.0225 0.0000 0.0000
4 0.05 -0.14 0.0025 -0.0070 0.0196
5 0.00 0.10 0.0000 0.0000 0.0100
x y
x 0.00625000
y -0.00425000 0.01208000
Correlation of x and y = -0.489
N MEAN MEDIAN TRMEAN STDEV SEMEAN
x 5 0.0500 0.0500 0.0500 0.0791 0.0354
y 5 -0.0260 0.0000 -0.0260 0.1099 0.0492
MIN MAX Q1 Q3
x -0.0500 0.1500 -0.0250 0.1250
y -0.1400 0.1000 -0.1400 0.0750
MTB > save 'sec4';
SUBC> port.
Saving worksheet in file: sec4.MTP
MTB > retr 'sec5';
SUBC> port.
If your SS number contains 5.
Retrieving worksheet from file: sec5.MTP
Worksheet was saved on 12/ 1/2003
MTB > exec 'cov5'
Executing from file: cov5.MTB
SUM = 0.25000
SUM = -0.15000
SUM = 0.037500
SUM = -0.025000
SUM = 0.057500
ROW x y xsq xy ysq
1 0.10 -0.15 0.0100 -0.0150 0.0225
2 -0.05 0.05 0.0025 -0.0025 0.0025
3 0.15 0.00 0.0225 0.0000 0.0000
4 0.05 -0.15 0.0025 -0.0075 0.0225
5 0.00 0.10 0.0000 0.0000 0.0100
x y
x 0.00625000
y -0.00437500 0.01325000
Correlation of x and y = -0.481
N MEAN MEDIAN TRMEAN STDEV SEMEAN
x 5 0.0500 0.0500 0.0500 0.0791 0.0354
y 5 -0.0300 0.0000 -0.0300 0.1151 0.0515
MIN MAX Q1 Q3
x -0.0500 0.1500 -0.0250 0.1250
y -0.1500 0.1000 -0.1500 0.0750
MTB > save 'sec5';
SUBC> port;
SUBC> repl.
Saving worksheet in file: sec5.MTP
* NOTE * Existing file replaced.
If your SS number contains 6.
MTB > retr 'sec6';
SUBC> port.
Retrieving worksheet from file: sec6.MTP
Worksheet was saved on 12/ 1/2003
MTB > exec 'cov5'
Executing from file: cov5.MTB
SUM = 0.25000
SUM = -0.17000
SUM = 0.037500
SUM = -0.026500
SUM = 0.063700
ROW x y xsq xy ysq
1 0.10 -0.16 0.0100 -0.0160 0.0256
2 -0.05 0.05 0.0025 -0.0025 0.0025
3 0.15 0.00 0.0225 0.0000 0.0000
4 0.05 -0.16 0.0025 -0.0080 0.0256
5 0.00 0.10 0.0000 0.0000 0.0100
x y
x 0.00625000
y -0.00450000 0.01448000
Correlation of x and y = -0.473
N MEAN MEDIAN TRMEAN STDEV SEMEAN
x 5 0.0500 0.0500 0.0500 0.0791 0.0354
y 5 -0.0340 0.0000 -0.0340 0.1203 0.0538
MIN MAX Q1 Q3
x -0.0500 0.1500 -0.0250 0.1250
y -0.1600 0.1000 -0.1600 0.0750
MTB > save 'sec6';
SUBC> port;
SUBC> repl.
Saving worksheet in file: sec6.MTP
* NOTE * Existing file replaced.
If your SS number contains 7.
MTB > retr 'sec7';
SUBC> port.
Retrieving worksheet from file: sec7.MTP
Worksheet was saved on 12/ 1/2003
MTB > exec 'cov5'
Executing from file: cov5.MTB
SUM = 0.25000
SUM = -0.19000
SUM = 0.037500
SUM = -0.028000
SUM = 0.070300
ROW x y xsq xy ysq
1 0.10 -0.17 0.0100 -0.0170 0.0289
2 -0.05 0.05 0.0025 -0.0025 0.0025
3 0.15 0.00 0.0225 0.0000 0.0000
4 0.05 -0.17 0.0025 -0.0085 0.0289
5 0.00 0.10 0.0000 0.0000 0.0100
x y
x 0.00625000
y -0.00462500 0.01577000
Correlation of x and y = -0.466
N MEAN MEDIAN TRMEAN STDEV SEMEAN
x 5 0.0500 0.0500 0.0500 0.0791 0.0354
y 5 -0.0380 0.0000 -0.0380 0.1256 0.0562
MIN MAX Q1 Q3
x -0.0500 0.1500 -0.0250 0.1250
y -0.1700 0.1000 -0.1700 0.0750
MTB > save 'sec7';
SUBC> port;
SUBC> repl.
Saving worksheet in file: sec7.MTP
* NOTE * Existing file replaced.
If your SS number contains 8.
MTB > retr 'sec8';
SUBC> port.
Retrieving worksheet from file: sec8.MTP
Worksheet was saved on 12/ 1/2003
MTB > exec 'cov5'
Executing from file: cov5.MTB
SUM = 0.25000
SUM = -0.21000
SUM = 0.037500
SUM = -0.029500
SUM = 0.077300
ROW x y xsq xy ysq
1 0.10 -0.18 0.0100 -0.0180 0.0324
2 -0.05 0.05 0.0025 -0.0025 0.0025
3 0.15 0.00 0.0225 0.0000 0.0000
4 0.05 -0.18 0.0025 -0.0090 0.0324
5 0.00 0.10 0.0000 0.0000 0.0100
x y
x 0.00625000
y -0.00475000 0.01712000
Correlation of x and y = -0.459
N MEAN MEDIAN TRMEAN STDEV SEMEAN
x 5 0.0500 0.0500 0.0500 0.0791 0.0354
y 5 -0.0420 0.0000 -0.0420 0.1308 0.0585
MIN MAX Q1 Q3
x -0.0500 0.1500 -0.0250 0.1250
y -0.1800 0.1000 -0.1800 0.0750
MTB > save 'sec8';
SUBC> port;
SUBC> repl.
Saving worksheet in file: sec8.MTP
* NOTE * Existing file replaced.
If your SS number contains 9.
MTB > retr 'sec9';
SUBC> port.
Retrieving worksheet from file: sec9.MTP
Worksheet was saved on 12/ 1/2003
MTB > exec 'cov5'
Executing from file: cov5.MTB
SUM = 0.25000
SUM = -0.23000
SUM = 0.037500
SUM = -0.031000
SUM = 0.084700
ROW x y xsq xy ysq
1 0.10 -0.19 0.0100 -0.0190 0.0361
2 -0.05 0.05 0.0025 -0.0025 0.0025
3 0.15 0.00 0.0225 0.0000 0.0000
4 0.05 -0.19 0.0025 -0.0095 0.0361
5 0.00 0.10 0.0000 0.0000 0.0100
x y
x 0.00625000
y -0.00487500 0.01853000
Correlation of x and y = -0.453
N MEAN MEDIAN TRMEAN STDEV SEMEAN
x 5 0.0500 0.0500 0.0500 0.0791 0.0354
y 5 -0.0460 0.0000 -0.0460 0.1361 0.0609
MIN MAX Q1 Q3
x -0.0500 0.1500 -0.0250 0.1250
y -0.1900 0.1000 -0.1900 0.0750
MTB > save 'sec9';
SUBC> port;
SUBC> repl.
Saving worksheet in file: sec9.MTP
* NOTE * Existing file replaced.
1