MTH61304 Engineering Mathematics II Assignment 2 @ 20% Date: 27 May 2022 Due date: 13 June 2022 (Mon, 3 pm) Assignment title: Solve engineering problem using analysis toolpak

MTH61304 Engineering Mathematics II

Assignment 2 @ 20%

Date: 27 May 2022

Due date: 13 June 2022 (Mon, 3 pm)

Assignment title:

Solve engineering problem using analysis toolpak.

Introduction to the assignment:

This is group assignment aiming to use Microsoft EXCEL as analysis toolpak to provide

solution for the following questions. All the answers/steps need to clearly type on the

Word/PDF file and paste the print screen/image of the EXCEL solution as evidence. The

assignment should not exceed 10 pages. Submit the Word/PDF file into the assignment

link in TiMES. Submit the Excel file as supplementary file as well in the assignment link.

Question 2:

Gigi is planning to pursue her dream to be a successful human resource manager working

for multinational company and she wants to do her full-time degree in Malaysia. You as a

cousin, needs to assist Gigi to shortlist at least 4 institutions of higher learning (IHLs) which

is offering human resource related degree programs. List down all the

assumptions/values/methods and references used to solve the following questions.

a. Identify the key variables such as duration, tuition fees, ranking of the IHL, starting

pay of the fresh graduate etc for the shortlisting of the IHLs and tabulated it into a

table. (7 marks)

b. Show how you can 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 Gigi which IHL is most

suitable for her and justify your suggestion.

 (18 marks)