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 1: Ginny is working as a chemist for a food manufacturing company. She is tasked to perform a sugar content analysis on the 4 types of company products – biscuit brand A, B, C and D. She has completed the sugar content analysis in the 60 biscuits (15 for each brand) and tabulated in Table Q1 as shown in Appendix A. List down all methods/assumptions/values used to solve the following questions.Complete the Table Q1 which consists of 60 biscuits details and use EXCEL to draw a graph for sugar content comparison in 4 different brands and draw conclusion.(5 marks)Refer to part (a) Table Q1, use EXCEL to calculate the average sugar content and standard deviation for the brand A biscuit. If the sugar contents are normally distributed, calculate the probability that a randomly selected brand A biscuit will have sugar content smaller than 19g/100g. Repeat the same calculation for brand B. Compare the answers with manual calculation and draw conclusions.(10 marks)Refer to part (a) Table Q1, the company has decided to reject any biscuit with sugar content greater than 20g/100g. Use EXCEL to calculate the probability that a randomly selected 30 biscuits will have the following :Exactly 18 good biscuits.At least 20 good biscuits.Compare the answer(s) with manual calculation and draw conclusion(s).(10 marks)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. 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 atable. (7 marks) 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) [Total = 50 marks] Rubric for Question 1 Criteria Weightage Outstanding (9-10) Mastering (7-8) Developing (5-6) Beginning (0-4) a. Apply appropriate toolpak to solve problem. 5%Very comprehensive, well-organized, and excellent presentation of the 60 data in a table form, including the graph. All the methods/ assumptions/values used are clearly defined. Mostly comprehensive,clear, and good presentation of the 60 data in a table form, including the graph. Most of the methods/assumptions/valu es used are clearly defined. Some portion of the presentation for the table and/or graph is not clear, or notorganized. Partial methods/assumptions/ values used are defined.Large portion of the presentation for the table and/or graph is not clear or not organized. Few or littlemethods/assumptions/va lues used are defined.b. Apply appropriate toolpak to solve problem. 10%All the calculations and comparisons (EXCEL and manual) are presented in clear, precise, and correct manner. All the assumptions/values and methods used are clearly stated and explained, including the conclusions. Most of the calculations and comparison (EXCEL and manual) are presented in clear and correct manner. Most of the assumptions/values and methods used are clearly stated and explained, including the conclusions. Small portion of the calculations and comparison (EXCEL and manual) are presented in unclear or incorrect manner. Missing some of the assumptions/or unclear values or methods used. Partial explanation for the conclusions. Most of the calculations and comparison (EXCEL and manual) are not clear or incorrect. Missing some of the assumptions or unclear values or methods used, little to no explanation is given for the conclusions..c. Apply appropriate toolpak to solve problem. 10%All the calculations and comparisons (EXCEL and manual) are presented in clear, precise, and correct manner. All the assumptions/values and methods used are clearly stated and explained, including the conclusions. Most of the calculations and comparison (EXCEL and manual) are presented in clear and correct manner. Most of the assumptions/values and methods used are clearly stated and explained, including the conclusions. Small portion of the calculations and comparison (EXCEL and manual) are presented in unclear or incorrect manner. Missing some of the assumptions/or unclear values or methods used. Partial explanation for the conclusions. Most of the calculations and comparison (EXCEL and manual) are not clear or incorrect. Missing some of the assumptions or unclear values or methods used, little to no explanation is given for the conclusions. Rubric for Question 2 Criteria Weightage Outstanding (9-10) Mastering (7-8) Developing (5-6) Beginning (0-4) a. Introduction of the problem statement and the presentation of the data. 7%Excellent tabulation and presentation of data which includes properselection of key variables, arrangement and grouping of data. All the assumptions/values/refe rences and methods used are clearly defined. Mostly comprehensive, clear, and good tabulation and presentation of data, which includes properselection of key variables, arrangement and grouping of data. Most of the assumptions/values/refere nces and methods used are clearly defined. Some portion of the table or presentation of the data is not clear, or not organized, which includes the selection of the key variables, arrangement and grouping of data. Partial assumptions/values/ref erences or methods used are provided. Large portion of the table or presentation of the data is not clear or not organized which includes few or minimum assumptions/values/refe rences or methods used are defined. b. Apply appropriate statistical and probability methods in solving problems. 18%All the calculations and comparisons (EXCEL and manual) are presented in clear, precise, and correct manner. All the assumptions/values and methods used are clearly stated and explained, including the suggestion and conclusions. Most of the calculations and comparison (EXCEL and manual) are presented in clear and correct manner. Most of the assumptions/values and methods used are clearly stated and explained, including the suggestion and conclusions. Small portion of the calculations and comparison (EXCEL and manual) are presented in unclear or incorrect manner. Missing some of the assumptions/or unclear values or methods used. Partial explanation for the suggestion and conclusions. Most of the calculations and comparison (EXCEL and manual) are not clear or incorrect. Missing some of the assumptions or unclear values or methods used, little to no explanation is given for the suggestion and conclusions. Appendix A ( Fill up the empty column) No Brand Sugar content ( g/100g) 1A13.52A14.73A15.74A18.05A22.56A24.27A17.08A14.09A15.010A19.011B15.212B15.513B17.814B17.015B18.016B25.017B21.218B23.419B22.020B16.021C15.022C16.023C18.024C19.025C26.526C21.527C22.528C14.029C25.030C16.531D19.032D14.533D15.534D16.835D17.536D19.537D20.538D22.039D22.540D23.0 59 60
0 comments