BUSN9115 assignment on Data Analysis Assignment

You are provided with an Excel file entitled 'BUSN9115 Quantitative Methods assignment data', which is available in FLO now. The data are about salaries of a SAMPLE of employees in a big company in Australia. The main variables include: 'Year', 'Gender', and 'Salary'.

For this assignment we assume that the number of ALL employees in the company is much larger than the number of employees in the sample data provided to you. You need to apply what have you learned in BUSN9115 Quantitative Methods and write a report about your findings after analysing the sample data. It is up to you to decide what should be included in your report, but you may want to consider all or part of the following analyses:

1. Descriptive Statistics measures of location, variability, and shape (you might want to consider measures such as mean, mode, median, percentiles, range, interquartile ranges, standard deviation, variance, histograms, frequency tables, etc.)
2. Confidence interval estimates for the mean/proportion.
3. Changes in (a) gender composition of employees and (b) salaries in the Australian company before and after the outbreak of COVID-19. Note that the 'Year' variable takes on the value of either 2019 or 2020. The first cases of COVID-19 in Australia were identified in late January 2020.

Please note that the finished assignment should be presented as a report with the appropriate measures selected, clearly stated hypotheses, and the associated tests. The assignment must be clearly written; any diagrams, charts, tables, etc. should be clearly labeled and explained in your text and any equations defined and explained. Apart from the statistical analysis, you will also be graded based on the quality of your writing. Your arguments and the clarity with which you explain and illustrate the relevant findings are very important.