Call center typically have high turnover. The director of human resources for a large bank has compiled data on about 70 former employees at one of the bank’s call centers in the Excel file Call Center Data. In writing an article about call center working

Call center typically have high turnover. The director of human resources for a large bank has compiled data on about 70 former employees at one of the bank’s call centers in the Excel file Call Center Data. In writing an article about call center working conditions, a reporter has claimed that the average tenure is no more than two years. Formulate and test a hypothesis using these data to determine if this claim can be disputed.

PLEASE ATTACHED IS THE CALL CENTER DATA FOR THE ASSIGNMENT.

Please be sure your work is organized, legible, and your responses are substantive. You need to submit all details of your work including excel sheets used to arrive to the solution. It is not enough to attach your excel sheet. You MUST provide interpretation of results and describe conclusions.

Call Center

Female =

Yes = 1
No = 0

0

0 0

1 18 1 0

0

0 0

0 19 0 0

0 19 0 0

0 19 0 0

0 19 1 0

1 19 1 0

1 19 1 0

1 19 0 0

0

0 0

0 20 1 0

0 20 0 0

1 20 0 0

1 20 0 0

0

0 0 2.15

1 21 0 0

1 21 0 0

1 21 0 0 1.78
0

0 0

0 22 1 0

0

1 0

0 23 1 0

0 23 0 1

1 23 1 0

1 23 0 0

1 23 0 1

1

0 0 2.53

1 24 0 1

1 24 0 1

0

1 1

1 25 1 0

1 25 0 1

1 25 1 1

0

1 0

0 26 1 1

0 26 1 1 2.13
1 26 1 1

1 26 0 1

1 27 0 0

0

0 0

0 28 0 1

1 29 0 1

0 30 0 1 2.15
1 30 1 0 2.12
1 30 0 1

0

0 0

0 31 0 0

0 31 0 1

1 31 0 0

0

0 1

1 32 1 0 1.75
1 32 1 1

1

0 0

0

1 0

0 34 0 1

1 34 0 0

1 34 1 0

1

0 1

0

0 0 1.16

0 39 0 1

1 39 0 0

0

1 0

0 40 0 0

1 41 1 0

0

1 0

0 43 1 0

0

0 0

0 47 1 1

0

1 0

	Call Center Data
Male =																																																																																		1																																																																																																																																0		Yes = 1 No = 0
Gender	Starting Age	Prior Call Center Experience	College Degree	Length of Service (years)
	18	7.02
3.	47
							19	2.07
	1.78
4.42
3.	29
3.05
0.49
0.61
3.12
				20	2.95
		2.15
4.03
3.53
2.47
			21
3.	27
1.10
	22	1.94
2.91
					23	3.02
	2.53
1.84
2.88
2.20
1.44
		24
1.	41
1.08
			25	0.98
0.63
1.			30
	2.13
				26	2.30
2.05
	2.12
2.16
2.04
	28	1.70
2.11
	1.75
0.37
			31	1.95
1.02
1.26
1.04
		32	1.64
1.71
33	1.29
			34	1.48
1.31
1.46
1.88
36		1.16
		39
1.05
0.96
	40	1.24
0.81
0.87
	43	0.99
0.76
45	0.32
0.35
50	0.57