Background

Aegis Inc. is a home inspection firm based in the Northern Virginia area. The President of the company, Ms. Rose Wilson, is concerned about the morale of the sales team. Ms. Wilson had contracted a local firm to survey the employees of Aegis Inc. and the results were delivered to her in an EXCEL spreadsheet. She has tasked her Vice President of Human Resources, Mark Wolfe, to analyse the results of the survey and to report the results to her. Ms. Wilson told Mark that she was concerned about the attitudes of the sales force. In addition to the questions that were asked some additional data were recorded: the most recent base annual salary, commission and total pay, the years of seniority, the sales region of the individual, the gender (0=male, 1=female) and the number of contracts written in the pay period.

The survey instructions indicated that the first 5 questions were measured using a 5-point scale using the following key: 1 = strongly disagree, 2 = disagree, 3 = neither agree nor disagree, 4 = agree, 5 = strongly agree. The questions were as follows:

Q1:Aegis Inc. has a good mentoring program

Q2:Aegis Inc. is committed to delivering good value to customers

Q3:Aegis Inc. has very traditional and conservative values

Q4:Aegis Inc. company practices favor men

Q5:Aegis Inc. has a lot of internal power politics.

The final question used a 1-10 scale:

Q6:On a numeric scale, where 0 means totally autocratic and 10 means totally democratic, how would you rate the management style at Aegis Inc.?

The final question used a 1-10 scale: Check for Spelling, down Q6: On a numeric scale, where 0 means totally autocratic and 10 means totally democratic, ho Writing Suppritions would you rate the management style at Aegis Inc.? There are only 2 divisional managers for Aegis Inc. The geographic regions of the sales team are as follows: O Region Divisional Size of Sales Number Manager Area Force A South East 60 A North East 93 A Midwest 59 B South West 49 B Mountain States 80 B West Coast 67 Total 408 Region 4 was only established eight months ago. Prior to that time, the branches were part of Regions 1. 5 and 6.Group D Location Question Question 2 Question Question Question Question 1 3 4 5 6 1-South East 3.79 3,68 2.59 3,79 2.09 6,35 2-North East 3.75 4.02 3.05 3.73 1.98 6.57 3-midwest 3.67 4.11 3.44 3.96 2.26 7.33 4-southwest 3.48 2.68 2.88 3.8 3.56 2.08 5- mountain states 3.85 2.76 2.88 3.58 1.94 6.79 6-west coast 4.08 2.97 2.89 4.05 2.05 6.46