Assignment 2: Analyzing Organizational Archival Data
Scenario:
JetMidWest (JMW) is a successful and rapidly growing
regional airline company with operations in Chicago, Dallas, Denver, and major
destinations in between. The company has been in operation for ten years and
expanded from initial operations in and out of Chicago, which remains its
headquarters today.
The heart of JMW is its Airline Operations Center (AOC) that
comprises four departments, including Maintenance, Crew Services, Dispatch, and
Cargo. The AOC plays a critical role to ensure that the airline’s vision of
being “the first-choice provider to travelers in all of our primary
markets” is achieved.
The airline entered the industry as a low-cost provider and
has survived competition from major airlines, other low-cost carriers entering
the market, and increased fuel prices. As JMW has grown and expanded, a culture
shift occurred. Processes that were sufficient in one market became inadequate
as the airline expanded into other areas. The increased number of flights, new
aircraft types, and operations at a range of airport sizes and types greatly
increased the complexity of operations. The scope of current leaders’
responsibilities expanded quickly, and new leaders were hired from outside the
airline. As one department head put it: “We’ve been running a marathon of
changes for several years now at the speed of a sprint.”
In this tumultuous environment, the executive team of JMW
identified a critical need to investigate the strengths, weaknesses, and needed
changes in the AOC in order to better serve customers in new markets and
prepare for continued future expansion. JMW’s internal Organizational
Development (OD) team conducted an initial round of interviews and focus groups
of employees and managers. Three key themes were identified:
Employee development may be needed for both technical and
interpersonal skills.
Some departments may have more of a technical and
interpersonal skill deficit than others.
Female employees may be more dissatisfied with their jobs in
AOC than male employees.
The OD team and the leadership team of the AOC want to
further validate these qualitative themes with quantitative data analysis. They
have shared some recent corporate data with you from AOC that includes employee
demographic information, recent performance rating data, and general job
satisfaction ratings.
Directions:
For this assignment, you will do the following:
Describe the AOC workforce overall and by department in
terms of diversity, job satisfaction, and technical and interpersonal skills
ratings.
Determine whether employee development is needed for technical
skills.
Determine whether employee development is needed for
interpersonal skills.
Determine whether there is a difference among the
departments in terms of technical skills.
Determine whether there is a difference among the
departments in terms of interpersonal skills.
Determine whether there is a correlation between gender and
job satisfaction.
Report your findings and your conclusion regarding whether
the initial themes are supported by the data.
Make a recommendation as to which of the results presents
the most pressing trouble for JMW and, therefore, should be addressed first.
Make sure to support your recommendation with your data analysis as well as
scholarly literature.
Your final product will be a 4- to 6-page Microsoft Word
document written in APA format and should utilize at least four professional
literature sources. Professional literature may include the Argosy University
online library resources, relevant textbooks, peer-reviewed journal articles,
and websites created by professional organizations, agencies, or institutions
(.edu, .org, and .gov). In addition, you will submit a Microsoft Excel file you
used to conduct all appropriate statistical analyses to help you make your
determinations. Your paper should be written in a clear, concise, and organized
manner; demonstrate ethical scholarship in accurate representation and
attribution of sources; and display accurate spelling, grammar, and punctuation.
Department Gender Ethnicity Age Job Satisfaction 1 2 1 20.00
2.00 1 1 1 26.00 3.00 1 1 1 40.00 2.00 1 1 3 31.00 2.00 1 1 2 32.00 1.00 1 1 4
27.00 3.00 1 1 4 42.00 1.00 1 1 3 28.00 3.00 1 1 3 29.00 2.00 1 1 3 26.00 2.00
1 1 3 27.00 1.00 1 1 1 33.00 2.00 1 1 3 34.00 1.00 1 1 1 35.00 3.00 1 1 1 48.00
1.00 1 2 1 28.00 1.00 1 2 3 29.00 5.00 1 2 3 26.00 2.00 1 2 3 36.00 1.00 1 2 2
44.00 3.00 1 2 1 40.00 4.00 1 2 4 42.00 1.00 1 2 4 29.00 2.00 1 2 1 19.00 4.00
1 2 3 43.00 3.00 2 1 4 21.00 1.00 2 1 4 24.00 1.00 2 1 1 52.00 2.00 2 1 2 51.00
1.00 2 1 2 56.00 1.00 2 1 1 53.00 2.00 2 2 3 27.00 4.00 2 2 3 26.00 4.00 2 2 3
25.00 4.00 2 2 3 18.00 4.00 2 2 4 18.00 3.00 2 2 4 19.00 2.00 2 1 4 20.00 2.00
2 1 3 20.00 3.00 2 1 3 35.00 1.00 2 1 4 23.00 2.00 2 1 3 19.00 2.00 2 1 3 32.00
3.00 2 1 3 34.00 1.00 2 2 3 22.00 3.00 2 2 3 21.00 2.00
2 2 1 38.00 2.00 2 2 1 31.00 2.00 2 2 3 33.00 4.00 2 1 3
39.00 2.00 3 2 3 22.00 5.00 3 2 3 45.00 4.00 3 2 3 42.00 3.00 3 2 1 48.00 1.00
3 2 3 38.00 5.00 3 2 3 39.00 3.00 3 2 3 32.00 2.00 3 2 3 33.00 3.00 3 2 4 49.00
3.00 3 2 4 29.00 4.00 3 2 1 30.00 2.00 3 2 2 37.00 3.00 3 2 2 38.00 4.00 3 2 1
39.00 3.00 3 2 1 31.00 2.00 3 2 4 30.00 5.00 3 2 2 33.00 2.00 3 2 3 37.00 4.00
3 2 4 28.00 3.00 3 2 4 36.00 2.00 3 2 3 43.00 2.00 3 2 4 48.00 3.00 3 2 3 35.00
2.00 3 2 3 21.00 4.00 3 2 3 36.00 3.00 4 1 2 28.00 2.00 4 1 2 42.00 1.00 4 1 1
27.00 2.00 4 1 1 32.00 3.00 4 1 3 24.00 2.00 4 2 3 42.00 3.00 4 2 1 23.00 3.00
4 2 3 22.00 2.00 4 2 3 38.00 2.00 4 1 3 26.00 2.00 4 1 3 33.00 2.00 4 2 3 39.00
4.00 4 2 1 32.00 3.00 4 2 3 33.00 2.00 4 2 1 22.00 5.00 4 2 3 23.00 4.00 4 2 3
25.00 2.00 4 2 3 26.00 4.00
4 2 1 27.00 2.00 4 2 3 28.00 3.00 4 2 2 29.00 4.00 4 2 3
34.00 2.00 4 1 1 25.00 2.00 4 2 1 31.00 3.00 4 2 1 24.00 1.00
Tech Skills – manager ratin Interpersonal Skills – manager
Rating 2.00 1.00 3.00 1.00 2.00 2.00 3.00 1.00 2.00 2.00 3.00 2.00 2.00 1.00
3.00 2.00 2.00 1.00 3.00 1.00 2.00 1.00 3.00 1.00 2.00 1.00 3.00 1.00 2.00 1.00
3.00 1.00 2.00 2.00 3.00 2.00 2.00 1.00 1.00 1.00 2.00 1.00 3.00 2.00 2.00 1.00
2.00 1.00 2.00 2.00 1.00 1.00 1.00 2.00 1.00 2.00 1.00 2.00 1.00 2.00 1.00 2.00
1.00 2.00 1.00 2.00 1.00 2.00 1.00 2.00 1.00 2.00 1.00 2.00 1.00 2.00 2.00 1.00
1.00 2.00 1.00 2.00 2.00 3.00 1.00 2.00 2.00 3.00 1.00 2.00 2.00 3.00
1.00 2.00 1.00 2.00 2.00 2.00 1.00 3.00 1.00 2.00 1.00 2.00
1.00 2.00 1.00 2.00 1.00 2.00 1.00 3.00 1.00 3.00 1.00 1.00 1.00 3.00 1.00 3.00
1.00 3.00 1.00 3.00 1.00 1.00 1.00 3.00 1.00 3.00 1.00 3.00 1.00 2.00 1.00 2.00
1.00 2.00 1.00 2.00 1.00 2.00 1.00 2.00 1.00 2.00 2.00 2.00 2.00 1.00 2.00 1.00
3.00 1.00 2.00 1.00 3.00 1.00 2.00 1.00 3.00 1.00 2.00 1.00 3.00 1.00 2.00 1.00
3.00 2.00 2.00 2.00 3.00 2.00 2.00 2.00 3.00 2.00 2.00 2.00 3.00 2.00 2.00 2.00
3.00 1.00
2.00 1.00 3.00 1.00 2.00 2.00 3.00 2.00 2.00 2.00 3.00 2.00
2.00 3.00
AOC data
