Lista Exercícios

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

Questão 1
	
	
	
				MATLAB/EXCEL
				Faça predições para os valores de y1 a y7
	
	
	
	
				y	x1	x2	x3	x4	x5	x6	x7	x8
				3224.4184078724	246.101557776	233.6263145375	234.3705881581	227.6487515596	137.5194555498	100.843836787	61.2460707419	287.9375591296
				5276.8336855456	228.4543364917	207.6646291139	228.6645889294	216.708007782	216.0512100589	159.6835230567	149.391155736	285.73259682
				5299.1474261956	223.4613583719	216.3361608732	233.1611534723	228.3629095368	85.2717673269	172.8980376598	171.3950010681	261.8366039003
				5351.407703058	232.4685959943	251.1649421544	214.7476829018	214.4136709726	261.3254188665	165.9855952635	77.169103061	293.1714835047
				5529.6962386648	231.5657974473	235.0302332966	243.1708475237	223.8070459393	233.5612048708	174.8741111484	55.4704428236	248.1566820276
				5831.2374652701	238.6267164079	233.4682784644	235.5627879192	250.8588971873	258.5711233863	222.3227637562	84.7758415479	278.1334879604
				6054.0949369083	236.8332724368	229.3136498233	222.6392320049	219.0246726864	182.0078127384	208.9632862331	81.0296945097	239.6954252754
				6618.4549423762	240.1277692011	237.6343440014	226.4951484799	223.092137629	255.6108279672	140.9070101016	70.0888088626	188.264107181
				6870.840705812	245.7720023708	230.3768491297	228.5402155289	248.3032170753	134.4447157201	110.4647968993	166.9545579394	159.9124118778
				7301.4181215395	222.5203610474	231.4636498236	227.6856997819	227.9168933351	197.320474868	51.2436292611	160.9500412	115.1417584765
				7462.0516550929	236.5623453338	226.6444306665	228.5494923749	223.991343672	244.8377941221	132.7127903073	155.2125614185	184.4492934965
				8622.7782192613	232.0370066522	220.18662038	249.3957930605	228.7278442859	163.0710776086	147.84234138	194.7721793268	127.288125248
				9787.9036535692	226.689712134	232.1222149371	205.2617441118	229.3113533492	237.0784630879	252.360606708	286.4421521653	232.3480941191
				10051.2319177048	219.9916019785	235.4799329519	236.5898802859	221.4793306743	104.0177617725	192.193365276	215.494247261	87.7056184576
				10497.2587603732	206.9523128634	241.7225226859	253.7436324824	226.1002458804	196.3133640553	259.143345439	101.8662068545	60.9637745293
				11313.8033601674	214.1236785869	226.6468521961	239.5723180493	226.1702997098	253.7720877712	295.4451124607	202.3941770684	124.8161259804
				12442.7820785191	232.7336909625	218.933404893	234.796322628	217.7146137806	105.269020661	279.0948210089	286.3887447737	69.7378460036
				7319.9303215244	223.6926542432	242.7113708004	229.8466137185	229.3558276401	220.5298013245	214.9906918546	193.2767723624	276.5999328593
				9516.3298778511	235.7125362218	223.62626113	226.5382244227	232.8593831303	247.7599414045	98.2039857173	257.3198644978	118.1936094241
				5788.9567533511	238.0929112301	236.6022494138	227.92548806	214.518490237	103.1250953703	160.5304116947	52.708517716	181.8704794458
				5831.2374652701	238.6267164079	233.4682784644	235.5627879192	250.8588971873	258.5711233863	222.3227637562	84.7758415479	278.1334879604
				6054.0949369083	236.8332724368	229.3136498233	222.6392320049	219.0246726864	182.0078127384	208.9632862331	81.0296945097	239.6954252754
				6618.4549423762	240.1277692011	237.6343440014	226.4951484799	223.092137629	255.6108279672	140.9070101016	70.0888088626	188.264107181
				6870.840705812	245.7720023708	230.3768491297	228.5402155289	248.3032170753	134.4447157201	110.4647968993	166.9545579394	159.9124118778
	
					10.9144871364	19.5065767388	5.678090762	-13.6361888485	6.8962675863	13.5557725761	14.2250434889	-18.8653218177
	
	
				RESUMO DOS RESULTADOS
	
				Estatística de regressão
				R múltiplo	1
				R-Quadrado	1
				R-quadrado ajustado	0.8888888889
				Erro padrão	0
				Observações	17
	
				ANOVA
					gl	SQ	MQ	F	F de significação
				Regressão	8	1060398670.3758326	132549833.79697907	59477361288729340000000000000000	0
				Resíduo	9	0	0
				Total	17	1060398670.3758326
	
					Coeficientes	Erro padrão	Stat t	valor-P	95% inferiores	95% superiores	Inferior 95,0%	Superior 95,0%
				Interseção	0
				Variável X 1	10.9144871364	0	258100936985782.53	0	10.9144871364	10.9144871364	10.9144871364	10.9144871364
				Variável X 2	19.5065767388	0	549116866547262.1	0	19.5065767388	19.5065767388	19.5065767388	19.5065767388
				Variável X 3	5.678090762	0	168644785477664.2	0	5.678090762	5.678090762	5.678090762	5.678090762
				Variável X 4	-13.6361888485	0	-314058978420248.9	0	-13.6361888485	-13.6361888485	-13.6361888485	-13.6361888485
				Variável X 5	6.8962675863	0	914739871029690.4	0	6.8962675863	6.8962675863	6.8962675863	6.8962675863
				Variável X 6	13.5557725761	0	1882472208519331.5	0	13.5557725761	13.5557725761	13.5557725761	13.5557725761
				Variável X 7	14.2250434889	0	1911662525060080.2	0	14.2250434889	14.2250434889	14.2250434889	14.2250434889
				Variável X 8	-18.8653218177	0	-2636133334614327.5	0	-18.8653218177	-18.8653218177	-18.8653218177	-18.8653218177
Questão 2
	EXCEL
	
	Filtrar vendas > 130 unidades
	
	Filtrar produtos com preço > 300
	
	Filtrar vendas de Omeprazol efetuadas em Campinas
	
	Filtrar, em outra tabela, vendas feitas no rio de Janeiro pelo vendedor Marcos
	
	Filtrar, em outra tabela, vendas feitas em Franca pelo vendedor João ou em Campinas pelo vendedor Marcos
	
	Filtrar, em outra tabela, vendas cujo total < média do total
	
	Data	Medicamento	Cidade	Vendedor	Quantidade	Unitário	Total
			Franca	João
			Campinas	Marcos
	
									Filtrar vendas > 130 unidades								Filtrar produtos com preço > 300								Filtrar vendas de Omeprazol efetuadas em Campinas								Filtrar, em outra tabela, vendas feitas no rio de Janeiro pelo vendedor Marcos								vendas feitas em Franca pelo vendedor João ou em Campinas pelo vendedor Marcos								Filtrar, em outra tabela, vendas cujo total < média do total
	Data	Medicamento	Cidade	Vendedor	Quantidade	Unitário	Total		Data	Medicamento	Cidade	Vendedor	Quantidade	Unitário	Total		Data	Medicamento	Cidade	Vendedor	Quantidade	Unitário	Total		Data	Medicamento	Cidade	Vendedor	Quantidade	Unitário	Total		Data	Medicamento	Cidade	Vendedor	Quantidade	Unitário	Total		Data	Medicamento	Cidade	Vendedor	Quantidade	Unitário	Total		Data	Medicamento	Cidade	Vendedor	Quantidade	Unitário	Total
	1/18/01	Cloranfenicol	Rio de Janeiro	Sandra	102	R$150.00	R$15,300.00		2/7/01	Cloranfenicol	Campinas	Marina	153	R$150.00	R$22,950.00		1/30/01	Vancomicina	Curitiba	João	111	R$1,214.00	R$134,754.00		2/15/01	Omeprazol	Campinas	Marcos	81	R$14.00	R$1,134.00		4/7/01	Fenobarbital	Rio de Janeiro	Marcos	106	R$86.00	R$9,116.00		1/23/01	Hidantal	Campinas	Marcos	116	R$110.00	R$12,760.00		1/18/01	Cloranfenicol	Rio de Janeiro	Sandra	102	R$150.00	R$15,300.00
	1/23/01	Hidantal	Campinas	Marcos	116	R$110.00	R$12,760.00		8/4/01	Dipirona	Brasilia	Marina	134	R$65.00	R$8,710.00		4/4/01	Vancomicina	Salvador	João	114	R$1,214.00	R$138,396.00		3/29/01	Omeprazol	Campinas	Marina	71	R$14.00	R$994.00		9/27/01	Omeprazol	Rio de Janeiro	Marcos	96	R$14.00	R$1,344.00		2/15/01	Omeprazol	Campinas	Marcos	81	R$14.00	R$1,134.00		1/23/01	Hidantal	Campinas	Marcos	116	R$110.00	R$12,760.00
	1/30/01	Vancomicina	Curitiba	João	111	R$1,214.00	R$134,754.00		9/6/01	Dipirona	Rio de Janeiro	João	131	R$65.00	R$8,515.00		4/5/01	Vancomicina	Salvador	Marina	123	R$1,214.00	R$149,322.00		7/23/01	Omeprazol	Campinas	João	69	R$14.00	R$966.00		12/16/01	Cloranfenicol	Rio de Janeiro	Marcos	98	R$150.00	R$14,700.00		5/15/01	Dipirona	Campinas	Marcos	118	R$65.00	R$7,670.00		2/7/01	Cloranfenicol	Campinas	Marina	153	R$150.00	R$22,950.00
	2/7/01	Cloranfenicol	Campinas	Marina	153	R$150.00	R$22,950.00		1/3/02	Cloranfenicol	Campinas	Marina	153	R$150.00	R$22,950.00		4/11/01	Vancomicina	Curitiba	João	117	R$1,214.00	R$142,038.00		10/2/01	Omeprazol	Campinas	Marina	108	R$14.00	R$1,512.00										12/19/01	Hidantal	Campinas	Marcos	116	R$110.00	R$12,760.00		2/11/01	Cloranfenicol	Curitiba	Sandra	78	R$150.00	R$11,700.00
	2/11/01	Cloranfenicol	Curitiba	Sandra	78	R$150.00	R$11,700.00										5/30/01	Vancomicina	Curitiba	Sandra
120	R$1,214.00	R$145,680.00		1/11/02	Omeprazol	Campinas	Marcos	81	R$14.00	R$1,134.00										1/11/02	Omeprazol	Campinas	Marcos	81	R$14.00	R$1,134.00		2/15/01	Omeprazol	Campinas	Marcos	81	R$14.00	R$1,134.00
	2/15/01	Omeprazol	Campinas	Marcos	81	R$14.00	R$1,134.00										7/28/01	Vancomicina	Ribeirão Preto	Sandra	118	R$1,214.00	R$143,252.00		2/22/02	Omeprazol	Campinas	Marina	71	R$14.00	R$994.00																		2/20/01	Cloranfenicol	Brasilia	João	106	R$150.00	R$15,900.00
	2/20/01	Cloranfenicol	Brasilia	João	106	R$150.00	R$15,900.00										10/11/01	Vancomicina	Barretos	Marcos	113	R$1,214.00	R$137,182.00																										3/7/01	Hidantal	Campinas	Marina	118	R$110.00	R$12,980.00
	3/7/01	Hidantal	Campinas	Marina	118	R$110.00	R$12,980.00										10/22/01	Vancomicina	Ribeirão Preto	Marina	83	R$1,214.00	R$100,762.00																										3/11/01	Omeprazol	Rio de Janeiro	Sandra	76	R$14.00	R$1,064.00
	3/11/01	Omeprazol	Rio de Janeiro	Sandra	76	R$14.00	R$1,064.00										10/30/01	Vancomicina	Brasilia	Sandra	92	R$1,214.00	R$111,688.00																										3/16/01	Cloranfenicol	Salvador	Marcos	82	R$150.00	R$12,300.00
	3/16/01	Cloranfenicol	Salvador	Marcos	82	R$150.00	R$12,300.00										11/13/01	Vancomicina	Brasilia	Sandra	108	R$1,214.00	R$131,112.00																										3/19/01	Dipirona	Ribeirão Preto	João	110	R$65.00	R$7,150.00
	3/19/01	Dipirona	Ribeirão Preto	João	110	R$65.00	R$7,150.00										11/17/01	Vancomicina	Ribeirão Preto	Marcos	107	R$1,214.00	R$129,898.00																										3/20/01	Fenobarbital	Franca	Marina	110	R$86.00	R$9,460.00
	3/20/01	Fenobarbital	Franca	Marina	110	R$86.00	R$9,460.00										11/18/01	Vancomicina	Campinas	João	103	R$1,214.00	R$125,042.00																										3/23/01	Cloranfenicol	Santos	Sandra	86	R$150.00	R$12,900.00
	3/23/01	Cloranfenicol	Santos	Sandra	86	R$150.00	R$12,900.00										11/19/01	Vancomicina	Salvador	Marina	95	R$1,214.00	R$115,330.00																										3/25/01	Dipirona	Barretos	Marcos	95	R$65.00	R$6,175.00
	3/25/01	Dipirona	Barretos	Marcos	95	R$65.00	R$6,175.00										11/20/01	Vancomicina	Ribeirão Preto	João	86	R$1,214.00	R$104,404.00																										3/28/01	Hidantal	Brasilia	João	120	R$110.00	R$13,200.00
	3/28/01	Hidantal	Brasilia	João	120	R$110.00	R$13,200.00										12/5/01	Vancomicina	Campinas	Sandra	98	R$1,214.00	R$118,972.00																										3/29/01	Omeprazol	Campinas	Marina	71	R$14.00	R$994.00
	3/29/01	Omeprazol	Campinas	Marina	71	R$14.00	R$994.00										12/6/01	Vancomicina	Ribeirão Preto	Marcos	98	R$1,214.00	R$118,972.00																										3/30/01	Dipirona	Brasilia	Sandra	119	R$65.00	R$7,735.00
	3/30/01	Dipirona	Brasilia	Sandra	119	R$65.00	R$7,735.00										12/10/01	Vancomicina	Santos	João	93	R$1,214.00	R$112,902.00																										4/2/01	Cloranfenicol	Salvador	Marcos	86	R$150.00	R$12,900.00
	4/2/01	Cloranfenicol	Salvador	Marcos	86	R$150.00	R$12,900.00										12/11/01	Vancomicina	Ribeirão Preto	Marina	101	R$1,214.00	R$122,614.00																										4/7/01	Dipirona	Rio de Janeiro	Sandra	113	R$65.00	R$7,345.00
	4/4/01	Vancomicina	Salvador	João	114	R$1,214.00	R$138,396.00										12/19/01	Vancomicina	Salvador	João	110	R$1,214.00	R$133,540.00																										4/7/01	Fenobarbital	Rio de Janeiro	Marcos	106	R$86.00	R$9,116.00
	4/5/01	Vancomicina	Salvador	Marina	123	R$1,214.00	R$149,322.00										12/26/01	Vancomicina	Curitiba	João	111	R$1,214.00	R$134,754.00																										4/18/01	Dipirona	Curitiba	Marina	107	R$65.00	R$6,955.00
	4/7/01	Dipirona	Rio de Janeiro	Sandra	113	R$65.00	R$7,345.00										12/28/01	Vancomicina	Santos	Marina	88	R$1,214.00	R$106,832.00																										4/22/01	Fenobarbital	Franca	Sandra	96	R$86.00	R$8,256.00
	4/7/01	Fenobarbital	Rio de Janeiro	Marcos	106	R$86.00	R$9,116.00										12/30/01	Vancomicina	Barretos	Sandra	89	R$1,214.00	R$108,046.00																										4/27/01	Dipirona	Ribeirão Preto	Marcos	92	R$65.00	R$5,980.00
	4/11/01	Vancomicina	Curitiba	João	117	R$1,214.00	R$142,038.00										1/6/02	Vancomicina	Ribeirão Preto	Marcos	104	R$1,214.00	R$126,256.00																										5/2/01	Dipirona	Santos	João	104	R$65.00	R$6,760.00
	4/18/01	Dipirona	Curitiba	Marina	107	R$65.00	R$6,955.00										2/28/02	Vancomicina	Salvador	João	114	R$1,214.00	R$138,396.00																										5/7/01	Fenobarbital	Rio de Janeiro	Marina	98	R$86.00	R$8,428.00
	4/22/01	Fenobarbital	Franca	Sandra	96	R$86.00	R$8,256.00										3/1/02	Vancomicina	Salvador	Marina	123	R$1,214.00	R$149,322.00																										5/11/01	Cloranfenicol	Barretos	Sandra	90	R$150.00	R$13,500.00
	4/27/01	Dipirona	Ribeirão Preto	Marcos	92	R$65.00	R$5,980.00																																										5/15/01	Dipirona	Campinas	Marcos	118	R$65.00	R$7,670.00
	5/2/01	Dipirona	Santos	João	104	R$65.00	R$6,760.00																																										5/18/01	Dipirona	Santos	João	116	R$65.00	R$7,540.00
	5/7/01	Fenobarbital	Rio de Janeiro	Marina	98	R$86.00	R$8,428.00																																										5/20/01	Dipirona	Barretos	Marina	114	R$65.00	R$7,410.00
	5/11/01	Cloranfenicol	Barretos	Sandra	90	R$150.00	R$13,500.00																																										5/20/01	Dipirona	Curitiba	Sandra	94	R$65.00	R$6,110.00
	5/15/01	Dipirona	Campinas	Marcos	118	R$65.00	R$7,670.00																																										5/21/01	Hidantal	Franca	Marcos	122	R$110.00	R$13,420.00
	5/18/01	Dipirona	Santos	João	116	R$65.00	R$7,540.00																																										5/23/01	Cloranfenicol	Brasilia	João	98	R$150.00	R$14,700.00
	5/20/01	Dipirona	Barretos	Marina	114	R$65.00	R$7,410.00																																										5/26/01	Dipirona	Campinas	Marina	110	R$65.00	R$7,150.00
	5/20/01	Dipirona	Curitiba	Sandra	94	R$65.00	R$6,110.00																																										6/1/01	Dipirona	Franca	Marcos	101	R$65.00	R$6,565.00
	5/21/01	Hidantal	Franca	Marcos	122	R$110.00	R$13,420.00																																										6/8/01	Dipirona	Salvador	João	98	R$65.00	R$6,370.00
	5/23/01	Cloranfenicol	Brasilia	João	98	R$150.00	R$14,700.00																																										6/11/01	Dipirona	Curitiba	Marina	122	R$65.00	R$7,930.00
	5/26/01	Dipirona	Campinas	Marina	110	R$65.00	R$7,150.00																																										6/15/01	Fenobarbital	Santos	Sandra	108	R$86.00	R$9,288.00
	5/30/01	Vancomicina	Curitiba	Sandra	120	R$1,214.00	R$145,680.00																																										6/23/01	Dipirona	Ribeirão Preto	Marcos	126	R$65.00	R$8,190.00
	6/1/01	Dipirona	Franca	Marcos	101	R$65.00	R$6,565.00																																										6/24/01	Fenobarbital	Ribeirão Preto	João	114	R$86.00	R$9,804.00
	6/8/01	Dipirona	Salvador	João	98	R$65.00	R$6,370.00																																										7/2/01	Fenobarbital	Curitiba	Marina	112	R$86.00	R$9,632.00
	6/11/01	Dipirona	Curitiba	Marina	122	R$65.00	R$7,930.00																																										7/10/01	Dipirona	Salvador	João	130	R$65.00	R$8,450.00
	6/15/01	Fenobarbital	Santos	Sandra	108	R$86.00	R$9,288.00																																										7/13/01	Omeprazol	Curitiba	Marina	66	R$14.00	R$924.00
	6/23/01	Dipirona	Ribeirão Preto	Marcos	126	R$65.00	R$8,190.00																																										7/19/01	Hidantal	Curitiba	Sandra	111	R$110.00	R$12,210.00
	6/24/01	Fenobarbital	Ribeirão Preto	João	114	R$86.00	R$9,804.00																																										7/21/01	Hidantal	Salvador	Marcos	106	R$110.00	R$11,660.00
	7/2/01	Fenobarbital	Curitiba	Marina	112	R$86.00	R$9,632.00																																										7/23/01	Omeprazol	Campinas	João	69	R$14.00	R$966.00
	7/10/01	Dipirona	Salvador	João	130	R$65.00	R$8,450.00																																										7/26/01	Hidantal	Salvador	Marina	101	R$110.00	R$11,110.00
	7/13/01	Omeprazol	Curitiba	Marina	66	R$14.00	R$924.00																																										7/29/01	Hidantal	Barretos	Marcos	124	R$110.00	R$13,640.00
	7/19/01	Hidantal	Curitiba	Sandra	111	R$110.00	R$12,210.00																																										8/1/01
Hidantal	Brasilia	João	86	R$110.00	R$9,460.00
	7/21/01	Hidantal	Salvador	Marcos	106	R$110.00	R$11,660.00																																										8/4/01	Dipirona	Brasilia	Marina	134	R$65.00	R$8,710.00
	7/23/01	Omeprazol	Campinas	João	69	R$14.00	R$966.00																																										8/10/01	Hidantal	Barretos	Sandra	91	R$110.00	R$10,010.00
	7/26/01	Hidantal	Salvador	Marina	101	R$110.00	R$11,110.00																																										8/11/01	Fenobarbital	Curitiba	Marcos	100	R$86.00	R$8,600.00
	7/28/01	Vancomicina	Ribeirão Preto	Sandra	118	R$1,214.00	R$143,252.00																																										8/13/01	Omeprazol	Santos	João	90	R$14.00	R$1,260.00
	7/29/01	Hidantal	Barretos	Marcos	124	R$110.00	R$13,640.00																																										8/20/01	Cloranfenicol	Santos	Marina	124	R$150.00	R$18,600.00
	8/1/01	Hidantal	Brasilia	João	86	R$110.00	R$9,460.00																																										8/22/01	Omeprazol	Ribeirão Preto	João	72	R$14.00	R$1,008.00
	8/4/01	Dipirona	Brasilia	Marina	134	R$65.00	R$8,710.00																																										8/28/01	Hidantal	Franca	Marina	96	R$110.00	R$10,560.00
	8/10/01	Hidantal	Barretos	Sandra	91	R$110.00	R$10,010.00																																										8/30/01	Hidantal	Ribeirão Preto	Sandra	116	R$110.00	R$12,760.00
	8/11/01	Fenobarbital	Curitiba	Marcos	100	R$86.00	R$8,600.00																																										9/2/01	Fenobarbital	Santos	Marcos	102	R$86.00	R$8,772.00
	8/13/01	Omeprazol	Santos	João	90	R$14.00	R$1,260.00																																										9/6/01	Dipirona	Rio de Janeiro	João	131	R$65.00	R$8,515.00
	8/20/01	Cloranfenicol	Santos	Marina	124	R$150.00	R$18,600.00																																										9/8/01	Omeprazol	Ribeirão Preto	Marina	105	R$14.00	R$1,470.00
	8/22/01	Omeprazol	Ribeirão Preto	João	72	R$14.00	R$1,008.00																																										9/10/01	Omeprazol	Franca	Sandra	99	R$14.00	R$1,386.00
	8/28/01	Hidantal	Franca	Marina	96	R$110.00	R$10,560.00																																										9/11/01	Dipirona	Franca	Marcos	128	R$65.00	R$8,320.00
	8/30/01	Hidantal	Ribeirão Preto	Sandra	116	R$110.00	R$12,760.00																																										9/14/01	Omeprazol	Santos	João	87	R$14.00	R$1,218.00
	9/2/01	Fenobarbital	Santos	Marcos	102	R$86.00	R$8,772.00																																										9/19/01	Omeprazol	Ribeirão Preto	Marina	102	R$14.00	R$1,428.00
	9/6/01	Dipirona	Rio de Janeiro	João	131	R$65.00	R$8,515.00																																										9/23/01	Omeprazol	Brasilia	Sandra	93	R$14.00	R$1,302.00
	9/8/01	Omeprazol	Ribeirão Preto	Marina	105	R$14.00	R$1,470.00																																										9/27/01	Omeprazol	Rio de Janeiro	Marcos	96	R$14.00	R$1,344.00
	9/10/01	Omeprazol	Franca	Sandra	99	R$14.00	R$1,386.00																																										9/30/01	Hidantal	Ribeirão Preto	João	126	R$110.00	R$13,860.00
	9/11/01	Dipirona	Franca	Marcos	128	R$65.00	R$8,320.00																																										10/2/01	Omeprazol	Campinas	Marina	108	R$14.00	R$1,512.00
	9/14/01	Omeprazol	Santos	João	87	R$14.00	R$1,218.00																																										10/7/01	Fenobarbital	Ribeirão Preto	João	104	R$86.00	R$8,944.00
	9/19/01	Omeprazol	Ribeirão Preto	Marina	102	R$14.00	R$1,428.00																																										10/9/01	Omeprazol	Ribeirão Preto	Marina	75	R$14.00	R$1,050.00
	9/23/01	Omeprazol	Brasilia	Sandra	93	R$14.00	R$1,302.00																																										10/10/01	Omeprazol	Brasilia	Sandra	78	R$14.00	R$1,092.00
	9/27/01	Omeprazol	Rio de Janeiro	Marcos	96	R$14.00	R$1,344.00																																										10/20/01	Omeprazol	Curitiba	João	84	R$14.00	R$1,176.00
	9/30/01	Hidantal	Ribeirão Preto	João	126	R$110.00	R$13,860.00																																										11/2/01	Dipirona	Curitiba	Marcos	125	R$65.00	R$8,125.00
	10/2/01	Omeprazol	Campinas	Marina	108	R$14.00	R$1,512.00																																										11/4/01	Dipirona	Ribeirão Preto	João	122	R$65.00	R$7,930.00
	10/7/01	Fenobarbital	Ribeirão Preto	João	104	R$86.00	R$8,944.00																																										11/11/01	Omeprazol	Franca	Marina	81	R$14.00	R$1,134.00
	10/9/01	Omeprazol	Ribeirão Preto	Marina	75	R$14.00	R$1,050.00																																										11/24/01	Hidantal	Barretos	Marina	121	R$110.00	R$13,310.00
	10/10/01	Omeprazol	Brasilia	Sandra	78	R$14.00	R$1,092.00																																										12/14/01	Cloranfenicol	Rio de Janeiro	Sandra	102	R$150.00	R$15,300.00
	10/11/01	Vancomicina	Barretos	Marcos	113	R$1,214.00	R$137,182.00																																										12/14/01	Cloranfenicol	Campinas	Sandra	90	R$150.00	R$13,500.00
	10/20/01	Omeprazol	Curitiba	João	84	R$14.00	R$1,176.00																																										12/16/01	Cloranfenicol	Rio de Janeiro	Marcos	98	R$150.00	R$14,700.00
	10/22/01	Vancomicina	Ribeirão Preto	Marina	83	R$1,214.00	R$100,762.00																																										12/19/01	Hidantal	Campinas	Marcos	116	R$110.00	R$12,760.00
	10/30/01	Vancomicina	Brasilia	Sandra	92	R$1,214.00	R$111,688.00																																										1/3/02	Cloranfenicol	Campinas	Marina	153	R$150.00	R$22,950.00
	11/2/01	Dipirona	Curitiba	Marcos	125	R$65.00	R$8,125.00																																										1/7/02	Cloranfenicol	Curitiba	Sandra	78	R$150.00	R$11,700.00
	11/4/01	Dipirona	Ribeirão Preto	João	122	R$65.00	R$7,930.00																																										1/7/02	Cloranfenicol	Curitiba	João	94	R$150.00	R$14,100.00
	11/11/01	Omeprazol	Franca	Marina	81	R$14.00	R$1,134.00																																										1/11/02	Omeprazol	Campinas	Marcos	81	R$14.00	R$1,134.00
	11/13/01	Vancomicina	Brasilia	Sandra	108	R$1,214.00	R$131,112.00																																										1/16/02	Cloranfenicol	Brasilia	João	106	R$150.00	R$15,900.00
	11/17/01	Vancomicina	Ribeirão Preto	Marcos	107	R$1,214.00	R$129,898.00																																										1/31/02	Hidantal	Campinas	Marina	118	R$110.00	R$12,980.00
	11/18/01	Vancomicina	Campinas	João	103	R$1,214.00	R$125,042.00																																										2/4/02	Omeprazol	Rio de Janeiro	Sandra	76	R$14.00	R$1,064.00
	11/19/01	Vancomicina	Salvador	Marina	95	R$1,214.00	R$115,330.00																																										2/9/02	Cloranfenicol	Salvador	Marcos	82	R$150.00	R$12,300.00
	11/20/01	Vancomicina	Ribeirão Preto	João	86	R$1,214.00	R$104,404.00																																										2/12/02	Dipirona	Ribeirão Preto	João	110	R$65.00	R$7,150.00
	11/24/01	Hidantal	Barretos	Marina	121	R$110.00	R$13,310.00																																										2/13/02	Fenobarbital	Franca	Marina	110	R$86.00	R$9,460.00
	12/5/01	Vancomicina	Campinas	Sandra	98	R$1,214.00	R$118,972.00																																										2/16/02	Cloranfenicol	Santos	Sandra	86	R$150.00	R$12,900.00
	12/6/01	Vancomicina	Ribeirão Preto	Marcos	98	R$1,214.00	R$118,972.00																																										2/18/02	Dipirona	Barretos	Marcos	95	R$65.00	R$6,175.00
	12/10/01	Vancomicina	Santos	João	93	R$1,214.00	R$112,902.00																																										2/21/02	Hidantal	Brasilia	João	120	R$110.00	R$13,200.00
	12/11/01	Vancomicina	Ribeirão Preto	Marina	101	R$1,214.00	R$122,614.00																																										2/22/02	Omeprazol	Campinas	Marina	71	R$14.00	R$994.00
	12/14/01	Cloranfenicol	Rio de Janeiro	Sandra	102	R$150.00	R$15,300.00																																										2/23/02	Dipirona	Brasilia	Sandra	119	R$65.00	R$7,735.00
	12/14/01	Cloranfenicol	Campinas	Sandra	90	R$150.00	R$13,500.00																																										2/26/02	Cloranfenicol	Salvador	Marcos	86	R$150.00	R$12,900.00
	12/16/01	Cloranfenicol	Rio de Janeiro	Marcos	98	R$150.00	R$14,700.00
	12/19/01	Hidantal	Campinas	Marcos	116	R$110.00	R$12,760.00
	12/19/01	Vancomicina	Salvador	João	110	R$1,214.00	R$133,540.00
	12/26/01	Vancomicina	Curitiba	João	111	R$1,214.00	R$134,754.00
	12/28/01	Vancomicina	Santos	Marina	88	R$1,214.00	R$106,832.00
	12/30/01	Vancomicina	Barretos	Sandra
89	R$1,214.00	R$108,046.00
	1/3/02	Cloranfenicol	Campinas	Marina	153	R$150.00	R$22,950.00
	1/6/02	Vancomicina	Ribeirão Preto	Marcos	104	R$1,214.00	R$126,256.00
	1/7/02	Cloranfenicol	Curitiba	Sandra	78	R$150.00	R$11,700.00
	1/7/02	Cloranfenicol	Curitiba	João	94	R$150.00	R$14,100.00
	1/11/02	Omeprazol	Campinas	Marcos	81	R$14.00	R$1,134.00
	1/16/02	Cloranfenicol	Brasilia	João	106	R$150.00	R$15,900.00
	1/31/02	Hidantal	Campinas	Marina	118	R$110.00	R$12,980.00
	2/4/02	Omeprazol	Rio de Janeiro	Sandra	76	R$14.00	R$1,064.00
	2/9/02	Cloranfenicol	Salvador	Marcos	82	R$150.00	R$12,300.00
	2/12/02	Dipirona	Ribeirão Preto	João	110	R$65.00	R$7,150.00
	2/13/02	Fenobarbital	Franca	Marina	110	R$86.00	R$9,460.00
	2/16/02	Cloranfenicol	Santos	Sandra	86	R$150.00	R$12,900.00
	2/18/02	Dipirona	Barretos	Marcos	95	R$65.00	R$6,175.00
	2/21/02	Hidantal	Brasilia	João	120	R$110.00	R$13,200.00
	2/22/02	Omeprazol	Campinas	Marina	71	R$14.00	R$994.00
	2/23/02	Dipirona	Brasilia	Sandra	119	R$65.00	R$7,735.00
	2/26/02	Cloranfenicol	Salvador	Marcos	86	R$150.00	R$12,900.00
	2/28/02	Vancomicina	Salvador	João	114	R$1,214.00	R$138,396.00
	3/1/02	Vancomicina	Salvador	Marina	123	R$1,214.00	R$149,322.00
Questão 3
	
	
	
		Gere gráficos para os dados abaixo utilizando as linhas de tendência do Excel. Estime o R2 para cada equação. Faça uma predição de demanda para os meses 49 ao 54 para os dados abaixo
	
	
	
	
		Mês, t	Demanda
		1	317
		2	194
		3	312
		4	316
		5	322
		6	334
		7	317
		8	356
		9	428
		10	411
		11	494
		12	412
		13	460
		14	395
		15	392
		16	447
		17	452
		18	571
		19	517
		20	397
		21	410
		22	579
		23	473
		24	558
		25	538
		26	570
		27	600
		28	565
		29	485
		30	604
		31	527
		32	603
		33	604
		34	790
		35	714
		36	653
		37	626
		38	690
		39	680
		40	673
		41	613
		42	744
		43	718
		44	767
		45	728
		46	793
		47	726
		48	777
		49	793.896
		50	806.57
		51	819.5466
		52	832.8396
		53	846.4628
		54	860.43
Questão 3
	
Dados Históricos
Previsão
Tempo (mês)
Demanda
Questão 4
	
	
			Faça uma análise descritiva dos valores de resistência à tração provenientes de um processo de fabriação de cabos de aço.
	
	
	
					Amostra	Tração			Tração
					1	278
					2	252			Média	265.0259909032
					3	258			Erro padrão	0.2305775315
					4	269			Mediana	265
					5	272			Modo	257
					6	280			Desvio padrão	9.0455774264
					7	250			Variância da amostra	81.8224709778
					8	268			Curtose	-1.2510355343
					9	272			Assimetria	-0.0064004827
					10	264			Intervalo	30
					11	264			Mínimo	250
					12	251			Máximo	280
					13	274			Soma	407875
					14	279			Contagem	1539
					15	250
					16	264
					17	270
					18	265
					19	251
					20	260
					21	258
					22	273
					23	262
					24	256
					25	250
					26	260
					27	254
					28	275
					29	265
					30	264
					31	270
					32	264
					33	276
					34	280
					35	275
					36	262
					37	265
					38	253
					39	276
					40	265
					41	261
					42	272
					43	273
					44	258
					45	274
					46	273
					47	272
					48	254
					49	280
					50	262
					51	278
					52	260
					53	254
					54	267
					55	257
					56	254
					57	271
					58	257
					59	260
					60	268
					61	264
					62	258
					63	269
					64	277
					65	266
					66	280
					67	280
					68	268
					69	270
					70	267
					71	256
					72	279
					73	261
					74	279
					75	260
					76	256
					77	258
					78	263
					79	252
					80	256
					81	254
					82	270
					83	277
					84	276
					85	256
					86	267
					87	280
					88	259
					89	255
					90	257
					91	251
					92	277
					93	260
					94	252
					95	261
					96	276
					97	256
					98	254
					99	255
					100	280
					101	256
					102	280
					103	252
					104	266
					105	268
					106	257
					107	278
					108	275
					109	255
					110	264
					111	262
					112	254
					113	252
					114	273
					115	260
					116	272
					117	266
					118	277
					119	268
					120	253
					121	271
					122	257
					123	280
					124	261
					125	278
					126	261
					127	274
					128	273
					129	266
					130	276
					131	253
					132	275
					133	271
					134	256
					135	252
					136	259
					137	278
					138	276
					139	265
					140	260
					141	269
					142	279
					143	259
					144	276
					145	265
					146	259
					147	276
					148	262
					149	271
					150	265
					151	254
					152	252
					153	278
					154	251
					155	272
					156	275
					157	271
					158	280
					159	255
					160	269
					161	273
					162	275
					163	271
					164	253
					165	253
					166	261
					167	252
					168	250
					169	280
					170	250
					171	263
					172	270
					173	273
					174	260
					175	255
					176	265
					177	270
					178	271
					179	270
					180	256
					181	254
					182	271
					183	279
					184	256
					185	258
					186	255
					187	261
					188	253
					189	272
					190	261
					191	269
					192	254
					193	257
					194	273
					195	259
					196	275
					197	273
					198	269
					199	276
					200	252
					201	272
					202	272
					203	259
					204	250
					205	259
					206	261
					207	262
					208	250
					209	276
					210	257
					211	251
					212	275
					213	265
					214	278
					215	270
					216	257
					217	276
					218	279
					219	253
					220	269
					221	256
					222	269
					223	253
					224	258
					225	255
					226	277
					227	268
					228	276
					229	266
					230	255
					231	274
					232	254
					233	274
					234	255
					235	251
					236	250
					237	271
					238	254
					239	266
					240	257
					241	262
					242	259
					243	273
					244	253
					245	273
					246	252
					247	267
					248	262
					249	262
					250	253
					251	270
					252	269
					253	260
					254	271
					255	269
					256	269
					257	270
					258	279
					259	255
					260	271
					261	276
					262	251
					263	267
					264	257
					265	256
					266	256
					267	277
					268	274
					269	276
					270	280
					271	280
					272	272
					273	272
					274	267
					275	255
					276	278
					277	274
					278	273
					279	280
					280	279
					281	258
					282	256
					283	257
					284	259
					285	251
					286	253
					287	279
					288	268
					289	263
					290	260
					291	279
					292	275
					293	257
					294	258
					295	275
					296	250
					297	264
					298	274
					299	270
					300	279
					301	273
					302	251
					303	262
					304	257
					305	272
					306	267
					307	265
					308	266
					309	265
					310	276
					311	271
					312	274
					313	252
					314	257
					315	250
					316	278
					317	274
					318	271
					319	270
					320	268
					321	253
					322	266
					323	254
					324	270
					325	265
					326	251
					327	270
					328	258
					329	251
					330	257
					331	252
					332	279
					333	264
					334	265
					335	256
					336	256
					337	252
					338	251
					339	277
					340	259
					341	279
					342	265
					343	277
					344	264
					345	259
					346	277
					347	251
					348	276
					349	271
					350	262
					351	262
					352	265
					353	253
					354	258
					355	261
					356	256
					357	280
					358	271
					359	256
					360	264
					361	265
					362	253
					363	268
					364	267
					365	278
					366	256
					367	272
					368	276
					369	264
					370	271
					371	260
					372	274
					373	260
					374	273
					375	262
					376	261
					377	279
					378	267
					379	278
					380	251
					381	271
					382	273
					383	267
					384	271
					385	277
					386	264
					387	258
					388	255
					389	252
					390	274
					391	254
					392	272
					393	276
					394	251
					395	267
					396	260
					397	251
					398	255
					399	275
					400	277
					401	274
					402	256
					403	251
404	259
					405	257
					406	270
					407	279
					408	253
					409	256
					410	253
					411	250
					412	274
					413	276
					414	280
					415	261
					416	268
					417	278
					418	280
					419	279
					420	277
					421	255
					422	257
					423	261
					424	252
					425	250
					426	259
					427	255
					428	267
					429	260
					430	270
					431	271
					432	265
					433	272
					434	252
					435	268
					436	253
					437	275
					438	272
					439	259
					440	280
					441	251
					442	270
					443	261
					444	264
					445	250
					446	258
					447	276
					448	278
					449	257
					450	271
					451	270
					452	273
					453	269
					454	279
					455	261
					456	250
					457	273
					458	260
					459	265
					460	276
					461	262
					462	257
					463	275
					464	258
					465	275
					466	257
					467	273
					468	279
					469	277
					470	272
					471	265
					472	265
					473	270
					474	253
					475	268
					476	264
					477	278
					478	276
					479	257
					480	269
					481	266
					482	252
					483	250
					484	272
					485	271
					486	277
					487	271
					488	258
					489	276
					490	259
					491	255
					492	265
					493	272
					494	278
					495	264
					496	278
					497	278
					498	275
					499	272
					500	274
					501	272
					502	264
					503	278
					504	272
					505	274
					506	250
					507	268
					508	258
					509	266
					510	255
					511	265
					512	279
					513	279
					514	253
					515	264
					516	276
					517	279
					518	259
					519	279
					520	259
					521	268
					522	253
					523	264
					524	259
					525	277
					526	279
					527	251
					528	278
					529	268
					530	272
					531	275
					532	254
					533	255
					534	255
					535	275
					536	275
					537	276
					538	271
					539	256
					540	254
					541	255
					542	272
					543	260
					544	269
					545	279
					546	258
					547	253
					548	268
					549	275
					550	277
					551	262
					552	276
					553	278
					554	262
					555	267
					556	250
					557	254
					558	262
					559	278
					560	274
					561	253
					562	254
					563	256
					564	256
					565	265
					566	260
					567	257
					568	268
					569	256
					570	256
					571	271
					572	275
					573	252
					574	272
					575	263
					576	256
					577	279
					578	269
					579	276
					580	263
					581	250
					582	269
					583	260
					584	262
					585	251
					586	276
					587	251
					588	267
					589	267
					590	272
					591	272
					592	253
					593	256
					594	264
					595	251
					596	266
					597	275
					598	274
					599	277
					600	271
					601	255
					602	258
					603	256
					604	265
					605	260
					606	272
					607	272
					608	268
					609	268
					610	273
					611	256
					612	271
					613	278
					614	269
					615	251
					616	258
					617	270
					618	250
					619	255
					620	260
					621	271
					622	279
					623	252
					624	264
					625	254
					626	275
					627	263
					628	259
					629	269
					630	254
					631	267
					632	258
					633	258
					634	269
					635	252
					636	266
					637	271
					638	280
					639	250
					640	254
					641	260
					642	250
					643	253
					644	263
					645	272
					646	263
					647	253
					648	262
					649	276
					650	273
					651	280
					652	267
					653	259
					654	253
					655	260
					656	261
					657	279
					658	258
					659	271
					660	254
					661	258
					662	276
					663	273
					664	254
					665	261
					666	272
					667	269
					668	261
					669	260
					670	280
					671	270
					672	270
					673	257
					674	278
					675	259
					676	273
					677	274
					678	255
					679	272
					680	267
					681	253
					682	277
					683	259
					684	280
					685	270
					686	266
					687	254
					688	277
					689	253
					690	259
					691	267
					692	265
					693	266
					694	262
					695	268
					696	260
					697	256
					698	276
					699	256
					700	280
					701	260
					702	276
					703	258
					704	269
					705	261
					706	277
					707	266
					708	267
					709	250
					710	263
					711	277
					712	271
					713	255
					714	270
					715	278
					716	274
					717	257
					718	276
					719	259
					720	264
					721	252
					722	271
					723	261
					724	258
					725	252
					726	266
					727	274
					728	269
					729	255
					730	260
					731	257
					732	255
					733	252
					734	269
					735	279
					736	252
					737	267
					738	260
					739	270
					740	280
					741	268
					742	265
					743	259
					744	264
					745	268
					746	278
					747	269
					748	254
					749	261
					750	260
					751	262
					752	267
					753	266
					754	260
					755	277
					756	261
					757	253
					758	277
					759	251
					760	269
					761	270
					762	268
					763	273
					764	273
					765	251
					766	265
					767	262
					768	264
					769	264
					770	278
					771	253
					772	274
					773	265
					774	274
					775	274
					776	279
					777	259
					778	264
					779	266
					780	253
					781	263
					782	269
					783	263
					784	250
					785	271
					786	264
					787	260
					788	270
					789	276
					790	256
					791	273
					792	253
					793	267
					794	253
					795	272
					796	252
					797	271
					798	263
					799	255
					800	254
					801	266
					802	269
					803	250
					804	272
					805	258
					806	252
					807	250
					808	256
					809	276
					810	268
					811	269
					812	255
					813	261
					814	251
					815	266
					816	252
					817	251
					818	270
					819	258
					820	277
					821	261
					822	271
					823	279
					824	275
					825	250
					826	270
					827	274
					828	266
					829	279
					830	270
					831	268
					832	257
					833	256
					834	256
					835	264
					836	274
					837	257
					838	266
					839	265
					840	266
					841	252
					842	257
					843	257
					844	269
					845	255
					846	279
					847	266
					848	265
					849	251
					850	277
					851	253
					852	280
					853	268
					854	280
					855	271
					856	259
					857	279
					858	266
					859	274
					860	259
					861	270
					862	273
					863	278
					864	257
					865	256
					866	261
					867	251
					868	279
					869	279
					870	280
					871	278
					872	254
					873	270
					874	251
					875	257
					876	260
					877	268
					878	280
					879	269
					880	269
					881	274
					882	274
					883	259
					884	264
					885	252
					886	280
					887	253
					888	256
					889	259
					890	272
					891	274
					892	262
					893	265
					894	267
					895	263
					896	259
					897	257
					898	250
					899	262
					900	259
					901	279
					902	267
					903	278
					904	268
					905	250
					906	270
					907	272
					908	254
					909	257
					910	264
					911	256
					912	263
					913	267
					914	277
					915	251
					916	273
					917	258
					918	272
					919	251
					920	266
					921	264
					922	272
					923	251
					924	271
					925	262
					926	259
					927	251
					928	262
					929	256
					930	276
					931	277
					932	280
					933	257
					934	271
					935	273
					936	271
					937	259
					938	256
					939	264
					940	260
					941	273
					942	265
					943	254
					944	268
					945	269
					946	266
					947	251
					948	277
					949	269
					950	255
					951	250
					952	252
					953	272
					954	280
					955	264
					956	264
					957	280
					958	257
					959	276
					960	258
					961	280
					962	261
					963	278
					964	251
					965	253
					966	264
					967	258
					968	279
					969	259
					970	259
					971	261
					972	254
					973	257
					974	256
					975	250
					976	251
					977	280
					978	269
979	273
					980	271
					981	275
					982	261
					983	268
					984	261
					985	276
					986	279
					987	268
					988	254
					989	254
					990	251
					991	263
					992	271
					993	278
					994	269
					995	251
					996	250
					997	254
					998	251
					999	267
					1000	267
					1001	274
					1002	272
					1003	279
					1004	278
					1005	250
					1006	266
					1007	261
					1008	260
					1009	278
					1010	263
					1011	264
					1012	270
					1013	269
					1014	279
					1015	264
					1016	275
					1017	279
					1018	265
					1019	268
					1020	277
					1021	268
					1022	266
					1023	273
					1024	270
					1025	266
					1026	260
					1027	259
					1028	274
					1029	267
					1030	273
					1031	271
					1032	269
					1033	250
					1034	273
					1035	265
					1036	269
					1037	258
					1038	250
					1039	270
					1040	277
					1041	273
					1042	255
					1043	264
					1044	270
					1045	276
					1046	271
					1047	276
					1048	265
					1049	260
					1050	274
					1051	272
					1052	279
					1053	256
					1054	267
					1055	272
					1056	261
					1057	266
					1058	253
					1059	263
					1060	263
					1061	273
					1062	256
					1063	279
					1064	277
					1065	258
					1066	276
					1067	280
					1068	259
					1069	274
					1070	273
					1071	262
					1072	280
					1073	256
					1074	263
					1075	276
					1076	259
					1077	278
					1078	271
					1079	276
					1080	264
					1081	259
					1082	273
					1083	260
					1084	254
					1085	261
					1086	253
					1087	267
					1088	261
					1089	251
					1090	273
					1091	277
					1092	254
					1093	274
					1094	266
					1095	268
					1096	259
					1097	260
					1098	276
					1099	280
					1100	268
					1101	268
					1102	251
					1103	257
					1104	257
					1105	266
					1106	273
					1107	260
					1108	265
					1109	262
					1110	279
					1111	273
					1112	258
					1113	265
					1114	257
					1115	256
					1116	262
					1117	271
					1118	273
					1119	267
					1120	258
					1121	275
					1122	263
					1123	259
					1124	251
					1125	272
					1126	258
					1127	253
					1128	277
					1129	279
					1130	252
					1131	261
					1132	265
					1133	260
					1134	274
					1135	269
					1136	271
					1137	278
					1138	266
					1139	263
					1140	262
					1141	263
					1142	267
					1143	279
					1144	250
					1145	263
					1146	252
					1147	272
					1148	277
					1149	263
					1150	273
					1151	272
					1152	277
					1153	254
					1154	258
					1155	277
					1156	270
					1157	251
					1158	254
					1159	275
					1160	264
					1161	252
					1162	251
					1163	279
					1164	265
					1165	275
					1166	253
					1167	271
					1168	265
					1169	275
					1170	276
					1171	257
					1172	258
					1173	261
					1174	264
					1175	260
					1176	274
					1177	279
					1178	256
					1179	279
					1180	253
					1181	253
					1182	253
					1183	275
					1184	273
					1185	273
					1186	270
					1187	257
					1188	259
					1189	280
					1190	273
					1191	263
					1192	275
					1193	259
					1194	261
					1195	259
					1196	277
					1197	271
					1198	260
					1199	272
					1200	264
					1201	251
					1202	252
					1203	279
					1204	269
					1205	252
					1206	274
					1207	260
					1208	267
					1209	269
					1210	257
					1211	259
					1212	269
					1213	268
					1214	272
					1215	269
					1216	278
					1217	263
					1218	256
					1219	261
					1220	264
					1221	272
					1222	274
					1223	266
					1224	252
					1225	256
					1226	263
					1227	262
					1228	278
					1229	263
					1230	258
					1231	280
					1232	269
					1233	273
					1234	251
					1235	278
					1236	251
					1237	253
					1238	270
					1239	271
					1240	268
					1241	252
					1242	266
					1243	259
					1244	260
					1245	273
					1246	254
					1247	274
					1248	257
					1249	272
					1250	272
					1251	256
					1252	260
					1253	272
					1254	278
					1255	275
					1256	273
					1257	280
					1258	262
					1259	255
					1260	275
					1261	279
					1262	268
					1263	277
					1264	262
					1265	254
					1266	253
					1267	259
					1268	273
					1269	254
					1270	271
					1271	257
					1272	253
					1273	271
					1274	257
					1275	260
					1276	278
					1277	260
					1278	277
					1279	250
					1280	280
					1281	262
					1282	252
					1283	265
					1284	275
					1285	250
					1286	272
					1287	255
					1288	279
					1289	257
					1290	257
					1291	279
					1292	260
					1293	257
					1294	251
					1295	261
					1296	259
					1297	259
					1298	271
					1299	256
					1300	269
					1301	267
					1302	256
					1303	270
					1304	256
					1305	266
					1306	264
					1307	253
					1308	264
					1309	254
					1310	259
					1311	263
					1312	269
					1313	262
					1314	275
					1315	280
					1316	275
					1317	262
					1318	262
					1319	263
					1320	263
					1321	252
					1322	261
					1323	270
					1324	258
					1325	258
					1326	269
					1327	255
					1328	274
					1329	264
					1330	269
					1331	250
					1332	268
					1333	257
					1334	278
					1335	270
					1336	273
					1337	278
					1338	250
					1339	274
					1340	277
					1341	257
					1342	253
					1343	275
					1344	255
					1345	257
					1346	271
					1347	261
					1348	256
					1349	254
					1350	268
					1351	250
					1352	255
					1353	267
					1354	258
					1355	268
					1356	250
					1357	271
					1358	255
					1359	253
					1360	251
					1361	257
					1362	275
					1363	278
					1364	279
					1365	255
					1366	257
					1367	260
					1368	261
					1369	265
					1370	268
					1371	280
					1372	260
					1373	253
					1374	251
					1375	251
					1376	259
					1377	260
					1378	261
					1379	269
					1380	270
					1381	260
					1382	278
					1383	256
					1384	268
					1385	259
					1386	267
					1387	274
					1388	266
					1389	252
					1390	262
					1391	259
					1392	254
					1393	262
					1394	256
					1395	264
					1396	278
					1397	265
					1398	251
					1399	271
					1400	252
					1401	250
					1402	270
					1403	263
					1404	270
					1405	276
					1406	278
					1407	278
					1408	266
					1409	271
					1410	253
					1411	252
					1412	277
					1413	257
					1414	275
					1415	271
					1416	261
					1417	255
					1418	255
					1419	252
					1420	250
					1421	257
					1422	266
					1423	251
					1424	265
					1425	271
					1426	258
					1427	254
					1428	258
					1429	266
					1430	274
					1431	251
					1432	262
					1433	273
					1434	276
					1435	259
					1436	275
					1437	255
					1438	278
					1439	278
					1440	280
					1441	278
					1442	253
					1443	255
					1444	276
					1445	267
					1446	259
					1447	279
					1448	265
					1449	269
					1450	276
					1451	258
					1452	276
					1453	272
					1454	274
					1455	258
					1456	256
					1457	251
					1458	260
					1459	276
					1460	256
					1461	272
					1462	253
					1463	250
					1464	277
					1465	278
					1466	263
					1467	264
					1468	276
					1469	262
					1470	251
					1471	265
					1472	250
					1473	270
					1474	271
					1475	274
					1476	273
					1477	261
					1478	274
					1479	279
					1480	276
					1481	261
					1482	257
					1483	251
					1484	268
					1485	262
					1486	274
					1487	257
					1488	257
					1489	276
					1490	269
					1491	258
					1492	253
					1493	250
					1494	253
					1495	256
					1496	266
					1497	273
					1498	275
					1499	264
					1500	276
					1501	257
					1502	257
					1503	279
					1504	266
					1505	273
					1506	275
					1507	253
					1508	266
					1509	276
					1510	258
					1511	252
					1512	278
					1513	278
					1514	268
					1515	262
					1516	271
1517	265
					1518	274
					1519	264
					1520	275
					1521	277
					1522	257
					1523	251
					1524	265
					1525	251
					1526	280
					1527	266
					1528	275
					1529	265
					1530	276
					1531	274
					1532	276
					1533	274
					1534	260
					1535	279
					1536	262
					1537	271
					1538	267
					1539	266
Questão 5
	
	
	
	
	Item	Demanda anual	Valor unitário
	P1	870	R$2,040.00
	P2	2275	R$21,556.00
	P3	1817	R$18,514.00		a) dispor Demanda anual em ordem crescente
	P4	111	R$2,041.00
	P5	1873	R$641.00
	P6	708	R$18,187.00		b) dispor demanda anual em ordem decrescente e então valor unitário em ordem crescente
	P7	2315	R$24,635.00
	P8	1936	R$19,247.00
	P9	338	R$11,656.00		c) Fazer uma classificação ABC dos produtos de acordo com seu Total (unidades compradas x valor unitário)
	P10	1600	R$1,565.00
	P11	101	R$12,574.00		a)				b)				c)
	P12	2492	R$9,719.00		Item	Demanda anual	Valor unitário		Item	Demanda anual	Valor unitário		Item	Demanda anual	Valor unitário	Rendimento	% Rend.	% Acumulada	Classe
	P13	155	R$1,890.00		P11	101	R$ 12,574.00		P12	2492	R$9,719.00		P7	2315	R$24,635.00	R$57,030,025.00	9.73%	9.73%	A
	P14	1538	R$14,348.00		P4	111	R$ 2,041.00		P7	2315	R$24,635.00		P18	2164	R$24,346.00	R$52,684,744.00	8.99%	18.72%
	P15	366	R$11,181.00		P13	155	R$ 1,890.00		P20	2300	R$19,099.00		P2	2275	R$21,556.00	R$49,039,900.00	8.37%	27.09%
	P16	1624	R$17,245.00		P31	158	R$ 9,223.00		P2	2275	R$21,556.00		P20	2300	R$19,099.00	R$43,927,700.00	7.49%	34.58%
	P17	212	R$10,373.00		P22	159	R$ 24,063.00		P18	2164	R$24,346.00		P21	2159	R$17,829.00	R$38,492,811.00	6.57%	41.15%
	P18	2164	R$24,346.00		P19	179	R$ 4,698.00		P21	2159	R$17,829.00		P8	1936	R$19,247.00	R$37,262,192.00	6.36%	47.50%
	P19	179	R$4,698.00		P17	212	R$ 10,373.00		P8	1936	R$19,247.00		P3	1817	R$18,514.00	R$33,639,938.00	5.74%	53.24%
	P20	2300	R$19,099.00		P30	245	R$ 8,799.00		P5	1873	R$641.00		P23	1571	R$19,543.00	R$30,702,053.00	5.24%	58.48%
	P21	2159	R$17,829.00		P24	335	R$ 23,067.00		P29	1851	R$11,301.00		P16	1624	R$17,245.00	R$28,005,880.00	4.78%	63.26%
	P22	159	R$24,063.00		P9	338	R$ 11,656.00		P3	1817	R$18,514.00		P27	1460	R$18,585.00	R$27,134,100.00	4.63%	67.89%
	P23	1571	R$19,543.00		P26	343	R$ 6,077.00		P16	1624	R$17,245.00		P12	2492	R$9,719.00	R$24,219,748.00	4.13%	72.02%
	P24	335	R$23,067.00		P28	363	R$ 17,579.00		P10	1600	R$1,565.00		P14	1538	R$14,348.00	R$22,067,224.00	3.76%	75.79%	B
	P25	375	R$4,612.00		P15	366	R$ 11,181.00		P23	1571	R$19,543.00		P29	1851	R$11,301.00	R$20,918,151.00	3.57%	79.36%
	P26	343	R$6,077.00		P25	375	R$ 4,612.00		P14	1538	R$14,348.00		P35	1028	R$16,854.00	R$17,325,912.00	2.96%	82.31%
	P27	1460	R$18,585.00		P33	688	R$ 10,977.00		P27	1460	R$18,585.00		P34	1281	R$12,743.00	R$16,323,783.00	2.79%	85.10%
	P28	363	R$17,579.00		P6	708	R$ 18,187.00		P34	1281	R$12,743.00		P36	1015	R$14,442.00	R$14,658,630.00	2.50%	87.60%
	P29	1851	R$11,301.00		P1	870	R$ 2,040.00		P32	1134	R$7,551.00		P6	708	R$18,187.00	R$12,876,396.00	2.20%	89.79%
	P30	245	R$8,799.00		P36	1015	R$ 14,442.00		P35	1028	R$16,854.00		P32	1134	R$7,551.00	R$8,562,834.00	1.46%	91.26%	C
	P31	158	R$9,223.00		P35	1028	R$ 16,854.00		P36	1015	R$14,442.00		P24	335	R$23,067.00	R$7,727,445.00	1.32%	92.57%
	P32	1134	R$7,551.00		P32	1134	R$ 7,551.00		P1	870	R$2,040.00		P33	688	R$10,977.00	R$7,552,176.00	1.29%	93.86%
	P33	688	R$10,977.00		P34	1281	R$ 12,743.00		P6	708	R$18,187.00		P28	363	R$17,579.00	R$6,381,177.00	1.09%	94.95%
	P34	1281	R$12,743.00		P27	1460	R$ 18,585.00		P33	688	R$10,977.00		P15	366	R$11,181.00	R$4,092,246.00	0.70%	95.65%
	P35	1028	R$16,854.00		P14	1538	R$ 14,348.00		P25	375	R$4,612.00		P9	338	R$11,656.00	R$3,939,728.00	0.67%	96.32%
	P36	1015	R$14,442.00		P23	1571	R$ 19,543.00		P15	366	R$11,181.00		P22	159	R$24,063.00	R$3,826,017.00	0.65%	96.97%
					P10	1600	R$ 1,565.00		P28	363	R$17,579.00		P10	1600	R$1,565.00	R$2,504,000.00	0.43%	97.40%
					P16	1624	R$ 17,245.00		P26	343	R$6,077.00		P17	212	R$10,373.00	R$2,199,076.00	0.38%	97.78%
					P3	1817	R$ 18,514.00		P9	338	R$11,656.00		P30	245	R$8,799.00	R$2,155,755.00	0.37%	98.14%
					P29	1851	R$ 11,301.00		P24	335	R$23,067.00		P26	343	R$6,077.00	R$2,084,411.00	0.36%	98.50%
					P5	1873	R$ 641.00		P30	245	R$8,799.00		P1	870	R$2,040.00	R$1,774,800.00	0.30%	98.80%
					P8	1936	R$ 19,247.00		P17	212	R$10,373.00		P25	375	R$4,612.00	R$1,729,500.00	0.30%	99.10%
					P21	2159	R$ 17,829.00		P19	179	R$4,698.00		P31	158	R$9,223.00	R$1,457,234.00	0.25%	99.35%
					P18	2164	R$ 24,346.00		P22	159	R$24,063.00		P11	101	R$12,574.00	R$1,269,974.00	0.22%	99.56%
					P2	2275	R$ 21,556.00		P31	158	R$9,223.00		P5	1873	R$641.00	R$1,200,593.00	0.20%	99.77%
					P20	2300	R$ 19,099.00		P13	155	R$1,890.00		P19	179	R$4,698.00	R$840,942.00	0.14%	99.91%
					P7	2315	R$ 24,635.00		P4	111	R$2,041.00		P13	155	R$1,890.00	R$292,950.00	0.05%	99.96%
					P12	2492	R$ 9,719.00		P11	101	R$12,574.00		P4	111	R$2,041.00	R$226,551.00	0.04%	100.00%
																R$586,126,596.00
Questão 6
	
	
	Q - tamanho do lote	273.2520204256
	A - custo colocação pedido	70
	D - demanda anual	20000
	i - % custo guarda	0.25
	C - custo unitário	150
	
				a) qual o tamanho do lote ótimo (Q*)?
				273.25
	
				b) qual a demanda para Q*=250 unidades
				16,741
	
				c) qual o custo C para Q*=1000?
				R$ 11.20
	
				d) qual o custo de estoque para Q=1150?
				R$ 3,022,779.89
MBD01438B3C.unknown
MBD01438B3D.unknown