BUSINESS ANALYTICS
ASSESSMENT 3 – REPORT (50%)
Instructions
You work as a business analyst in a small boutique consulting firm. One of your clients has
hired you to write a brief report on whether there is a gender wage gap in their organization
and, if so, what policies could be introduced to reduce the gap. Your client has provided you
with an Excel spreadsheet <wages and gender> that contains a sample of 533 observations
for each of the following variables:

Using the Excel data file, prepare a 1500 word report using the following structure as
requested by your client:
Purpose (5 marks)
The report’s purpose needs to be clearly and concisely stated in this section.
Background (10 marks)
In this section, write a brief overview of the gender wage gap literature.
Method (5 marks)
In this section, you need to provide an overview of the empirical approach used to examine
the gender wage gap.
Results (15 marks)
In this section, you need to present and summarize the results from your statistical analysis.
Your client has requested that you:
• Provide a descriptive analysis of the two variables
• Estimate the hourly gender wage gap
• Conduct a pooled-variance t-test for the difference between two means
• Conduct a separate-variances t-test for the difference between two means.
Discussion (10 marks)
In this section, you should provide a summary of the key findings. What are the key strengths
and limitations of this analysis? (e.g., data, method, etc.). What caveats would you place on
your analysis? How do the results from your analysis compare with other studies? Do these
findings have clear policy implications for your client? What policies could be implemented
to reduce the gender wage gap?
6. Recommendation (5 marks).
Based on your analysis, please provide your client with a clear recommendation.
Please ensure that your report is submitted as a single file.