Assignment attached with therubric. Some questions have templates provided to help finish the assignment as shown under each question labeled by hits and notes.
Assignment 2 MATH2114 !" Total points: 16.0 Assignment 2 Due Friday by 17:00 Points 16 Submitting a file upload File types pdf, docx, and, and doc Available 9 Oct at 9:00 - 16 Oct at 17:00 7 days Stats Assignment 2 Rubric Criteria Ratings Pts 0.5 pts 0.5 pts 1.3 pts 0.2 pts 0.5 pts 2.0 pts 2.0 pts 1.0 pts 2.0 pts 0.5 pts 1.0 pts 2.0 pts 1.0 pts 1.0 pts 0.5 pts Submit Assignment Assignment 2 Please download the Lab paper and the supporting spreadsheets, complete the questions in a report. 2020_MATH2114 Stats Assign2.pdf Supporting Excel workbook files: Z Mean_Template.xlsx T Mean_Template.xlsx Sample Size Mean_Template.xlsx CIE sigma known_Template.xlsx CIE sigma unknown_Template.xlsx BMI-Soda Raw data.xlsx t Test_Two-tail_2-sample Assumed EQUAL- VAR template.xlsx Steps for submitting an assignment report: (1) Check if your report is in the PDF format. If not, please save it in a PDF file first. (2) Click on Assignment 2 above to submit the .pdf document by the due time: 5.00 pm Friday, 16th October. NOTE: Late submission WILL NOT be marked unless special consideration is granted by RMIT Special Consideration. When finished, make sure that you click Submit. Optionally, click Save as Draft to save changes and continue working later or click Cancel to quit without saving changes. You are previewing the assignment - your submission will not be saved. # Q1(A) 0.5 Pts Excellent Presented the correct answer in both hand calculation and Excel output. Excellent! 0.3 Pts Good Presented the correct answer in hand calculation, but failed to present Excel output; or vice versa. 0.1 Pts Acceptable Answered the question. However, the answer was incorrect. 0.0 Pts Below Expectation Did not answer the question at all. Q1(B) 0.5 Pts Excellent Presented the correct answer in both hand calculation and Excel output. Well done! 0.3 Pts Good Presented the correct answer in hand calculation, but failed to present Excel output; or vice versa. 0.1 Pts Acceptable Answered the question. However, the answer was incorrect. 0.0 Pts Below Expectation Did not answer the question at all. Q2(A) 1.3 Pts Excellent Constructed and presented both the box- whisker's plot and the normal probability plot correctly. Adequate justification for the normality of data distribution. Excellent! 0.7 Pts Good Constructed the correct box- whisker's plot and the normal probability plot. But the justification for the normality of the data distribution was inadequate. 0.3 Pts Acceptable Answered the question,but neither of the required plots were correct. 0.0 Pts Below Expectation Did not answer the question at all. Q2(B) 0.2 Pts Excellent Presented the correct answers for both sample mean and standard deviation. Good work! 0.1 Pts Good Answered the question, however, only one of the two results (sample mean and standard deviation) was correct. 0.0 Pts Acceptable Answered the question, however, both required results (sample mean and standard deviation) were wrong. 0.0 Pts Below Expectation Did not answer the question at all. Q2(C) 0.5 Pts Excellent Presented the correct answer in either hand calculation or Excel output. Excellent! 0.3 Pts Good Answered the question. However, the answer was partially correct. 0.1 Pts Acceptable Answered the question. However, the answer was completely incorrect. 0.0 Pts Below Expectation Did not answer the question at all. Q2(D) 2.0 Pts Excellent Performed the correct hypothesis testing in both hand calculation and Excel output. The full conclusion was stated properly. Well done! 1.0 Pts Good Performed the correct hypothesis testing in both hand calculation and Excel output. However, the test conclusion was incomplete. 0.6 Pts Acceptable Answered the question. However, part of required information (steps for hypothesis test in both hand calculation and Excel output as well as the full conclusion) was incorrect or missing. 0.0 Pts Below Expectation Did not answer the question at all. Q3 2.0 Pts Excellent Performed the correct hypothesis testing in both hand calculation and Excel output. The full conclusion was stated properly. Excellent! 1.0 Pts Good Performed the correct hypothesis testing in both hand calculation and Excel output. However, the test conclusion was incomplete . 0.5 Pts Acceptable Answered the question. However, part of required information (steps for hypothesis test in both hand calculation and Excel output as well as the full conclusion) was incorrect or missing. 0.0 Pts Below Expectation Did not answer the question at all. Q4(A) 1.0 Pts Excellent Presented the correct hypothesis test statements. Well done! 0.5 Pts Good Only one of the statements is correct (either the null hypothesis statement or the alternative hypothesis statement). 0.2 Pts Acceptable Answered the question, but the hypothesis test statements are incorrect. 0.0 Pts Below Expectation Did not answer the question at all. Q4(B) 2.0 Pts Excellent Presented the correct answer in both hand calculation and Excel output. Well done! 1.0 Pts Good Performed the correct hypothesis testing in manual calculation, but failed to presented Excel output; or vice versa. 0.5 Pts Acceptable Answered the question. However, part of the required information was incorrect. 0.0 Pts Below Expectation Did not answer the question at all. Q4(C) 0.5 Pts Excellent Stated the correct and full conclusion. Well done! 0.2 Pts Good Presented the correct conclusion, but not the full conclusion as required. 0.1 Pts Acceptable Presented a wrong conclusion or an improper conclusion. 0.0 Pts Below Expectation Did not answer the question at all. Q5(A) 1.0 Pts Excellent Presented the correct hypothesis test statements. Well done! 0.6 Pts Good Only one of the statements is correct (either the null hypothesis statement or the alternative hypothesis statement). 0.2 Pts Acceptable Answered the question, but the hypothesis test statements are incorrect. 0.0 Pts Below Expectation Did not answer the question at all. Q5(B) 2.0 Pts Excellent Presented the complete Excel output correctly and stated the conclusion properly. Well done 1.0 Pts Good Presented the required and correct Excel output. However, failed to state the full conclusion or state a wrong conclusion. 0.5 Pts Acceptable Presented the Excel output. However, part of the required information was missing, or incorrect. 0.0 Pts Below Expectation Did not answer the question at all. Q5(C) 1.0 Pts Excellent Presented the required line of best fit plot, with adequate comments. Excellent work! 0.5 Pts Good Presented the required line of best fit plot with comments, but the comments were inadequate. 0.2 Pts Acceptable Presented the required line of best fit plot only. Failed to comment on the plot. 0.0 Pts Below Expectation Did not answer the question at all. Q5(D) 1.0 Pts Excellent Presented the required two plots, with adequate comments. Excellent work! 0.5 Pts Good Presented the required plots with some comments, but inadequate. 0.2 Pts Acceptable Presented the required plots only. Failed to comment on the plots. 0.0 Pts Below Expectation Did not answer the question at all. Q5(E) 0.5 Pts Excellent Presented the correct and complete answer. Well done! 0.3 Pts Good Answered the question correctly. But failed to present the manual work-out. 0.1 Pts Acceptable Answered the question. But the predicted BMI value is incorrect. 0.0 Pts Below Expectation Did not answer the question at all. 9/10/20, 3:32 pm Page 1 of 1 YD Stats Assignments Dr Yan Ding, MATH2114 - Assignment 2 (Stats.) Page 1 of 4 RMIT Classification: Trusted RMIT University, School of Science, Mathematical Sciences Math2114 – Numerical Methods & Statistics for Engineers Assignment 2 (Statistics Module) Due: Friday 5:00 pm 16th October 2020 This assignment contributes 16% towards the assessment for the subject. The Assignment reports should be in the PDF format, and must be individual and submitted online via course Canvas under the tab: Assignments. Late assignments will not be marked, unless a special consideration is granted prior to the due day for a later submission. Instructions: - The following list of questions is based on the material covered in the text book Chapters 7, 8, 9, 10 and 12. Please work through these problems and present your calculations and/or Excel output where required. - You will need to create a Microsoft Word document, copy your Excel output in the form of tables into the word document, or take a screen shot and then insert the image into the word document. - You are also required to present your manually calculated answers to the questions in the report. - At the completions of the report, save it to a .pdf file, then submit it online to the course Canvas site. Question 1 (1 mark) The compressive strength of a concrete is a normally distributed quantity with standard deviation 7.9. In an effort to improve the quality of the concrete compressive strength, measurements were taken on 30 specimens. For these specimens the mean was found to be 56.2. 1a). Find the 95% confidence interval for the mean compressive strength for the concrete based on the sample of 30 specimens. (0.5 marks) 1b). How many specimens should be sampled to be 95% confident that the 95% confidence interval for µ will contain the maximum error of 0.8? (0.5 marks) Hint and Instruction: - (1a) Use the Excel worksheet: CIE sigma known_Template. You may refer to Chapter 8 Excel Guide EG8.1 – EG8.4 In-Depth Excel on page 302 – 303 of the textbook. - (1b) Use the Excel worksheet: Sample Size Mean_Template. You may refer to Chapter 8 Excel Guide EG8.1 – EG8.4 In-Depth Excel on page 302 – 303 of the textbook You are also required to present your manual calculations, using the Standard Normal Probability table (Z table). You may present you calculations either in typeset or hand-written. Question 2 (4 marks) Among 18 patients with mitral stenosis and third heat sounds, the following heart rates were observed (Source: Wm. H. Gamble and P.S.