1 723 Conditions for promotions 5 Years of service (Years) 6 Psychometric test (%) Required: a) LIST OF EMPLOYEES FOR PROMOTION 9 Names of employees Years of service 10 Munawarah Ali 11 Amiruddin Atan 12 Yuslina Amran 13 Norazlina Abu 14 Pang Poh Yee 15 Sithalechumy 16 Mardhiah Ibrahim b) 3 80 4 3 5 4 2 4 1 Percentage qualified employees Results for psychometric test (%) State the formulas used in the following cells. i. D10 ii. What is the decision in cell D15? State a formula in cell D5 (answers must be in %) (b) Decisions to give promotion? 85 QUALIFIED NOT QUALIFIED 72 88 QUALIFIED 67 NOT QUALIFIED 76 NOT QUALIFIED 55 (a)ii 87 NOT QUALIFIED [3 marks]