Tabelas do exel das diferenças finitas, divididas e ajuste de curvas

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

02
	x	y	x*y	x²	yc	(y-yc)²	(y-ym)²
	0.5	-2.8	-1.4	0.25	-2.8	0	1.21
	0.75	-0.6	-0.45	0.5625	-0.6	0	0.36
	1.25	-3.4	-1.85	0.8125	0	1.57
	SQE	SQT
	N=	2
	a= 	8.8	ym=	-1.7	r2=	1
	b=	-7.2
03
	x	y	x*y	x²	yc	(y-yc)²	(y-ym)²
	0.5	-2.8	-1.4	0.25	-2.7	0.01	4
	0.75	-0.6	-0.45	0.5625	-0.8	0.04	0.36
	1	1	1	1	1.1	0.01	1
	2.25	-2.4	-0.85	1.8125	0.06	5.36
	SQE	SQT
	N=	3
	a= 	7.6	ym=	-0.8	r2=	0.9888059701
	b=	-6.5
04
	x	y	x*y	x²	yc	(y-yc)²	(y-ym)²
	0.5	-2.8	-1.4	0.25	-2.36	0.1936	9
	0.75	-0.6	-0.45	0.5625	-0.8971428571	0.0882938776	0.36
	1	1	1	1	0.5657142857	0.1886040816	1
	1.5	3.2	4.8	2.25	3.4914285714	0.0849306122	10.24
	3.75	0.8	3.95	4.0625	0.5554285714	20.6
	SQE	SQT
	N=	4
	a= 	5.8514285714	ym=	0.2	r2=	0.973037448
	b=	-5.2857142857
05
	x	y	x*y	x²	yc	(y-yc)²	(y-ym)²
	0.5	-2.8	-1.4	0.25	-2.0672413793	0.5369351962	15.3664
	0.75	-0.6	-0.45	0.5625	-0.8413793103	0.0582639715	0.36
	1	1	1	1	0.3844827586	0.3788614744	1
	1.5	3.2	4.8	2.25	2.8362068966	0.1323454221	10.24
	2	4.8	9.6	4	5.2879310345	0.2380766944	23.04
	5.75	5.6	13.55	8.0625	1.3444827586	50.0064
	SQE	SQT
	N=	5
	a= 	4.9034482759	ym=	1.12	r2=	0.9731137863
	b=	-4.5189655172
06
	x	y	x*y	x²	yc	(y-yc)²	(y-ym)²
	0.5	-2.8	-1.4	0.25	-1.7803508772	1.0396843336	22.4044444444
	0.75	-0.6	-0.45	0.5625	-0.7192982456	0.0142320714	0.36
	1	1	1	1	0.341754386	0.4332872884	1
	1.5	3.2	4.8	2.25	2.4638596491	0.5419026162	10.24
	2	4.8	9.6	4	4.5859649123	0.0458110188	23.04
	2.5	6	15	6.25	6.7080701754	0.5013633733	36
	8.25	11.6	28.55	14.3125	2.5762807018	93.0444444444
	SQE	SQT
	N=	6
	a= 	4.2442105263	ym=	1.9333333333	r2=	0.9723112893
	b=	-3.9024561404
07
	x	y	x*y	x²	yc	(y-yc)²	(y-ym)²
	0.5	-2.8	-1.4	0.25	-1.5023890785	1.6837941036	29.7804081633
	0.75	-0.6	-0.45	0.5625	-0.5631399317	0.0013586646	0.36
	1	1	1	1	0.376109215	0.3892397116	1
	1.5	3.2	4.8	2.25	2.2546075085	0.8937669629	10.24
	2	4.8	9.6	4	4.133105802	0.4447478713	23.04
	2.5	6	15	6.25	6.0116040956	0.000134655	36
	3	7	21	9	7.8901023891	0.792282263	49
	11.25	18.6	49.55	23.3125	4.2053242321	149.4204081633
	SQE	SQT
	N=	7
	a= 	3.756996587	ym=	2.6571428571	r2=	0.9718557573
	b=	-3.380887372
08
	x	y	x*y	x²	yc	(y-yc)²	(y-ym)²
	0.5	-2.8	-1.4	0.25	-1.2530345472	2.3931021123	37.515625
	0.75	-0.6	-0.45	0.5625	-0.4013071895	0.0394788329	0.36
	1	1	1	1	0.4504201681	0.3020379917	1
	1.5	3.2	4.8	2.25	2.1538748833	1.0943777598	10.24
	2	4.8	9.6	4	3.8573295985	0.8886274859	23.04
	2.5	6	15	6.25	5.5607843137	0.1929104191	36
	3	7	21	9	7.2642390289	0.0698222644	49
	3.5	8	28	12.25	8.9676937442	0.9364311825	64
	14.75	26.6	77.55	35.5625	5.9167880486	221.155625
	SQE	SQT
	N=	8
	a= 	3.4069094304	ym=	3.325	r2=	0.9732460431
	b=	-2.9564892624
09
	x	y	x*y	x²	yc	(y-yc)²	(y-ym)²
	0.5	-2.8	-1.4	0.25	-1.033	3.122289	45.6375308642
	0.75	-0.6	-0.45	0.5625	-0.2453333333	0.1257884444	0.36
	1	1	1	1	0.5423333333	0.2094587778	1
	1.5	3.2	4.8	2.25	2.1176666667	1.1714454444	10.24
	2	4.8	9.6	4	3.693	1.225449	23.04
	2.5	6	15	6.25	5.2683333333	0.5353361111	36
	3	7	21	9	6.8436666667	0.0244401111	49
	3.5	8	28	12.25	8.419	0.175561	64
	4	9	36	16	9.9943333333	0.9886987778	81
	18.75	35.6	113.55	51.5625	7.5784666667	310.2775308642
	SQE	SQT
	N=	9
	a= 	3.1506666667	ym=	3.9555555556	r2=	0.9755751999
	b=	-2.6083333333
10
	x	y	x*y	x²	yc	(y-yc)²	(y-ym)²
	0.5	-2.8	-1.4	0.25	-0.7772967265	4.0913285326	53.4361
	0.75	-0.6	-0.45	0.5625	-0.0530095037	0.299198603	0.36
	1	1	1	1	0.6712777191	0.108058338	1
	1.5	3.2	4.8	2.25	2.1198521647	1.166719346	10.24
	2	4.8	9.6	4	3.5684266103	1.5167730141	23.04
	2.5	6	15	6.25	5.017001056	0.966286924	36
	3	7	21	9	6.4655755016	0.2856095445	49
	3.5	8	28	12.25	7.9141499472	0.0073702316	64
	4	9	36	16	9.3627243928	0.1315689851	81
	4.5	9.5	42.75	20.25	10.8112988384	1.7195046437	90.25
	23.25	45.1	156.3	71.8125	10.2924181626	408.3261
	SQE	SQT
	N=	10
	a= 	2.8971488912	ym=	4.51	r2=	0.9747936315
	b=	-2.2258711721
Plan1
	interpolação: depende da curva e trabalha com modo analitico
	ajuste analisa comportamento dos dados para escolher o grau dos polinomios
	integral numerica 
	trabalha com integrais definidas
	quando não tem solução analitica a solução original é complicada
	problemas de area 
	a ideia de qqr metodo numerico é substituir a funçaõ originall por um polinomio
	a variação de x tem de ser constante.