Please answer a. and b. and show work

Week 1 Defectives 19 11 1 11 1 1 1 6 11 1 12 Person Billy Tom Amanda Sam Rachel James Fred Jake Shirley Mary Bob Carl Dave Pam Stuart Lisa Accounts 100 100 100 100 100 100 100 100 100 100 100 100 100 1 1 16 4 1 1 10 13 11 1 1 9 1 13 1 8 1 100 100 100 8 1 12 Week Defectives Accounts 100 5 2 2 100 2 100 100 9 18 12 15 2 2 Person Billy Tom Amanda Sam Rachel James Fred Jake Shirley Mary Bob Carl 2 2 7 100 100 100 100 2 5 11 14 2 100 2 8 2 100 100 100 11 2 5 14 2 Dave 2 Pam 100 100 100 12 2 9 10 2 3 100 100 100 10 10 3 3 100 19 3 100 9 3 7 Stuart Lisa Billy Tom Amanda Sam Rachel James Fred Jake Shirley Mary Bob Carl 100 100 3 9 3 100 14 3 7 3 7 100 100 100 100 3 10 10 3 3 11 3 Dave 9 3 100 100 100 100 100 14 Pam Stuart Lisa 3 8 3 6 The employees at a marketing research firm each service 100 accounts per week. The file Service Errors 1.xlsx contains the number of accounts that each employee messed up each week. a. Do these data indicate that Jake should receive a raise and Billy should be fired? Use a control chart to explain your answer. b. The file Service Errors 2.xlsx contains two additional weeks of data from the marketing research firm. Does it appear that Amanda is a problem? |