newton raphson model using excel

2
x f(x) 0 -12 0.1 -10.469 0.2 -9.072 0.3 -7.803 0.4 -6.656 0.5 -5.625 0.6 -4.704 0.7 -3.887 0.8 -3.168 0.9 -2.541 1 -2 x f(x) 1.9 -0.011 2 0 2.1 -0.009 2.2 -0.032 2.3 -0.063 2.4 -0.096 2.5 -0.125 2.6 -0.144 2.7 -0.147 2.8 -0.128 2.9 -0.081 3 0 3.1 0.121 3.2 0.288 3.3 0.507 f(x)=0 and x=2 (double root) and at x=3 1.8 2 2.2 2.4 2.6 2.8 3 -0.2 -0.1 0 0.1 0.2 0.3 0.4 0.5 0.6 f(x)= x³-7x²+16x-12 x f(x)

Upload: muhammad-farhan-gul

Post on 09-Dec-2015

7 views

Category:

Documents


3 download

DESCRIPTION

Newton Raphson Model Using Excel

TRANSCRIPT

Page 1: Newton Raphson Model Using Excel

x f(x)0 -12

0.1 -10.4690.2 -9.0720.3 -7.8030.4 -6.6560.5 -5.6250.6 -4.7040.7 -3.8870.8 -3.1680.9 -2.541

1 -2

x f(x)1.9 -0.011

2 02.1 -0.0092.2 -0.0322.3 -0.0632.4 -0.0962.5 -0.1252.6 -0.1442.7 -0.1472.8 -0.1282.9 -0.081

3 03.1 0.1213.2 0.2883.3 0.507

f(x)=0 and x=2 (double root) and at x=3

1.8 2 2.2 2.4 2.6 2.8 3 3.2 3.4

-0.2

-0.1

0

0.1

0.2

0.3

0.4

0.5

0.6

f(x)= x³-7x²+16x-12

x

f(x)

Page 2: Newton Raphson Model Using Excel

1.8 2 2.2 2.4 2.6 2.8 3 3.2 3.4

-0.2

-0.1

0

0.1

0.2

0.3

0.4

0.5

0.6

f(x)= x³-7x²+16x-12

x

f(x)