CHE XXXXXXXXXXFall XXXXXXXXXXExam 3 The part 1 of the exam(problems 1-4) need to be submitted by 5 pm today(11/15). You will turn in part 2(problem 5 and 6) by 5 pm on 11/16(Tuesday). This exam is...

please help with question 5 and 6 only


CHE1311-02 Fall 2021 Exam 3 The part 1 of the exam(problems 1-4) need to be submitted by 5 pm today(11/15). You will turn in part 2(problem 5 and 6) by 5 pm on 11/16(Tuesday). This exam is given under the Honor System and by signing here _________________________, you have agreed that the work submitted is your work alone and that you neither gave nor received help from others on this exam. Part 1 (70%) 1. (20%)Solve the system of two nonlinear equations using Excel solver y + 1 =x2; x2 = 5 – y2 (Make sure to include solver dialog box to show how you do it) Use matrices R and S below for Problems 2 and 3. 2. (15%)Use Excel to calculate the resultant matrix Z = R–1S for matrices R and S above. 3. (15%)Use MATLAB to calculate the resultant matrix Z = R–1S for matrices R and S above. 4. (20%)Solve the following set of equations using MATLAB to determine whether there is no solution, an unique solution or an infinite number of solutions. (In addition to answers, make sure to include checking of rank and number of unknowns’ procedure.) (a) 3x -2y+4z=10 x + z =2 x +5y -4z =-4 (b) 3x+5y+6z=4 x-2y-3z=10 Part 2(30%) 5. (20%)A 400-gallon cylindrical tank is filled with water. When a valve at the bottom of the tank is opened, the flow rate q (in gallons per minute) through the valve is:      where t is the time in minutes. Knowing that the total amount of water through the valve at any time is the integral of this function, use MATLAB to determine the amount of water left in the tank after 15 minutes. You have to use numerical integration using trapezoidal rule with 100 increments. 6. (10%) Use the function normdist created in Example 9.3 in the textbook to evaluate this problem. A population of steel bolts has an average breaking strength of 74,000 lb, with a standard deviation of 2,000 lb. What is the probability that a given bolt will have a breaking strength of less than 67,000 lb?