Aula 6

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

Plan1
	Lote	Medicações	Média	R
	1	10.69	10.8	10.39	10.6267	0.41000000000000014	desviop	0.21559362079149458
	2	10.199999999999999	10.3	10.72	10.4067	0.52000000000000135	LIE	9
	3	10.42	10.61	10.54	10.5233	0.1899999999999995	LSE	12
	4	10.98	10.27	10.5	10.5833	0.71000000000000085	d	10.5
	5	10.61	10.52	10.67	10.6000	0.15000000000000036	Cp	2.3191780822
	6	10.57	10.46	10.5	10.5100	0.10999999999999943	Cpk	2.3019130898
	7	10.44	10.29	9.86	10.1967	0.58000000000000007	Cpm	2.3160734751
	8	10.199999999999999	10.29	10.41	10.3000	0.21000000000000085	Sistema considerado incapaz
	9	10.46	10.76	10.74	10.6533	0.29999999999999893
	10	10.11	10.33	10.98	10.4733	0.87000000000000099
	11	10.29	10.57	10.65	10.5033	0.36000000000000121
	12	10.83	11	10.65	10.8267	0.34999999999999964
	13	10.35	10.07	10.48	10.3000	0.41000000000000014
	14	10.69	10.54	10.61	10.6133	0.15000000000000036
	15	10.44	10.44	10.57	10.4833	0.13000000000000078
	16	10.63	9.86	10.54	10.3433	0.77000000000000135
	17	10.54	10.82	10.48	10.6133	0.33999999999999986
	18	10.5	10.61	10.54	10.5500	0.10999999999999943
	19	10.29	10.79	10.74	10.6067	0.5
	20	10.57	10.44	10.52	10.5100	0.13000000000000078
	Média Geral	10.5112	0.36500000000000032
	 
Plan2
	Lote	Unideade	R
	1	3.2	0.10000000000000009	desviop	0.25783096926713939
	2	3.1	0.20000000000000018
	3	2.9	0	LSE	4.5
	4	2.9	0.10000000000000009
	5	2.8	0.20000000000000018
	6	3	0	Cpk	0.376
	7	3	0.5	Sistema considerado incapaz
	8	2.5	0.79999999999999982
9	3.3	0.5
	10	2.8	0.5
	11	3.3	0.29999999999999982
	12	3	0.29999999999999982
	13	3.3	4.0000000000000036E-2
	14	3.26	0.6599999999999997
	15	2.6	0.5
	16	3.1	0.19999999999999973
	17	3.3	0.19999999999999973
	18	3.1	0.29000000000000004
	19	2.81	0.48999999999999977
	20	3.3	0.20000000000000018
	21	3.5	0
	22	3.5	0.20000000000000018
	23	3.7	0.5
	24	4.2	0.20000000000000018
	25	4
	Médias	3.1445833333333333	0.29083333333333322
Plan3
	Lote	Média	R
	1	1.48412	0.71399999999999997	sigma	0.28191229578675836
	2	1.46782	0.74209999999999998	LIE	0.15
	3	1.15360	0.88749999999999996	LSE	2.8	4- Pegar o pior lado (cenário) com o intuito de maximizar a chance de detectar a não capacidade (itens não conformes), pegando o lado pior, logicamene você considera o melhor lado e o contrário não acontece, permite a avaliação da capacidade do processo na "pior situação possível".
	4	1.15417	0.1943
	5	1.06081	0.53600000000000003	Cp	1.5666811035
	6	1.22694	0.63829999999999998	Cpk	1.443639527
	7	1.42857	0.61570000000000003	Cpm	1.5462851701
	8	1.57338	0.39850000000000002	Sistema considerado capaz
	9	1.36668	0.4425
	10	1.40551	0.57420000000000004
	11	1.41522	0.31390000000000001
	12	1.22695	0.4793
	13	1.44757	1.0983000000000001
	14	1.21628	0.6371
	15	1.09659	0.16830000000000001
	16	1.14506	0.77339999999999998
	17	1.52564	1.4715
	18	1.33756	0.53520000000000001
	19	1.43040	0.36580000000000001
	20	1.40018	1.0718000000000001
	21	2.11205	0.75260000000000005
	22	1.92540	1.2107000000000001
	23	1.40704	0.83640000000000003
	24	1.20172	0.49459999999999998
	25	1.06422	0.44119999999999998
	1.37094	0.65573