Exercício de estatística

Prévia do material em texto

Sheet1
	Id	Turma	Sexo	Idade	Alt	Peso	Filhos	Fuma	Toler	Exerc	Cine	OpCine	TV	OpTV	IMC
	1	A	F	17	1.60	60.5	2	NAO	P	0	1	B	16	R	23.6
	2	A	F	18	1.69	55.0	1	NAO	M	0	1	B	7	R	19.3
	3	A	M	18	1.85	72.8	2	NAO	P	5	2	M	15	R	21.3
	4	A	M	25	1.85	80.9	2	NAO	P	5	2	B	20	R	23.6
	5	A	F	19	1.58	55.0	1	NAO	M	2	2	B	5	R	22.0
	6	A	M	19	1.76	60.0	3	NAO	M	2	1	B	2	R	19.4
	7	A	F	20	1.60	58.0	1	NAO	P	3	1	B	7	R	22.7
	8	A	F	18	1.64	47.0	1	SIM	I	2	2	M	10	R	17.5
	9	A	F	18	1.62	57.8	3	NAO	M	3	3	M	12	R	22.0
	10	A	F	17	1.64	58.0	2	NAO	M	2	2	M	10	R	21.6
	11	A	F	18	1.72	70.0	1	SIM	I	10	2	B	8	N	23.7
	12	A	F	18	1.66	54.0	3	NAO	M	0	2	B	0	R	19.6
	13	A	F	21	1.70	58.0	2	NAO	M	6	1	M	30	R	20.1
	14	A	M	19	1.78	68.5	1	SIM	I	5	1	M	2	N	21.6
	15	A	F	18	1.65	63.5	1	NAO	I	4	1	B	10	R	23.3
	16	A	F	19	1.63	47.4	3	NAO	P	0	1	B	18	R	17.8
	17	A	F	17	1.82	66.0	1	NAO	P	3	1	B	10	N	19.9
	18	A	M	18	1.80	85.2	2	NAO	P	3	4	B	10	R	26.3
	19	A	F	20	1.60	54.5	1	NAO	P	3	2	B	5	R	21.3
	20	A	F	18	1.68	52.5	3	NAO	M	7	2	B	14	M	18.6
	21	A	F	21	1.70	60.0	2	NAO	P	8	2	B	5	R	20.8
	22	A	F	18	1.65	58.5	1	NAO	M	0	3	B	5	R	21.5
	23	A	F	18	1.57	49.2	1	SIM	I	5	4	B	10	R	20.0
	24	A	F	20	1.55	48.0	1	SIM	I	0	1	M	28	R	20.0
	25	A	F	20	1.69	51.6	2	NAO	P	8	5	M	4	N	18.1
	26	A	F	19	1.54	57.0	2	NAO	I	6	2	B	5	R	24.0
	27	B	F	23	1.62	63.0	2	NAO	M	8	2	M	5	R	24.0
	28	B	F	18	1.62	52.0	1	NAO	P	1	1	M	10	R	19.8
	29	B	F	18	1.57	49.0	2	NAO	P	3	1	B	12	R	19.9
	30	B	F	25	1.65	59.0	4	NAO	M	1	2	M	2	R	21.7
	31	B	F	18	1.61	52.0	1	NAO	P	2	2	M	6	N	20.1
	32	B	M	17	1.71	73.0	1	NAO	P	1	1	B	20	R	25.0
	33	B	F	17	1.65	56.0	3	NAO	M	2	1	B	14	R	20.6
	34	B	F	17	1.67	58.0	1	NAO	M	4	2	B	10	R	20.8
	35	B	M	18	1.73	87.0	1	NAO	M	7	1	B	25	B	29.1
	36	B	F	18	1.60	47.0	1	NAO	P	5	1	M	14	R	18.4
	37	B	M	17	1.70	95.0	1	NAO	P	10	2	M	12	N	32.9
	38	B	M	21	1.85	84.0	1	SIM	I	6	4	B	10	R	24.5
	39	B	F	18	1.70	60.0	1	NAO	P	5	2	B	12	R	20.8
	40	B	M	18	1.73	73.0	1	NAO	M	4	1	B	2	R	24.4
	41	B	F	17	1.70	55.0	1	NAO	I	5	4	B	10	B	19.0
	42	B	F	23	1.45	44.0	2	NAO	M	2	2	B	25	R	20.9
	43	B	M	24	1.76	75.0	2	NAO	I	7	0	M	14	N	24.2
	44	B	F	18	1.68	55.0	1	NAO	P	5	1	B	8	R	19.5
	45	B	F	18	1.55	49.0	1	NAO	M	0	1	M	10	R	20.4
	46	B	F	19	1.70	50.0	7	NAO	M	0	1	B	8	R	17.3
	47	B	F	19	1.55	54.5	2	NAO	M	4	3	B	3	R	22.7
	48	B	F	18	1.60	50.0	1	NAO	P	2	1	B	5	R	19.5
	49	B	M	17	1.80	71.0	1	NAO	P	7	0	M	14	R	21.9
	50	B	M	18	1.83	86.0	1	NAO	P	7	0	M	20	B	25.7
Planilha1
		Peso
		60.5
		55.0		maximo	95
		72.8		minimo	44
		80.9		amplitude	51
		55.0		intervalo de classes 	8		x			ni	fr	fr%	fac	fac%
		60.0		amplitude do intervalo de classe	6.375		44	|------------	50.375	10	0.2	20%	0.2	20%
		58.0					50.375	|------------	56.75	12	0.24	24%	0.44	44%
		47.0					56.75	|------------	63.125	13	0.26	26%	0.7	70%
		57.8					63.125	|------------	69.5	3	0.06	6%	0.76	76%
		58.0					69.5	|------------	75.875	6	0.12	12%	0.88	88%
		70.0					75.875	|------------	82.25	1	0.02	2%	0.9	90%
		54.0					82.25	|------------	88.625	4	0.08	8%	0.98	98%
		58.0					88.625	|------------	95	1	0.02	2%	1	100%
		68.5							total	50
		63.5
		47.4
		66.0
		85.2
		54.5
		52.5
		60.0
		58.5
		49.2
		48.0
		51.6
		57.0
		63.0
		52.0
		49.0
		59.0
		52.0
		73.0
		56.0
		58.0
		87.0
		47.0
		95.0
		84.0
		60.0
		73.0
		55.0
		44.0
		75.0
		55.0
		49.0
		50.0
		54.5
		50.0
		71.0
		86.0
Tabelas de Frequências
					Fuma 	ni	fr	fr%			Idade	ni	fr	fr%	fac	fac%
					SIM	6	0.12	12%			17	9	0.18	18%	0.18	18%
					NÃO	44	0.88	88%			18	22	0.44	44%	0.62	62%
					Total	50					19	7	0.14	14%	0.76	76%
											20	4	0.08	8%	0.84	84%
					Toler	ni	fr	fr%			21	3	0.06	6%	0.9	90%
					M	19	0.38	38%			22	0	0	0%	0.9	90%
					I	10	0.20	20%			23	2	0.04	4%	0.94	94%
					P	21	0.42	42%			24	1	0.02	2%	0.96	96%
					Total	50	1.00				25	2	0.04	4%	1	100%
											Total	50	1
					OpCine	ni	fr	fr%
					B	18	0.36	36%			Filhos	ni	fr	fr%	fac	fac%
					M	32	0.64	64%			1	28	0.56	56%	0.56	56%
					Total	50	1				2	14	0.28	28%	0.84	84%
											3	6	0.12	12%	0.96	96%
					OpTV	ni	fr	fr%			4	1	0.02	2%	0.98	98%
					B	3	0.06	6%			7	1	0.02	2%	1	100%
					M	1	0.02	2%			Total	50	1
					R	39	0.78	78%
					N	7	0.14	14%			Cine	ni	fr	fr%	fac	fac%
					Total	50	1				0	3	0.06	6%	0.06	6%
											1	21	0.42	42%	0.48	48%
											2	18	0.36	36%	0.84	84%
											3	3	0.06	6%	0.9	90%
											4	4	0.08	8%	0.98	98%
											5	1	0.02	2%	1	100%
											Total	50	1
Variáveis Contínuas
	Alt	Variável ALTURA
	1.60	Máximo	1.850
	1.69	Mínimo	1.450
	1.85	k (Número de intervalos de classe)	7.00
	1.85	Amplitude	0.400		X			ni	fr	fr%	fac	fac%
	1.58	Amplitude do Intervalo de Classe	0.057		1.450	|-----------	1.507	1	0.02	2%	0.02	2%
	1.76				1.507	|-----------	1.564	4	0.08	8%	0.1	10%
	1.60				1.564	|-----------	1.621	12	0.24	24%	0.34	34%
	1.64				1.621	|-----------	1.679	9	0.18	18%	0.52	52%
	1.62				1.679	|-----------	1.736	14	0.28	28%	0.8	80%
	1.64				1.736	|-----------	1.793	3	0.06	6%	0.86	86%
	1.72				1.793	|-----------|	1.850	7	0.14	14%	1	100%
	1.66				Total			50	1	100%	-
	1.70
	1.78
	1.65
	1.63
	1.82
	1.80
	1.60
	1.68
	1.70
	1.65
	1.57
	1.55
	1.69
	1.54
	1.62
	1.62
	1.57
	1.65
	1.61
	1.71
	1.65
	1.67
	1.73
	1.60
	1.70
	1.85
	1.70
	1.73
	1.70
	1.45
	1.76
	1.68
	1.55
	1.70
	1.55
	1.60
	1.80
	1.83
Atividade 10
	IMC	IMC Feminino e Menor que 20	IMC Masculino e Menor que 20	IMC adultos Idade>20 anos		IMC	IMC Feminino e Menor que 20	IMC Masculino e Menor que 20	IMC adultos Idade>20 anos
	17.30	17.30	19.37	18.1	MÁXIMO	32.87	24.03	32.87	24.54
	17.47	17.47	21.27	20.0	MÍNIMO	17.30	17.30	19.37	18.07
	17.84	17.84	21.62	20.1	AMPLITUDE	15.57	6.73	13.50	6.48
	18.07	18.36	21.91	20.8	K	7
	18.36	18.60	24.39	20.9	AMPLITUDE DO IC	2.224	0.962	1.929	0.925	IMC			ni	fr	fr%	fac	fac%			OMS			ni	fr	fr%	fac	fac%
	18.60	19.03	24.96	21.3						17.30	|-----	19.53	10	0.2	20%	0.2	20%			0	|------	18.5	5	0.10	10.0%	0.10	10%
	19.03	19.26	25.68	21.7						19.53	|-----	21.75	21	0.42	42%	0.62	62%			18.5	|------	25	41	0.82	82.0%	0.92	92%
	19.26	19.49	26.30	22.7						21.75	|-----	23.97	9	0.18	18%	0.8	80%			25	|------	30	3	0.06	6.0%	0.98	98%
	19.37	19.53	29.07	23.6						23.97	|-----	26.20	7	0.14	14%	0.94	94%			30	|------	35	1	0.02	2.0%	1.00	100%
	19.49	19.60	32.87	24.0						26.20	|-----	28.42	1	0.02	2%	0.96	96%			35	|------	40	0	0.00	0.0%	1.00	100%
	19.53	19.81		24.2						28.42	|-----	30.65	1	0.02	2%	0.98	98%			Above 40	|------	ind	0	0.00	0.0%	1.00	100%
	19.60	19.88		24.5						30.65	|-----|	32.872	1	0.02	2%	1	100%			Total			50
	19.81	19.93								Total			50	1	100%
	19.88	19.96
	19.93	20.06
	19.96	20.40								IMC Feminino <20			ni	fr	fr%	fac	fac%
	19.98	20.57								17.30	|-----	18.263	3	0.107	11%	0.107	11%
	20.06	20.76								18.263	|-----	19.225	3	0.107	11%	0.214	21%
	20.07	20.80								19.225	|-----	20.187	9	0.321	32%	0.536	54%
	20.40	21.49								20.187	|-----	21.149	4	0.143	14%	0.679	68%
	20.57	21.56								21.149	|-----	22.111	4	0.143	14%	0.821	82%
	20.76	22.02								22.111	|-----	23.072	1	0.036	4%	0.857	86%
	20.76	22.03								23.072	|-----|	24.034	4	0.143	14%	1.000	100%
	20.80	22.68								Total			28	1	100%
	20.93	23.32
	21.27	23.63
	21.29	23.66								IMC Masculino <20			ni	fr	fr%	fac	fac%
	21.49	24.03								19.37	|-----	21.299	2	0.2	20%	0.2	20%
	21.56									21.299	|-----	23.228	2	0.2	20%	0.4	40%
	21.62									23.228	|-----	25.156	2	0.2	20%	0.6	60%
	21.67									25.156	|-----	27.085	2	0.2	20%	0.8	80%
	21.91									27.085	|-----	29.014	0	0	0%	0.8	80%
	22.02									29.014	|-----	30.943	1	0.1	10%	0.9	90%
	22.03									30.943	|-----|	32.872	1	0.1	10%	1	100%
	22.66									Total			10	1	100%
	22.68
	23.32									IMC >=20 anos			ni	fr	fr%	fac	fac%
	23.63									18.07	|-----	18.992	1	0.083	8.3%	0.083	8.3%
	23.64									18.992	|-----	19.917	0	0.000	0.0%	0.083	8.3%
	23.66									19.917	|-----	20.842	3	0.250	25.0%	0.333	33.3%
	24.01									20.842	|-----	21.768	3	0.250	25.0%	0.583	58.3%
	24.03									21.768	|-----	22.693	1	0.083	8.3%	0.667	66.7%
	24.21									22.693	|-----	23.618	0	0.000	0.0%	0.667	66.7%
	24.39									23.618	|-----|	24.543	4	0.333	33.3%	1.000	100.0%
	24.54									Total			12	1.000	100.0%
	24.96
	25.68
	26.30
	29.07
	32.87
BMI WHO
		Adults over20 years old
		BMI	Nutritional status
		Below 18.5	Underweight
		18.5–24.9	Normal weight
		25.0–29.9	Pre-obesity
		30.0–34.9	Obesity class I
		35.0–39.9	Obesity class II
		Above 40	Obesity class III
		Source: WHO
		International Obesity Task Force
		verificar PDF