CÁLCULOS ESTATISTICOS AUTOMÁTICOS

Prévia do material em texto

Planilha1
		TABELAS ESTATISTICAS
		DADOS			TABELA COMPLETA						MÉDIAS
		Horas de trinamento(X)	 Chumbo no sangue(mmol/L) (Y)		X	Y	X.Y	X²	Y²		X	Y
		8	0.53		8	0.53	4.24	64	0.2809		6.3	0.442
		10	0.25		10	0.25	2.5	100	0.0625											COLOQUE OS VALORES NAS COLUNAS "X" E "y"
		12	0.34		12	0.34	4.08	144	0.1156		MEDIANA
		5	0.25		5	0.25	1.25	25	0.0625		X	Y
		6	0.29		6	0.29	1.74	36	0.0841		5.5	0.435
		8	0.3		8	0.3	2.4	64	0.09
		2	0.53		2	0.53	1.06	4	0.2809		VARIÂNCIA
		5	0.53		5	0.53	2.65	25	0.2809		X	Y
		4	0.53		4	0.53	2.12	16	0.2809		8.2	0.01362
		3	0.87		3	0.87	2.61	9	0.7569
					0	0	0	0	0		DESVIO PADRÃO
					0	0	0	0	0		X	Y
					0	0	0	0	0		2.8635642127	0.1167047557
					0	0	0	0	0
					0	0	0	0	0		COEFICIENTE DE VARIAÇÃO
					0	0	0	0	0		X	Y
					0	0	0	0	0		45.4534002009	26.4037908794
					0	0	0	0	0
					0	0	0	0	0
					0	0	0	0	0		COEFICIENTE DE CORRELAÇÃO LINEAR
					0	0	0	0	0
					0	0	0	0	0		-0.5761172417
					0	0	0	0	0
	TOTAL	63	4.42	TOTAL	63	4.42	24.65	487	2.2952
8	10	12	5	6	8	2	5	4	3	0.53	0.25	0.34	0.25	0.28999999999999998	0.3	0.53	0.53	0.53	0.87	
IDADE X PULSO
8	10	12	5	6	8	2	0.53	0.25	0.34	0.25	0.28999999999999998	0.3	0.53	8	10	12	5	6	8	2	0.25	8	10	12	5	6	8	2	0.34	8	10	12	5	6	8	2	0.25	8	10	12	5	6	8	2	0.28999999999999998	8	10	12	5	6	8	2	0.3	8	10	12	5	6	8	2	0.53