Scribd Logo
Upload

Welcome to Scribd!

  • 6 views

    Division Sintetica Excel

    Uploaded by

    ismael dominguez
    The document contains two examples of numerical methods for finding the roots of functions. The first uses Newton's method to find the root of f(x)=4x^2-5x near x=1. The second uses Newton's method to find the root of f(x)=1/x-2x near x=0.5. Both examples show the iterative process of calculating successive approximations that converge on the root.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Division Sintetica Excel

    Uploaded by

    ismael dominguez
    6 views4 pages
    The document contains two examples of numerical methods for finding the roots of functions. The first uses Newton's method to find the root of f(x)=4x^2-5x near x=1. The second uses Newton's method to find the root of f(x)=1/x-2x near x=0.5. Both examples show the iterative process of calculating successive approximations that converge on the root.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains two examples of numerical methods for finding the roots of functions. The first uses Newton's method to find the root of f(x)=4x^2-5x near x=1. The second uses Newton's method to find the root of f(x)=1/x-2x near x=0.5. Both examples show the iterative process of calculating successive approximations that converge on the root.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    6 views4 pages

    Division Sintetica Excel

    Uploaded by

    ismael dominguez
    The document contains two examples of numerical methods for finding the roots of functions. The first uses Newton's method to find the root of f(x)=4x^2-5x near x=1. The second uses Newton's method to find the root of f(x)=1/x-2x near x=0.5. Both examples show the iterative process of calculating successive approximations that converge on the root.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 4

    x 2 -1 -3

    -3 2 -7 18
    -2 2 -5 7
    -1 2 -3 0
    0 2 -1 -3
    1 2 1 -2
    2 2 3 3
    3 2 5 12

    x 9 6 3
    -3 9 -21 66
    -2 9 -12 27
    -1 9 -3 6
    0 9 6 3
    1 9 15 18
    2 9 24 51
    3 9 33 102

    f(x)= 4x^2-5x

    ITERACIONES Xi Xu F(x)i
    1 1 1.6 -1
    2 1.00000 1.30000 -1.00000
    3 1.15000 1.30000 -0.46000
    4 1.22500 1.30000 -0.12250
    5 1.22500 1.26250 -0.12250
    6 1.24375 1.26250 -0.03109
    7 1.24375 1.25313 -0.03109
    8 1.24844 1.25313 -0.00780
    9 1.24844 1.25078 -0.00780
    10 1.24961 1.25078 -0.00195
    11 1.24961 1.25020 -0.00195
    12 1.24990 1.25020 -0.00049
    13 1.24990 1.25005 -0.00049
    14 1.24998 1.25005 -0.00012
    15 1.24998 1.25001 -0.00012
    16 1.24999 1.25001 -0.00003
    17 1.24999 1.25000 -0.00003
    18 1.25000 1.25000 -0.00001
    19 1.25000 1.25000 -0.00001
    20 1.25000 1.25000 0.00000

    f(x)= 1/x-2x

    ITERACIONES Xi Xu F(x)i
    1 0.5 1 1
    2 0.50000 0.75000 -1.50000
    3 0.62500 0.75000 -1.56250
    4 0.68750 0.75000 -1.54688
    5 0.71875 0.75000 -1.52734
    6 0.73438 0.75000 -1.51465
    7 0.74219 0.75000 -1.50757
    8 0.74609 0.75000 -1.50385
    9 0.74805 0.75000 -1.50194
    10 0.74902 0.75000 -1.50097
    11 0.74951 0.75000 -1.50049
    12 0.74976 0.75000 -1.50024
    13 0.74988 0.75000 -1.50012
    14 0.74994 0.75000 -1.50006
    15 0.74997 0.75000 -1.50003
    16 0.74998 0.75000 -1.50002
    17 0.74999 0.75000 -1.50001
    18 0.75000 0.75000 -1.50000
    19 0.75000 0.75000 -1.50000
    20 0.75000 0.75000 -1.50000
    -7 9
    -61 192
    -21 51
    -7 16
    -7 9
    -9 0
    -1 7
    29 96

    Xi=1
    Xu=1.6

    F(x)u m f(m) f(i)*f(m) Error


    15.24 1.3 0.26 -0.26
    11.76000 1.15000 -0.46000 0.46000 0.13043
    9.06000 1.22500 -0.12250 0.05635 0.06122
    7.37250 1.26250 0.06313 -0.00773 0.02970
    6.98812 1.24375 -0.03109 0.00381 0.01508
    6.53109 1.25313 0.01566 -0.00049 0.00748
    6.43676 1.24844 -0.00780 0.00024 0.00375
    6.32030 1.25078 0.00391 -0.00003 0.00187
    6.29683 1.24961 -0.00195 0.00002 0.00094
    6.26758 1.25020 0.00098 0.00000 0.00047
    6.26172 1.24990 -0.00049 0.00000 0.00023
    6.25439 1.25005 0.00024 0.00000 0.00012
    6.25293 1.24998 -0.00012 0.00000 0.00006
    6.25110 1.25001 0.00006 0.00000 0.00003
    6.25073 1.24999 -0.00003 0.00000 0.00001
    6.25027 1.25000 0.00002 0.00000 0.00001
    6.25018 1.25000 -0.00001 0.00000 0.00000
    6.25007 1.25000 0.00000 0.00000 0.00000
    6.25005 1.25000 0.00000 0.00000 0.00000
    6.25002 1.25000 0.00000 0.00000 0.00000

    Xi=0.5
    Xu=1

    F(x)u m f(m) f(i)*f(m) Error


    -3 0.75 -1.5 -1.5
    9.75000 0.62500 -1.56250 2.34375 0.20000
    10.06250 0.68750 -1.54688 2.41699 0.09091
    9.98438 0.71875 -1.52734 2.36261 0.04348
    9.88672 0.73438 -1.51465 2.31339 0.02128
    9.82324 0.74219 -1.50757 2.28344 0.01053
    9.78784 0.74609 -1.50385 2.26715 0.00524
    9.76923 0.74805 -1.50194 2.25868 0.00261
    9.75969 0.74902 -1.50097 2.25437 0.00130
    9.75486 0.74951 -1.50049 2.25219 0.00065
    9.75244 0.74976 -1.50024 2.25110 0.00033
    9.75122 0.74988 -1.50012 2.25055 0.00016
    9.75061 0.74994 -1.50006 2.25027 0.00008
    9.75031 0.74997 -1.50003 2.25014 0.00004
    9.75015 0.74998 -1.50002 2.25007 0.00002
    9.75008 0.74999 -1.50001 2.25003 0.00001
    9.75004 0.75000 -1.50000 2.25002 0.00001
    9.75002 0.75000 -1.50000 2.25001 0.00000
    9.75001 0.75000 -1.50000 2.25000 0.00000
    9.75000 0.75000 -1.50000 2.25000 0.00000

    You might also like