## Business 221 – Business Statistics Case Study- Aegis Home Inspections Inc.

Question

Aegis Home Inspections Inc.

Mark DAntonio of Northern Virginia Community College provided this case and associated data. The company and data were totally fabricated. Any resemblance to any organization is coincidental. Please use Microsoft Excel to do this assignment.

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.?

There are only 2 divisional managers for Aegis Inc. The geographic regions of the sales team are as follows:

Region Number

Divisional

Manager

Area

Size of Sales Force

1

A

South East

60

2

A

North East

93

3

A

Midwest

59

4

B

South West

49

5

B

Mountain States

80

6

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.

INSTRUCTIONS

As a group: Answer the following questions involving Descriptive Statistics

Draw a random sample of 50 from the full database then answer the following questions.

1) Draw a random sample of 50 from the full population provided by using the systematic random sampling method.

2) Describe how the random sample was taken.

3) Determine the mean, mode, median, variance, standard deviation, high value, low value and range for years of seniority, base salary, commission and total salary for your SAMPLE.

4) Determine the mean, mode, median, variance, standard deviation, high value, low value and range for years of seniority, base salary, commission and total salary for the POPULATION.

5) Briefly explain the differences between the population and your sample.

6) Briefly explain the similarities between the population and your sample.

7) Is there a difference between your sample and the population in how the sales force is distributed within the regions? (Is the number of sales people in each of your sample regions proportionally the same as in the total population?)

Answer the following questions involving Inferential Statistics

8) Is there a relationship between years of seniority and base pay for the sample? The population? (Hint: Scatter chart)

9) Is there a relationship between years of seniority and commission pay for the sample? The population? (Hint: Scatter chart)

10) Is there a relationship between years of seniority and total pay for the sample? The population? (Hint: Scatter chart)

11) Is there a large or small difference in your answers for the sample and the population for questions 8,9 and 10?

## Business 221 – Business Statistics Case Study- Aegis Home Inspections Inc.

Question
Northern Virginia Community College

Assignment for Course:

Submitted to:

Mark DAntonio

Submitted by:

(Name of Group – name of each member Below)

Date of Submission

MM/DD/YY

Title of Assignment

Case Study

CERTIFICATION OF AUTHORSHIP: I certify that the members of the group named above equally contributed to the assignment that is attached. Any assistance received in its preparation is fully acknowledged and disclosed in the paper. Any sources from which the group used data, ideas or words, either quoted directly or paraphrased is also disclosed. Please print and sign below.

Student’s Signature: ______________________________________

Student’s Signature: ______________________________________

Student’s Signature: ______________________________________

Student’s Signature: ______________________________________

Student’s Signature: ______________________________________

Student’s Signature: ______________________________________

Student’s Signature: ______________________________________

Student’s Signature: ______________________________________

Aegis Home Inspections Inc.

Mark DAntonio of Northern Virginia Community College provided this case and associated data. The company and data were totally fabricated. Any resemblance to any organization is coincidental. Please use Microsoft Excel to do this assignment.

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.?

There are only 2 divisional managers for Aegis Inc. The geographic regions of the sales team are as follows:

Region Number

Divisional

Manager

Area

Size of Sales Force

1

A

South East

60

2

A

North East

93

3

A

Midwest

59

4

B

South West

49

5

B

Mountain States

80

6

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.

INSTRUCTIONS

As a group: Answer the following questions involving Descriptive Statistics

Draw a random sample of 50 from the full database then answer the following questions.

1) Draw a random sample of 50 from the full population provided by using the systematic random sampling method.

2) Describe how the random sample was taken.

3) Determine the mean, mode, median, variance, standard deviation, high value, low value and range for years of seniority, base salary, commission and total salary for your SAMPLE.

4) Determine the mean, mode, median, variance, standard deviation, high value, low value and range for years of seniority, base salary, commission and total salary for the POPULATION.

5) Briefly explain the differences between the population and your sample.

6) Briefly explain the similarities between the population and your sample.

7) Is there a difference between your sample and the population in how the sales force is distributed within the regions? (Is the number of sales people in each of your sample regions proportionally the same as in the total population?)

Answer the following questions involving Inferential Statistics

8) Is there a relationship between years of seniority and base pay for the sample? The population? (Hint: Scatter chart)

9) Is there a relationship between years of seniority and commission pay for the sample? The population? (Hint: Scatter chart)

10) Is there a relationship between years of seniority and total pay for the sample? The population? (Hint: Scatter chart)

11) Is there a large or small difference in your answers for the sample and the population for questions 8,9 and 10?