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.

Aegis Home Inspections Inc.

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 4 was only established eight months ago. Prior to that time, the branches were part of Regions 1, 5 and 6.

INSTRUCTIONS (This project is worth 100 points – please FULLY answer all questions in detail)

As a group: Answer the following questions involving Descriptive Statistics

Draw (create) a sample from the full database then answer the following questions. You will ultimately use the sample from the full population of 408 to compare and contrast the sample and the population in the questions below. Typically you would not have the data for the entire population (such as in an election). So the point of this project is to use various statistical methods to examine how well your sample matches the population. It is obvious that the charts, figures etc. for the population should be the same for each group (or individual) that does this project. However, I would not expect to see the same results for any two groups (or individuals) samples since they are created using the Random number generator (RNG) mentioned below. This is a detailed and important project in this course, start early and take the time to do a good job. This assignment is worth twice what any one exam is worth.

Questions

1) Are total pay and years of seniority different for males and females in your sample? In the population? (Use scatter charts and linear regression – Display the Scatter chart and the results of the linear regression for this question.) Here you need to determine how many employees from the population and the sample are males and females. Then you need to compare the sample and population statistics. In a perfect world we would like to see these about the same. Can you think of any reasons why they might be different other than gender discrimination? Discuss fully.

2) Is there a correlation between years of seniority and total pay in your sample? In the population? (Use correlation – Display the correlation – Use Excel Correlation). What correlation would be considered a strong correlation? Is this correlation strong for the population and your sample

3) How does the result you obtained in Question 14 influence the conclusion that you reached in question 13? Explain fully.

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.