Assignment Brief

Purpose:
This case study intends to assess student’s ability to perform a social research on compensation management and find out applicable and useful intelligence for talking informed decision making in the higher education sector specific to state and private university education system. The relevant higher level administrative officials of the university and authorized administrative bodies in higher education sector (Ex: The University grants commission of Sri Lanka) can use business analytics to generate maximum efficiency and benefits on compensation management of academic staffs’ of universities while eliminating discrimination.

Tasks Introduction
Understand the given case study based on XYZ University situated in New York, United States of America (USA) and apply relevant tools, techniques and methodologies relevant to the module scope and conduct a research on case study with the support of sources of data provided in comma separated (.csv) file format. The research data analysis and visual demonstration required to be conducted using standard software tools recommended for the module (R/ R studio). The research should comprise of descriptive business statistics and inferential business statistics related to the field of business analytics to generate and justify findings related to the tasks of the assignment.

Case study
XYZ University lecturer compensation management study
XYZ University is one of the most reputed universities located in heart of the New York City providing higher education over 10,000 students at present based on engineering sciences and bio medical sciences. The university has been recognized as one of the top 5 universities in the world consecutively for last 5 years according to the global university ranking.
The university comprises of state of the art facilities for world first class education delivery and research purposes of the students. The university students are provided with professional industry exposure via best government and private sector institutions and companies. In order to develop students’ extra curriculum activities such as sport and entertainment, varieties of special facilities have been provided by the management of the university such as Gymnasiums, Indoor and outdoor stadiums, grounds, swimming pools, Drama Theaters and music studios.
Apart from all above mentioned facilities the XYZ University comprises of well qualified, highly experienced academic panel of over 300 lecturers belong to four different levels such as professor, associate professor and assistant professor. It is believed that the university strength, success and students attraction mainly due to the best education and assistance provided by the faculty. The management of the university always gives priority for the development of the quality and the satisfaction of the academics therefore they provide maximum support to enhance quality of education and research within the campus that uplift the competitive advantage of the university over rest of the other universities operated in the United Sates specifically.
The university management is seeking a sophisticated mechanism using business analytics to predict the future requirements of the university as well as optimize the present operation efficiency in all departments attached to the university. The department of human resource has been considered as one of the prioritized departments to advance on the new initiation. The management is considering to have full scale of business analytics support to develop essential business intelligence required for academics’ compensation management.
The university management has appointed a panel of experts in the field of Business Analytics and data science to provide necessary recommendation to standardize compensation and reward mechanism of the academics. Assume that you are one of the data scientists in the panel who has been assigned with a special set of tasks to accomplish and provide a report to the panel by the head of the panel. You are required to complete the below mentioned tasks and prepare a report based on the findings.

Task 1 – Report
Write a report approximately with 3000 words covering the following areas based on the case study provided.
a) Provide a brief explanation about possible advantages generated by business analytics in higher education sector problem solving specific to university education system.

b) Find out whether or not lecturer salaries, lecturer years of service and lecturer years since Phd comply with normal distribution pattern using normality tests using suitable hypothesis. Include the results of the finding along with the sub conclusion using normality tests; Shapiro-Wilk Test, Anderson-Darling Test and Lilliefors-Test supported by Monte Carlo graphical simulations.

c) Clearly justify whether or not lecturers’ salary mean values and salary variances are different with respect to their positions using one way Analysis of Variance (ANOVA) supported by suitable hypothesis and boxplot analysis .

d) Clearly justify whether or not there are relationship can be identify between lecturer salary –lecturer years of service, lecturer salary- lecturer years since Phd and lecturer salary-lecturer rank using correlation analysis supported by suitable hypothesis.

e) Using the finding of the research conducted, develop a well explained statistical model to predict precisely the salary required to be offered based on lecturer rank, lecturer years of service and lecturer years since Phd using statistical regression analysis followed by explanation of the resulting model.

f) Provide final conclusion(s) of the research followed by recommendations based on the findings of data analysis.

Guidelines for the report format
• Paper A4
• Margins 1.5” left, 1” right, top and bottom
• Page numbers – bottom, right
• Line spacing 1.5
• Font
o Headings 14pt, Bold
o Normal 12pt
o Font face- Times New Roman
• Referencing and in-text citation should be done strictly using Harvard Referencing System.

Assignment Brief Purpose: This case study intends to assess st...