Question: Subject is numrical analysis .. please just final answer without sloution method and withou explanation 3 If we want to find a root of (1)


3 If we want to find a root of (1) X-COS first, you can enter a value for x in a cell. Then set up another cell for () that would obtain its value for x from the first cell. You can then vary thercell until the cell approaches zero. This process can be further enhanced by using Excel's plotting capabilities to obtain a good initial guess Although Excel does facilitate a trial-and-error approach. It also has two standard tools that can be employed for root location: Goal Seek and Solver. Both these tools can be em- ployed to systematically adjust the initial guesses. Goal Seek is expressly used to drive an equation to a value in our case, zero) by varying a single parameter. B11 -A11-COS(A11) c D F G H 1 values for plot: 2 x 0 2 0.3 -0.37758 5 10.459698 1 6 1.5 1.429263 7 2 2.416147 0 8 9 values for trial and error: 0.5 1 1.5 2 10 11 0.739083.2811 -2 12 your guess is entered in cell ? and your function result in cell ? The Goal Seek dialogue box would be filled out as Goal Seek ? X2 what is written here? NOWN 8 - -1 0 Set cell: To value By changing cell: what is written here? OK Cancel what is written here? What is written By changing cell: I 10 x f(x) 11 0.739085-3.2E-11 12 your guess is entered in cell ? and your function result in cell ? The Goal Seek dialogue box would be filled out as Goal Seek ? x 7 what is written here? Set cell: To yalue: what is written here? By changing cell: 3 OK Cancel what is written here? What is written By changing cell:'.... .? OA) B$115 OB) SA11$ C) A12 OD SA 125 O ESAS F 1 YA 1 14 10.30 1 26 112 15 28 136 33 51 5 13 US 2.125 2018 ORTOK aj- nxy-xy nEx} = (2x) 14 Regrepen im COUR MBS Kre 271719 Ayaka 051582 Standart Oy Om 10 37- ap=j-2 ANOVA 30 21 22 23 Buy Fort Toplam 55 NES F A. 1 AS 043 5.0 153125 2 1.2005) OOH 3 21 BIOS! Kesim 2005/205 / 21 x 0.961429 02600 235313 0.153125 CIBLE Note: comma () are used instead of point in turkish excel * data values are [1 3 4 5 y data values corresponding to x data values are 11 1.2 33 31 What is the lineer regression equation? OA) y=0.02857+0.91429"x B) y=0 2857+0 691429% Cy=0,502857+0.291429 Di 020285719 591-29 257091423
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
