Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Could you state on how to put this in the excel cell. Using the following methods, determine the real roots of f(x)=2x311.1x226.75x+70.6 1. a) Rearrange

image text in transcribedCould you state on how to put this in the excel cell.

Using the following methods, determine the real roots of f(x)=2x311.1x226.75x+70.6 1. a) Rearrange the original function [with f(x)=0 ] to find three iterative functions for x. Call them g1(x),g2(x), and g3(x). Use successive substitution (also known as fixed-point iteration) to solve for the roots in Excel: b) Use initial guesses of x=1 for each of the iterative functions. How many iterations does it take each function to converge to an error of less than 0.0001 ? Do they all converge? What are the values of the roots found? c) Use initial guesses of x=3 for each of the iterative functions given. How many iterations does it take each function to converge to an error of less than 0.0001 ? Do they all converge? What are the values of the roots found

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Surfactant Based Separations Science And Technology

Authors: John F. Scamehorn, Jeffrey H. Harwell

1st Edition

0841236186, 978-0841236189

More Books

Students also viewed these Chemical Engineering questions

Question

What is a verb?

Answered: 1 week ago