ID# 877 556 611 325 811 118 207 496 558 206 327 300 906 605 17 508 945 101 421 204 901 721 58 233 971 128 727 728 765 507 138 264 222 852 333 694 261 169 301 Dept. 3 2 3 2 1 3 3 5 1 2 3 5 4 2 1 3 2 5 5 1 5 5 2 2 1 4 1 4 5 4 4 4 3 2 4 4 1 5 1 Ethnicity N B W B W H B W H A H W N W W B B B B W N N B W W H N N W W W W H H W A N H A Gender F F F F F F F F F F F F F F F F F F M M M M M M M M M M M M M M M M M M M M M Weight 252 132 178 162 192 110 270 229 189 124 226 399 97 204 155 198 214 314 219 138 220 217 127 310 126 255 288 271 287 315 194 215 151 210 262 174 407 212 290 Age 18 21 21 22 24 25 30 31 31 32 34 35 41 43 47 47 51 73 24 25 27 30 31 31 31 35 37 38 38 41 42 44 46 48 51 53 54 59 66 Salary 69380 40881 39986 31797 84400 12775 97424 97742 67089 65358 27082 13810 83331 21500 15544 86274 56151 91312 31008 25594 21928 16298 47435 21285 37328 31466 51243 22697 35605 40718 73582 43847 80712 26293 15155 29050 43761 11092 12484 Vacation Hrs 392 138 278 159 376 62 390 747 124 336 499 217 534 317 288 87 155 569 214 271 82 310 444 192 85 64 128 330 513 212 564 58 365 384 156 151 189 452 263 Absences 16 34 22 32 18 0 16 15 81 47 24 15 28 90 85 17 39 12 70 0 7 45 10 40 61 9 40 42 43 15 110 0 34 0 0 0 21 78 28 E. Score 24 14 22 17 11 14 22 13 20 21 10 8 18 25 19 17 11 25 19 12 16 7 15 14 25 18 1 17 10 23 23 21 12 18 18 25 15 1 16 P. Score 94 86 90 76 80 93 65 84 70 96 76 75 88 74 94 82 77 73 98 72 87 77 91 71 84 80 72 71 86 97 97 80 80 79 81 76 85 92 87 Department #1 84,400.00 67,089.00 15,544.00 25,594.00 37,328.00 51,243.00 43,761.00 12,484.00 $42,219.63 $24,908.63 -$26,636.38 -$16,586.38 -$4,852.38 $9,062.63 $1,580.63 -$29,696.38 $42,180.38 $42,219.63 1782496735.14 $24,908.63 620439599.391 $26,636.38 709496473.141 $16,586.38 275107835.641 $4,852.38 23545543.1406 $9,062.63 82131171.8906 $1,580.63 2498375.39063 $29,696.38 881874688.141 4377590421.88 625370060.268 25007.4001 Department #2 40881.00 31797.00 65358.00 21500.00 56151.00 47435.00 21285.00 26293.00 $2,043.50 $7,040.50 $26,520.50 $17,337.50 $17,313.50 $8,597.50 $17,552.50 $12,544.50 $2,043.50 $7,040.50 $26,520.50 $17,337.50 $17,313.50 $8,597.50 $17,552.50 $12,544.50 4175892.25 49568640.25 703336920.25 300588906.25 299757282.25 73917006.25 308090256.25 157364480.25 1896799384 $38,837.50 270971340.571 16461.2071 Department #3 $69,380.00 $39,986.00 $12,775.00 $97,424.00 $27,082.00 $86,274.00 $80,712.00 $10,289.57 $19,104.43 $46,315.43 $38,333.57 $32,008.43 $27,183.57 $21,621.57 $59,090.43 10289.5714285714 105875280.184 19104.4285714286 364979191.041 46315.4285714286 2145118923.76 38333.5714285714 1469462698.47 32008.4285714286 1024539499.61 27183.5714285714 738946555.612 21621.5714285714 467492351.041 6316414499.71 1052735750 32445.8896 Department #4 $83,331.00 $31,466.00 $22,697.00 $40,718.00 $73,582.00 $40,850.25 $11,014.75 $19,783.75 $1,762.75 $31,101.25 40850.25 1668742925.06 11014.75 121324717.563 19783.75 391396764.063 1762.75 3107287.5625 31101.25 967287751.563 $43,847.00 $15,155.00 $29,050.00 $1,366.25 $27,325.75 $13,430.75 $42,480.75 1366.25 1866639.0625 27325.75 746696613.063 13430.75 180385045.563 4080807743.5 582972534.786 24144.8242 Department #5 $97,742.00 $13,810.00 $91,312.00 $31,008.00 $21,928.00 $16,298.00 $35,605.00 $11,092.00 $39,849.38 $57,892.63 $26,039.38 $51,462.63 $8,841.38 $17,921.38 $23,551.38 $4,244.38 $28,757.38 57892.625 3351556029.39 26039.375 678049050.391 51462.625 2648401771.89 8841.375 78169911.8906 17921.375 321175681.891 23551.375 554667264.391 4244.375 18014719.1406 28757.375 826986616.891 8477021045.88 1211003006.55 34799.4684809 59090.42857 Ad-hoc Statistics Report submitted to the CEO By: Alicia Galloway 03/30/2017 Table of Contents Title Page .......................................................................i Table of Contents...............................................................ii Vacation Frequency Distribution...............................................1 Means...............................................................................2 Salary Analysis....................................................................3 Yearly Medical Physicals.........................................................4 Bonus Recommendation..........................................................5 Downsizing Recommendation.....................................................6 Issue 1: Classes F RF CRF 45 - 90 6 .154 .595 91-136 2 .052 .312 137-182 5 .129 .441 183 - 228 5 .129 .441 229 - 274 1 .026 .026 275 - 320 20 .513 1.108 Issue 2: Find the Mean weight for Departments 3 and 5 combined. = 89.282 Find the Mean salary for Department 2. = 185.375 Find Mean age for Department 1. = 223.125 Find the Mean Placement Score (P. Score) for Department 4. = 81.750 Issue 3: Standard deviation for the evaluation score (E. Score) of: Department 5: Department 2: The CEO is thinking about giving one of these departments a $1000 per person bonus. Based on their means and standard deviation, which department is doing better as it relates to this year's evaluation? Who should the bonus go to and why? Issue 4: Department 3 and 5 are under consideration for downsizing. Please find the 95% standard deviation for the age for the departments individually. Which department seems to be older? If we eliminate Department 5 instead of Department 3, will there be a valid claim that we downsized the department with the oldest employees? Dept 3: 95% range is = 8.570 - 54.574 Dept 5: 95% range is = 5.119 - 74.131 From the Data and the accuracy of the 95% standard deviation, department 5 seems to be older significantly. The valid reasoning for eliminating that department is within the data. To be absolutely sure, the 99.7% (3 sigma) can be applied and will reveal even more precise data. Issue 5