1) 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 w

(1)

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.

(2)    Using the date in the excel file Home Market Value, develop a multiple linear regression model for estimating the market value as a function of both the age and size of the house. Find a 95% confidence interval for the mean market value for houses that are 30 years old and have 1,800 square feet and a 95% prediction interval for a house that is 30 years old with 1,800 square feet.

PLEASE ATTACHED IS THE CALL CENTER DATA  and  HOME MARKET VALUES 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

Home Market Value

Home Market Value

Market Value

32

33 1,812

32

33

32

33

32

33

32

32

32

32

32 2,372

33 1,666 \$87,500.00
32

32 1,620

32

32 1,666

28

28

28

\$87,100.00

28 1,484

28 1,484

28 1,520 \$87,600.00
27

28 1,484

28

28 1,520 \$88,100.00
27 1,520

27 1,484

28 1,520

27

28 1,588

28

27 1,484

27 1,520

28 1,520

27

\$96,700.00

27

House Age Square Feet
33 1,812 \$90,000.00
32 1,914 \$104,400.00
1,842 \$93,300.00
\$91,000.00
1,836 \$101,900.00
2,0

28 \$108,500.00
1,732 \$87,600.00
1,850 \$96,000.00
1,791 \$89,200.00
1,666 \$88,400.00
1,852 \$100,800.00
1,620 \$96,700.00
1,692 \$87,500.00
2,372 \$114,000.00
\$113,200.00
2,123 \$116,100.00
\$94,700.00
1,731 \$86,400.00
\$87,100.00
1,520 \$83,400.00
27 1,484 \$79,800.00
1,588 \$81,500.00
1,598
\$82,600.00
\$78,800.00
1,701 \$94,200.00
\$82,000.00
1,468 \$88,100.00
\$88,600.00
\$76,600.00
\$84,400.00
1,668 \$90,900.00
\$81,000.00
1,784 \$91,300.00
\$81,300.00
\$100,700.00
\$87,200.00
1,684
1,581 \$120,700.00