Case Study: Use of regression model in human resource models Assignment Task 1 T

Case Study: Use of regression model in human resource models
Assignment Task 1
Through Microsoft Excel, Use the data attached and perform following tasks
1. Build a theory of wages and variables mentioned in the data. How are variables related to monthly income (positive or negative) and why? What does the literature conclude?
2. Calculate mean and median of the variables and interpret your results.
3. Run a regression and explain the results by looking at the signs and statistical significance of coefficients?
4. Does your signs and significance are in line with theory? If not, what could be the reason?
5. What would be your recommendation to the Saudi Ministry of Labour to improve the well-being of workers based on your findings?