What is the tenure with company distribution by gender

Question

Assignment:

Discuss the below:

Compose an email to the head of the American Intellectual Union which discusses the following:

Begin your email to AIU by first providing an overview of the database, i.e. a story.

Be sure to include information about how you would use the concept of probabilities to apply to profiles for hiring more satisfied individuals.

(Job Satisfaction is an attitude about one's job. It may be measured globally or via facets (e.g. intrinsic/extrinsic). However, job satisfaction is a post hoc phenomenon. Using "profiles" developed via the DataSet to predict job satisfaction is not feasible. Further, the only variables you could use would be gender, age, department, position. To say, for example, that salaried females between 22-49 years of age and working in IT are more likely to be satisfied says nothing about potential hires. It probably says more about the way the department is managed and the resources available to accomplish tasks. Finally, unless job satisfaction is a performance criterion, it would most likely be illegal to use this concept.)

Be sure to include other ways that probability is used in business. (Feel free to use the Business Source Premier Database in the Library as a resource to research.)

Keeping in mind that in this email you are going to try to apply probabilities to profile hiring more satisfied individuals, discuss the following in your email:

What is the gender distribution (% females and % males)?

What is the "tenure with company" distribution by gender?

What % of the survey participants are in each department?

What is the mean overall satisfaction by gender?

If we choose a person at random from this database:

What is the probability that this person will be between 22 and 49 years old?

What is the probability that their overall job satisfaction is 4.7 or lower?

What is the probability that this person will be a male in the information technology department?

What is the probability that this person will be an hourly employee whose intrinsic satisfaction is 6 or more?

KEY TO JOB SATISFACTION SURVEY
Gender
1	Male
2	Female
Age
1	21 and under
2	22-49
3	50 and over
Department
1	Human Resources
2	Information Technology
3	Administration
Position
1	Hourly Employee (Overtime Eligible)
2	Salaried Employee (No Overtime)
Tenure With Company
1	Less than 2 years
2	2 to 5 years
3	Over 5 Years
OVERALL	Scale from 1-7
	1 = Least Satisfied
	7 = Most Satisfied
INTRINSIC	Scale from 1-7
	1= Least Satisfied
	7= Most Satisfied
EXTRINSIC	Scale from 1-7
	1 = Least Satisfied
	7 = Most Satisfied
BENEFITS	Scale from 1-7
	1= Least Satisfied
	7= Most Satisfied

GENDER	AGE	DEPT	POSITION	TENURE	OVERALL	INTRINSIC	EXTRINSIC	BENEFITS
1	1	2	1	2	5.1	3.8	4.7	3.7
1	2	2	1	1	2.6	4.2	5.4	5.2
1	1	2	1	3	6.4	4.2	5.5	4.5
1	2	3	1	2	4	4.7	4.6	4.5
1	3	1	1	3	3.2	5.2	4.3	4.9
1	1	2	1	1	2.3	5.4	6	3.2
1	2	3	1	3	5.1	5.6	4.8	2.5
1	3	2	1	1	5.5	5.7	6	4.6
1	2	1	1	3	4.4	5.8	2	4.6
1	3	3	1	3	4.6	6.2	6.2	3.5
1	3	2	1	1	5.6	6.4	3.8	3.8
2	2	1	2	2	4.1	3.2	4.5	4.6
2	2	3	1	3	6.5	3.8	6	4.6
2	2	2	2	3	4.5	4.2	4.6	6.3
2	1	3	2	2	5.5	5	5.9	6.6
2	1	3	2	2	6	5	7	6.1
2	2	3	2	1	6.4	5.4	3.2	3.2
2	3	2	2	1	6	5.7	2.7	2.6
2	1	2	2	2	6.2	5.9	6	5.5
2	1	2	2	2	6.6	6	4.5	4.2
2	1	3	2	3	2.7	6	4.1	3.1
2	1	3	2	3	3.1	6.1	2.4	3.5
2	3	1	2	1	4.2	6.2	7	5.4
2	2	1	2	3	5.4	6.3	6.5	3.2
2	3	2	2	2	2.6	6.3	4.5	3.7
2	2	2	2	1	5	6.4	5.4	4.8
2	1	3	2	3	5.1	6.5	5.5	4.8
2	1	1	2	2	6.2	6.6	5.5	4.1
2	3	3	2	3	7	7	6	4