metode numerik (secant)

3
xi xi-1 f(xi) f(xi-1) xi-(xi-1) xi+1 xi fxi 2 0 2 -4 2 1.333333 0.5 -2.28172 1.333333 2 -2.96296 2 -0.66667 1.731343 1 0.126483 1.731343 1.333333 -0.54156 -2.96296 0.39801 1.82036 0.574376 0.035734 1.82036 1.731343 0.211782 -0.54156 0.089016 1.795335 0.596731 -0.00112 1.795335 1.82036 -0.00856 0.211782 -0.02502 1.796307 0.605533 9.36E-06 1.796307 1.795335 -0.00013 -0.00856 0.000972 1.796322 0.605265 2.41E-09 1.796322 1.796307 7.76E-08 -0.00013 1.46E-05 1.796322 0.605267 0 1.796322 1.796322 -7E-13 7.76E-08 -8.9E-09 1.796322 0.605267 0 1.796322 1.796322 0 -7E-13 8.1E-14 1.796322 0.605267 #DIV/0! 1.796322 1.796322 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 1

Upload: herukristianto

Post on 17-Dec-2015

34 views

Category:

Documents


7 download

DESCRIPTION

METODE SECANT

TRANSCRIPT

secantxixi-1f(xi)f(xi-1)xi-(xi-1)xi+1xifxif(xi-1)xi-(xi-1)xi+1e202-421.33333333330.5-2.28171817150.39872127070.50.57437610120.07437610121.33333333332-2.9629629632-0.66666666671.731343283610.1264825948-2.2817181715-0.42562389880.5967305560.4032694441.73134328361.3333333333-0.541555976-2.9629629630.39800995021.82035957380.57437610120.03573443060.12648259480.02235445480.60553319920.0311570981.82035957381.73134328360.2117822888-0.5415559760.08901629021.7953348610.596730556-0.00112338530.03573443060.00880264320.60526490440.00853434841.7953348611.8203595738-0.00856259030.2117822888-0.02502471281.796307320.60553319920.0000093573-0.0011233853-0.00026829480.60526712070.00026607851.796307321.795334861-0.0001265858-0.00856259030.0009724591.79632191220.60526490440.00000000240.00000935730.00000221630.60526712130.00000221691.79632191221.796307320.0000000776-0.00012658580.00001459221.79632190330.6052671207-00.00000000240.00000000060.60526712130.00000000061.79632190331.7963219122-00.0000000776-0.00000000891.79632190330.60526712130-0-00.605267121301.79632190331.79632190330-001.79632190330.6052671213000ERROR:#DIV/0!ERROR:#DIV/0!1.79632190331.7963219033000ERROR:#DIV/0!0.6052671213ERROR:#DIV/0!0ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!1ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

modified secant24.000014.0000160.000479998860.0004799988216001.184028512216001.18402851210077861727011200100778617270112001023540863592074400000000000000000000000000000000102354086359207440000000000000000000000000000000010722981532457528000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001072298153245752800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!ERROR:#NUM!

Sheet3