Is there an imbalance between how much female staff are paid and how much male staff are paid

In this assessment task, you will undertake an exploratory data analysis in the role of a consultant. The task is designed to test your R skills. You must present your findings, supported by data visualisations, in the form of a written report.

Workload

This task should take you 10 – 14 hours to complete.

Instructions

A pharmaceutical company called Globex Pharma has contracted your consulting company to investigate their firm’s workforce. Recently there has been some staff turnover at Globex, and the leadership team is aware of rumours that dissatisfied employees are seeking job opportunities elsewhere.

As it happens, the firm’s employees have recently completed a survey (within the last year) measuring various attributes of them and their jobs. Here are the results of that survey, and an explanation of the variables in the data set:

File

employees.csv

File

Dictionary.csv

Globex wants you to use this data to identify factors that might be causing staff discontent.

They would like you to submit a short report in which you consider three possible causes and draw a conclusion about each, supporting your conclusions with appropriate calculations and visualisations.

You should do the following:

Identify three research questions about the data. These should be questions about possible causes of staff discontent. For example: “Is there an imbalance between how much female staff are paid and how much male staff are paid”? Or: “Are single staff doing a disproportionate amount of overtime and not maintaining a healthy work-life balance”?

Try to answer each question by analysing the data. Explore ways of visualising the data that might help to answer each question, and perform any necessary calculations.