Question: For questions 1 , and 2 please use an excel spreadsheet to perform calculations and submit your spreadsheet. Use Sheet 1 for question 1 and

For questions 1 , and 2 please use an excel spreadsheet to perform calculations and submit your spreadsheet. Use Sheet 1 for question 1 and Sheet 2 for question 2. Question 3 can be submitted as a screenshot of your workings on paper. 1. ROOTS OF A NON-LINEAR EQUATION 10 1.1 Use bisection method to find the root (s) of the following equation f(x)=xex2usinga=0andb=1 1.2 Use the secant method to find the root (s) of the following equation f(x)=x33x+1 Start with the point x0=1.5 and x1=1.3172 2. FIXED POINT ITERATION VS WEGSTEIN METHOD 10 Use fixed point iteration to find the roots of the following equation. Note the number of iterations required with this method. x3=sinx Now use Wegstein method to find the roots of the same equation. Note the number of iterations you needed for this method. 3. NEWTONS METHOD FOR SYSTEMS OF EQUATIONS 10 1. Use Newtons method to solve the following system of non-linear equations. Show three iterations and clearly show the steps you followed. y=x2+x+0.75y+5xy=x2 Use initial guesses x=y=1.5 Write a short report of your results
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
