metodos TRABAJO.xlsx

Embed Size (px)

DESCRIPTION

ingenieria

Citation preview

Hoja1METODO SECANTEMETODO DE NEWTONMETODO DE BISECCIONMETODO PUNTO FIJO1XiX(i-1)X(i+1)Es(%)XiX(i+1)xlxuxrf(xl)f(xr)f(xl)*f(xr)abs(ea)Xif(a)f(b)fX(i+1)ab0.98-0.021.20390.81.4650601.30.65-1-0.98653725670.98653725670.65-112.785849184910.6044993730.09429959540.743001.31.2038811420.980.9873-21.93151.46505805971.321770.651.30.975-0.9865372567-0.22367037910.220659162233.330.74303006410.83250.98734223071.2038811420.99200.47341.32176818291.197710.9751.31.1375-0.22367037912.6267202172-0.587519506914.290.83249268620.91170.99203878290.98734223071.00050.84281.19771223091.097660.9751.13751.05625-0.22367037910.7284913861-0.16294194457.690.91171531060.96861.00047113760.99203878291.0000-0.04881.09765740861.031120.9751.056251.015625-0.22367037910.1677068465-0.0375110544.000.9685950330.99440.99998288911.00047113761.00000.00171.03112300641.003900.9751.0156250.9953125-0.2236703791-0.04589848930.01026613252.040.99435650550.99951.00390440251.000070.99531251.0156251.00546875-0.04589848930.0560531409-0.00257275451.010.99954516121.00001.00006762891.000000.99531251.005468751.0004-0.04589848930.0039131236-0.00017960650.511.00000002061.00000Xif(a)f(b)fX(i+1)abXiX(i-1)X(i+1)Es(%)XiX(i+1)xlxuxrf(xl)f(xr)f(xl)*f(xr)abs(ea)30.39125-0.30875-3.5-0.28571428573.014292.93.12323.019033.014292.93.130.391250.050.01956253.01428571433.014233.01904761933.0047-0.47623.014293.0142433.13.050.05-0.1271875-0.0063593751.643.01423469393.014243.00473933653.0190476193.01190.23673.014243.0142433.053.0250.05-0.038046875-0.00190234370.833.01423505773.014243.01186803823.00473933653.0083-0.117633.0253.01250.050.00611328120.00030566410.413.00833116713.01186803823.01010.05863.01253.0253.018750.0061132812-0.0159326172-0.00009740060.213.01009387733.00833116713.0092-0.02913.01253.018753.0156250.0061132812-0.004901123-0.00002996190.103.00921734163.01009387733.00970.01453.01253.0156253.014060.00611328120.00060821530.00000371820.053.0096536973.00921734163.0094-0.00723.00943659163.0096536973.00950.00363.00954464053.00943659163.0095-0.0018

XiX(i-1)X(i+1)Es(%)XiX(i+1)xlxuxrf(xl)f(xr)f(xl)*f(xr)abs(ea)Xif(a)f(b)fX(i+1)ab33.533.3678163.53.39252333.53.25-8-3.17187525.3753.25-82.87521.750.04597701153.39583333.53.3678160923.53.3867200.55823.392523.3876293.253.53.375-3.171875-0.3066406250.97262573243.703.39583333333.3865763.3867197823.3678160923.3876270.02683.387633.3876193.3753.53.4375-0.3066406251.2438964844-0.38142919541.823.38657615283.3877473.38762651643.3867197823.387619-0.00023.387623.3876193.3753.43753.40625-0.3066406250.4586486816-0.14064031840.923.38774695423.3876033.38761905573.38762651643.3876190.00003.3753.406253.390625-0.3066406250.0735206604-0.02254442130.463.38760330413.3876213.3753.3906253.3828125-0.306640625-0.11717939380.03593196250.233.38762099813.3876193.38281253.3906253.38671875-0.1171793938-0.02198439840.00257611850.123.38761881973.3876193.386718753.3906253.388671875-0.02198439840.0257293507-0.00056564430.063.386718753.3886718753.3876953125-0.02198439840.0018627839-0.00004095220.03

4XiX(i-1)X(i+1)Es(%)XiX(i+1)xlxuxrf(xl)f(xr)f(xl)*f(xr)abs(ea)Xif(a)f(b)fX(i+1)ab1.50.51.586051.5121.5-0.5-0.09453489190.04726744591.5-0.50.19314718060.69314718061.44269504091.636385121.58604936691.51.645833.63241.521.75-0.09453489190.0596157879-0.005635772114.291.63638501971.6472201.64583186021.58604936691.648670.17191.51.751.625-0.0945348919-0.01449218420.00137001717.691.64722030491.6485341.64866598321.64583186021.648720.00341.6251.751.6875-0.01449218420.0232481438-0.00033691643.701.64853430641.6486981.64872122221.64866598321.648720.00001.6251.68751.65625-0.01449218420.0045560108-0.00006602651.891.64869791671.6487181.6251.656251.640625-0.0144921842-0.00492273320.00007134120.951.64871835251.6487211.6406251.656251.6484375-0.0049227332-0.00017213040.00000084740.471.6487209061.648721

5XiX(i-1)X(i+1)Es(%)XiX(i+1)xlxuxrf(xl)f(xr)f(xl)*f(xr)abs(ea)Xif(a)f(b)fX(i+1)ab4.544.663594.54.64609454.5-36-8.875319.54.5-3625610.01639344264.645492454.663594.54.64091-0.48894.6460905354.641694.554.75-8.8757.171875-63.6503906255.264.64549180334.6413534.640914.663594474.641590.01464.64169250614.641594.54.754.625-8.875-1.0683593759.48168945312.704.6413529024.6416034.641594.64090591974.641590.00014.64158893414.641594.6254.754.6875-1.0683593752.9968261719-3.2016873361.334.64160287254.6415884.641594.64158560584.64159-0.00004.6254.68754.65625-1.0683593750.950592041-1.01557391880.674.64158799744.6415894.6254.656254.640625-1.068359375-0.06228256230.06654015930.344.64158888344.6415894.6406254.656254.6484375-0.06228256230.4433035851-0.02761008310.174.6406254.64843754.64453125-0.06228256230.1902979016-0.01185224090.084.6406254.644531254.642578125-0.06228256230.0639545396-0.00398325260.044.6406254.6425781254.6416015625-0.06228256230.0008227089-0.00005124040.02

9XiX(i-1)X(i+1)Es(%)XiX(i+1)xlxuxrf(xl)f(xr)f(xl)*f(xr)abs(ea)Xif(a)f(b)fX(i+1)ab0.500.55962010.510.10653065970.10653065970.51-0.6321205588-1.6321205588-0.61269983680.565271010.55961629290.50.567051.31110.510.750.1065306597-0.2776334473-0.029576474333.330.56527131780.5670690.56705080460.55961629290.567140.01630.50.750.6250.1065306597-0.0897385715-0.009559909220.000.56706937350.5671400.56714316430.56705080460.567140.00000.50.6250.56250.10653065970.00728282470.000775844111.110.56714034860.5671430.56250.6250.593750.0072828247-0.0414975498-0.00030221945.260.56714317330.5671430.56250.593750.5781250.0072828247-0.0171758392-0.00012508862.700.56250.5781250.57031250.0072828247-0.0049637604-0.00003615021.370.56250.57031250.566406250.00728282470.0011552020.00000841310.690.566406250.57031250.5683593750.001155202-0.0019053596-0.00000220110.340.566406250.5683593750.56738281250.001155202-0.0003753492-0.00000043360.170.566406250.56738281250.56689453120.0011552020.00038985880.00000045040.090.56689453120.56738281250.56713867190.00038985880.00000723790.00000000280.04

10XiX(i-1)X(i+1)Es(%)XiX(i+1)xlxuxrf(xl)f(xr)f(xl)*f(xr)abs(ea)Xif(a)f(b)fX(i+1)ab1.7512.101591.751.910691.521.75-0.2474949866-0.10898594690.02697347551.75-0.24749498660.09070257320.67639511961.47842580631.9111281.522.101591.751.8788611.85481.91068791841.895631.7521.875-0.1089859469-0.01658578160.00180761716.671.91112763641.8920271.878862.10159019641.893750.78631.89562507461.895491.87521.9375-0.01658578160.0352357191-0.00058441193.231.89202683051.8962171.893751.87885520471.895510.09321.89549427691.895491.8751.93751.90625-0.01658578160.0088639413-0.00014701541.641.89621699821.8953421.895511.89374531791.895490.00091.8751.906251.890625-0.0165857816-0.00397679780.00006595830.831.89534150311.8955261.895491.89551132041.895490.00001.8906251.906251.8984375-0.00397679780.0024146777-0.00000960270.411.89552646311.8954871.8906251.89843751.89453125-0.0039767978-0.00078829310.00000313490.211.89548747731.8954961.894531251.89843751.896484375-0.00078829310.0008113852-0.00000063960.101.89549569871.8954941.894531251.8964843751.8955078125-0.00078829310.0000110941-0.00000000870.051.89549396511.895494

14XiX(i-1)X(i+1)Es(%)XiX(i+1)xlxuxrf(xl)f(xr)f(xl)*f(xr)abs(ea)1.511.727271.51.63158121.5-2-0.6251.251.72727272731.51.607317.46371.63157894741.618181.521.75-0.6250.859375-0.53710937514.29Xif(a)f(b)fX(i+1)ab1.60730755591.72727272731.617120.60671.61818358951.618031.51.751.625-0.6250.041015625-0.02563476567.691.5-2350.21.625000121.61711911671.60730755591.618040.05701.61803400731.618031.51.6251.5625-0.625-0.31030273440.1939392094.001.6251.6167971.61804218521.61711911671.618030.00051.56251.6251.59375-0.3103027344-0.13931274410.04322912541.961.6167968751.6182441.61803398251.61804218521.618030.00001.593751.6251.609375-0.1393127441-0.0503273010.00701123440.971.61824382761.6179981.6093751.6251.6171875-0.050327301-0.00495195390.00024921850.481.61799810121.6180401.61718751.6251.62109375-0.00495195390.0179576278-0.00008892530.241.61804011781.6180331.61718751.621093751.619140625-0.00495195390.0064843073-0.000032110.121.61803294171.6180341.61718751.6191406251.6181640625-0.00495195390.0007615471-0.00000377110.061.61803416761.618034

17XiX(i-1)X(i+1)Es(%)XiX(i+1)xlxuxrf(xl)f(xr)f(xl)*f(xr)abs(ea)0.25-0.75-0.472310.250.03902-0.510.25-0.22942553860.3099039593-0.0710998828-0.47231492420.25-0.163181.89450.03902489030.00140-0.50.25-0.125-0.2294255386-0.10904973340.02501879383.00Xif(a)f(b)fX(i+1)ab-0.163178309-0.47231492420.274031.59550.00139529410.00000-0.1250.250.0625-0.10904973340.0663655678-0.00723714753.000.25-0.22942553861.84147098481.38059768230.72432397420.02553-0.510.2740306387-0.163178309-0.039857.87600.00000194050.00000-0.1250.0625-0.03125-0.1090497334-0.03026835150.00330075573.000.02552913260.00657-0.03985343610.2740306387-0.008583.6445-0.031250.06250.015625-0.03026835150.0158685048-0.00048031353.000.00656770990.00178-0.0085807316-0.03985343610.0003624.6771-0.031250.015625-0.0078125-0.0302683515-0.00775138540.00023462173.000.00177935080.000490.0003624058-0.0085807316-0.00000116.4229-0.00781250.0156250.00390625-0.00775138540.0039214989-0.0000303973.000.00048823180.00013-0.00000313980.0003624058-0.000002759.4945-0.00781250.00390625-0.001953125-0.0077513854-0.00194930910.00001510983.000.00013442110.00004-0.0019531250.003906250.0009765625-0.00194930910.000977516-0.00000190553.000.00003704360.000010.0000102110.0000020XiX(i-1)X(i+1)Es(%)XiX(i+1)xlxuxrf(xl)f(xr)f(xl)*f(xr)abs(ea)0.00000281490.0000010.059.59.999619.810.310.05-0.28598445820.0717689207-0.02052479599.9996110.0510.000000.00399.810.059.925-0.2859844582-0.10744963430.03072892551.26Xif(a)f(b)fX(i+1)ab10.000009.999613001110.000000.00009.92510.059.9875-0.1074496343-0.01792528670.00192606550.6310.05-0.28598445820.43222341451.43641574540.696177275410.00003610849.810.39.987510.0510.01875-0.01792528670.0269006509-0.00048220190.3110.000036108410.00000005339.987510.0187510.003125-0.01792528670.0044823823-0.0000803480.1610.000000053310.00000000019.987510.0031259.9953125-0.0179252867-0.00672277820.00012050770.0810.0000000001109.995312510.0031259.99921875-0.0067227782-0.00112052930.00000753310.049.9992187510.00312510.001171875-0.00112052930.0016808437-0.00000188340.029.9992187510.00117187510.0001953125-0.00112052930.0002801365-0.00000031390.01

25XiX(i-1)X(i+1)Es(%)XiX(i+1)xlxuxrf(xl)f(xr)f(xl)*f(xr)abs(ea)2.5522.553242.52.62.55-0.2731829258-0.0130529320.00356583822.55324207352.552.552450.03112.552.62.575-0.0130529320.1215735671-0.00158689150.97Xif(a)f(b)fX(i+1)ab2.5524480482.55324207352.552450.00002.552.5752.5625-0.0130529320.0538789142-0.00070327780.492.55-0.27318292580.25925736845.32440294170.18781448572.5524522.52.62.552.56252.55625-0.0130529320.0203177356-0.0002652060.242.55245152972.5524492.552.556252.553125-0.0130529320.0036085999-0.00004710280.122.552448932.5524492.552.5531252.5515625-0.013052932-0.0047281150.00006171580.062.55156252.5531252.55234375-0.004728115-0.0005612450.00000265360.032.552343752.5531252.552734375-0.0005612450.0015233055-0.00000085490.022.552343752.5527343752.5525390625-0.0005612450.0004809373-0.00000026990.012.552343752.55253906252.5524414062-0.000561245-0.00004017710.00000002250.00

Hoja2

Hoja3