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.)
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?
Word and Excel documents show how to apply probability concepts to hiring in email format.
Survey on Population of American Intellectual Union
Details: The data set for our course is a sample of a survey conducted on the population of the American Intellectual Union (AIU). It is available via the following link: DataSet with DataSet Key which contains the following nine sections of data that will be used throughout our course:
(1) Gender (2) Age (3) Department (4) Position (5) Tenure (6) Overall Job Satisfaction (7) Intrinsic Job Satisfaction - Satisfaction with the actual performance of the job (8) Extrinsic Job Satisfaction- Things external to the job, e.g., office location, your work colleagues, your own office (cubicle/hard walled office, etc), and (9) Benefits - Health insurance, pension plan, vacation, sick days, etc.
American Intellectual Union (AIU) has assembled a team of researchers in the United States and around the world to study job satisfaction. Congratulations, you have been selected to participate in this massive global undertaking.
The study will require that you examine data, analyze the results, and share the results with groups of other researchers. Job Satisfaction is important to companies large and small and understanding it provides managers with insights into human behavior that can be used to strengthen the company's bottom line.
You will need to examine two of the nine sections of data, one section of qualitative data and one section of quantitative data, from the provided Unit 1 data set. Each section should include all data points. After analyzing your data, it will be necessary to write up a single concise professional report in Word that includes numerical data and graphs. The requirements include providing the data you selected, discussing why the data was selected and what was learned by examining these sets of data. Your analysis should include using Excel to obtain information about the data through the use of three measures of central tendency (mean, median, mode) and the use of two measures of variability (standard deviation and variance). Some measures are appropriate for qualitative data and some are appropriate for quantitative data. If a measure is not applicable, then explain why. You will have to also provide 1 chart/graph for each of the results of the two processed sections of data (2 total), such as a pie or bar chart or a histogram. (A table is NOT a chart/graph.) Ensure that you label the chart/graph clearly. You will then need to discuss what you additionally learned from the results of this process. Explain why charts/graphs are important in conveying information in a visual format and why standard deviation and variation are important. Finally, you will need to combine all of the items above into one comprehensive report. This report must be completed in Microsoft Word and should contain:
The data selected
Discussion (Why you selected your data and what you learned by examining your selected data set.)
The measures of central tendency and variability. (Copy and paste from your Excel process.)
Summary (what you learned and why the processes are important.)