Crane Life Crane Life is a major life insurance company in the US The CEO of Crane Life was recently tragically killed in a car accident Graham Land, the newly appointed CEO, is quite worried about the attitudes of the sales force, especially their perceptions of company values Consequently, he has asked you to conduct a survey to measure key elements related to these issues He has suggested that the extent of agreement with the following five statements be measured on a 5 point Likert scale where 1 strongly disagree, 2 disagree, 3 neither agree nor disagree, 4 agree, 5 strongly agree Q1 The company has an excellent training program Q2 The company is committed to providing excellent service Q3 The management of the company has very traditional and conservative values Q4 Company practices do not discriminate against women Q5 The company is rife with internal power politics The sales force is located in six distinct geographic regions Region Area 1 Southeast 2 Northeast 3 Midwest 4 Southwest 5 Mountain States 6 West Coast Each of the six regions comprises several branch offices headed by a Branch Manager The various branch managers report to a regional manager There are two Regional Directors, one controlling Regions 1 3 and the other 4 6 Region 4 was only established eight months ago Prior to that time, the branch was part of Regions 1, 5 and 6 A member of your staff has captured the results of the survey in an Excel spreadsheet Besides the responses to the five questions, the following personal details were also captured Basic annual salary (BAS) Commission earned over past 12 months (COM) Total annual pay (TOT BAS COM) Years with the company or seniority (SEN) Region to which the person is currently allocated (REG) Gender (GENDER, 0 female, 1 male) Number of contracts written over the past 12 months (CON)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 16, 2024

Crane Life Crane Life is a major life insurance company in the US. The CEO of Crane Life was recently tragically killed in a car

Crane Life

Crane Life is a major life insurance company in the US. The CEO of Crane Life was recently tragically killed in a car accident. Graham Land, the newly appointed CEO, is quite worried about the attitudes of the sales force, especially their perceptions of company values. Consequently, he has asked you to conduct a survey to measure key elements related to these issues.

He has suggested that the extent of agreement with the following five statements be measured on a 5- point Likert scale where: 1 = strongly disagree, 2 = disagree, 3 = neither agree nor disagree, 4 = agree, 5 = strongly agree.

Q1: The company has an excellent training program
Q2: The company is committed to providing excellent service
Q3: The management of the company has very traditional and conservative values
Q4: Company practices do not discriminate against women
Q5: The company is rife with internal power politics.

The sales force is located in six distinct geographic regions:

Region	Area
1	Southeast
2	Northeast
3	Midwest
4	Southwest
5	Mountain States
6	West Coast

Each of the six regions comprises several branch offices headed by a Branch Manager. The various branch managers report to a regional manager. There are two Regional Directors, one controlling Regions 1-3 and the other 4-6. Region 4 was only established eight months ago. Prior to that time, the branch was part of Regions 1, 5 and 6. A member of your staff has captured the results of the survey in an Excel spreadsheet. Besides the responses to the five questions, the following personal details were also captured:

Basic annual salary (BAS) Commission earned over past 12 months (COM) Total annual pay (TOT = BAS + COM) Years with the company or seniority (SEN) Region to which the person is currently allocated (REG) Gender (GENDER, 0 = female, 1 = male) Number of contracts written over the past 12 months (CON)