This assignment will test your skill to collect and analyse data to answer a specific business problem. It will also test your understanding and skill to use statistical methods to make inferences about business data and solve business problems, including constructing hypotheses, test them and interpret the findings. Gender gap is the difference between the salary of men and the salary of women. The reasons of gender gap are not only because of discrimination in hiring, but also includes the different industries that women and men are working, as well as many other reasons. By using an edited subset of the sample file from the Australian Taxation Office (ATO), your task is to summarise and analyse several aspects of the salary and occupation of the different gender. In addition, you are also asked to suggest one relevant research question and then collect and analyse a dataset that will answer your research question.
2 TASK DESCRIPTION: WRITTEN REPORT There are two datasets involved in this assignment: Dataset 1 and Dataset 2, detailed below. Dataset 1: You will receive an email that contains a dataset that is specifically allocated to you. This dataset is a subset of 2013-2014 individual sample file, provided by the ATO and has been edited to only include a subset of the cases and variables. The original dataset can be obtained from and it is under the license of Creative Commons Attribution 3.0 Australia. Data dictionary of the edited dataset is given in the following table. Variable Description Values Gender Gender (sex) Female or Male Occ_code Salary/wage occupation code 0 = Occupation not listed/ Occupation not specified 1 = Managers 2 = Professionals 3 = Technicians and Trades Workers 4 = Community and Personal Service Workers 5 = Clerical and Administrative Workers 6 = Sales workers 7 = Machinery operators and drivers 8 = Labourers 9 = Consultants, apprentices and type not specified or not listed Sw_amt Salary/wage amount All numeric Gift_amt Gifts or donation deductions All numeric
Dataset 2: Collect data (e.g. via a survey) that will answer your research question. There is no requirement about the number of variables, sampling methods and sample size, but you need to justify your approaches in Section 1 (see below). Both datasets should be saved in an Excel file (one file, separate worksheets). All data processing should be performed in Excel or Statkey . Prepare a report in a document file (.doc or .docx) which includes all relevant tables and figures, using the following structure: 1. Section 1: Introduction a. Give a brief introduction about the assignment, including your research question. Include a short summary of a related article with a proper citation. b. Dataset 1: Give a short description about this dataset. Is this primary or secondary data? What types of variable(s) is involved? Display the first 5 cases of your dataset. c. Dataset
2: Explain how you collect the data and discuss its limitation (e.g. whether your sample is biased). Is this primary or secondary data? What type of variable(s) is/are involved? You don’t need to display your data in this section. 2. Section 2: Descriptive Statistics Use Dataset 1 a. Using suitable graphical display, describe the relationship between the variables Gender and Occ_code for Dataset 1. Make sure your graph shows the distribution of Gender for each Occ_code. b. Using suitable graphical display, describe the relationship between the variables Gender and Sw_amt. c. Using suitable numerical summary, describe the relationship between the variables Gender and Sw_amt. d. Using suitable graphical display, describe the relationship between the variables Sw_amt and Gift_amt. 3. Section 3: Inferential Statistics Use Dataset 1 a. List top 4 occupation based on median salary and find the proportion of the gender of those top
4 occupation. b. Perform a suitable hypothesis test at a 5% level of significance to test whether the proportion of machinery operators and drivers who are male is more than 80%. c. Perform a suitable hypothesis test at a 5% level of significance to test whether there is a difference in salary amount between gender. Use Dataset 2 d. Perform a suitable statistical analysis on dataset 2 (the one you collected) that will answer your research question. 4. Section 4: Discussion & Conclusion a. What can you conclude from your findings in the previous sections? b. Give a suggestion for further research
3 TASK DESCRIPTION: PRESENTATION/INTERVIEW A presentation/interview for the assignment is scheduled on Week 11, in your allocated tutorial. You do NOT need to prepare a presentation material (e.g. power-point slides), instead, you will be asked to demonstrate and/or explain how you summarised the data and how you performed the analysis. You may be asked to reproduce what you have made in your written report (e.g. generate a chart or numerical summary using Excel or Statkey).