Question 2 Harry is a sales advisor for a car company, and he is exploring new potential customers. He is interested to

[answerhappygod]

Question 2 Harry Is A Sales Advisor For A Car Company And He Is Exploring New Potential Customers He Is Interested To 1 (108.08 KiB) Viewed 73 times

Question 2 Harry is a sales advisor for a car company, and he is exploring new potential customers. He is interested to know the graduate engineer salary in Malaysia, as each year the local institutions of higher learning will produce about 16000 engineers. (ref: https://news.ump.edu.my/experts/malaysi ... -engineers) List down all the assumptions/values/methods and references used to solve this question. a. You need to assist Harry in the data collection for the graduates' salary with background from the most common engineering courses. Identify the key variables for the trend analysis, which including the graduate's qualification/background, working experience, industry that is hiring etc. Compile the data and tabulate it using EXCEL. (7 marks) . b. Show how can you apply the statistical toolpak and probability toolpak in EXCEL for the data analysis and draw meaningful conclusions based on the data that you have collected in part (a). You need to compare the EXCEL result with manual calculation. Refer to your own significant findings, suggest to Harry, which type of fresh graduate will have a better financial ability to purchase a new car and after 5 years of working, which type of graduate engineer will be more likely to upgrade their car. Justify your suggestion. (18 marks) [Q2:25 marks)