CNC - Planilha de Métodos Newton-Bissecção-Cordas

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

Newton-Raphson
	Método de Newton-Raphson
	f(x)=5*x^3-3*x^2+8*x-10	[0,2]
	f'(x)=15*x^2-6*x+8
	n	xn	f(xn)	f'(xn)	f(xn)/f'(xn)
	0	2.0000	34.0000	56.0000	0.6071428571428571
	1	1.3929	8.8338	28.7436	0.30732986782465366
	2	1.0855	1.5449	19.1624	8.0619991448517073E-2
	3	1.0049	0.0837	17.1181	4.890333202821783E-3
	4	1.0000	0.0003	17.0004	1.6950178341326043E-5
	5	1.0000	0.0000	17.0000	2.0280895911099199E-10
	6	1.0000	0.0000	17.0000	0
	7	1.0000	0.0000	17.0000	0
Bissecção
	Método da Bissecção
	f(x)=5*x^3-2*x^2+8*x-10	[0,2]	E=0,001
	|Ea|<E	|Ea|=aproximação atual-aproximação anterior
	f(x1).f(xu)	-380	Tem raíz
	Iteração	x1	xu	f(x1)	f(xu)	xr	f(xr)	f(x1).f(xr)	|Ea|	Obs:
	1	0	2	-10	38	1	1	-10	não	não
	2	0	1	-10	1	0.5	-5.875	58.75	0.5	Continuar
	3	0.5	1	-5.875	1	0.75	-3.015625	17.716796875	0.25	Continuar
	4	0.75	1	-3.015625	1	0.875	-1.181640625	3.563385009765625	0.125	Continuar
	5	0.875	1	-1.181640625	1	0.9375	-0.137939453125	0.1629948616027832	6.25E-2	Continuar
	6	0.9375	1	-0.137939453125	1	0.96875	0.418792724609375	-5.7768039405345917E-2	3.125E-2	Continuar
	7	0.9375	0.96875	-0.137939453125	0.418792724609375	0.953125	0.13742446899414063	-1.8956256099045277E-2	1.5625E-2	Continuar
	8	0.9375	0.953125	-0.137939453125	0.13742446899414063	0.9453125	-1.0008811950683594E-3	1.3806100469082594E-4	7.8125E-3	Continuar
	9	0.9453125	0.953125	-1.0008811950683594E-3	0.13742446899414063	0.94921875	6.8025052547454834E-2	-6.8084995888284539E-5	3.90625E-3	Continuar
	10	0.9453125	0.94921875	-1.0008811950683594E-3	6.8025052547454834E-2	0.947265625	3.3465512096881866E-2	-3.349500174110176E-5	1.953125E-3	Continuar
	11	0.9453125	0.947265625	-1.0008811950683594E-3	3.3465512096881866E-2	0.9462890625	1.622068602591753E-2	-1.6234979614448974E-5	9.765625E-4	Fim
Método das Cordas
	Método das Cordas
	f(x)=5*x^3-2*x^2+8*x-10	[0,2]	E=0,001
	|Ea|<E	|Ea|=aproximação atual-aproximação anterior
	f(x1).f(xu)	-380	Tem raíz
	Iteração	x1	xu	f(x1)	f(xu)	xr	f(xr)	f(x1).f(xr)	|Ea|	Obs:
	1	0	2	-10	38	0.41666666666666669	-6.6521990740740744	66.521990740740748	não	não
	2	0.41666666666666669	2	-6.6521990740740744	38	0.65254863334154145	-4.2419099930077113	28.21802972779146	0.23588196667487477	Continuar
	3	0.65254863334154145	2	-4.2419099930077113	38	0.7878589784056389	-2.4933656151055956	10.576632518938245	0.13531034506409745	Continuar
	4	0.7878589784056389	2	-2.4933656151055956	38	0.86249616150940411	-1.3797770940032308	3.4402887626979766	7.4637183103765214E-2	Continuar
	5	0.86249616150940411	2	-1.3797770940032308	38	0.90235168778482022	-0.73601590212440904	1.0155378825733834	3.9855526275416109E-2	Continuar
	6	0.90235168778482022	2	-0.73601590212440904	38	0.92320790115409679	-0.38465275947346278	0.28311054776850403	2.0856213369276566E-2	Continuar
	7	0.92320790115409679	2	-0.38465275947346278	38	0.93399843910153413	-0.19883656052892817	7.6483031691664427E-2	1.079053794743734E-2	Continuar
	8	0.93399843910153413	2	-0.19883656052892817	38	0.93954730139611342	-0.10219703011434866	2.0320505964208382E-2	5.5488622945792931E-3	Continuar
	9	0.93954730139611342	2	-0.10219703011434866	38	0.94239162862187442	-5.2371569851370481E-2	5.3522189012362234E-3	2.8443272257610008E-3	Continuar
	10	0.94239162862187442	2	-5.2371569851370481E-2	38	0.94384721754871292	-2.6797398385195237E-2	1.4034218213652549E-3	1.4555889268385025E-3	Continuar
	11	0.94384721754871292	2	-2.6797398385195237E-2	38	0.94459148603313114	-1.3700970251429467E-2	3.67150358091264E-4	7.4426848441822013E-4	Fim
	12	0.94459148603313114	2	-1.3700970251429467E-2	38	0.94497187837283747	-7.0022383798828969E-3	9.5937459736193233E-5	3.803923397063258E-4	Fim
	13	0.94497187837283747	2	-7.0022383798828969E-3	38	0.94516625198743554	-3.5779473602204348E-3	2.5053640326936225E-5	1.9437361459806457E-4	Fim
	14	0.94516625198743554	2	-3.5779473602204348E-3	38	1.4725831259937179	13.410153252109097	-4.7980822428535221E-2	0.52741687400628234	Continuar