op2 relatorio 2

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

Plan4
	RESUMO DOS RESULTADOS
	Estatística de regressão
	R múltiplo	0.9928330057
	R-Quadrado	0.9857173772
	R-quadrado ajustado	0.9301618217
	Erro padrão	29.796013386
	Observações	19
	ANOVA
	gl	SQ	MQ	F	F de significação
	Regressão	1	1102892.7283374725	1102892.7283374725	1242.2727301961	0
	Resíduo	18	15980.4434465369	887.8024136965
	Total	19	1118873.1717840096
	Coeficientes	Erro padrão	Stat t	valor-P	95% inferiores	95% superiores	Inferior 95,0%	Superior 95,0%
	Interseção	0	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A	ERROR:#N/A
	50.3	13.152959308	0.373177113	35.2458895504	0	12.3689432876	13.9369753284	12.3689432876	13.9369753284
	RESULTADOS DE RESÍDUOS	RESULTADOS DE PROBABILIDADE
	Observação	Previsto(a) 541,6503476384	Resíduos	Resíduos padrão	Percentil	541.6503476384
	1	572.1537298981	-75.2702122533	-2.5954073364	2.6315789474	61.140457092
	2	474.8218310189	-26.7812963629	-0.9234512695	7.8947368421	69.2911294504
	3	402.4805548249	-3.2897243865	-0.1134336486	13.1578947368	73.3663431072
	4	327.5086867693	26.8973437235	0.9274527219	18.4210526316	77.4414750824
	5	272.2662576756	37.3493251724	1.2878495976	23.6842105263	81.516525376
	6	230.17678789	34.642699614	1.194521897	28.9473684211	93.7411861672
	7	197.29438962	30.86954638	1.064419041	34.2105263158	105.965111824
	8	168.3578791424	31.299573252	1.0792468842	39.4736842105	118.1883023464
	9	144.682552388	26.4644140024	0.912524785	44.7368421053	130.4107577344
	10	126.2684093568	20.4378120192	0.7047203092	50	146.706221376
	11	109.1695622564	21.241195478	0.7324219359	55.2631578947	171.1469663904
	12	93.3860110868	24.8022912596	0.8552127962	60.5263157895	199.6574523944
	13	84.1789395712	21.7861722528	0.7512133898	65.7894736842	228.163936
	14	73.6565721248	20.0846140424	0.6925416187	71.0526315789	264.819487504
	15	68.3953884016	13.1211369744	0.4524325646	76.3157894737	309.615582848
	16	61.8189087476	15.6225663348	0.5386848537	81.5789473684	354.4060304928
	17	55.2424290936	18.1239140136	0.6249343264	86.8421052632	399.1908304384
	18	49.9812453704	19.30988408	0.665827999	92.1052631579	448.040534656
	19	48.6659494396	12.4745076524	0.4301360088	97.3684210526	496.8835176448
Plan1
	t	T_saida_frio (°C)	T_fluido_quente_saida (°C)	Densidade	T_quente_entrada	Q_quente	Variação da temperatura	Media das temperaturas	Cp
	0	7.3	972.40000000000009	82.15	1464.7720872665452	0	82.15	4196.006
	60	6.9	Vazão(m^3/s)	Vazão(Kg/m^3)	1456.9909330391274	-7.4	41.075000000000003	4173.716
	120	7.4	4.3699999999999997E-6	4.2493879999999998E-3	1456.9909330391274	-12.8	41.075000000000003	4173.716
	180	12.8	1456.9909330391274	-18.399999999999999	41.075000000000003	4173.716
	240	18.399999999999999	1456.9909330391274	-25.2	41.075000000000003	4173.716
	300	25.2	D_externo	D_interno	Pi	1456.9909330391274	-30.7	41.075000000000003	4173.716
	360	30.7	6.4000000000000003E-3	3.8999999999999998E-3	3.1415	1456.9909330391274	-35.4	41.075000000000003	4173.716
	420	35.4	Area(m^2)	L	M_diametro	1456.9909330391274	-39.5	41.075000000000003	4173.716
	480	39.5	1.3751916250000001E-2	0.85	5.1500000000000001E-3	1456.9909330391274	-43.1	41.075000000000003	4173.716
	540	43.1	1452.7275307699729	-46.3	41.075000000000003	4161.503
	600	46.3	Coeficiente linear	1452.7275307699729	-49	41.075000000000003	4161.503
	660	49	1452.7275307699729	-50.5	41.075000000000003	4161.503
	720	50.5	U	1452.7275307699729	-53.6	41.075000000000003	4161.503
	780	53.6	0	1452.7275307699729	-55.6	41.075000000000003	4161.503
	840	55.6	1452.7275307699729	-57.3	41.075000000000003	4161.503
	900	57.3	1452.7275307699729	-58.7	41.075000000000003	4161.503
	960	58.7	1452.7275307699729	-60	41.075000000000003	4161.503
	1020	60	1452.7275307699729	-60.9	41.075000000000003	4161.503
	1080	60.9	1452.7275307699729	-62.1	41.075000000000003	4161.503
	1140	62.1	1452.7275307699729	-63	41.075000000000003	4161.503
	1200	63	1452.7275307699729	-63.6	41.075000000000003	4161.503
	1260	63.6	1452.7275307699729	-64.3	41.075000000000003	4161.503
	1320	64.3	1452.7275307699729	-64.900000000000006	41.075000000000003	4161.503
	1380	64.900000000000006	1452.7275307699729	-65.5	41.075000000000003	4161.503
	1440	65.5	1452.7275307699729	-66	41.075000000000003	4161.503
	1500	66	1452.7275307699729	-68	41.075000000000003	4161.503
	1560	68	1452.7275307699729	-67.599999999999994	41.075000000000003	4161.503
	1620	67.599999999999994	1452.7275307699729	-68	41.075000000000003	4161.503
	1680	68	1452.7275307699729	-68.3	41.075000000000003	4161.503
	1740	68.3	1452.7275307699729	-68.599999999999994	41.075000000000003	4161.503
	1800	68.599999999999994	1452.7275307699729	0	41.075000000000003	4161.503
Plan2
	t	T_saida_frio (°C)	T_fluido_quente_saida (°C)	Densidade	T_quente_entrada	Q_quente	Variação da temperatura	Media das temperaturas	Cp
	0	25.5	972.40000000000009	80.400000000000006	0	0	82.15	4196.006
	60	5	Vazão(m^3/s)	Vazão(Kg/m^3)	0	-8.8000000000000007	41.075000000000003	4173.716
	120	8.8000000000000007	0	-17.3	41.075000000000003	4173.716
	180	17.3	0	-22.8	41.075000000000003	4173.716
	240	22.8	0	-29.9	41.075000000000003	4173.716
	300	29.9	D_externo	D_interno	Pi	0	-35.4	41.075000000000003	4173.716
	360	35.4	6.4000000000000003E-3	3.8999999999999998E-3	3.1415	0	-41.2	41.075000000000003	4173.716
	420	41.2	Area(m^2)	L	M_diametro	0	-45.7	41.075000000000003	4173.716
	480	45.7	1.3751916250000001E-2	0.85	5.1500000000000001E-3	0	-49.8	41.075000000000003	4173.716
	540	49.8	0	-53.1	41.075000000000003	4161.503
	600	53.1	Coeficiente linear	0	-56.1	41.075000000000003	4161.503
	660	56.1	0	-58.5	41.075000000000003	4161.503
	720	58.5	U	0	-60.5	41.075000000000003	4161.503
	780	60.5	0	0	-62.4	41.075000000000003	4161.503
	840	62.4	0	-64	41.075000000000003	4161.503
	900	64	0	-65.400000000000006	41.075000000000003	4161.503
	960	65.400000000000006	0	-66.599999999999994	41.075000000000003	4161.503
	1020	66.599999999999994	0	-67.7	41.075000000000003	4161.503
	1080	67.7	0	-68.599999999999994	41.075000000000003	4161.503
	1140	68.599999999999994	0	-69.400000000000006	41.075000000000003	4161.503
	1200	69.400000000000006	0	-70	41.075000000000003	4161.503
	1260	70	0	-70.599999999999994	41.075000000000003	4161.503
	1320	70.599999999999994	0	-71.099999999999994	41.075000000000003	4161.503
	1380	71.099999999999994	0	-71.599999999999994	41.075000000000003	4161.503
	1440	71.599999999999994	0	-72.099999999999994	41.075000000000003	4161.503
	1500	72.099999999999994	0	-72.5	41.075000000000003	4161.503
	1560	72.5	0	-72.8	41.075000000000003	4161.503
	1620	72.8	0	-73	41.075000000000003	4161.503
	1680	73	0	0	41.075000000000003	4161.503
Plan3