Question

The business faculty of a public university recorded data on the number of students enrolled in the different study majors for the years 2018 and 2019. These data are useful for the faculty for their decision making process with regard to future planning. The data are stored in BUSSTUDYMAJOR worksheet in the .xls file attached.

1. Use an appropriate graphical technique or chart to compare the number of enrolment in 2018 and 2019 of the different study major. Display the chart.  

BUSSTUDYMAJOR worksheet details:

Study Major	2018	2019
Business Analytics	95	105
Employment Relations	335	360
Human Resource Management	650	630
Logistic	285	230
Management	810	820
Marketing	750	735
Strategic Management	135	150
Tourism	453	470

Answer 1

The chart for comparing the number of enrolments in 2018 and 2019 of the different study major is as follows

Cearly from the Chart, Number of enrolments in 2019 have increased in Tourism, Stategic Management, Management, Employment Relations and Business Analytics Majors when compared to 2018.

Number of enrolments in 2019 have decreased in Marketing, Logistic, Human Resource Management Majors when compared to 2018.

So 3 of the majors have registered lower enrolments in 2019 when compared to 2018 which needs to looked upon