SAS OUTPUT for ServePro - Short Table 1 - Grade by Race race Grade MIN NON Total Asst ServRep 39 (61.9%) 19 (24.7%) 58 Senior ServRe 9 (14.3%) 32 (41.6%) 41 P ServiceRep 15 (23.8%) 26 (33.8%) 41 Total 63 77 140 D Statistic F Value Prob Chi- 2 21.565 Square 9 It Pooled Equal 13 -3.61 0.0004 8 Equality of Variances Num D Den D F Pr>F Method F F Value Folded F 78 62 62 1.51 0.096 8 Table 3 - The TTEST Procedure Performance Rating by Race race Metho d N Std De Std Er Minimu Mean v m Maximum MIN 3 7 NO N 8 5.031 2.2286 7 6.961 2.4303 0.2770 0.2808 2.0000 10.0000 2.0000 10.0000 7 0 Metho Std De race d MIN Mean 5.0317 95% CL Mean v 95% CL Std Dev 4.4705 5.5930 2.2286 1.8961 2.7037 NON 6.9610 6.4094 7.5126 2.4303 2.0978 2.8890 Diff (1- Pooled -1.929 2) 3 -2.715 9 -1.142 2.3418 6 2.0951 2.6549 Metho d Variance DF tValu Pr>Itl S e Pooled Equal 13 -4.85 It S e Pooled Equal 13 -4.93 8 F Method F F Value Folded 76 62 1.09 0.743 F 4 Table 5a - The TTEST Procedure Salary by Grade-Assistant Service Rep Metho race d N Std De Std Err Minimu Maximu Mean v m m MIN 3 1190.3 130.8 g 20.950 7 890.0 1420.0 NON 1 1143.2 142.0 9 32.570 7 880.0 1360.0 Diff (1- Pooled 2) 47.098 5 134.5 37.634 1 Metho Std De race d Mean MIN 95% CL Mean 1190.3 1147.8 1232. V 95% CL Std Dev 130.8 106.9 168.6 7 NON 1143.2 1074.7 1211. 142.0 107.3 210.0 6 Diff (1- Pooled 47.098 -28.291 122.5 134.5 113.8 165.0 2) 5 7 Metho Variance D tValu Pr> It d S F e Pooled Equal 58 1.25 0.216 0 Equality of Variances Num D Den D F Pr>F Method F F Value Folded F 18 38 1.18 0.651 2 Table 5b - The TTEST Procedure Performance rating by Grade-Assistant Service Rep Metho N race d Mean Std De v Std Er Minimu Maximu m m MIN 9 3 3.512 0.5559 0.0890 2.0000 8 4.0000 NON 1 3.473 0.7723 0.1772 2.0000 5.0000 9 7 Diff (1- Pooled 2) 0.039 0.6336 1 0.1773 Metho Std De race d MIN Mean 95% CL Mean 3.512 3.3326 3.693 8 0 v 95% CL Std Dev 0.5559 0.4543 0.7165 0.7723 0.5836 1.1421 NON Diff (1- 2) 3.473 3.1014 3.845 7 9 Pooled 0.039 -0.316 0.394 0.6336 0.5349 0.7773 1 0 2 Metho Variance D tValu Pr>It S d Pooled Equal 58 0.22 F e 0.826 1 Equality of Variances Num D Den D F Pr>F Method F F Value Folded 18 38 1.93 0.087 F 4 Table 5c - The TTEST Procedure Tenure by Grade-Assistant Service Rep N Std De Std Er Minimu Maximu MIN Method Mean m m 3 1.7949 0.7840 0.1255 0.5000 3.4000 9 NON 1 1.9789 0.7627 0.1750 0.4000 3.2000 9 Diff (1- Pooled -0.184 0.7772 0.2175 2) 1 Diff (1- Satterthwait -0.184 0.2154 2) 1 Metho race MIN d Mean 95% CL Mean 1.7949 1.5407 Std De V 95% CL Std Dev 2.049 0.7840 0.6407 1.0104 0 NON 1.9789 1.6113 2.346 0.7627 0.5763 1.1279 6 Diff (1- 2) Pooled -0.184 1 -0.619 7 0.251 5 0.7772 0.6562 0.9535 Metho d Varlance D tValu Pr>t 8 F Pooled Equal 56 -0.85 Equality of Variances 0.400 9 Num D Den D Fer F Method F F Value Folded F 38 18 1.06 0.931 5 Table 6a - The TTEST Procedure Salary by Grade-Senior Service Rep Metho N Std De Std Err d Mean v Minimu m Maximu m MIN 9 2070.0 406.3 NON 3 2062.8 360.3 135.4 63.689 1 1440.0 2680.0 1400.0 2710.0 Diff (1- Pooled 2) 17.187 5 370.2 139.7 std De race Method Mean MIN 2070.0 95% CL Mean 1757. 7 V 95% CL Std Dev 2382. 3 406.3 274.5 778.4 NON 2062.8 1922. 9 2182. 7 360.3 288.8 479.0 Diff (1- Pooled 2) 17.187 -285.3 299.7 5 370.2 303.2 475.3 Diff (1- 2) Satterthwait 17.187 -309.6 344.0 5 Metho Varlance D tValu Pr>t d 8 F Pooled Equal 39 0.12 0.902 7 Equality of Variances Num D Den D F Pr F Method F F Value Folded F 8 31 1.27 0.586 9 Table 6b - The TTEST Procedure Performance rating by Grade-Senior Service Rep N Std De Std Er Minimu Method Mean v r m Maximu m MIN 9 9.2222 0.6667 0.2222 8.0000 10.0000 NON Nw 9.3125 0.6927 0.1225 8.0000 10.0000 Diff (1- Pooled -0.090 0.6874 0.2594 2) 3 Diff (1- Satterthwait -0.090 0.2537 2) 3 Metho Std De race d Mean 95% CL Mean V 95% CL Sta Dev MIN 9.2222 8.7098 7 NON 9.3125 9.0628 9.734 0.6667 9.562 0.6927 0.5553 0.9209 0.4503 1.2772 2 Diff (1- Pooled -0.090 2) 3 -0.614 9 0.434 0.6874 0.5631 0.8827 4 Metho Varlance D tValu Prxt d 8 F Pooled Equal 39 -0.35 0.729 7 Equality of Variances Num D Den D F Pr>F Method F F Value Folded F 31 8 1.08 0.982 3 Table 6c - The TTEST Procedure Tenure by Grade-Senior Service Rep N Std De Std Er Minimu Maximu Method Mean V m m MIN 9 3.9000 0.6576 0.2192 3.0000 4.7000 NON 3 4.2813 0.6893 0.1219 2.7000 5.7000 2 Diff (1- Pooled -0.381 0.6829 0.2577 2) 3 Diff (1- 2) Satterthwait -0.381 0.2508 3 race Method MIN Mean 95% CL Mean 3.9000 3.3945 Std De V 95% CL Std Dev 4.405 0.6576 0.4442 1.2599 5 NON 4.2813 4.0327 4.529 0.6893 0.5526 0.9164 8 Diff (1- Pooled 2) Diff (1- 2) Satterthwait -0.381 -0.902 3 -0.381 -0.921 3 5 4 0.139 0.6829 9 0.159 0.5594 0.8769 Variance tvalu Pr>it Method Pooled 8 Equal DF 39 -1.48 0.147 0 Satterthwait Unequal 13.37 -1.52 Equality of Variances Num D Den D 8 0.151 8 F Pr>F Method F F Value Folded F 31 8 1.10 0.958 4 Table 7a - The TTEST Procedure Salary by Grade Service Rep 8td De 8td Err Metho N Minimu Maximu d Mean v m m MIN 1 1586.7 244.0 62.994 1 1210.0 1980.0 NON 1600.4 302.3 59.279 0 1190.0 2230.0 Diff (1- Pooled -13.717 282.7 91.669 20 9 7 Metho d 8td De Mean 96% CL Mean v 86% CL Bid Dev MIN 1586.7 1451. 6 1721. 244.0 178.6 384.8 NON 1600.4 1478. 3 172 1722. 302.3 237.1 417.2 Diff (1- Pooled -13.717 -199.1 171.7 282.7 231.6 363.0 20 9 Variance D Valu Pr Metho d 5 F -0.15 0.881 Pooled Equal 39 Equality of Variances Num D Den D Pr>F Method F F Value Folded 25 14 1.53 0.406 3 Table 7b - The TTEST Procedure Peformance Rating by Grade= Service Rep N Method Mean Bid De v 8td Er Minimu m Maximu MIN 1 6.4667 0.9904 0.2567 5.0000 8.0000 5 NON 2 6.6154 0.0072 0.1367 5.0000 8.0000 6 Diff(1- Pooled -0.148 0.8147 0.2642 2) 7 Diff (1- Batterthwait -0.148 0.2900 20 7 Metho d MIN Mean 86% CL Mean 6.4667 5.9182 ald De v 86% CL std Dev 7.015 0.9904 0.7251 1.5620 1 NON 6.6154 6.3338 6.897 0.6972 0.5468 0.9625 0 Diff (1- Pooled 20 -0.148 7 -0.683 0 0.385 0.8147 0.6674 1.0461 6 Metho Variance D Valu Pr d G F Pooled Equal 39 -0.56 0.576 7 Equality of Variances Num D Den D Pr>F Method F Folded F 14 25 F Value 2.02 0.121 9 Table 7c - The TTEST Procedure Tenure by Grade Service Rep Metho N Mean 8td De 8td Er Minimu Maximu v 1 3.1933 0.5612 0.1449 5 d MIN NON 6 Diff (1- Pooled 20 LU 2.2000 4.3000 2 3.2731 0.6685 0.1311 2.3000 4.6000 -0.079 0.6321 0.2049 7 race MIN NON Metho 8td De d Mean 86% CL Mean 86% CL sid Dev 3.1933 2.8825 3.504 0.5612 0.4109 0.8851 1 3.2731 3.0031 3.543 0.6685 0.5242 0.9228 Diff (1- Pooled -0.079 -0.494 0.334 0.6321 0.5178 0.8116 2) Metho d G 7 3 Variance D Valu Pr F Pooled Equal 39 -0.39 0.699 8 Equality of Variances 3 Num D Den D F Pr>F Method F F Value Folded 25 14 1.42 0.500 F 9 Table 8a - Mean Salary by Grade and Race race tValu Pr>t grade Obs Mean McG Asst SvRep MN 39 1190.2 3 0 56.81 Table 9 - ANOVA Procedure Dep. Variable: Salary DF Bum of Source Squares Mean Square Value F PrF Model 1 2438201.22 2438201.22 13.02 0.000 4 Error 13 25833892.35 187202.12 8 Corrected Total 13 28272093.57 9 R- Coeff Square Var 0.086241 27.80264 432.6686 Root Salary Mea MBE 1556.214 Bouro Mean F Pr F Anova 88 Square Value Race 1 2438201.21 2438201.219 13.02 9 0.000 4 Monthly salary (in 3000) Grade ALBR MIN Mes P $1,190.26 NO Mea N $1,143.16 Sent_3vRe MIN Mes P $2,070.00 NO Mea N n $2,062.81 Service Rep MIN Mea $1,586.67 NO Mos N $1,600.38 All Mos $1,556.21 Grade race Asst ByRep MIN Mea Peformance Rating 3.51 NO Mea N 3.47 Ben ByRap MIN Mea 9.22 NO Mea N 9.31 Service Rep MIN Mea 6.47 NO Mea N 6.62 All Mea 6.09 Table 10 - GLM Procedure - Dependent Variable: Salary DF Source Sum of Squares Mean Square F Value Pr>F Model 3 18776458.69 6258819.56 89.64 F Race 1 11964.86 11954.86 0.17 0.679 7 Grad 2 16338257.4 8169128.74 117.00 MIN 1620.65438 0.41 0.6797 NON 1600.45027 Balary Grade LIMEAN L3MEAN Number Acct_vo 1171.34567 1 P Senr 3vRe 2062 24985 2 P ServiceRep 1588.07496 3 Least Squares Means for Effect grade t for HO: L8Mean(0) Mean])/P> Dependent Variable: Salary VJ 1 2 3 1 -15.2804 (