Why measure is appropriate for qualitative data

Question

Assignment:

American Intellectual Union (AIU) has assembled a team of researchers in the United States and around the world to study job satisfaction.

You have been selected to participate in this massive global undertaking.

You will need to 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)

What data did you select and why? What have you learned from the sets of data?

Use Microsoft Excel to obtain information about the data through the use of three mean, median, and mode.

Use standard deviation and variance.

Explain if a measure is appropriate for qualitative data or for quantitative data and why.

Include a 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.

Identify anything else learned from the process.

Why are charts/graphs important to convey information? Why are standard deviation and variation are important?

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

Gender	Age	Department	Position	Tenure	Job Satisfaction	Intrinsic	Extrinsic	Benefits
1	1	1	1	3	5.5	5.5	5.5	5.4
1	3	3	1	1	4.9	5.2	4.6	6.2
1	1	2	2	1	5.5	5.3	5.7	2.3
1	1	3	1	1	5.2	4.7	5.6	4.5
1	3	3	1	1	4.9	5.2	4.6	6.2
1	2	2	1	1	5.2	4.7	5.6	4.5
1	2	1	1	2	5.2	4.7	5.6	4.5
1	3	3	1	2	5.5	5.4	5.6	5.4
1	2	2	1	3	5.9	3.7	5.5	6.2
1	1	3	2	1	4.9	5.2	4.6	6.2
1	1	1	1	3	3.2	5.5	5.5	3.5
1	3	3	1	1	4.9	5.2	4.6	6.2
1	1	2	2	1	5.5	5.3	5.7	2.3
1	1	3	1	3	5.2	4.7	5.6	4.5
1	2	2	1	3	5.5	5.5	5.5	5.4
1	3	3	1	1	4.9	5.2	4.6	6.2
1	2	2	1	1	5.2	4.7	5.6	4.5
1	2	2	1	3	5.5	5.4	5.6	5.4
1	1	1	1	3	3.2	5.5	4.6	6.2
1	2	1	1	2	5.2	4.7	5.6	4.5
1	3	3	1	1	4.9	5.2	5.7	6.2
1	1	1	1	2	5.5	5.3	5.6	5.4
1	1	1	1	2	5.5	5.3	5.6	5.4
1	1	1	1	3	5.5	5.5	5.5	5.4
1	3	3	1	1	4.9	5.2	4.6	6.2
1	1	2	2	1	5.5	5.3	5.7	2.3
1	1	3	1	1	5.2	4.7	5.6	4.5
1	3	3	1	1	4.9	5.2	4.6	6.2
1	2	2	1	1	5.2	4.7	5.6	4.5
1	2	1	1	2	5.2	4.7	5.6	4.5
1	3	3	1	2	5.5	5.4	5.6	5.4
1	2	2	1	3	5.9	3.7	5.5	6.2
1	1	3	2	1	4.9	5.2	4.6	6.2
1	1	1	1	3	3.2	5.5	5.5	3.5
1	3	3	1	1	4.9	5.2	4.6	6.2
1	1	3	2	1	5.5	5.3	5.7	2.3
1	1	3	1	3	5.2	4.7	5.6	4.5
1	2	3	1	3	5.5	5.5	5.5	5.4
1	3	2	1	1	4.9	5.2	4.6	6.2
1	2	2	1	1	5.2	4.7	5.6	4.5
1	2	2	1	3	5.5	5.4	5.6	5.4
1	1	3	1	3	3.2	5.5	4.6	6.2
1	2	2	1	2	5.2	4.7	5.6	4.5
1	3	3	1	1	5.5	5.2	5.7	6.2
1	1	1	1	2	5.2	5.3	5.6	5.4
1	3	2	1	1	4.9	5.2	5.7	6.2
1	1	3	1	2	5.2	5.3	5.6	5.4
1	2	1	2	3	5.2	5.3	5.7	2.3
1	2	1	1	1	5.5	5.2	5.6	2.3
1	3	3	1	1	5.9	5.3	5.6	4.5
2	2	3	2	3	4.9	4.7	5.5	5.4
2	2	2	2	1	3.2	5.4	4.6	6.2
2	2	2	1	1	4.9	5.5	5.4	4.5
2	1	2	2	1	5.5	5.3	5.7	2.3
2	1	3	1	1	5.2	4.7	5.6	4.5
2	3	3	1	1	4.9	5.2	4.6	6.2
2	2	2	1	1	5.2	4.7	5.6	4.5
2	2	1	1	2	5.2	4.7	5.6	4.5
2	3	3	1	2	5.5	5.4	5.6	5.4
2	2	2	1	3	5.9	3.7	5.5	6.2
2	1	3	2	1	4.9	5.2	4.6	6.2
2	1	1	1	3	3.2	5.5	5.5	3.5
2	3	3	1	1	4.9	5.2	4.6	6.2
2	1	2	2	1	5.5	5.3	5.7	2.3
2	1	3	1	3	5.2	4.7	5.6	4.5
2	2	2	1	3	5.5	5.5	5.5	5.4
2	3	3	1	1	4.9	5.2	4.6	6.2
2	2	2	1	1	5.2	4.7	5.6	4.5
2	2	2	1	3	5.5	5.4	5.6	5.4
2	1	1	1	3	3.2	5.5	4.6	6.2
2	2	1	1	2	5.2	4.7	5.6	4.5
2	3	3	1	1	4.9	5.2	5.7	6.2
2	1	1	1	2	5.5	5.3	5.6	5.4
2	1	1	1	2	5.5	5.3	5.6	5.4
2	1	1	1	3	5.5	5.5	5.5	5.4
2	3	3	1	1	4.9	5.2	4.6	6.2
2	1	2	2	1	5.5	5.3	5.7	2.3
2	1	3	1	1	5.2	4.7	5.6	4.5
2	3	3	1	1	4.9	5.2	4.6	6.2
2	2	2	1	1	5.2	4.7	5.6	4.5
2	2	1	1	2	5.2	4.7	5.6	4.5
2	3	3	1	2	5.5	5.4	5.6	5.4
2	1	1	1	3	3.2	5.5	5.5	3.5
2	3	3	1	1	4.9	5.2	4.6	6.2
2	1	2	2	1	5.5	5.3	5.7	2.3
2	1	3	1	3	5.2	4.7	5.6	4.5
2	2	2	1	3	5.5	5.5	5.5	5.4
2	3	3	1	1	4.9	5.2	4.6	6.2
2	2	2	1	1	5.2	4.7	5.6	4.5
2	2	2	1	3	5.5	5.4	5.6	5.4
2	1	1	1	3	3.2	5.5	4.6	6.2
2	2	1	1	2	5.2	4.7	5.6	4.5
2	2	2	1	3	5.5	5.5	5.5	5.4
2	3	3	1	1	4.9	5.2	4.6	6.2
2	2	2	1	1	5.2	4.7	5.6	4.5
2	2	2	1	3	5.5	5.4	5.6	5.4
2	1	1	1	3	3.2	5.5	4.6	6.2
2	1	3	1	1	5.2	4.7	5.6	4.5
2	3	3	1	1	4.9	5.2	4.6	6.2
2	2	2	1	1	5.2	4.7	5.6	4.5