Employment variables and intrinsic job satisfaction
Examine two of the nine sections of data:
â-¦one section of qualitative data (choose either Gender or Position)
â-¦one section of quantitative data (choose either Intrinsic or Extrinsic)
â?¢Each section should include all data points listed in the column for the variable. The requirements include:
1.Identify the data you selected.
2.Explain why the data was selected.
3.Explain what was learned by examining these sets of data.
4.Your analysis should include using Microsoft Excel to obtain information about the data through the use of three measures of central tendency (mean, median, mode).
5.Your analysis should also include 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.
6.If a measure is not applicable, then explain why.
7.You will have to also provide one chart/graph for each of the results of the two processed sections of data
8.You will then need to discuss what you additionally learned from the results of this process.
9.Explain why charts/graphs are important in conveying information in a visual format and why standard deviation and variation are important.
This question has the following supporting file(s):
- Copy of DataSetandDataSetKey_1101A.xlsx
Solution Summary
The effects of employment variables, particularly the position of employees, on their intrinsic job satisfaction level was analyzed through statistical tools that include mean, median, mode, standard deviation, and variance. Among the major findings was that the intrinsic job satisfaction levels of salaried employee are more varied than that of the hourly paid employees. The importance of tables and charts in analyzing data was also provided.
This answer includes:
- Plain text
- Cited sources when necessary
- Attached file(s)
- SOLUTIONS 2.docx
- SOLUTION FINAL.xlsx
Active since 2011
Responses 800
Extracted Content from Question Files:
- Copy of DataSetandDataSetKey_1101A.xlsx
Gender Age Department Position Tenure Job Satisfaction Intrinsic Extrinsic Benefits
1 1 3 2 3 5.2 5.5 6.8 1.4
1 1 1 1 3 5.1 5.5 5.5 5.4
1 1 1 1 1 5.8 5.2 4.6 6.2
1 1 2 1 1 5.5 5.3 5.7 2.3
1 1 2 1 1 3.2 4.7 5.6 4.5
2 2 2 1 1 5.2 5.5 5.5 5.4
2 2 1 1 1 5.1 5.2 4.6 6.2
2 2 1 1 1 5.8 5.3 5.7 2.3
2 2 2 1 2 5.3 4.7 5.6 4.5
2 2 2 1 2 5.9 5.4 5.6 5.4
1 2 2 2 2 3.7 6.2 5.5 6.2
2 2 1 1 1 5.1 5.2 4.6 6.2
2 2 1 1 1 5.8 5.3 5.7 2.3
2 2 2 1 2 5.3 4.7 5.6 4.5
2 2 2 1 2 5.9 5.4 5.6 5.4
1 2 2 2 2 3.7 6.2 5.5 6.2
1 2 2 2 2 5.5 5.2 4.6 6.2
2 2 1 1 1 5.8 5.3 5.7 5.4
2 2 2 1 2 5.3 4.7 5.6 6.2
1 1 2 1 1 5.5 5.3 5.7 2.3
1 1 2 1 1 3.2 4.7 5.6 4.5
2 2 2 1 1 5.2 5.5 5.5 5.4
2 2 1 1 1 5.1 5.2 4.6 6.2
2 2 1 1 1 5.8 5.3 5.7 2.3
1 2 2 2 2 3.7 6.2 5.5 6.2
2 2 1 1 1 5.1 5.2 4.6 6.2
2 2 1 1 1 5.8 5.3 5.7 2.3
2 2 2 1 2 5.3 4.7 5.6 4.5
2 2 2 1 2 5.9 5.4 5.6 5.4
1 2 2 2 2 3.7 6.2 5.5 6.2
1 2 2 2 2 5.5 5.2 4.6 6.2
2 2 1 1 1 5.8 5.3 5.7 5.4
2 2 1 1 1 5.8 5.3 5.7 2.3
2 2 2 1 2 5.3 4.7 5.6 4.5
2 2 2 1 2 5.9 5.4 5.6 5.4
1 2 2 2 2 3.7 6.2 5.5 6.2
1 2 2 2 2 5.5 5.2 4.6 6.2
1 2 2 2 2 5.5 5.2 4.6 6.2
KEY TO SURVEY
Demographics
Gender
1 Male
2 Female
Age
1 16 - 21
2 22 - 49
3 50 - 65
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
Four Survey Measures
SURVEY MEASURE #1 OVERALL JOB SATISFACTION (Scale 1-7)
1 = Least Satisfied
7 = Most Satisfied
SURVEY MEASURE #2 INTRINSIC JOB SATISFACTION (Scale 1-7)
1= Least Satisfied
7= Most Satisfied
SURVEY MEASURE #3 EXTRINSIC JOB SATISFACTION (Scale 1-7)
1 = Least Satisfied
7 = Most Satisfied
SURVEY MEASURE #4 BENEFITS (Scale 1-7)
1= Least Satisfied
7= Most Satisfied

"This paper does not meet my expectations, if didnt use the reference that was attached and only vaguely focused on the main point, as to PEST analysis and Porter's 5 Forces analysis would be useful tools for HD executives to help them make wise strategic choices."
"Thank you for your help!"
"Thank you for your thorough response and well made points. I was able to bring in the points you had made to a current project I am working on. It is interesting and sad how quickly ethics gets thrown out the door when managing large projects in the business world."
"thank you"
"Dr. Valdez, Thank you for your assistance, this will get me started in the right direction."