Statistics Demographics Key Survey's

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 KEY TO SURVEY
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 Demographics
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 Gender
2 2 1 1 1 5.1 5.2 4.6 6.2 1 Male
2 2 1 1 1 5.8 5.3 5.7 2.3 2 Female
2 2 2 1 2 5.3 4.7 5.6 4.5 Age
2 2 2 1 2 5.9 5.4 5.6 5.4 1 16 - 21
1 2 2 2 2 3.7 6.2 5.5 6.2 2 22 - 49
2 2 1 1 1 5.1 5.2 4.6 6.2 3 50 - 65
2 2 1 1 1 5.8 5.3 5.7 2.3 Department
2 2 2 1 2 5.3 4.7 5.6 4.5 1 Human Resources
2 2 2 1 2 5.9 5.4 5.6 5.4 2 Information Technology
1 2 2 2 2 3.7 6.2 4.6 6.2 3 Administration
1 2 2 2 2 5.5 5.2 5.7 6.2 Position
2 2 2 1 1 5.8 5.3 5.6 5.4 1 Hourly Employee (Overtime Eligible)
2 2 2 1 2 5.3 5.3 5.5 6.2 2 Salaried Employee (No Overtime)
1 1 1 1 1 5.5 4.7 4.6 2.3 Tenure With Company
1 1 2 1 1 5.5 5.3 5.7 2.3 1 Less than 2 years
1 1 2 1 1 3.2 4.7 5.6 4.5 2 2 to 5 years
2 2 2 1 1 5.2 5.5 5.5 5.4 3 Over 5 Years
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 Four Survey Measures
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 SURVEY MEASURE #1 OVERALL JOB SATISFACTION (Scale 1-7)
1 2 2 2 2 3.7 6.2 5.5 6.2 1 = Least Satisfied
2 2 1 1 1 5.1 5.2 4.6 6.2 7 = Most Satisfied
2 2 1 1 1 5.8 5.3 5.7 2.3 SURVEY MEASURE #2 INTRINSIC JOB SATISFACTION (Scale 1-7)
2 2 2 1 2 5.3 4.7 5.6 4.5 1= Least Satisfied
2 2 2 1 2 5.9 5.4 5.6 5.4 7= Most Satisfied
2 2 1 1 1 5.8 5.3 5.7 6.2 SURVEY MEASURE #3 EXTRINSIC JOB SATISFACTION (Scale 1-7)
2 2 2 1 2 5.3 4.7 5.6 2.3 1 = Least Satisfied
2 2 2 1 2 5.9 5.3 5.5 4.5 7 = Most Satisfied
1 2 2 2 2 3.7 4.7 4.6 5.4 SURVEY MEASURE #4 BENEFITS (Scale 1-7)
1 2 2 2 2 5.5 5.5 5.7 6.2 1= Least Satisfied
1 2 2 2 2 5.5 5.2 5.5 6.2 7= Most Satisfied
1 1 2 1 1 3.2 4.7 4.6 5.4
2 2 2 1 1 5.2 5.5 5.7 2.3
2 2 1 1 1 5.1 5.2 5.6 4.5
2 2 1 1 1 5.8 5.3 5.6 5.4
2 2 2 1 2 5.3 4.7 5.5 6.2
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 2 1 2 5.9 5.4 5.6 5.4
2 2 1 1 1 5.8 5.3 5.7 6.2
2 2 2 1 2 5.3 4.7 5.6 2.3
2 2 2 1 2 5.9 5.3 5.5 4.5
1 2 2 2 2 3.7 4.7 4.6 5.4
1 2 2 2 2 5.5 5.5 5.7 6.2
1 2 2 2 2 5.5 5.2 5.5 6.2
1 1 2 1 1 3.2 4.7 4.6 5.4
2 2 2 1 1 5.2 5.5 5.7 2.3

I have attached a sample/example of data to be used to examine two of the nine sections of data:
one section of qualitative data ( Gender)
one section of quantitative data ( Intrinsic)
I would like to see how you work it out so that I can learn from it and do my own.
Identify the data you selected.
Explain why the data was selected.
Explain what was learned by examining these sets of data.
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).
Your analysis should 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.
If a measure is not applicable, then why is it not applicable? I need to better understand this.
I would like to see one 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.chart/graph I also need to see how to label the graph or chart clearly so that it speaks for itself.
It would be good to explain what is actually being said by the graph in words.
Also, why standard deviation and variation are important in this type of analysis.