SAS coefficient of variation vs. Excel coefficient of variation

vitamins · Apr 26, 2016

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 A		Day 0		DAY 7		DAY 14		DAY 21		DAY 28		DAY 30
Block	Rep	Trmt	Cage #		ALW		ALW	ADG	FC	TFCR	AFCR	MORT	ALW	ADG	FC	TFCR	AFCR	MORT	ALW	ADG	FC	TFCR	AFCR	MORT	ALW	ADG	FC	TFCR	AFCR	MORT	ALW	ADG	FC	TFCR	AFCR	MORT

1	1	2	1		47.20		190.24	27.18	186	0.979	0.981	0.11	521.30	37.24	644	1.235	1.237	0.42	1003.20	47.77	1385	1.381	1.384	0.74	1622.40	60.09	2466	1.520	1.524	0.95	2027.32	67.58	3304	1.630	1.638	1.48
1	1	6	2		47.37		195.76	27.97	188	0.962	0.963	0.00	521.80	37.27	636	1.220	1.224	0.63	1023.68	48.75	1376	1.344	1.351	1.38	1667.40	61.76	2394	1.436	1.443	1.48	2031.82	67.73	3214	1.582	1.593	1.90
1	1	4	3		46.90		193.84	27.69	182	0.941	0.944	0.21	519.20	37.09	631	1.215	1.220	0.95	993.92	47.33	1368	1.376	1.384	1.69	1645.00	60.93	2390	1.453	1.461	1.80	1922.77	64.09	3239	1.684	1.700	2.54
1	1	1	4		47.01		187.52	26.79	174	0.926	0.927	0.00	517.70	36.98	632	1.221	1.223	0.32	986.24	46.96	1371	1.390	1.397	1.27	1653.00	61.22	2357	1.426	1.429	1.59	1973.65	65.79	3177	1.610	1.622	2.43
1	1	5	5		47.72		195.88	27.98	192	0.981	0.984	0.11	521.80	37.27	651	1.247	1.249	0.32	1029.60	49.03	1408	1.368	1.373	0.85	1670.60	61.87	2455	1.469	1.476	0.95	1992.91	66.43	3251	1.631	1.650	2.22
1	1	3	6		47.47		195.04	27.86	187	0.959	0.959	0.00	524.80	37.49	626	1.193	1.193	0.00	1013.12	48.24	1361	1.343	1.346	0.42	1666.40	61.72	2375	1.425	1.430	0.74	1984.55	66.15	3185	1.605	1.614	1.16
3	3	6	13		47.34		200.72	28.67	185	0.921	0.923	0.11	535.70	38.26	635	1.185	1.187	0.21	1015.84	48.37	1361	1.340	1.348	1.16	1606.20	59.49	2377	1.480	1.486	1.16	2039.39	67.98	3163	1.551	1.565	2.01
3	3	1	14		46.94		187.68	26.81	198	1.053	1.059	0.32	493.10	35.22	659	1.337	1.345	0.85	974.72	46.42	1412	1.448	1.459	1.90	1580.60	58.54	2367	1.498	1.506	2.01	1933.75	64.46	3159	1.633	1.659	3.49
3	3	4	15		46.88		194.16	27.74	193	0.992	0.995	0.11	507.90	36.28	638	1.256	1.259	0.42	972.00	46.29	1356	1.395	1.406	1.80	1591.40	58.94	2400	1.508	1.517	2.01	1962.02	65.40	3161	1.611	1.631	3.07
3	3	3	16		46.96		201.12	28.73	194	0.967	0.969	0.00	539.90	38.56	653	1.210	1.216	0.95	1028.96	49.00	1402	1.363	1.370	1.48	1671.20	61.90	2453	1.468	1.476	1.59	2054.55	68.49	3238	1.576	1.589	2.22
3	3	2	17		46.96		197.84	28.26	195	0.984	0.986	0.11	533.20	38.09	653	1.225	1.228	0.42	1019.52	48.55	1392	1.366	1.372	1.06	1670.20	61.86	2444	1.463	1.470	1.27	2066.24	68.87	3266	1.580	1.606	2.86
3	3	5	18		47.34		203.44	29.06	198	0.974	0.978	0.00	534.20	38.16	649	1.215	1.221	0.63	1023.36	48.73	1380	1.348	1.357	1.48	1644.00	60.89	2370	1.442	1.451	1.80	2020.51	67.35	3151	1.559	1.574	2.33
4	4	6	19		46.31		192.72	27.53	176	0.916	0.917	0.11	538.70	38.48	611	1.135	1.139	0.74	1033.12	49.20	1316	1.274	1.280	1.38	1704.20	63.12	2333	1.369	1.375	1.48	2040.49	68.02	3132	1.535	1.580	4.76
4	4	2	20		45.71		194.08	27.73	175	0.900	0.903	0.11	542.30	38.74	617	1.138	1.145	0.95	1033.76	49.23	1320	1.277	1.282	1.16	1671.80	61.92	2364	1.414	1.418	1.48	2000.21	66.67	3141	1.571	1.601	3.60
4	4	5	21		46.12		193.52	27.65	172	0.890	0.891	0.00	540.30	38.59	604	1.119	1.121	0.32	1029.60	49.03	1293	1.256	1.260	0.74	1662.20	61.56	2344	1.410	1.414	1.16	2079.40	69.31	3172	1.526	1.549	2.75
4	4	4	22		46.46		196.72	28.10	179	0.910	0.910	0.00	541.90	38.71	615	1.135	1.137	0.42	1026.56	48.88	1260	1.228	1.232	0.85	1653.60	61.24	2262	1.368	1.374	0.85	2050.41	68.35	3055	1.490	1.516	2.54
4	4	1	23		46.50		187.52	26.79	169	0.900	0.903	0.11	524.40	37.46	602	1.149	1.152	0.42	1009.92	48.09	1297	1.284	1.293	1.38	1718.40	63.64	2334	1.358	1.365	1.80	2050.59	68.35	3187	1.554	1.569	2.43
4	4	3	24		46.50		194.08	27.73	177	0.915	0.916	0.11	536.80	38.34	607	1.132	1.135	0.42	1030.24	49.06	1268	1.231	1.239	1.38	1739.60	64.43	2294	1.319	1.326	1.69	2122.37	70.75	3149	1.484	1.511	3.49
6	6	6	31		46.39		190.08	27.15	176	0.924	0.928	0.00	490.23	35.02	591	1.205	1.208	0.32	932.80	44.42	1217	1.305	1.310	0.85	1501.80	55.62	2127	1.416	1.420	0.85	1802.15	60.07	2842	1.577	1.588	1.48
6	6	5	32		46.65		192.56	27.51	179	0.932	0.934	0.00	490.90	35.06	610	1.242	1.245	0.21	914.40	43.54	1250	1.366	1.372	0.85	1453.60	53.84	2215	1.523	1.529	0.95	1876.19	62.54	2941	1.567	1.581	1.69
6	6	3	33		46.50		193.52	27.65	187	0.968	0.970	0.00	500.90	35.78	621	1.240	1.243	0.32	933.12	44.43	1298	1.391	1.401	1.38	1476.60	54.69	2235	1.513	1.522	1.59	1908.26	63.61	2970	1.556	1.570	2.12
6	6	1	34		46.50		188.24	26.89	189	1.004	1.006	0.00	480.40	34.31	609	1.269	1.271	0.32	928.00	44.19	1298	1.398	1.410	1.59	1507.40	55.83	2269	1.505	1.515	1.90	1857.09	61.90	3025	1.629	1.647	2.54
6	6	4	35		46.48		184.96	26.42	185	1.000	1.005	0.00	472.80	33.77	610	1.289	1.293	0.11	908.96	43.28	1276	1.404	1.411	0.95	1463.40	54.20	2200	1.503	1.512	1.27	1755.31	58.51	2918	1.662	1.679	1.90
6	6	2	36		45.87		183.28	26.18	185	1.008	1.009	0.00	476.80	34.06	620	1.301	1.301	0.11	915.36	43.59	1307	1.428	1.434	0.95	1431.40	53.01	2246	1.569	1.578	1.38	1766.64	58.89	3006	1.701	1.725	2.33

		1			46.7		187.74	26.82	182	0.971	0.974	0.11	503.90	35.99	626	1.244	1.248	0.48	974.72	46.42	1344	1.380	1.390	1.53	1614.85	59.81	2332	1.447	1.454	1.83	1953.77	65.13	3137	1.607	1.624	2.72
		2			46.4		191.36	27.34	185	0.968	0.970	0.08	518.40	37.03	634	1.225	1.228	0.48	992.96	47.28	1351	1.363	1.368	0.98	1598.95	59.22	2380	1.492	1.497	1.27	1965.10	65.50	3179	1.621	1.642	2.57
		3			46.9		195.94	27.99	187	0.952	0.954	0.03	525.60	37.54	627	1.193	1.197	0.42	1001.36	47.68	1332	1.332	1.339	1.16	1638.45	60.68	2339	1.431	1.438	1.40	2017.43	67.25	3136	1.555	1.571	2.25
		4			46.7		192.42	27.49	185	0.961	0.964	0.08	510.45	36.46	623	1.224	1.227	0.48	975.36	46.45	1315	1.351	1.358	1.32	1588.35	58.83	2313	1.458	1.466	1.48	1922.63	64.09	3093	1.612	1.632	2.51
		5			47.0		196.35	28.05	186	0.945	0.947	0.03	521.80	37.27	629	1.206	1.209	0.37	999.24	47.58	1333	1.335	1.340	0.98	1607.60	59.54	2346	1.461	1.468	1.22	1992.25	66.41	3129	1.571	1.588	2.25
		6			46.9		194.82	27.83	181	0.931	0.933	0.05	521.61	37.26	618	1.186	1.190	0.48	1001.36	47.68	1317	1.316	1.322	1.19	1619.90	60.00	2308	1.425	1.431	1.24	1978.46	65.95	3088	1.561	1.582	2.54

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

StephenCrump · Apr 26, 2016

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?

vitamins · Apr 27, 2016

Ok, I will simplify it. Sorry for having messy question.

Here is my data set:

DATA INPUT

SLY FARM A	DAY 32
Block	Rep	Trmt	Cage #	ALW	ADG	FC	TFCR	AFCR	MORT

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

	AVERAGE	1		1953.77	65.13	3137	1.607	1.624	2.72
	2		1965.10	65.50	3179	1.621	1.642	2.57
	3		2017.43	67.25	3136	1.555	1.571	2.25
	4		1922.63	64.09	3093	1.612	1.632	2.51
	5		1992.25	66.41	3129	1.571	1.588	2.25
	6		1978.46	65.95	3088	1.561	1.582	2.54

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!

StephenCrump · Apr 27, 2016

vitamins said:
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

vitamins · Apr 28, 2016

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!

StephenCrump · Apr 28, 2016

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?

vitamins · Apr 28, 2016

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!

vitamins · Apr 28, 2016

Hey Sir Stephen Crump, I also have another question. If I have these data:

	A	B	C	D	E
1	Range	Rate		Performance	Rate
2	1.9000	5.5		1.6067	=WHAT FUNCTION?
3	1.8000	5.0		1.8402	=WHAT FUNCTION?
4	1.7000	4.5
5	1.6000	4.0
6	1.5000	3.5
7	1.4000	3.0
8	1.3000	2.5
9	1.2000	2.0
10	1.1000	1.5

--> 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!

StephenCrump · Apr 28, 2016

vitamins said:
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.

StephenCrump · Apr 28, 2016

vitamins said:
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?

SAS coefficient of variation vs. Excel coefficient of variation

vitamins

New Member

Excel Facts

StephenCrump

MrExcel MVP

vitamins

New Member

StephenCrump

MrExcel MVP

vitamins

New Member

StephenCrump

MrExcel MVP

vitamins

New Member

vitamins

New Member

StephenCrump

MrExcel MVP

StephenCrump

MrExcel MVP

Similar threads

Forum statistics

Share this page

SAS coefficient of variation vs. Excel coefficient of variation

New Member

Excel Facts

MrExcel MVP

New Member

MrExcel MVP

New Member

MrExcel MVP

New Member

New Member

MrExcel MVP

MrExcel MVP

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock