Statistical Analysis of Workforce Demographics and Wages 11405
- Subject Code :
11405
- University :
University of New south Wales Exam Question Bank is not sponsored or endorsed by this college or university.
- Country :
Australia
Template for the calculation questions
It is NOT compulsory to use this template to submit your major assignment. If you want to use this template, you can include it in the appendix of your report. The word count from this template will be excluded from the report's length.
Keep in mind that in your report, you must provide a number, a meaningful title, labels of axes, data labels, and a source of data for each table and chart you use.
The template contains the minimum requirement for the results that you must calculate. You can calculate more measures if you think they help to better interpret, analyse or discuss the other compulsory results.
Question 1
Age (years) |
Wage ($) |
Height (cm) |
||
Male workers |
Mean |
|||
Median |
||||
Standard deviation |
||||
Female workers |
Mean |
|||
Median |
||||
Standard deviation |
||||
All workers |
Mean |
|||
Median |
||||
Standard deviation |
Education Level |
Percentage of workers |
1 received tertiary education |
|
2 vocational education |
|
3 Year 12 only |
|
4 did not finish Year 12 |
|
Total |
|
State |
Percentage of workers |
[1] NSW |
|
[2] VIC |
|
[3] QLD |
|
[4] SA |
|
[5] WA |
|
[6] TAS |
|
[7] NT |
|
[8] ACT |
|
Total |
|
Question 2
- Histogram
Wages ($) |
|
Q1 |
|
Q3 |
|
IQR |
2 standard deviations below the mean |
2 standard deviations above the mean |
Percentage of workers are within 2 standard deviations of the mean |
State |
Average wage ($) |
[6] TAS |
|
[4] SA |
|
[2] VIC |
|
[3] QLD |
|
[1] NSW |
|
[8] ACT |
|
[7] NT |
|
[5] WA |
|
Total (average of the sample) |
|
And a chart of your choice based on the above table.
Age (years) |
Average wage ($) |
Min wage ($) |
Max wage ($) |
If you think other measures should also be calculated, feel free to add more columns. |
<21> |
||||
21-25 |
||||
26-30 |
||||
31-35 |
||||
36-40 |
||||
41-45 |
||||
46-50 |
||||
51-55 |
||||
56-60 |
||||
61-65 |
||||
Total |
|
|
|
|
And a chart of your choice based on the above table. This is to help you describe the pattern.
Question 3
You can use a table and a chart of your choice for this question. An example of a chart is as below.
Education Level |
Average wage $) |
1 received tertiary education |
|
2 vocational education |
|
3 Year 12 only |
|
4 did not finish Year 12 |
|
Total |
|
And a chart of your choice based on the above table.
Question 4
- You need to examine the shape of the distribution for height for male and female workers separately. You can apply the empirical rule for 95% of the observations if the shape is symmetrical.
- Correlation coefficient (r)
r |
Comment on the direction and strength of the simple linear relationship |
|
Whole sample |
||
Male workers |
||
Female workers |
Question 5 - For postgraduate students (Master's degree) of unit 11405 only.
- You need to create a new variable that shows the hourly wage per week first.
Education Level |
Average hourly wage per week ($) |
1 received tertiary education |
|
2 vocational education |
|
3 Year 12 only |
|
4 did not finish Year 12 |
|
Total |
|
