SAS coefficient of variation vs. Excel coefficient of variation

vitamins

New Member
Joined
Apr 26, 2016
Messages
5
Good day everyone!

I just want to ask why is that the CV of SAS is different from the calculated CV of excel?
for example, here is the data set:
DATA INPUT
SLY FARM ADay 0DAY 7DAY 14DAY 21DAY 28DAY 30
BlockRepTrmtCage #ALWALWADGFCTFCRAFCRMORTALWADGFCTFCRAFCRMORTALWADGFCTFCRAFCRMORTALWADGFCTFCRAFCRMORTALWADGFCTFCRAFCRMORT
112147.20190.2427.181860.9790.9810.11521.3037.246441.2351.2370.421003.2047.7713851.3811.3840.741622.4060.0924661.5201.5240.952027.3267.5833041.6301.6381.48
116247.37195.7627.971880.9620.9630.00521.8037.276361.2201.2240.631023.6848.7513761.3441.3511.381667.4061.7623941.4361.4431.482031.8267.7332141.5821.5931.90
114346.90193.8427.691820.9410.9440.21519.2037.096311.2151.2200.95993.9247.3313681.3761.3841.691645.0060.9323901.4531.4611.801922.7764.0932391.6841.7002.54
111447.01187.5226.791740.9260.9270.00517.7036.986321.2211.2230.32986.2446.9613711.3901.3971.271653.0061.2223571.4261.4291.591973.6565.7931771.6101.6222.43
115547.72195.8827.981920.9810.9840.11521.8037.276511.2471.2490.321029.6049.0314081.3681.3730.851670.6061.8724551.4691.4760.951992.9166.4332511.6311.6502.22
113647.47195.0427.861870.9590.9590.00524.8037.496261.1931.1930.001013.1248.2413611.3431.3460.421666.4061.7223751.4251.4300.741984.5566.1531851.6051.6141.16
3361347.34200.7228.671850.9210.9230.11535.7038.266351.1851.1870.211015.8448.3713611.3401.3481.161606.2059.4923771.4801.4861.162039.3967.9831631.5511.5652.01
3311446.94187.6826.811981.0531.0590.32493.1035.226591.3371.3450.85974.7246.4214121.4481.4591.901580.6058.5423671.4981.5062.011933.7564.4631591.6331.6593.49
3341546.88194.1627.741930.9920.9950.11507.9036.286381.2561.2590.42972.0046.2913561.3951.4061.801591.4058.9424001.5081.5172.011962.0265.4031611.6111.6313.07
3331646.96201.1228.731940.9670.9690.00539.9038.566531.2101.2160.951028.9649.0014021.3631.3701.481671.2061.9024531.4681.4761.592054.5568.4932381.5761.5892.22
3321746.96197.8428.261950.9840.9860.11533.2038.096531.2251.2280.421019.5248.5513921.3661.3721.061670.2061.8624441.4631.4701.272066.2468.8732661.5801.6062.86
3351847.34203.4429.061980.9740.9780.00534.2038.166491.2151.2210.631023.3648.7313801.3481.3571.481644.0060.8923701.4421.4511.802020.5167.3531511.5591.5742.33
4461946.31192.7227.531760.9160.9170.11538.7038.486111.1351.1390.741033.1249.2013161.2741.2801.381704.2063.1223331.3691.3751.482040.4968.0231321.5351.5804.76
4422045.71194.0827.731750.9000.9030.11542.3038.746171.1381.1450.951033.7649.2313201.2771.2821.161671.8061.9223641.4141.4181.482000.2166.6731411.5711.6013.60
4452146.12193.5227.651720.8900.8910.00540.3038.596041.1191.1210.321029.6049.0312931.2561.2600.741662.2061.5623441.4101.4141.162079.4069.3131721.5261.5492.75
4442246.46196.7228.101790.9100.9100.00541.9038.716151.1351.1370.421026.5648.8812601.2281.2320.851653.6061.2422621.3681.3740.852050.4168.3530551.4901.5162.54
4412346.50187.5226.791690.9000.9030.11524.4037.466021.1491.1520.421009.9248.0912971.2841.2931.381718.4063.6423341.3581.3651.802050.5968.3531871.5541.5692.43
4432446.50194.0827.731770.9150.9160.11536.8038.346071.1321.1350.421030.2449.0612681.2311.2391.381739.6064.4322941.3191.3261.692122.3770.7531491.4841.5113.49
6663146.39190.0827.151760.9240.9280.00490.2335.025911.2051.2080.32932.8044.4212171.3051.3100.851501.8055.6221271.4161.4200.851802.1560.0728421.5771.5881.48
6653246.65192.5627.511790.9320.9340.00490.9035.066101.2421.2450.21914.4043.5412501.3661.3720.851453.6053.8422151.5231.5290.951876.1962.5429411.5671.5811.69
6633346.50193.5227.651870.9680.9700.00500.9035.786211.2401.2430.32933.1244.4312981.3911.4011.381476.6054.6922351.5131.5221.591908.2663.6129701.5561.5702.12
6613446.50188.2426.891891.0041.0060.00480.4034.316091.2691.2710.32928.0044.1912981.3981.4101.591507.4055.8322691.5051.5151.901857.0961.9030251.6291.6472.54
6643546.48184.9626.421851.0001.0050.00472.8033.776101.2891.2930.11908.9643.2812761.4041.4110.951463.4054.2022001.5031.5121.271755.3158.5129181.6621.6791.90
6623645.87183.2826.181851.0081.0090.00476.8034.066201.3011.3010.11915.3643.5913071.4281.4340.951431.4053.0122461.5691.5781.381766.6458.8930061.7011.7252.33
146.7187.7426.821820.9710.9740.11503.9035.996261.2441.2480.48974.7246.4213441.3801.3901.531614.8559.8123321.4471.4541.831953.7765.1331371.6071.6242.72
246.4191.3627.341850.9680.9700.08518.4037.036341.2251.2280.48992.9647.2813511.3631.3680.981598.9559.2223801.4921.4971.271965.1065.5031791.6211.6422.57
346.9195.9427.991870.9520.9540.03525.6037.546271.1931.1970.421001.3647.6813321.3321.3391.161638.4560.6823391.4311.4381.402017.4367.2531361.5551.5712.25
446.7192.4227.491850.9610.9640.08510.4536.466231.2241.2270.48975.3646.4513151.3511.3581.321588.3558.8323131.4581.4661.481922.6364.0930931.6121.6322.51
547.0196.3528.051860.9450.9470.03521.8037.276291.2061.2090.37999.2447.5813331.3351.3400.981607.6059.5423461.4611.4681.221992.2566.4131291.5711.5882.25
646.9194.8227.831810.9310.9330.05521.6137.266181.1861.1900.481001.3647.6813171.3161.3221.191619.9060.0023081.4251.4311.241978.4665.9530881.5611.5822.54

<tbody>
</tbody>

and here is the SAS result:

Specialty Protein 15:10 Thursday, April 26, 2016 73


Obs block rep trmt cage ABW0 ABW7 ADG7 FC7 TFCR7 AFCR7 MORT7 ABW14 ADG14 FC14 TFCR14


1 1 1 1 4 47.01 187.52 26.79 174 0.926 0.927 0.00 517.70 36.98 632 1.221
2 3 3 1 14 46.94 187.68 26.81 198 1.053 1.059 0.32 493.10 35.22 659 1.337
3 4 4 1 23 46.50 187.52 26.79 169 0.900 0.903 0.11 524.40 37.46 602 1.149
4 6 6 1 34 46.50 188.24 26.89 189 1.004 1.006 0.00 480.40 34.31 609 1.269
5 1 1 2 1 47.20 190.24 27.18 186 0.979 0.981 0.11 521.30 37.24 644 1.235
6 3 3 2 17 46.96 197.84 28.26 195 0.984 0.986 0.11 533.20 38.09 653 1.225
7 4 4 2 20 45.71 194.08 27.73 175 0.900 0.903 0.11 542.30 38.74 617 1.138
8 6 6 2 36 45.87 183.28 26.18 185 1.008 1.009 0.00 476.80 34.06 620 1.301
9 1 1 3 6 47.47 195.04 27.86 187 0.959 0.959 0.00 524.80 37.49 626 1.193
10 3 3 3 16 46.96 201.12 28.73 194 0.967 0.969 0.00 539.90 38.56 653 1.210
11 4 4 3 24 46.50 194.08 27.73 177 0.915 0.916 0.11 536.80 38.34 607 1.132
12 6 6 3 33 46.50 193.52 27.65 187 0.968 0.970 0.00 500.90 35.78 621 1.240
13 1 1 4 3 46.90 193.84 27.69 182 0.941 0.944 0.21 519.20 37.09 631 1.215
14 3 3 4 15 46.88 194.16 27.74 193 0.992 0.995 0.11 507.90 36.28 638 1.256
15 4 4 4 22 46.46 196.72 28.10 179 0.910 0.910 0.00 541.90 38.71 615 1.135


Obs AFCR14 MORT14 ABW21 ADG21 FC21 TFCR21 AFCR21 MORT21 ABW28 ADG28 FC28 TFCR28 AFCR28


1 1.223 0.32 986.24 46.96 1371 1.390 1.397 1.27 1653.0 61.22 2357 1.426 1.429
2 1.345 0.85 974.72 46.42 1412 1.448 1.459 1.90 1580.6 58.54 2367 1.498 1.506
3 1.152 0.42 1009.92 48.09 1297 1.284 1.293 1.38 1718.4 63.64 2334 1.358 1.365
4 1.271 0.32 928.00 44.19 1298 1.398 1.410 1.59 1507.4 55.83 2269 1.505 1.515
5 1.237 0.42 1003.20 47.77 1385 1.381 1.384 0.74 1622.4 60.09 2466 1.520 1.524
6 1.228 0.42 1019.52 48.55 1392 1.366 1.372 1.06 1670.2 61.86 2444 1.463 1.470
7 1.145 0.95 1033.76 49.23 1320 1.277 1.282 1.16 1671.8 61.92 2364 1.414 1.418
8 1.301 0.11 915.36 43.59 1307 1.428 1.434 0.95 1431.4 53.01 2246 1.569 1.578
9 1.193 0.00 1013.12 48.24 1361 1.343 1.346 0.42 1666.4 61.72 2375 1.425 1.430
10 1.216 0.95 1028.96 49.00 1402 1.363 1.370 1.48 1671.2 61.90 2453 1.468 1.476
11 1.135 0.42 1030.24 49.06 1268 1.231 1.239 1.38 1739.6 64.43 2294 1.319 1.326
12 1.243 0.32 933.12 44.43 1298 1.391 1.401 1.38 1476.6 54.69 2235 1.513 1.522
13 1.220 0.95 993.92 47.33 1368 1.376 1.384 1.69 1645.0 60.93 2390 1.453 1.461
14 1.259 0.42 972.00 46.29 1356 1.395 1.406 1.80 1591.4 58.94 2400 1.508 1.517
15 1.137 0.42 1026.56 48.88 1260 1.228 1.232 0.85 1653.6 61.24 2262 1.368 1.374


Obs MORT28 ABW32 ADG32 FC32 TFCR32 AFCR32 MORT32 T7 T14 T21 T28 T32


1 1.59 1973.65 65.79 3177 1.610 1.622 2.43 0.70711 0.90554 1.33041 1.44568 1.71172
2 2.01 1933.75 64.46 3159 1.633 1.659 3.49 0.90554 1.16190 1.54919 1.58430 1.99750
3 1.80 2050.59 68.35 3187 1.554 1.569 2.43 0.78102 0.95917 1.37113 1.51658 1.71172
4 1.90 1857.09 61.90 3025 1.629 1.647 2.54 0.70711 0.90554 1.44568 1.54919 1.74356
5 0.95 2027.32 67.58 3304 1.630 1.638 1.48 0.78102 0.95917 1.11355 1.20416 1.40712
6 1.27 2066.24 68.87 3266 1.580 1.606 2.86 0.78102 0.95917 1.24900 1.33041 1.83303
7 1.48 2000.21 66.67 3141 1.571 1.601 3.60 0.78102 1.20416 1.28841 1.40712 2.02485
8 1.38 1766.64 58.89 3006 1.701 1.725 2.33 0.70711 0.78102 1.20416 1.37113 1.68226
9 0.74 1984.55 66.15 3185 1.605 1.614 1.16 0.70711 0.70711 0.95917 1.11355 1.28841
10 1.59 2054.55 68.49 3238 1.576 1.589 2.22 0.70711 1.20416 1.40712 1.44568 1.64924
11 1.69 2122.37 70.75 3149 1.484 1.511 3.49 0.78102 0.95917 1.37113 1.47986 1.99750
12 1.59 1908.26 63.61 2970 1.556 1.570 2.12 0.70711 0.90554 1.37113 1.44568 1.61864
13 1.80 1922.77 64.09 3239 1.684 1.700 2.54 0.84261 1.20416 1.47986 1.51658 1.74356
14 2.01 1962.02 65.40 3161 1.611 1.631 3.07 0.78102 0.95917 1.51658 1.58430 1.88944
15 0.85 2050.41 68.35 3055 1.490 1.516 2.54 0.70711 0.95917 1.16190 1.16190 1.74356

Specialty Protein 15:10 Thursday, April 26, 2016 74


Obs block rep trmt cage ABW0 ABW7 ADG7 FC7 TFCR7 AFCR7 MORT7 ABW14 ADG14 FC14 TFCR14


16 6 6 4 35 46.48 184.96 26.42 185 1.000 1.005 0.00 472.80 33.77 610 1.289
17 1 1 5 5 47.72 195.88 27.98 192 0.981 0.984 0.11 521.80 37.27 651 1.247
18 3 3 5 18 47.34 203.44 29.06 198 0.974 0.978 0.00 534.20 38.16 649 1.215
19 4 4 5 21 46.12 193.52 27.65 172 0.890 0.891 0.00 540.30 38.59 604 1.119
20 6 6 5 32 46.65 192.56 27.51 179 0.932 0.934 0.00 490.90 35.06 610 1.242
21 1 1 6 2 47.37 195.76 27.97 188 0.962 0.963 0.00 521.80 37.27 636 1.220
22 3 3 6 13 47.34 200.72 28.67 185 0.921 0.923 0.11 535.70 38.26 635 1.185
23 4 4 6 19 46.31 192.72 27.53 176 0.916 0.917 0.11 538.70 38.48 611 1.135
24 6 6 6 31 46.39 190.08 27.15 176 0.924 0.928 0.00 490.23 35.02 591 1.205


Obs AFCR14 MORT14 ABW21 ADG21 FC21 TFCR21 AFCR21 MORT21 ABW28 ADG28 FC28 TFCR28 AFCR28


16 1.293 0.11 908.96 43.28 1276 1.404 1.411 0.95 1463.4 54.20 2200 1.503 1.512
17 1.249 0.32 1029.60 49.03 1408 1.368 1.373 0.85 1670.6 61.87 2455 1.469 1.476
18 1.221 0.63 1023.36 48.73 1380 1.348 1.357 1.48 1644.0 60.89 2370 1.442 1.451
19 1.121 0.32 1029.60 49.03 1293 1.256 1.260 0.74 1662.2 61.56 2344 1.410 1.414
20 1.245 0.21 914.40 43.54 1250 1.366 1.372 0.85 1453.6 53.84 2215 1.523 1.529
21 1.224 0.63 1023.68 48.75 1376 1.344 1.351 1.38 1667.4 61.76 2394 1.436 1.443
22 1.187 0.21 1015.84 48.37 1361 1.340 1.348 1.16 1606.2 59.49 2377 1.480 1.486
23 1.139 0.74 1033.12 49.20 1316 1.274 1.280 1.38 1704.2 63.12 2333 1.369 1.375
24 1.208 0.32 932.80 44.42 1217 1.305 1.310 0.85 1501.8 55.62 2127 1.416 1.420


Obs MORT28 ABW32 ADG32 FC32 TFCR32 AFCR32 MORT32 T7 T14 T21 T28 T32


16 1.27 1755.31 58.51 2918 1.662 1.679 1.90 0.70711 0.78102 1.20416 1.33041 1.54919
17 0.95 1992.91 66.43 3251 1.631 1.650 2.22 0.78102 0.90554 1.16190 1.20416 1.64924
18 1.80 2020.51 67.35 3151 1.559 1.574 2.33 0.70711 1.06301 1.40712 1.51658 1.68226
19 1.16 2079.40 69.31 3172 1.526 1.549 2.75 0.70711 0.90554 1.11355 1.28841 1.80278
20 0.95 1876.19 62.54 2941 1.567 1.581 1.69 0.70711 0.84261 1.16190 1.20416 1.47986
21 1.48 2031.82 67.73 3214 1.582 1.593 1.90 0.70711 1.06301 1.37113 1.40712 1.54919
22 1.16 2039.39 67.98 3163 1.551 1.565 2.01 0.78102 0.84261 1.28841 1.28841 1.58430
23 1.48 2040.49 68.02 3132 1.535 1.580 4.76 0.78102 1.11355 1.37113 1.40712 2.29347
24 0.85 1802.15 60.07 2842 1.577 1.588 1.48 0.70711 0.90554 1.16190 1.16190 1.40712

Specialty Protein 15:10 Thursday, April 26, 2016 75


--------------------------------------------- trmt=1 ---------------------------------------------


The MEANS Procedure


Coeff of Std
Variable Mean Minimum Maximum Variance Variation Std Dev Error
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ABW0 46.7375 46.5000 47.0100 0.0760 0.5899 0.2757 0.1379
ABW7 187.7 187.5 188.2 0.1168 0.1820 0.3418 0.1709
ADG7 26.8200 26.7900 26.8900 0.00227 0.1775 0.0476 0.0238
FC7 182.5 169.0 198.0 179.0 7.3310 13.3791 6.6895
TFCR7 0.9708 0.9000 1.0530 0.00496 7.2546 0.0704 0.0352
AFCR7 0.9738 0.9030 1.0590 0.00517 7.3814 0.0719 0.0359
MORT7 0.1075 0 0.3200 0.0228 140.3 0.1509 0.0754
ABW14 503.9 480.4 524.4 426.5 4.0985 20.6525 10.3263
ADG14 35.9925 34.3100 37.4600 2.1854 4.1073 1.4783 0.7392
FC14 625.5 602.0 659.0 663.0 4.1165 25.7488 12.8744
TFCR14 1.2440 1.1490 1.3370 0.00628 6.3683 0.0792 0.0396
AFCR14 1.2478 1.1520 1.3450 0.00659 6.5075 0.0812 0.0406
MORT14 0.4775 0.3200 0.8500 0.0639 52.9357 0.2528 0.1264
ABW21 974.7 928.0 1009.9 1184.8 3.5314 34.4215 17.2107
ADG21 46.4150 44.1900 48.0900 2.6844 3.5299 1.6384 0.8192
FC21 1344.5 1297.0 1412.0 3225.7 4.2242 56.7950 28.3975
TFCR21 1.3800 1.2840 1.4480 0.00475 4.9967 0.0690 0.0345
AFCR21 1.3898 1.2930 1.4590 0.00487 5.0229 0.0698 0.0349
MORT21 1.5350 1.2700 1.9000 0.0768 18.0579 0.2772 0.1386
ABW28 1614.9 1507.4 1718.4 8298.9 5.6413 91.0981 45.5490
ADG28 59.8075 55.8300 63.6400 11.3701 5.6380 3.3720 1.6860
FC28 2331.8 2269.0 2367.0 1940.9 1.8894 44.0558 22.0279
TFCR28 1.4468 1.3580 1.5050 0.00478 4.7766 0.0691 0.0346
AFCR28 1.4538 1.3650 1.5150 0.00499 4.8593 0.0706 0.0353
MORT28 1.8250 1.5900 2.0100 0.0319 9.7866 0.1786 0.0893
ABW32 1953.8 1857.1 2050.6 6505.7 4.1283 80.6580 40.3290
ADG32 65.1250 61.9000 68.3500 7.2286 4.1284 2.6886 1.3443
FC32 3137.0 3025.0 3187.0 5709.3 2.4087 75.5601 37.7801
TFCR32 1.6065 1.5540 1.6330 0.00133 2.2664 0.0364 0.0182
AFCR32 1.6243 1.5690 1.6590 0.00159 2.4582 0.0399 0.0200
MORT32 2.7225 2.4300 3.4900 0.2645 18.8903 0.5143 0.2571
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ




--------------------------------------------- trmt=2 ---------------------------------------------


Coeff of Std
Variable Mean Minimum Maximum Variance Variation Std Dev Error
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ABW0 46.4350 45.7100 47.2000 0.5686 1.6238 0.7540 0.3770
ABW7 191.4 183.3 197.8 38.6432 3.2485 6.2164 3.1082
ADG7 27.3375 26.1800 28.2600 0.7899 3.2511 0.8888 0.4444
FC7 185.3 175.0 195.0 66.9167 4.4158 8.1803 4.0901
TFCR7 0.9678 0.9000 1.0080 0.00220 4.8470 0.0469 0.0235
AFCR7 0.9698 0.9030 1.0090 0.00213 4.7579 0.0461 0.0231
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

Specialty Protein 15:10 Thursday, April 26, 2016 76


--------------------------------------------- trmt=2 ---------------------------------------------


The MEANS Procedure


Coeff of Std
Variable Mean Minimum Maximum Variance Variation Std Dev Error
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
MORT7 0.0825 0 0.1100 0.00303 66.6667 0.0550 0.0275
ABW14 518.4 476.8 542.3 843.1 5.6010 29.0357 14.5179
ADG14 37.0325 34.0600 38.7400 4.3042 5.6023 2.0747 1.0373
FC14 633.5 617.0 653.0 315.0 2.8016 17.7482 8.8741
TFCR14 1.2248 1.1380 1.3010 0.00448 5.4660 0.0669 0.0335
AFCR14 1.2278 1.1450 1.3010 0.00410 5.2151 0.0640 0.0320
MORT14 0.4750 0.1100 0.9500 0.1216 73.4231 0.3488 0.1744
ABW21 993.0 915.4 1033.8 2832.2 5.3596 53.2187 26.6094
ADG21 47.2850 43.5900 49.2300 6.4238 5.3601 2.5345 1.2673
FC21 1351.0 1307.0 1392.0 1911.3 3.2360 43.7188 21.8594
TFCR21 1.3630 1.2770 1.4280 0.00398 4.6313 0.0631 0.0316
AFCR21 1.3680 1.2820 1.4340 0.00401 4.6278 0.0633 0.0317
MORT21 0.9775 0.7400 1.1600 0.0324 18.4214 0.1801 0.0900
ABW28 1599.0 1431.4 1671.8 13002.2 7.1314 114.0 57.0136
ADG28 59.2200 53.0100 61.9200 17.8602 7.1363 4.2261 2.1131
FC28 2380.0 2246.0 2466.0 9901.3 4.1809 99.5054 49.7527
TFCR28 1.4915 1.4140 1.5690 0.00455 4.5204 0.0674 0.0337
AFCR28 1.4975 1.4180 1.5780 0.00475 4.6038 0.0689 0.0345
MORT28 1.2700 0.9500 1.4800 0.0529 18.1045 0.2299 0.1150
ABW32 1965.1 1766.6 2066.2 18239.9 6.8727 135.1 67.5276
ADG32 65.5025 58.8900 68.8700 20.2481 6.8696 4.4998 2.2499
FC32 3179.3 3006.0 3304.0 18188.9 4.2421 134.9 67.4331
TFCR32 1.6205 1.5710 1.7010 0.00355 3.6787 0.0596 0.0298
AFCR32 1.6425 1.6010 1.7250 0.00329 3.4941 0.0574 0.0287
MORT32 2.5675 1.4800 3.6000 0.7969 34.7688 0.8927 0.4463
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ




--------------------------------------------- trmt=3 ---------------------------------------------


Coeff of Std
Variable Mean Minimum Maximum Variance Variation Std Dev Error
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ABW0 46.8575 46.5000 47.4700 0.2138 0.9867 0.4623 0.2312
ABW7 195.9 193.5 201.1 12.3195 1.7913 3.5099 1.7550
ADG7 27.9925 27.6500 28.7300 0.2492 1.7834 0.4992 0.2496
FC7 186.3 177.0 194.0 48.9167 3.7552 6.9940 3.4970
TFCR7 0.9523 0.9150 0.9680 0.000633 2.6419 0.0252 0.0126
AFCR7 0.9535 0.9160 0.9700 0.000650 2.6732 0.0255 0.0127
MORT7 0.0275 0 0.1100 0.00303 200.0 0.0550 0.0275
ABW14 525.6 500.9 539.9 313.6 3.3690 17.7074 8.8537
ADG14 37.5425 35.7800 38.5600 1.5935 3.3624 1.2623 0.6312
FC14 626.8 607.0 653.0 370.9 3.0729 19.2592 9.6296
TFCR14 1.1938 1.1320 1.2400 0.00207 3.8134 0.0455 0.0228
AFCR14 1.1968 1.1350 1.2430 0.00211 3.8403 0.0460 0.0230
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

Specialty Protein 15:10 Thursday, April 26, 2016 77


--------------------------------------------- trmt=3 ---------------------------------------------


The MEANS Procedure


Coeff of Std
Variable Mean Minimum Maximum Variance Variation Std Dev Error
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
MORT14 0.4225 0 0.9500 0.1558 93.4112 0.3947 0.1973
ABW21 1001.4 933.1 1030.2 2130.3 4.6092 46.1548 23.0774
ADG21 47.6825 44.4300 49.0600 4.8410 4.6143 2.2002 1.1001
FC21 1332.3 1268.0 1402.0 3664.3 4.5437 60.5330 30.2665
TFCR21 1.3320 1.2310 1.3910 0.00492 5.2667 0.0702 0.0351
AFCR21 1.3390 1.2390 1.4010 0.00495 5.2551 0.0704 0.0352
MORT21 1.1650 0.4200 1.4800 0.2489 42.8239 0.4989 0.2494
ABW28 1638.5 1476.6 1739.6 12760.2 6.8944 113.0 56.4805
ADG28 60.6850 54.6900 64.4300 17.5042 6.8943 4.1838 2.0919
FC28 2339.3 2235.0 2453.0 9044.3 4.0655 95.1013 47.5506
TFCR28 1.4313 1.3190 1.5130 0.00689 5.7999 0.0830 0.0415
AFCR28 1.4385 1.3260 1.5220 0.00704 5.8310 0.0839 0.0419
MORT28 1.4025 0.7400 1.6900 0.1973 31.6703 0.4442 0.2221
ABW32 2017.4 1908.3 2122.4 8463.2 4.5600 91.9954 45.9977
ADG32 67.2500 63.6100 70.7500 9.4157 4.5628 3.0685 1.5343
FC32 3135.5 2970.0 3238.0 13509.7 3.7069 116.2 58.1155
TFCR32 1.5553 1.4840 1.6050 0.00266 3.3168 0.0516 0.0258
AFCR32 1.5710 1.5110 1.6140 0.00192 2.7926 0.0439 0.0219
MORT32 2.2475 1.1600 3.4900 0.9145 42.5491 0.9563 0.4781
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ




--------------------------------------------- trmt=4 ---------------------------------------------


Coeff of Std
Variable Mean Minimum Maximum Variance Variation Std Dev Error
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ABW0 46.6800 46.4600 46.9000 0.0589 0.5201 0.2428 0.1214
ABW7 192.4 185.0 196.7 26.3952 2.6700 5.1376 2.5688
ADG7 27.4875 26.4200 28.1000 0.5398 2.6730 0.7347 0.3674
FC7 184.8 179.0 193.0 36.2500 3.2589 6.0208 3.0104
TFCR7 0.9608 0.9100 1.0000 0.00183 4.4497 0.0428 0.0214
AFCR7 0.9635 0.9100 1.0050 0.00199 4.6249 0.0446 0.0223
MORT7 0.0800 0 0.2100 0.0102 126.2 0.1010 0.0505
ABW14 510.5 472.8 541.9 829.9 5.6436 28.8079 14.4040
ADG14 36.4625 33.7700 38.7100 4.2426 5.6490 2.0598 1.0299
FC14 623.5 610.0 638.0 173.7 2.1136 13.1783 6.5891
TFCR14 1.2238 1.1350 1.2890 0.00442 5.4308 0.0665 0.0332
AFCR14 1.2273 1.1370 1.2930 0.00451 5.4719 0.0672 0.0336
MORT14 0.4750 0.1100 0.9500 0.1216 73.4231 0.3488 0.1744
ABW21 975.4 909.0 1026.6 2462.1 5.0873 49.6191 24.8095
ADG21 46.4450 43.2800 48.8800 5.5846 5.0881 2.3632 1.1816
FC21 1315.0 1260.0 1368.0 3012.0 4.1735 54.8817 27.4408
TFCR21 1.3508 1.2280 1.4040 0.00683 6.1197 0.0827 0.0413
AFCR21 1.3583 1.2320 1.4110 0.00722 6.2566 0.0850 0.0425
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

Specialty Protein 15:10 Thursday, April 26, 2016 78


--------------------------------------------- trmt=4 ---------------------------------------------


The MEANS Procedure


Coeff of Std
Variable Mean Minimum Maximum Variance Variation Std Dev Error
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
MORT21 1.3225 0.8500 1.8000 0.2417 37.1736 0.4916 0.2458
ABW28 1588.4 1463.4 1653.6 7696.2 5.5232 87.7280 43.8640
ADG28 58.8275 54.2000 61.2400 10.5557 5.5228 3.2490 1.6245
FC28 2313.0 2200.0 2400.0 9622.7 4.2410 98.0952 49.0476
TFCR28 1.4580 1.3680 1.5080 0.00422 4.4538 0.0649 0.0325
AFCR28 1.4660 1.3740 1.5170 0.00440 4.5258 0.0663 0.0332
MORT28 1.4825 0.8500 2.0100 0.2748 35.3574 0.5242 0.2621
ABW32 1922.6 1755.3 2050.4 15291.8 6.4318 123.7 61.8299
ADG32 64.0875 58.5100 68.3500 17.0000 6.4336 4.1231 2.0616
FC32 3093.3 2918.0 3239.0 19336.3 4.4954 139.1 69.5274
TFCR32 1.6118 1.4900 1.6840 0.00752 5.3814 0.0867 0.0434
AFCR32 1.6315 1.5160 1.7000 0.00676 5.0406 0.0822 0.0411
MORT32 2.5125 1.9000 3.0700 0.2292 19.0529 0.4787 0.2394
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ




--------------------------------------------- trmt=5 ---------------------------------------------


Coeff of Std
Variable Mean Minimum Maximum Variance Variation Std Dev Error
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ABW0 46.9575 46.1200 47.7200 0.5079 1.5177 0.7127 0.3563
ABW7 196.4 192.6 203.4 24.2873 2.5099 4.9282 2.4641
ADG7 28.0500 27.5100 29.0600 0.4922 2.5011 0.7016 0.3508
FC7 185.3 172.0 198.0 140.9 6.4080 11.8708 5.9354
TFCR7 0.9443 0.8900 0.9810 0.00178 4.4634 0.0421 0.0211
AFCR7 0.9468 0.8910 0.9840 0.00188 4.5776 0.0433 0.0217
MORT7 0.0275 0 0.1100 0.00302 200.0 0.0550 0.0275
ABW14 521.8 490.9 540.3 483.6 4.2145 21.9911 10.9955
ADG14 37.2700 35.0600 38.5900 2.4729 4.2193 1.5725 0.7863
FC14 628.5 604.0 651.0 623.0 3.9714 24.9600 12.4800
TFCR14 1.2058 1.1190 1.2470 0.00354 4.9361 0.0595 0.0298
AFCR14 1.2090 1.1210 1.2490 0.00359 4.9591 0.0600 0.0300
MORT14 0.3700 0.2100 0.6300 0.0327 48.8983 0.1809 0.0905
ABW21 999.2 914.4 1029.6 3207.7 5.6680 56.6364 28.3182
ADG21 47.5825 43.5400 49.0300 7.2830 5.6716 2.6987 1.3494
FC21 1332.8 1250.0 1408.0 5440.9 5.5346 73.7626 36.8813
TFCR21 1.3345 1.2560 1.3680 0.00282 3.9791 0.0531 0.0266
AFCR21 1.3405 1.2600 1.3730 0.00293 4.0405 0.0542 0.0271
MORT21 0.9800 0.7400 1.4800 0.1138 34.4227 0.3373 0.1687
ABW28 1607.6 1453.6 1670.6 10663.7 6.4236 103.3 51.6326
ADG28 59.5400 53.8400 61.8700 14.6073 6.4191 3.8219 1.9110
FC28 2346.0 2215.0 2455.0 9874.0 4.2356 99.3680 49.6840
TFCR28 1.4610 1.4100 1.5230 0.00229 3.2754 0.0479 0.0239
AFCR28 1.4675 1.4140 1.5290 0.00233 3.2890 0.0483 0.0241
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

Specialty Protein 15:10 Thursday, April 26, 2016 79


--------------------------------------------- trmt=5 ---------------------------------------------


The MEANS Procedure


Coeff of Std
Variable Mean Minimum Maximum Variance Variation Std Dev Error
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
MORT28 1.2150 0.9500 1.8000 0.1619 33.1167 0.4024 0.2012
ABW32 1992.3 1876.2 2079.4 7288.0 4.2851 85.3700 42.6850
ADG32 66.4075 62.5400 69.3100 8.0903 4.2832 2.8443 1.4222
FC32 3128.8 2941.0 3251.0 17520.3 4.2306 132.4 66.1820
TFCR32 1.5708 1.5260 1.6310 0.00193 2.7956 0.0439 0.0220
AFCR32 1.5885 1.5490 1.6500 0.00187 2.7220 0.0432 0.0216
MORT32 2.2475 1.6900 2.7500 0.1903 19.4093 0.4362 0.2181
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ




--------------------------------------------- trmt=6 ---------------------------------------------


Coeff of Std
Variable Mean Minimum Maximum Variance Variation Std Dev Error
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ABW0 46.8525 46.3100 47.3700 0.3379 1.2407 0.5813 0.2906
ABW7 194.8 190.1 200.7 20.8571 2.3442 4.5670 2.2835
ADG7 27.8300 27.1500 28.6700 0.4259 2.3449 0.6526 0.3263
FC7 181.3 176.0 188.0 38.2500 3.4122 6.1847 3.0923
TFCR7 0.9308 0.9160 0.9620 0.000445 2.2662 0.0211 0.0105
AFCR7 0.9328 0.9170 0.9630 0.000427 2.2152 0.0207 0.0103
MORT7 0.0550 0 0.1100 0.00403 115.5 0.0635 0.0318
ABW14 521.6 490.2 538.7 491.8 4.2515 22.1761 11.0880
ADG14 37.2575 35.0200 38.4800 2.5020 4.2455 1.5818 0.7909
FC14 618.3 591.0 636.0 463.6 3.4826 21.5310 10.7655
TFCR14 1.1863 1.1350 1.2200 0.00137 3.1235 0.0371 0.0185
AFCR14 1.1895 1.1390 1.2240 0.00136 3.1037 0.0369 0.0185
MORT14 0.4750 0.2100 0.7400 0.0628 52.7717 0.2507 0.1253
ABW21 1001.4 932.8 1033.1 2139.0 4.6187 46.2494 23.1247
ADG21 47.6850 44.4200 49.2000 4.8530 4.6198 2.2029 1.1015
FC21 1317.5 1217.0 1376.0 5139.0 5.4411 71.6868 35.8434
TFCR21 1.3158 1.2740 1.3440 0.00108 2.4995 0.0329 0.0164
AFCR21 1.3223 1.2800 1.3510 0.00114 2.5553 0.0338 0.0169
MORT21 1.1925 0.8500 1.3800 0.0629 21.0299 0.2508 0.1254
ABW28 1619.9 1501.8 1704.2 7832.7 5.4635 88.5024 44.2512
ADG28 59.9975 55.6200 63.1200 10.7588 5.4670 3.2801 1.6400
FC28 2307.8 2127.0 2394.0 15180.9 5.3390 123.2 61.6054
TFCR28 1.4253 1.3690 1.4800 0.00212 3.2313 0.0461 0.0230
AFCR28 1.4310 1.3750 1.4860 0.00214 3.2342 0.0463 0.0231
MORT28 1.2425 0.8500 1.4800 0.0912 24.3086 0.3020 0.1510
ABW32 1978.5 1802.2 2040.5 13830.9 5.9443 117.6 58.8024
ADG32 65.9500 60.0700 68.0200 15.3829 5.9471 3.9221 1.9610
FC32 3087.8 2842.0 3214.0 27984.3 5.4177 167.3 83.6425
TFCR32 1.5613 1.5350 1.5820 0.000491 1.4192 0.0222 0.0111
AFCR32 1.5815 1.5650 1.5930 0.000150 0.7736 0.0122 0.00612
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

Specialty Protein 15:10 Thursday, April 26, 2016 80


--------------------------------------------- trmt=6 ---------------------------------------------


The MEANS Procedure


Coeff of Std
Variable Mean Minimum Maximum Variance Variation Std Dev Error
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
MORT32 2.5375 1.4800 4.7600 2.2475 59.0803 1.4992 0.7496
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

Specialty Protein 15:10 Thursday, April 26, 2016 81


The GLM Procedure


Class Level Information


Class Levels Values


trmt 6 1 2 3 4 5 6


rep 4 1 3 4 6




Number of Observations Read 24
Number of Observations Used 24

Specialty Protein 15:10 Thursday, April 26, 2016 82


The GLM Procedure


Dependent Variable: ABW0


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 5.10996667 0.63874583 11.19 <.0001


Error 15 0.85656667 0.05710444


Corrected Total 23 5.96653333




R-Square Coeff Var Root MSE ABW0 Mean


0.856438 0.511119 0.238965 46.75333




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.67733333 0.13546667 2.37 0.0894
rep 3 4.43263333 1.47754444 25.87 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 83


The GLM Procedure


Dependent Variable: ABW7


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 443.3690667 55.4211333 5.95 0.0015


Error 15 139.7119333 9.3141289


Corrected Total 23 583.0810000




R-Square Coeff Var Root MSE ABW7 Mean


0.760390 1.580439 3.051906 193.1050




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 215.2238000 43.0447600 4.62 0.0094
rep 3 228.1452667 76.0484222 8.16 0.0019

Specialty Protein 15:10 Thursday, April 26, 2016 84


The GLM Procedure


Dependent Variable: ADG7


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 9.04371667 1.13046458 5.96 0.0015


Error 15 2.84724583 0.18981639


Corrected Total 23 11.89096250




R-Square Coeff Var Root MSE ADG7 Mean


0.760554 1.579335 0.435679 27.58625




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 4.39313750 0.87862750 4.63 0.0094
rep 3 4.65057917 1.55019306 8.17 0.0019

Specialty Protein 15:10 Thursday, April 26, 2016 85


The GLM Procedure


Dependent Variable: FC7


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 1180.666667 147.583333 5.23 0.0029


Error 15 423.291667 28.219444


Corrected Total 23 1603.958333




R-Square Coeff Var Root MSE FC7 Mean


0.736096 2.883799 5.312198 184.2083




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 73.208333 14.641667 0.52 0.7583
rep 3 1107.458333 369.152778 13.08 0.0002

Specialty Protein 15:10 Thursday, April 26, 2016 86


The GLM Procedure


Dependent Variable: TFCR7


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.02575017 0.00321877 3.36 0.0207


Error 15 0.01438567 0.00095904


Corrected Total 23 0.04013583




R-Square Coeff Var Root MSE TFCR7 Mean


0.641575 3.244751 0.030968 0.954417




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.00461133 0.00092227 0.96 0.4714
rep 3 0.02113883 0.00704628 7.35 0.0030

Specialty Protein 15:10 Thursday, April 26, 2016 87


The GLM Procedure


Dependent Variable: AFCR7


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.02672167 0.00334021 3.40 0.0198


Error 15 0.01474567 0.00098304


Corrected Total 23 0.04146733




R-Square Coeff Var Root MSE AFCR7 Mean


0.644403 3.277373 0.031354 0.956667




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.00476033 0.00095207 0.97 0.4677
rep 3 0.02196133 0.00732044 7.45 0.0028

Specialty Protein 15:10 Thursday, April 26, 2016 88


The GLM Procedure


Dependent Variable: T7


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.02417461 0.00302183 1.10 0.4139


Error 15 0.04113777 0.00274252


Corrected Total 23 0.06531238




R-Square Coeff Var Root MSE T7 Mean


0.370138 6.994289 0.052369 0.748740




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.00839776 0.00167955 0.61 0.6921
rep 3 0.01577685 0.00525895 1.92 0.1701

Specialty Protein 15:10 Thursday, April 26, 2016 89


The GLM Procedure


Dependent Variable: ABW14


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 10245.31463 1280.66433 15.26 <.0001


Error 15 1258.75906 83.91727


Corrected Total 23 11504.07370




R-Square Coeff Var Root MSE ABW14 Mean


0.890581 1.772022 9.160637 516.9596




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 1338.767021 267.753404 3.19 0.0369
rep 3 8906.547612 2968.849204 35.38 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 90


The GLM Procedure


Dependent Variable: ADG14


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 52.29686667 6.53710833 15.25 <.0001


Error 15 6.42869583 0.42857972


Corrected Total 23 58.72556250




R-Square Coeff Var Root MSE ADG14 Mean


0.890530 1.772885 0.654660 36.92625




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 6.82358750 1.36471750 3.18 0.0372
rep 3 45.47327917 15.15775972 35.37 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 91


The GLM Procedure


Dependent Variable: FC14


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 7232.166667 904.020833 12.17 <.0001


Error 15 1113.833333 74.255556


Corrected Total 23 8346.000000




R-Square Coeff Var Root MSE FC14 Mean


0.866543 1.376544 8.617166 626.0000




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 518.500000 103.700000 1.40 0.2810
rep 3 6713.666667 2237.888889 30.14 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 92


The GLM Procedure


Dependent Variable: TFCR14


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.06241867 0.00780233 8.68 0.0002


Error 15 0.01348029 0.00089869


Corrected Total 23 0.07589896




R-Square Coeff Var Root MSE TFCR14 Mean


0.822392 2.471316 0.029978 1.213042




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.00941321 0.00188264 2.09 0.1227
rep 3 0.05300546 0.01766849 19.66 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 93


The GLM Procedure


Dependent Variable: AFCR14


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.06230833 0.00778854 8.30 0.0003


Error 15 0.01408300 0.00093887


Corrected Total 23 0.07639133




R-Square Coeff Var Root MSE AFCR14 Mean


0.815647 2.519123 0.030641 1.216333




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.00957533 0.00191507 2.04 0.1308
rep 3 0.05273300 0.01757767 18.72 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 94


The GLM Procedure


Dependent Variable: T14


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.12783130 0.01597891 0.77 0.6308


Error 15 0.30938619 0.02062575


Corrected Total 23 0.43721749




R-Square Coeff Var Root MSE T14 Mean


0.292375 14.88476 0.143617 0.964857




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.01019303 0.00203861 0.10 0.9909
rep 3 0.11763828 0.03921276 1.90 0.1728

Specialty Protein 15:10 Thursday, April 26, 2016 95


The GLM Procedure


Dependent Variable: ABW21


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 42620.02347 5327.50293 32.86 <.0001


Error 15 2431.75147 162.11676


Corrected Total 23 45051.77493




R-Square Coeff Var Root MSE ABW21 Mean


0.946023 1.285030 12.73251 990.8333




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 3183.51893 636.70379 3.93 0.0178
rep 3 39436.50453 13145.50151 81.09 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 96


The GLM Procedure


Dependent Variable: ADG21


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 96.7276500 12.0909563 32.94 <.0001


Error 15 5.5056000 0.3670400


Corrected Total 23 102.2332500




R-Square Coeff Var Root MSE ADG21 Mean


0.946147 1.284032 0.605838 47.18250




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 7.22390000 1.44478000 3.94 0.0176
rep 3 89.50375000 29.83458333 81.28 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 97


The GLM Procedure


Dependent Variable: FC21


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 62368.83333 7796.10417 13.17 <.0001


Error 15 8878.50000 591.90000


Corrected Total 23 71247.33333




R-Square Coeff Var Root MSE FC21 Mean


0.875385 1.826273 24.32900 1332.167




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 4067.83333 813.56667 1.37 0.2886
rep 3 58301.00000 19433.66667 32.83 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 98


The GLM Procedure


Dependent Variable: TFCR21


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.07302083 0.00912760 12.44 <.0001


Error 15 0.01100717 0.00073381


Corrected Total 23 0.08402800




R-Square Coeff Var Root MSE TFCR21 Mean


0.869006 2.012552 0.027089 1.346000




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.01084350 0.00216870 2.96 0.0472
rep 3 0.06217733 0.02072578 28.24 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 99


The GLM Procedure


Dependent Variable: AFCR21


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.07539517 0.00942440 12.19 <.0001


Error 15 0.01159579 0.00077305


Corrected Total 23 0.08699096




R-Square Coeff Var Root MSE AFCR21 Mean


0.866701 2.055039 0.027804 1.352958




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.01160371 0.00232074 3.00 0.0449
rep 3 0.06379146 0.02126382 27.51 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 100


The GLM Procedure


Dependent Variable: T21


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.23113490 0.02889186 1.65 0.1926


Error 15 0.26302069 0.01753471


Corrected Total 23 0.49415559




R-Square Coeff Var Root MSE T21 Mean


0.467737 10.23209 0.132419 1.294151




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.13082902 0.02616580 1.49 0.2505
rep 3 0.10030588 0.03343529 1.91 0.1719

Specialty Protein 15:10 Thursday, April 26, 2016 101


The GLM Procedure


Dependent Variable: ABW28


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 173139.5467 21642.4433 23.72 <.0001


Error 15 13688.2333 912.5489


Corrected Total 23 186827.7800




R-Square Coeff Var Root MSE ABW28 Mean


0.926733 1.874728 30.20842 1611.350




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 6066.3400 1213.2680 1.33 0.3046
rep 3 167073.2067 55691.0689 61.03 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 102


The GLM Procedure


Dependent Variable: ADG28


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 237.5189500 29.6898688 23.70 <.0001


Error 15 18.7899458 1.2526631


Corrected Total 23 256.3088958




R-Square Coeff Var Root MSE ADG28 Mean


0.926690 1.875389 1.119224 59.67958




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 8.3401708 1.6680342 1.33 0.3038
rep 3 229.1787792 76.3929264 60.98 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 103


The GLM Procedure


Dependent Variable: FC28


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 157673.8333 19709.2292 13.09 <.0001


Error 15 22583.1250 1505.5417


Corrected Total 23 180256.9583




R-Square Coeff Var Root MSE FC28 Mean


0.874717 1.660808 38.80131 2336.292




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 13564.7083 2712.9417 1.80 0.1730
rep 3 144109.1250 48036.3750 31.91 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 104


The GLM Procedure


Dependent Variable: TFCR28


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.06924350 0.00865544 7.78 0.0004


Error 15 0.01667746 0.00111183


Corrected Total 23 0.08592096




R-Square Coeff Var Root MSE TFCR28 Mean


0.805898 2.295966 0.033344 1.452292




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.01140171 0.00228034 2.05 0.1291
rep 3 0.05784179 0.01928060 17.34 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 105


The GLM Procedure


Dependent Variable: AFCR28


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.07120667 0.00890083 7.81 0.0004


Error 15 0.01709229 0.00113949


Corrected Total 23 0.08829896




R-Square Coeff Var Root MSE AFCR28 Mean


0.806427 2.313592 0.033756 1.459042




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.01134121 0.00226824 1.99 0.1386
rep 3 0.05986546 0.01995515 17.51 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 106


The GLM Procedure


Dependent Variable: T28


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.20296168 0.02537021 1.41 0.2695


Error 15 0.26987975 0.01799198


Corrected Total 23 0.47284143




R-Square Coeff Var Root MSE T28 Mean


0.429238 9.765749 0.134134 1.373517




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.13407080 0.02681416 1.49 0.2510
rep 3 0.06889088 0.02296363 1.28 0.3183

Specialty Protein 15:10 Thursday, April 26, 2016 107


The GLM Procedure


Dependent Variable: ABW32


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 201684.8123 25210.6015 13.27 <.0001


Error 15 28504.3115 1900.2874


Corrected Total 23 230189.1238




R-Square Coeff Var Root MSE ABW32 Mean


0.876170 2.211002 43.59229 1971.608




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 21330.6780 4266.1356 2.24 0.1032
rep 3 180354.1342 60118.0447 31.64 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 108


The GLM Procedure


Dependent Variable: ADG32


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 224.1500833 28.0187604 13.27 <.0001


Error 15 31.6780125 2.1118675


Corrected Total 23 255.8280958




R-Square Coeff Var Root MSE ADG32 Mean


0.876175 2.211225 1.453227 65.72042




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 23.7313708 4.7462742 2.25 0.1030
rep 3 200.4187125 66.8062375 31.63 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 109


The GLM Procedure


Dependent Variable: FC32


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 295692.3333 36961.5417 16.60 <.0001


Error 15 33393.5000 2226.2333


Corrected Total 23 329085.8333




R-Square Coeff Var Root MSE FC32 Mean


0.898526 1.508930 47.18298 3126.917




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 22339.8333 4467.9667 2.01 0.1359
rep 3 273352.5000 91117.5000 40.93 <.0001

Specialty Protein 15:10 Thursday, April 26, 2016 110


The GLM Procedure


Dependent Variable: TFCR32


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.05092767 0.00636596 5.39 0.0025


Error 15 0.01770967 0.00118064


Corrected Total 23 0.06863733




R-Square Coeff Var Root MSE TFCR32 Mean


0.741982 2.164214 0.034361 1.587667




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.01619033 0.00323807 2.74 0.0593
rep 3 0.03473733 0.01157911 9.81 0.0008

Specialty Protein 15:10 Thursday, April 26, 2016 111


The GLM Procedure


Dependent Variable: AFCR32


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.04322767 0.00540346 3.80 0.0125


Error 15 0.02133829 0.00142255


Corrected Total 23 0.06456596




R-Square Coeff Var Root MSE AFCR32 Mean


0.669512 2.347698 0.037717 1.606542




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.01778121 0.00355624 2.50 0.0774
rep 3 0.02544646 0.00848215 5.96 0.0069

Specialty Protein 15:10 Thursday, April 26, 2016 112


The GLM Procedure


Dependent Variable: T32


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.61500133 0.07687517 2.10 0.1021


Error 15 0.54815617 0.03654374


Corrected Total 23 1.16315750




R-Square Coeff Var Root MSE T32 Mean


0.528734 11.17932 0.191164 1.709981




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.06428125 0.01285625 0.35 0.8732
rep 3 0.55072008 0.18357336 5.02 0.0132

Specialty Protein 15:10 Thursday, April 26, 2016 113


The GLM Procedure


Duncan's Multiple Range Test for ABW0


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.057104




Number of Means 2 3 4 5 6
Critical Range .3602 .3775 .3883 .3957 .4010




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 46.9575 4 5
A
A 46.8575 4 3
A
A 46.8525 4 6
A
B A 46.7375 4 1
B A
B A 46.6800 4 4
B
B 46.4350 4 2

Specialty Protein 15:10 Thursday, April 26, 2016 114


The GLM Procedure


Duncan's Multiple Range Test for ABW7


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 9.314129




Number of Means 2 3 4 5 6
Critical Range 4.600 4.822 4.960 5.054 5.121




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 196.350 4 5
A
A 195.940 4 3
A
A 194.820 4 6
A
B A 192.420 4 4
B A
B A 191.360 4 2
B
B 187.740 4 1

Specialty Protein 15:10 Thursday, April 26, 2016 115


The GLM Procedure


Duncan's Multiple Range Test for ADG7


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.189816




Number of Means 2 3 4 5 6
Critical Range .6566 .6883 .7080 .7215 .7311




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 28.0500 4 5
A
A 27.9925 4 3
A
A 27.8300 4 6
A
B A 27.4875 4 4
B A
B A 27.3375 4 2
B
B 26.8200 4 1

Specialty Protein 15:10 Thursday, April 26, 2016 116


The GLM Procedure


Duncan's Multiple Range Test for FC7


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 28.21944




Number of Means 2 3 4 5 6
Critical Range 8.006 8.393 8.633 8.797 8.914




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 186.250 4 3
A
A 185.250 4 2
A
A 185.250 4 5
A
A 184.750 4 4
A
A 182.500 4 1
A
A 181.250 4 6

Specialty Protein 15:10 Thursday, April 26, 2016 117


The GLM Procedure


Duncan's Multiple Range Test for TFCR7


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.000959




Number of Means 2 3 4 5 6
Critical Range .04667 .04893 .05033 .05128 .05197




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 0.97075 4 1
A
A 0.96775 4 2
A
A 0.96075 4 4
A
A 0.95225 4 3
A
A 0.94425 4 5
A
A 0.93075 4 6

Specialty Protein 15:10 Thursday, April 26, 2016 118


The GLM Procedure


Duncan's Multiple Range Test for AFCR7


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.000983




Number of Means 2 3 4 5 6
Critical Range .04725 .04954 .05095 .05192 .05261




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 0.97375 4 1
A
A 0.96975 4 2
A
A 0.96350 4 4
A
A 0.95350 4 3
A
A 0.94675 4 5
A
A 0.93275 4 6

Specialty Protein 15:10 Thursday, April 26, 2016 119


The GLM Procedure


Duncan's Multiple Range Test for T7


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.002743




Number of Means 2 3 4 5 6
Critical Range .07893 .08274 .08511 .08672 .08788




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 0.77519 4 1
A
A 0.76255 4 2
A
A 0.75946 4 4
A
A 0.74407 4 6
A
A 0.72559 4 3
A
A 0.72559 4 5

Specialty Protein 15:10 Thursday, April 26, 2016 120


The GLM Procedure


Duncan's Multiple Range Test for ABW14


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 83.91727




Number of Means 2 3 4 5 6
Critical Range 13.81 14.47 14.89 15.17 15.37




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 525.600 4 3
A
A 521.800 4 5
A
A 521.608 4 6
A
A 518.400 4 2
A
B A 510.450 4 4
B
B 503.900 4 1

Specialty Protein 15:10 Thursday, April 26, 2016 121


The GLM Procedure


Duncan's Multiple Range Test for ADG14


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.42858




Number of Means 2 3 4 5 6
Critical Range 0.987 1.034 1.064 1.084 1.099




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 37.5425 4 3
A
A 37.2700 4 5
A
A 37.2575 4 6
A
A 37.0325 4 2
A
B A 36.4625 4 4
B
B 35.9925 4 1

Specialty Protein 15:10 Thursday, April 26, 2016 122


The GLM Procedure


Duncan's Multiple Range Test for FC14


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 74.25556




Number of Means 2 3 4 5 6
Critical Range 12.99 13.61 14.00 14.27 14.46




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 633.500 4 2
A
B A 628.500 4 5
B A
B A 626.750 4 3
B A
B A 625.500 4 1
B A
B A 623.500 4 4
B
B 618.250 4 6

Specialty Protein 15:10 Thursday, April 26, 2016 123


The GLM Procedure


Duncan's Multiple Range Test for TFCR14


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.000899




Number of Means 2 3 4 5 6
Critical Range .04518 .04736 .04872 .04964 .05030




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 1.24400 4 1
A
B A 1.22475 4 2
B A
B A 1.22375 4 4
B A
B A 1.20575 4 5
B
B 1.19375 4 3
B
B 1.18625 4 6

Specialty Protein 15:10 Thursday, April 26, 2016 124


The GLM Procedure


Duncan's Multiple Range Test for AFCR14


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.000939




Number of Means 2 3 4 5 6
Critical Range .04618 .04841 .04980 .05074 .05142




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 1.24775 4 1
A
B A 1.22775 4 2
B A
B A 1.22725 4 4
B A
B A 1.20900 4 5
B
B 1.19675 4 3
B
B 1.18950 4 6

Specialty Protein 15:10 Thursday, April 26, 2016 125


The GLM Procedure


Duncan's Multiple Range Test for T14


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.020626




Number of Means 2 3 4 5 6
Critical Range .2165 .2269 .2334 .2378 .2410




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 0.9830 4 1
A
A 0.9812 4 6
A
A 0.9759 4 4
A
A 0.9759 4 2
A
A 0.9440 4 3
A
A 0.9292 4 5

Specialty Protein 15:10 Thursday, April 26, 2016 126


The GLM Procedure


Duncan's Multiple Range Test for ABW21


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 162.1168




Number of Means 2 3 4 5 6
Critical Range 19.19 20.12 20.69 21.08 21.37




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 1001.360 4 3
A
A 1001.360 4 6
A
A 999.240 4 5
A
B A 992.960 4 2
B
B 975.360 4 4
B
B 974.720 4 1

Specialty Protein 15:10 Thursday, April 26, 2016 127


The GLM Procedure


Duncan's Multiple Range Test for ADG21


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.36704




Number of Means 2 3 4 5 6
Critical Range 0.913 0.957 0.985 1.003 1.017




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 47.6850 4 6
A
A 47.6825 4 3
A
A 47.5825 4 5
A
B A 47.2850 4 2
B
B 46.4450 4 4
B
B 46.4150 4 1

Specialty Protein 15:10 Thursday, April 26, 2016 128


The GLM Procedure


Duncan's Multiple Range Test for FC21


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 591.9




Number of Means 2 3 4 5 6
Critical Range 36.67 38.44 39.54 40.29 40.82




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 1351.00 4 2
A
A 1344.50 4 1
A
A 1332.75 4 5
A
A 1332.25 4 3
A
A 1317.50 4 6
A
A 1315.00 4 4

Specialty Protein 15:10 Thursday, April 26, 2016 129


The GLM Procedure


Duncan's Multiple Range Test for TFCR21


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.000734




Number of Means 2 3 4 5 6
Critical Range .04083 .04280 .04402 .04486 .04546




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 1.38000 4 1
A
B A 1.36300 4 2
B A
B A C 1.35075 4 4
B C
B C 1.33450 4 5
B C
B C 1.33200 4 3
C
C 1.31575 4 6

Specialty Protein 15:10 Thursday, April 26, 2016 130


The GLM Procedure


Duncan's Multiple Range Test for AFCR21


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.000773




Number of Means 2 3 4 5 6
Critical Range .04190 .04393 .04518 .04604 .04666




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 1.38975 4 1
A
B A 1.36800 4 2
B A
B A 1.35825 4 4
B
B 1.34050 4 5
B
B 1.33900 4 3
B
B 1.32225 4 6

Specialty Protein 15:10 Thursday, April 26, 2016 131


The GLM Procedure


Duncan's Multiple Range Test for T21


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.017535




Number of Means 2 3 4 5 6
Critical Range .1996 .2092 .2152 .2193 .2222




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 1.42411 4 1
A
A 1.34062 4 4
A
A 1.29814 4 6
A
A 1.27714 4 3
A
A 1.21378 4 2
A
A 1.21112 4 5

Specialty Protein 15:10 Thursday, April 26, 2016 132


The GLM Procedure


Duncan's Multiple Range Test for ABW28


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 912.5489




Number of Means 2 3 4 5 6
Critical Range 45.53 47.73 49.09 50.02 50.69




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 1638.45 4 3
A
A 1619.90 4 6
A
A 1614.85 4 1
A
A 1607.60 4 5
A
A 1598.95 4 2
A
A 1588.35 4 4

Specialty Protein 15:10 Thursday, April 26, 2016 133


The GLM Procedure


Duncan's Multiple Range Test for ADG28


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 1.252663




Number of Means 2 3 4 5 6
Critical Range 1.687 1.768 1.819 1.853 1.878




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 60.6850 4 3
A
A 59.9975 4 6
A
A 59.8075 4 1
A
A 59.5400 4 5
A
A 59.2200 4 2
A
A 58.8275 4 4

Specialty Protein 15:10 Thursday, April 26, 2016 134


The GLM Procedure


Duncan's Multiple Range Test for FC28


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 1505.542




Number of Means 2 3 4 5 6
Critical Range 58.48 61.30 63.06 64.25 65.11




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 2380.00 4 2
A
B A 2346.00 4 5
B A
B A 2339.25 4 3
B A
B A 2331.75 4 1
B
B 2313.00 4 4
B
B 2307.75 4 6

Specialty Protein 15:10 Thursday, April 26, 2016 135


The GLM Procedure


Duncan's Multiple Range Test for TFCR28


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.001112




Number of Means 2 3 4 5 6
Critical Range .05026 .05268 .05419 .05522 .05595




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 1.49150 4 2
A
B A 1.46100 4 5
B A
B A 1.45800 4 4
B A
B A 1.44675 4 1
B
B 1.43125 4 3
B
B 1.42525 4 6

Specialty Protein 15:10 Thursday, April 26, 2016 136


The GLM Procedure


Duncan's Multiple Range Test for AFCR28


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.001139




Number of Means 2 3 4 5 6
Critical Range .05088 .05333 .05486 .05590 .05664




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 1.49750 4 2
A
B A 1.46750 4 5
B A
B A 1.46600 4 4
B A
B A 1.45375 4 1
B
B 1.43850 4 3
B
B 1.43100 4 6

Specialty Protein 15:10 Thursday, April 26, 2016 137


The GLM Procedure


Duncan's Multiple Range Test for T28


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.017992




Number of Means 2 3 4 5 6
Critical Range .2022 .2119 .2180 .2221 .2251




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 1.52394 4 1
A
A 1.39830 4 4
A
A 1.37120 4 3
A
A 1.32821 4 2
A
A 1.31614 4 6
A
A 1.30333 4 5

Specialty Protein 15:10 Thursday, April 26, 2016 138


The GLM Procedure


Duncan's Multiple Range Test for ABW32


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 1900.287




Number of Means 2 3 4 5 6
Critical Range 65.70 68.87 70.84 72.19 73.15




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 2017.43 4 3
A
B A 1992.25 4 5
B A
B A 1978.46 4 6
B A
B A 1965.10 4 2
B A
B A 1953.77 4 1
B
B 1922.63 4 4

Specialty Protein 15:10 Thursday, April 26, 2016 139


The GLM Procedure


Duncan's Multiple Range Test for ADG32


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 2.111868




Number of Means 2 3 4 5 6
Critical Range 2.190 2.296 2.362 2.406 2.439




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 67.250 4 3
A
B A 66.408 4 5
B A
B A 65.950 4 6
B A
B A 65.503 4 2
B A
B A 65.125 4 1
B
B 64.088 4 4

Specialty Protein 15:10 Thursday, April 26, 2016 140


The GLM Procedure


Duncan's Multiple Range Test for FC32


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 2226.233




Number of Means 2 3 4 5 6
Critical Range 71.11 74.55 76.68 78.13 79.17




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 3179.25 4 2
A
B A 3137.00 4 1
B A
B A 3135.50 4 3
B A
B A 3128.75 4 5
B
B 3093.25 4 4
B
B 3087.75 4 6

Specialty Protein 15:10 Thursday, April 26, 2016 141


The GLM Procedure


Duncan's Multiple Range Test for TFCR32


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.001181




Number of Means 2 3 4 5 6
Critical Range .05179 .05429 .05584 .05690 .05766




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 1.62050 4 2
A
B A 1.61175 4 4
B A
B A 1.60650 4 1
B A
B A 1.57075 4 5
B
B 1.56125 4 6
B
B 1.55525 4 3

Specialty Protein 15:10 Thursday, April 26, 2016 142


The GLM Procedure


Duncan's Multiple Range Test for AFCR32


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.001423




Number of Means 2 3 4 5 6
Critical Range .05685 .05959 .06129 .06246 .06329




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 1.64250 4 2
A
B A 1.63150 4 4
B A
B A 1.62425 4 1
B A
B A 1.58850 4 5
B A
B A 1.58150 4 6
B
B 1.57100 4 3

Specialty Protein 15:10 Thursday, April 26, 2016 143


The GLM Procedure


Duncan's Multiple Range Test for T32


NOTE: This test controls the Type I comparisonwise error rate, not the experimentwise error rate.




Alpha 0.05
Error Degrees of Freedom 15
Error Mean Square 0.036544




Number of Means 2 3 4 5 6
Critical Range .2881 .3020 .3107 .3166 .3208




Means with the same letter are not significantly different.




Duncan Grouping Mean N trmt


A 1.7911 4 1
A
A 1.7368 4 2
A
A 1.7314 4 4
A
A 1.7085 4 6
A
A 1.6535 4 5
A
A 1.6384

Thank you for the help
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

StephenCrump

MrExcel MVP
Joined
Sep 18, 2013
Messages
5,111
Office Version
  1. 365
Platform
  1. Windows
Welcome to the Forum!

Do you think you could narrow this down a bit ....

- Which specific calculation should we look at?

- How are you specifying this calculation in SAS?

- How are you calculating it in Excel?
 
Upvote 0

vitamins

New Member
Joined
Apr 26, 2016
Messages
5
Ok, I will simplify it. Sorry for having messy question.

Here is my data set:

DATA INPUT
SLY FARM ADAY 32
BlockRepTrmtCage #ALWADGFCTFCRAFCRMORT
11212027.3267.5833041.6301.6381.48
11622031.8267.7332141.5821.5931.90
11431922.7764.0932391.6841.7002.54
11141973.6565.7931771.6101.6222.43
11551992.9166.4332511.6311.6502.22
11361984.5566.1531851.6051.6141.16
336132039.3967.9831631.5511.5652.01
331141933.7564.4631591.6331.6593.49
334151962.0265.4031611.6111.6313.07
333162054.5568.4932381.5761.5892.22
332172066.2468.8732661.5801.6062.86
335182020.5167.3531511.5591.5742.33
446192040.4968.0231321.5351.5804.76
442202000.2166.6731411.5711.6013.60
445212079.4069.3131721.5261.5492.75
444222050.4168.3530551.4901.5162.54
441232050.5968.3531871.5541.5692.43
443242122.3770.7531491.4841.5113.49
666311802.1560.0728421.5771.5881.48
665321876.1962.5429411.5671.5811.69
663331908.2663.6129701.5561.5702.12
661341857.0961.9030251.6291.6472.54
664351755.3158.5129181.6621.6791.90
662361766.6458.8930061.7011.7252.33
AVERAGE11953.7765.1331371.6071.6242.72
21965.1065.5031791.6211.6422.57
32017.4367.2531361.5551.5712.25
41922.6364.0930931.6121.6322.51
51992.2566.4131291.5711.5882.25
6 1978.4665.9530881.5611.5822.54

<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>

And this is the syntax for the SAS program:

dm 'log;clear;output;clear';title "Specialty Protein";
data day0to33;
input block rep trmt cage ABW32 ADG32 FC32 TFCR32 AFCR32 MORT32;
T32=sqrt(mort32+0.5);
cards;
1 1 2 1 2027.32 67.58 3304 1.630 1.638 1.48
1 1 6 2 2031.82 67.73 3214 1.582 1.593 1.90
1 1 4 3 1922.77 64.09 3239 1.684 1.700 2.54
1 1 1 4 1973.65 65.79 3177 1.610 1.622 2.43
1 1 5 5 1992.91 66.43 3251 1.631 1.650 2.22
1 1 3 6 1984.55 66.15 3185 1.605 1.614 1.16
3 3 6 13 2039.39 67.98 3163 1.551 1.565 2.01
3 3 1 14 1933.75 64.46 3159 1.633 1.659 3.49
3 3 4 15 1962.02 65.40 3161 1.611 1.631 3.07
3 3 3 16 2054.55 68.49 3238 1.576 1.589 2.22
3 3 2 17 2066.24 68.87 3266 1.580 1.606 2.86
3 3 5 18 2020.51 67.35 3151 1.559 1.574 2.33
4 4 6 19 2040.49 68.02 3132 1.535 1.580 4.76
4 4 2 20 2000.21 66.67 3141 1.571 1.601 3.60
4 4 5 21 2079.40 69.31 3172 1.526 1.549 2.75
4 4 4 22 2050.41 68.35 3055 1.490 1.516 2.54
4 4 1 23 2050.59 68.35 3187 1.554 1.569 2.43
4 4 3 24 2122.37 70.75 3149 1.484 1.511 3.49
6 6 6 31 1802.15 60.07 2842 1.577 1.588 1.48
6 6 5 32 1876.19 62.54 2941 1.567 1.581 1.69
6 6 3 33 1908.26 63.61 2970 1.556 1.570 2.12
6 6 1 34 1857.09 61.90 3025 1.629 1.647 2.54
6 6 4 35 1755.31 58.51 2918 1.662 1.679 1.90
6 6 2 36 1766.64 58.89 3006 1.701 1.725 2.33
;
proc sort;
by trmt rep;
proc print;
proc means fw=8 mean min max var cv std stderr;
var ABW32 ADG32 FC32 TFCR32 AFCR32 MORT32;
by trmt;
proc glm;
class trmt rep;
model ABW32 ADG32 FC32 TFCR32 AFCR32 T32 = trmt rep/ss3;
means trmt/duncan;


run;

And this is the output of the SAS Program:

Specialty Protein 12:53 Thursday, April 27, 2016 21


The GLM Procedure


Dependent Variable: ABW32


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 201684.8123 25210.6015 13.27 <.0001


Error 15 28504.3115 1900.2874


Corrected Total 23 230189.1238




R-Square Coeff Var Root MSE ABW32 Mean


0.876170 2.211002 43.59229 1971.608




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 21330.6780 4266.1356 2.24 0.1032
rep 3 180354.1342 60118.0447 31.64 <.0001

Specialty Protein 12:53 Thursday, April 27, 2016 22


The GLM Procedure


Dependent Variable: ADG32


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 224.1500833 28.0187604 13.27 <.0001


Error 15 31.6780125 2.1118675


Corrected Total 23 255.8280958




R-Square Coeff Var Root MSE ADG32 Mean


0.876175 2.211225 1.453227 65.72042




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 23.7313708 4.7462742 2.25 0.1030
rep 3 200.4187125 66.8062375 31.63 <.0001

Specialty Protein 12:53 Thursday, April 27, 2016 23


The GLM Procedure


Dependent Variable: FC32


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 295692.3333 36961.5417 16.60 <.0001


Error 15 33393.5000 2226.2333


Corrected Total 23 329085.8333




R-Square Coeff Var Root MSE FC32 Mean


0.898526 1.508930 47.18298 3126.917




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 22339.8333 4467.9667 2.01 0.1359
rep 3 273352.5000 91117.5000 40.93 <.0001

Specialty Protein 12:53 Thursday, April 27, 2016 24


The GLM Procedure


Dependent Variable: TFCR32


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.05092767 0.00636596 5.39 0.0025


Error 15 0.01770967 0.00118064


Corrected Total 23 0.06863733




R-Square Coeff Var Root MSE TFCR32 Mean


0.741982 2.164214 0.034361 1.587667




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.01619033 0.00323807 2.74 0.0593
rep 3 0.03473733 0.01157911 9.81 0.0008

Specialty Protein 12:53 Thursday, April 27, 2016 25


The GLM Procedure


Dependent Variable: AFCR32


Sum of
Source DF Squares Mean Square F Value Pr > F


Model 8 0.04322767 0.00540346 3.80 0.0125


Error 15 0.02133829 0.00142255


Corrected Total 23 0.06456596




R-Square Coeff Var Root MSE AFCR32 Mean


0.669512 2.347698 0.037717 1.606542




Source DF Type III SS Mean Square F Value Pr > F


trmt 5 0.01778121 0.00355624 2.50 0.0774
rep 3 0.02544646 0.00848215 5.96 0.006

And I'm computing for the coefficient of variation of each parameters (ABW32, ADG32, FC32, AFCR32, TFCR32, T32).
The result of CV for SAS are highlighted above.
The formula I'm using for excel is st. dev. over mean multiply by 100%. The results are not the same with the SAS Program. Can you please help me to identify the factor that makes it different? Thank you very much for your help!
 
Upvote 0

StephenCrump

MrExcel MVP
Joined
Sep 18, 2013
Messages
5,111
Office Version
  1. 365
Platform
  1. Windows
The GLM Procedure

Dependent Variable: ABW32

R-Square Coeff Var Root MSE ABW32 Mean

0.876170 2.211002 43.59229 1971.608

I am guessing that you are using Excel to calculate 100* STDEV.S / AVERAGE for the ABW32 values (or ALW as you have labelled them above)?

I get 100 * 100.04 / 1971.6 = 5.07 as the CV of the raw sample data.

But in this context, where you are fitting a regression, SAS takes the coefficient of variation as RMSE / AVERAGE, where RMSE is the standard deviation of the differences between the values predicted by the regression model and the observed values.

100 * 43.59229 / 1971.608 = 2.211002
 
Upvote 0

vitamins

New Member
Joined
Apr 26, 2016
Messages
5
Whoah! You're good! Well, I didn't realize it fast. But thanks!!! How do we calculate for root mse in excel? I want to create an excel with function of SAS. Thank you very much again!
 
Upvote 0

StephenCrump

MrExcel MVP
Joined
Sep 18, 2013
Messages
5,111
Office Version
  1. 365
Platform
  1. Windows
RMSE is just the standard deviation of the "errors", i.e. the difference between the values predicted by the regression model and the actual sample values.

Software like SAS makes statistical analysis easier than building from scratch, e.g. using Excel. But in theory, if you know how SAS is calculating its regression model, you should be able to replicate it in Excel.

I have never used SAS myself, and I'm not totally clear what you're doing here. I'm guessing that the regression models that SAS is fitting aren't ends in themselves, but rather are just intermediate tools for data analysis?

If that's true, I'm wondering whether SAS makes the parameters of these regression models available to the user?
 
Upvote 0

vitamins

New Member
Joined
Apr 26, 2016
Messages
5
That's it, I'm having difficulty in determining how the SAS works out. Actually, it's just a tool for our analysis. We are commonly using the c.v., std. error and the p-value. I've been working this out for 2 weeks. I'm not goot at excel, if you can help me, it will be great. Thank you!
 
Upvote 0

vitamins

New Member
Joined
Apr 26, 2016
Messages
5
Hey Sir Stephen Crump, I also have another question. If I have these data:
ABCDE
1RangeRatePerformanceRate
21.90005.51.6067=WHAT FUNCTION?
31.80005.01.8402=WHAT FUNCTION?
41.70004.5
51.60004.0
61.50003.5
71.40003.0
81.30002.5
91.20002.0
101.10001.5

<tbody>
</tbody>

--> for cell E2 and E3, what function should i input to have the corresponding rate (A2:A10) based on range (A2:A10)? I have already used vlookup , =vlookup(D1,A2:B10,2,TRUE) but got #NA. I looked up in the internet for the problem and it says that probably that vlookup doesn't work well with atleast 3 decimals. I also used index match but got #NA also. Please help! THank you!
 
Upvote 0

StephenCrump

MrExcel MVP
Joined
Sep 18, 2013
Messages
5,111
Office Version
  1. 365
Platform
  1. Windows
If you can help me, it will be great. Thank you!

I'm not clear what help you're looking for? This is an Excel forum, so if you can define a problem, we can help you put it into Excel if that's what you want.

I for one have never used SAS, so unfortunately I can't help you there.
 
Upvote 0

StephenCrump

MrExcel MVP
Joined
Sep 18, 2013
Messages
5,111
Office Version
  1. 365
Platform
  1. Windows
for cell E2 and E3, what function should i input to have the corresponding rate (A2:A10) based on range (A2:A10)? I have already used vlookup , =vlookup(D1,A2:B10,2,TRUE) but got #NA.

Based on your screenshot, your formula needs to look up D2, not D1.

But if you're using VLOOKUP with approximate matches (i.e. the range_lookup argument = TRUE) your values in column A will need to be in ascending order.

What results do you want to see in cells E2 and E3?
 
Upvote 0

Forum statistics

Threads
1,186,540
Messages
5,958,382
Members
438,356
Latest member
Hnajibeddine

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top