Call centers have high turnover rates because of the stressful environment. The national average is approximately...

Transcribed Image Text:

Call centers have high turnover rates because of the stressful environment. The national average is approximately 50%. The director of human resources for a large bank has compiled data from about 70 former employees at one of the bank's call centers. A sample of 20 of these employees is provided below. Use Pivo Tables to find the statistics in parts a through c below. Click the icon to view the call center data a. Find the average length of service for males and females in the sample. Complete the table below (Type integers or decimals rounded to two decimal places as needed) Average of Length of Service (years) Female Male 0 1 Grand Total b. Find the average length of service for individuals with and without a college degree. Complete the table below. (Type integers or decimals rounded to two decimal places as needed.) Average of No college 0 degree College degree 1 Female Male Grand Total c. Find the average length of service for males and females with and without prior call center experience. Complete the table below (Type integers of decimals rounded to two decimal places as needed.) Without prior with prior call call experience experience Average of Length of Service (years) 0 1 Grand Total Length of Service (years) 80 000 0 000 D 1 000 Grand Total 000 DII DD Call Center Data Call Center Data Male=1 Female =0 Gender 0 1 0 O 1 1 0 1 1 1 0 0 0 0 0 0 1 1 0 1 Starting Age 2852242252222232 19 31 19 20 26 33 20 21 30 20 19 19 21 Yes 11 No 0 Prior Call Center Experience 10 1 0 0 0 0 1 1 0 0 1 0 0 0 0 1 1 1 0 0 Print 40 College Degree Yes 1 No=0 0 0 1 0 0 1 1 0 0 0 0 0 1 0 1 0 1 0. 0 0 Done Length of Service (years) 3.29 2.88 1.26 4.42 2.47 1,3 2.05 0.63 1.29 146 2.15 2.15 2:15 4.03 1.84 3.05 2.13 1.88 1.78 3.27 C Call centers have high turnover rates because of the stressful environment. The national average is approximately 50%. The director of human resources for a large bank has compiled data from about 70 former employees at one of the bank's call centers. A sample of 20 of these employees is provided below. Use Pivo Tables to find the statistics in parts a through c below. Click the icon to view the call center data a. Find the average length of service for males and females in the sample. Complete the table below (Type integers or decimals rounded to two decimal places as needed) Average of Length of Service (years) Female Male 0 1 Grand Total b. Find the average length of service for individuals with and without a college degree. Complete the table below. (Type integers or decimals rounded to two decimal places as needed.) Average of No college 0 degree College degree 1 Female Male Grand Total c. Find the average length of service for males and females with and without prior call center experience. Complete the table below (Type integers of decimals rounded to two decimal places as needed.) Without prior with prior call call experience experience Average of Length of Service (years) 0 1 Grand Total Length of Service (years) 80 000 0 000 D 1 000 Grand Total 000 DII DD Call Center Data Call Center Data Male=1 Female =0 Gender 0 1 0 O 1 1 0 1 1 1 0 0 0 0 0 0 1 1 0 1 Starting Age 2852242252222232 19 31 19 20 26 33 20 21 30 20 19 19 21 Yes 11 No 0 Prior Call Center Experience 10 1 0 0 0 0 1 1 0 0 1 0 0 0 0 1 1 1 0 0 Print 40 College Degree Yes 1 No=0 0 0 1 0 0 1 1 0 0 0 0 0 1 0 1 0 1 0. 0 0 Done Length of Service (years) 3.29 2.88 1.26 4.42 2.47 1,3 2.05 0.63 1.29 146 2.15 2.15 2:15 4.03 1.84 3.05 2.13 1.88 1.78 3.27 C