Mod - 01 lec - 08 successive substitution method and ...
www.allreadable.com/a85f7re6Yesterday Vinay askedme a question, when I try to plot all this on excel, I think some people misunderstood as me you employing the successive substitution method on excel. There is no way of, I do not know of any way of employing the successive substitution on excel.What they did yesterday, just plotting of the two curves and intersection.
S-A.1. ADVANCED FEATURES IN EXCEL
chethermo.net › files › docSuccessive substitution works by using f(x) to generate a new value of x and then substituting back into f(x). The technique will converge only if |f'(x)| < 1 at the value of x guessed. For the present example, there are two solutions: x ={0.652536, 2.37512}. To begin, enter the table into Excel. Then for Eqn. A, enter into B1, = exp(0.75*B2)/2.5.