The business faculty of a public university recorded data on the number of students enrolled in...

90.2K

Verified Solution

Question

Statistics

The business faculty of a public university recorded data on thenumber of students enrolled in the different study majors for theyears 2018 and 2019. These data are useful for the faculty fortheir decision making process with regard to future planning. Thedata are stored in BUSSTUDYMAJORworksheet in the .xls file attached.
Use an appropriate graphical technique or chart to display thepercentage value of the number of enrolment ofthe different study major in 2018. Display the chart.
Use an appropriate graphical technique or chart to compare thenumber of enrolment in 2018 and 2019 of thedifferent study major. Display the chart. Â Â
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 & Explanation Solved by verified expert

4.1 Ratings (680 Votes)

Thisquestion can be solved using MS ExcelAs pequestion percentage enrolment under each study major is to berepresented in a diagramThecategories under study See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

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