[Solved]Doll Given Steps Solve Root Equation Two Different Methods Need Demonstrate Functions Meth Q37212009

useExcel and please shoe me the code and the foumleaDOLL You have been given the steps to solve for the root of an equation in two different methods. ОРОЛ You need to demonstrate your functions for each of the methods by finding the root between 1 and 4 using each of the methods Write a function to evaluate your equation. Write a separate function for each of the two methods given. You should solve for the root between 1 and 4 for 4 Your functions should receive 1 and 4 as the limits. Run your functions with an error of 0.01,0.001,0.0001, and 0.00001. Put the results in four different cells. 0 Save your workbook in the LabFinal DropBox. Step 1: Receive xiI, X2, and E from user Xi is the lower estimate of the root, x, is the upper estimate of the root, and E is an error stopping criteria Step 2: Compute f(%) and f(x) and store the results in variables F1 and F2. Step 3: Use a temporary variable named temp. If f(xi) is greater than f(x2) then Set temp to x1, set x1 to x2, set x2 to temp Set temp to F1, set F1 to F2, set F2 to temp Step 4: Calculate root estimate, xn (x1+x2)/2 and also calculate f(xn) and store the result in FN. Step 5: If FN 0 (i.e. positive) then, Set X2 to XN Set F2 to FN else Set X1 to XN Set F1 to FN FN>E then repeat step 4, if not return value of XN Step 6: Step 7: Stop Step 1: Receive x x, and E from user x, is the lower estimate of the root, x, is the upper estimate of the root, and E is an error stopping criteria Step 2: Compute f(xy) and f(xe) and store the results in variables F1 and F2. Step 3: Calculate the next estimate x3 using x3 x1-(x1-x2)/(f(x1)-f(x2))*f(x1) Compute f(x3) and store the result in F3. Step 4: Set x1 to x2 Set x2 to x3 Set F1 to F2 Set F2 to F3 If F3>E then repeat step 3, if not return value of X3. Step 5: Step: Stop Show transcribed image text DOLL You have been given the steps to solve for the root of an equation in two different methods. ОРОЛ You need to demonstrate your functions for each of the methods by finding the root between 1 and 4 using each of the methods Write a function to evaluate your equation. Write a separate function for each of the two methods given. You should solve for the root between 1 and 4 for 4 Your functions should receive 1 and 4 as the limits. Run your functions with an error of 0.01,0.001,0.0001, and 0.00001. Put the results in four different cells. 0 Save your workbook in the LabFinal DropBox.
Step 1: Receive xiI, X2, and E from user Xi is the lower estimate of the root, x, is the upper estimate of the root, and E is an error stopping criteria Step 2: Compute f(%) and f(x) and store the results in variables F1 and F2. Step 3: Use a temporary variable named temp. If f(xi) is greater than f(x2) then Set temp to x1, set x1 to x2, set x2 to temp Set temp to F1, set F1 to F2, set F2 to temp Step 4: Calculate root estimate, xn (x1+x2)/2 and also calculate f(xn) and store the result in FN. Step 5: If FN 0 (i.e. positive) then,
Set X2 to XN Set F2 to FN else Set X1 to XN Set F1 to FN FN>E then repeat step 4, if not return value of XN Step 6: Step 7: Stop
Step 1: Receive x x, and E from user x, is the lower estimate of the root, x, is the upper estimate of the root, and E is an error stopping criteria Step 2: Compute f(xy) and f(xe) and store the results in variables F1 and F2. Step 3: Calculate the next estimate x3 using x3 x1-(x1-x2)/(f(x1)-f(x2))*f(x1) Compute f(x3) and store the result in F3. Step 4: Set x1 to x2 Set x2 to x3 Set F1 to F2 Set F2 to F3 If F3>E then repeat step 3, if not return value of X3. Step 5: Step: Stop