Aula 3 Exercícios

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

comandos variados
	
		Os valores abaixo referem-se ao resíduo de um componente químico medido em 1000 amostras. Responda às seguintes questões:
	
	
	
	
		Amostra	Resíduo	C)
		1	1.1460005493	1
		2	0.3020416883	1
		3	1.7894528031	0
		4	2.697317423	1		a) definir número de amostras com resíduo > 1,8
		5	2.653828547	1		408
		6	2.8753929258	1
		7	0.043488876	1		b) calcular a média das amostras com resíduo > 1,8
		8	1.2222663045	1		2.44034529
		9	2.5897396771	1
		10	0.4157536546	1		c) identificar amostras com resíduo < 1,6 e > 1,8
		11	0.7350993377	1
		12	0.1364177374	1
		13	0.0971404157	1		d) soma dos resíduos das amostras com resíduo >2.05
		14	0.4923856319	1		864.308
		15	0.6588335826	1
		16	0.0512710959	1		e) máximo resíduo
		17	0.8551286355	1		2.9961546678
		18	1.0292672506	1
		19	1.6609088412	0		f) mínimo resíduo
		20	1.0721152379	1		0.0084231086
		21	1.1155125584	1
		22	1.0668050172	1		g) gere um gráfico de colunas do resíduo
		23	2.730918302	1
		24	1.3980529191	1
		25	1.278481399	1
		26	0.9117099521	1
		27	2.9271217994	1
		28	2.4199957274	1
		29	2.9737235633	1
		30	0.7687917722	1
		31	2.8550675985	1
		32	0.1603137303	1
		33	2.1151158177	1
		34	2.4495681631	1
		35	2.9175084689	1
		36	1.3989684744	1
		37	0.9006317331	1
		38	2.2506179998	1
		39	1.0544450209	1
		40	2.3269753105	1
		41	0.2230292673	1
		42	0.5952940458	1
		43	0.1921750542	1
		44	1.0750450148	1
		45	1.4611346782	1
		46	1.5336466567	1
		47	1.1203650014	1
		48	2.9577013459	1
		49	0.1221350749	1
		50	0.6921597949	1
		51	0.0149235511	1
		52	2.7784356212	1
		53	0.3009430219	1
		54	0.7700735496	1
		55	2.3270668661	1
		56	2.0389416181	1
		57	2.4273201697	1
		58	2.1729789117	1
		59	0.2551652577	1
		60	0.3968016602	1
		61	2.2684713279	1
		62	1.8795434431	1
		63	0.5209509568	1
		64	1.2143925291	1
		65	1.6569719535	0
		66	2.1345255898	1
		67	1.6654866176	0
		68	0.5434736167	1
		69	2.9108249153	1
		70	2.0608233894	1
		71	1.5863826411	1
		72	2.3900570696	1
		73	2.416974395	1
		74	0.7866451003	1
		75	0.5338602863	1
		76	2.6002685629	1
		77	0.3445234535	1
		78	0.1785332804	1
		79	2.2846766564	1
		80	2.2151860103	1
		81	2.9588915677	1
		82	2.7767876217	1
		83	2.7116000855	1
		84	1.6349070711	0
		85	1.502334666	1
		86	2.0249336222	1
		87	1.4694662313	1
		88	0.4373607593	1
		89	0.1138950774	1
		90	2.3887752922	1
		91	2.0146794031	1
		92	2.1950437941	1
		93	1.753563036	0
		94	0.4566789758	1
		95	2.6765343181	1
		96	1.1334574419	1
		97	0.6014282662	1
		98	0.6173589282	1
		99	1.0018921476	1
		100	0.9754325999	1
		101	0.9006317331	1
		102	2.4065370647	1
		103	2.0882900479	1
		104	0.8144779809	1
		105	2.7121494186	1
		106	0.1173741874	1
		107	2.127109592	1
		108	1.3611560411	1
		109	1.5499435408	1
		110	0.769615772	1
		111	0.8738975188	1
		112	2.4064455092	1
		113	2.367076632	1
		114	2.0278633992	1
		115	2.2659993286	1
		116	2.8455458235	1
		117	1.858211005	1
		118	2.1662038026	1
		119	2.9041413617	1
		120	1.1058076724	1
		121	2.5512863552	1
		122	1.6711630604	0
		123	2.6192205573	1
		124	1.3231604968	1
		125	0.6532486953	1
		126	2.5771050142	1
		127	0.8410290841	1
		128	2.1098971526	1
		129	2.1221655934	1
		130	1.1275063326	1
		131	0.9890743736	1
		132	0.2579119236	1
		133	2.9306009095	1
		134	0.856593524	1
		135	1.6029541917	0
		136	1.222174749	1
		137	2.9931333354	1
		138	2.6841334269	1
		139	2.4324472793	1
		140	2.7257911924	1
		141	1.7235328227	0
		142	2.1182287057	1
		143	1.2043214209	1
		144	0.3330790124	1
		145	2.6920987579	1
		146	1.1590014344	1
		147	0.2873928037	1
		148	2.3329264199	1
		149	2.3506881924	1
		150	1.9971922971	1
		151	1.9705496384	1
		152	0.7753837703	1
		153	2.2955717643	1
		154	2.1009247108	1
		155	2.5764641255	1
		156	0.0084231086	1
		157	2.0358287301	1
		158	2.7864925077	1
		159	0.1274452956	1
		160	1.5544297617	1
		161	2.7364116337	1
		162	2.8629413739	1
		163	1.7829523606	0
		164	1.672994171	0
		165	2.9045075838	1
		166	1.4490493484	1
		167	0.7668691061	1
		168	2.4536881619	1
		169	1.4881435591	1
		170	2.5519272439	1
		171	2.0043336283	1
		172	2.7808160649	1
		173	1.3552964873	1
		174	0.5042878506	1
		175	0.1858577227	1
		176	0.0154728843	1
		177	1.623279519	0
		178	1.8528092288	1
		179	1.4787133396	1
		180	1.7383648183	0
		181	1.8056581317	1
		182	2.7901547288	1
		183	1.6019470809	0
		184	0.3961607715	1
		185	0.2468337046	1
		186	1.727744377	0
		187	2.4876552629	1
		188	0.1970274972	1
		189	0.8128299814	1
		190	2.0990936003	1
		191	1.2425916318	1
		192	1.096743675	1
		193	1.3052156133	1
		194	0.9902645955	1
		195	0.6332895901	1
		196	2.2214117862	1
		197	1.5703604236	1
		198	2.6903592029	1
		199	1.8102359081	1
		200	1.568346202	1
		201	1.7693105869	0
		202	1.7547532579	0
		203	1.491073336	1
		204	0.3315225684	1
		205	1.7791070284	0
		206	1.6767479476	0
		207	2.3223059786	1
		208	0.6924344615	1
		209	2.1935789056	1
		210	1.760155034	0
		211	1.6365550707	0
		212	2.422009949	1
		213	2.8928800317	1
		214	0.2861110263	1
		215	0.3256630146	1
		216	2.136814478	1
		217	2.6493423261	1
		218	0.5697500534	1
		219	0.0478835414	1
		220	0.5536362804	1
		221	1.7401043733	0
		222	1.9981994079	1
		223	0.4869838557	1
		224	0.5853144932	1
		225	2.0335398419	1
		226	1.6451612903	0
		227	0.8836939604	1
		228	1.6224555193	0
		229	0.5196691794	1
		230	0.5559251686	1
		231	2.5570543535	1
		232	2.8442640461	1
		233	0.7523117771	1
		234	1.2952360607	1
		235	1.6346324046	0
		236	2.9024018067	1
		237	2.1722464675	1
		238	2.8530533769	1
		239	1.7108066042	0
		240	2.8219244972	1
		241	0.7795953246	1
		242	0.5009918516	1
		243	2.6512649922	1
		244	2.4626606037	1
		245	0.125614185	1
		246	2.6949369793	1
		247	1.2624591815	1
		248	0.3846247749	1
		249	0.0903653066	1
		250	0.6141544847	1
		251	2.0460829493	1
		252	2.4618366039	1
		253	1.416913358	1
		254	1.4355906858	1
		255	1.7549363689	0
		256	1.0872219001	1
		257	2.4699850459	1
		258	0.9316690573	1
		259	2.9713431196	1
		260	2.3147068697	1
		261	2.1878109073	1
		262	0.4898220771	1
		263	2.4249397259	1
		264	2.7782525101	1
		265	0.6968291269	1
		266	1.1449934385	1
		267	0.2705465865	1
		268	2.735953856	1
		269	2.5560472427	1
		270	1.7194128239	0
		271	0.0426648762	1
		272	2.0802331614	1
		273	2.1019318216	1
		274	2.6640827662	1
		275	0.5069429609	1
		276	2.6580401013	1
		277	0.8612628559	1
		278	0.6947233497	1
		279	0.1268959624	1
		280	2.7461165197	1
		281	0.5015411847	1
		282	2.8167973876	1
		283	0.3646656697	1
		284	1.0237739189	1
		285	0.2863856929	1
		286	2.8321787164	1
		287	1.5344706565	1
		288	1.8884243294	1
		289	2.5066988128	1
		290	2.9230933561	1
		291	1.4271675771	1
		292	0.4547563097	1
		293	0.8536637471	1
		294	2.4049806207	1
		295	2.4254890591	1
		296	2.0857264931	1
		297	0.2059083834	1
		298	0.2439954833	1
		299	1.3284707175	1
		300	0.7940610981	1
		301	0.795434431	1
		302	2.4308908353	1
		303	0.6028015992	1
		304	1.3628040407	1
		305	1.2246467483	1
		306	2.806634724	1
		307	0.2815332499	1
		308	0.5243385113	1
		309	1.3006378368	1
		310	0.4329660939	1
		311	0.2273323771	1
		312	0.0457777642	1
		313	2.157963805	1
		314	1.1020538957	1
		315	1.9801629688	1
		316	0.0607013153	1
		317	2.6356089969	1
		318	0.0769981994	1
		319	0.9074068422	1
		320	0.4933011872	1
		321	1.3799249245	1
		322	1.6608172857	0
		323	2.8760338145	1
		324	0.9186681722	1
		325	0.6402478103	1
		326	0.682821131	1
		327	2.1639149144	1
		328	2.7012543107	1
		329	0.2267830439	1
		330	2.5013885922	1
		331	2.8314462722	1
		332	0.7572557756	1
		333	1.5993835261	1
		334	0.6112247078	1
		335	2.2699362163	1
		336	1.7835932493	0
		337	1.5558030946	1
		338	0.4546647542	1
		339	1.1467329936	1
		340	2.2969450972	1
		341	1.4884182257	1
		342	2.5256508072	1
		343	0.4659260842	1
		344	2.3278908658	1
		345	2.6784569842	1
		346	0.3632923368	1
		347	1.9624011963	1
		348	0.1123386334	1
		349	1.5948057497
1
		350	2.5285805841	1
		351	2.5492721335	1
		352	1.6255684072	0
		353	0.6693624683	1
		354	2.1555833613	1
		355	2.0363780633	1
		356	2.3007904294	1
		357	0.5139011811	1
		358	2.173894467	1
		359	2.8391369366	1
		360	1.777825251	0
		361	1.0500503555	1
		362	1.7946714682	0
		363	2.8964506973	1
		364	0.0245368816	1
		365	1.5200964385	1
		366	1.3530991546	1
		367	2.5164036988	1
		368	2.6753440962	1
		369	2.8471022675	1
		370	0.1033661916	1
		371	2.3679006317	1
		372	1.9294412061	1
		373	2.3130588702	1
		374	2.0573442793	1
		375	1.3384502701	1
		376	2.8544267098	1
		377	2.0256660665	1
		378	1.4626911222	1
		379	1.4753257851	1
		380	1.4372386853	1
		381	0.13861507	1
		382	2.0135807367	1
		383	1.7293008209	0
		384	2.2271797845	1
		385	1.2988067263	1
		386	2.386486404	1
		387	2.7204809717	1
		388	2.9143040254	1
		389	0.28501236	1
		390	2.1971495712	1
		391	1.2437818537	1
		392	0.6871242409	1
		393	2.3104037599	1
		394	2.9704275643	1
		395	2.734214301	1
		396	1.7139194922	0
		397	0.9540086062	1
		398	1.2176885281	1
		399	0.4082461013	1
		400	1.589495529	1
		401	1.1938840907	1
		402	2.2161931211	1
		403	0.3039643544	1
		404	2.0945158238	1
		405	2.5067903684	1
		406	0.581469161	1
		407	1.9345683157	1
		408	2.1067842647	1
		409	2.5060579241	1
		410	1.2309640797	1
		411	1.7764519181	0
		412	1.0126956999	1
		413	2.0850856044	1
		414	2.827784051	1
		415	1.3105258339	1
		416	0.4590594195	1
		417	0.5353251747	1
		418	2.3017059847	1
		419	2.8343760491	1
		420	0.7912228767	1
		421	0.6077455977	1
		422	2.5403912473	1
		423	1.7646412549	0
		424	2.0199896237	1
		425	2.9859920042	1
		426	0.8435926389	1
		427	0.649037141	1
		428	2.661976989	1
		429	1.1410565508	1
		430	0.2350230415	1
		431	2.6055787835	1
		432	0.296456801	1
		433	1.0354930265	1
		434	0.225409711	1
		435	0.4080629902	1
		436	2.1835077975	1
		437	1.6453444014	0
		438	0.1203955199	1
		439	2.9375591296	1
		440	1.7848750267	0
		441	2.769737846	1
		442	1.4677266762	1
		443	1.2171391949	1
		444	1.534745323	1
		445	0.0960417493	1
		446	0.7353740043	1
		447	2.7498702963	1
		448	1.7009186071	0
		449	0.9902645955	1
		450	0.8177739799	1
		451	0.3776665548	1
		452	2.6823938719	1
		453	2.9797662282	1
		454	2.4603717154	1
		455	1.381572924	1
		456	0.5854976043	1
		457	1.3986938078	1
		458	1.1983703116	1
		459	1.0393383587	1
		460	2.4241157262	1
		461	1.1648609882	1
		462	1.9038972137	1
		463	2.3619495224	1
		464	1.7852412488	0
		465	0.1548203986	1
		466	1.5322733238	1
		467	2.2267220069	1
		468	1.3065889462	1
		469	0.1485946226	1
		470	0.1651661733	1
		471	0.6245918149	1
		472	1.8073976867	1
		473	0.8106326487	1
		474	2.9413129063	1
		475	1.2424085208	1
		476	2.4181646168	1
		477	2.6772667623	1
		478	0.9698477126	1
		479	0.0975981933	1
		480	0.5509811701	1
		481	1.6183355205	0
		482	1.8203985717	1
		483	2.4441663869	1
		484	0.0570390942	1
		485	0.7425153356	1
		486	1.6822412793	0
		487	1.6688741722	0
		488	1.4119693594	1
		489	1.2145756401	1
		490	2.7874996185	1
		491	2.3969237342	1
		492	0.2745750298	1
		493	0.9530930509	1
		494	1.1918698691	1
		495	0.5247962889	1
		496	1.2635578478	1
		497	1.6786706137	0
		498	0.5066682943	1
		499	2.4003112888	1
		500	1.2925809503	1
		501	2.2799157689	1
		502	0.6753135777	1
		503	1.8664510025	1
		504	0.3118381298	1
		505	2.9663991211	1
		506	2.3885921812	1
		507	0.3911252174	1
		508	2.7965636158	1
		509	1.1778618732	1
		510	0.2328257088	1
		511	0.998321482	1
		512	1.8266243477	1
		513	0.7180700095	1
		514	2.1637318033	1
		515	1.2208929716	1
		516	2.1037629322	1
		517	0.0815759758	1
		518	0.4001892148	1
		519	2.7940916166	1
		520	1.7460554827	0
		521	2.4430677206	1
		522	0.3319803461	1
		523	0.3073519089	1
		524	1.2064271981	1
		525	1.276924955	1
		526	2.5351725822	1
		527	2.5353556932	1
		528	1.1578112125	1
		529	2.0774864956	1
		530	2.4871974853	1
		531	0.6628620258	1
		532	0.6890469069	1
		533	1.146458327	1
		534	2.0793176061	1
		535	0.1277199622	1
		536	2.6544694357	1
		537	2.9183324686	1
		538	1.5156102176	1
		539	0.2959074679	1
		540	1.5220191046	1
		541	2.7910702841	1
		542	1.6951506088	0
		543	2.6899929807	1
		544	2.563554796	1
		545	1.9319132054	1
		546	0.6707358013	1
		547	0.9888912626	1
		548	2.7292703024	1
		549	2.0259407331	1
		550	2.2770775475	1
		551	0.518570513	1
		552	0.0532853175	1
		553	1.4373302408	1
		554	2.5225379192	1
		555	2.4504837184	1
		556	0.9310281686	1
		557	0.7513046663	1
		558	1.8388012329	1
		559	0.4283883175	1
		560	2.1134678182	1
		561	0.1652577288	1
		562	2.7811822871	1
		563	2.8425244911	1
		564	0.7624744407	1
		565	2.6991485336	1
		566	2.2745139927	1
		567	2.4669637135	1
		568	0.4099856563	1
		569	2.6917325358	1
		570	0.996765038	1
		571	2.6830347606	1
		572	0.1658986175	1
		573	0.5537278359	1
		574	2.9961546678	1
		575	1.0041810358	1
		576	1.0163579211	1
		577	2.2458571123	1
		578	1.1332743309	1
		579	0.1229590747	1
		580	1.5592822047	1
		581	2.4481948302	1
		582	2.444532609	1
		583	1.1978209784	1
		584	2.0182500687	1
		585	2.8945280313	1
		586	2.017792291	1
		587	1.5991088595	1
		588	0.8790246284	1
		589	1.8350474563	1
		590	1.476516007	1
		591	2.8328196051	1
		592	2.9945066683	1
		593	0.1002533036	1
		594	1.6647541734	0
		595	2.8607440413	1
		596	2.4978179266	1
		597	1.7326883755	0
		598	2.6267281106	1
		599	2.5359965819	1
		600	1.3724173711	1
		601	0.655262917	1
		602	0.4754478591	1
		603	0.3724478896	1
		604	0.0177617725	1
		605	0.3465376751	1
		606	2.2438428907	1
		607	2.3667104099	1
		608	2.6585894345	1
		609	0.9897152623	1
		610	0.3116550188	1
		611	0.0915555284	1
		612	0.9384441664	1
		613	1.0650654622	1
		614	2.5027619251	1
		615	0.7806939909	1
		616	2.5436872463	1
		617	1.8552812281	1
		618	2.4454481643	1
		619	2.6203192236	1
		620	2.199530015	1
		621	1.8305612354	1
		622	1.2910245064	1
		623	1.9707327494	1
		624	0.8834192938	1
		625	2.3840144047	1
		626	1.3828547014	1
		627	0.7328104495	1
		628	0.5990478225	1
		629	2.8855555895	1
		630	1.9708243049	1
		631	1.5807977538	1
		632	2.554033021	1
		633	0.521866512	1
		634	1.5637684256	1
		635	1.2781151769	1
		636	2.0863673818	1
		637	2.8938871426	1
		638	1.0153508103	1
		639	2.7966551714	1
		640	2.1823175756	1
		641	2.8372142705	1
		642	2.9353617969	1
		643	2.4570757164	1
		644	2.9299600208	1
		645	1.4368724631	1
		646	1.5209204382	1
		647	2.809930723	1
		648	0.7515793329	1
		649	1.7042146062	0
		650	0.4019287698	1
		651	1.4747764519	1
		652	2.7604907376	1
		653	1.8841212195	1
		654	1.5934324168	1
		655	0.6583758049	1
		656	0.0820337535	1
		657	0.8619953001	1
		658	0.1490524003	1
		659	2.5680410169	1
		660	1.4886928922	1
		661	2.6398205512	1
		662	2.61015656	1
		663	2.4409619434	1
		664	2.1859797967	1
		665	2.3477584155	1
		666	1.8423718986	1
		667	1.4075746941	1
		668	1.0987578967	1
		669	0.7636646626	1
		670	1.3562120426	1
		671	2.9071626942	1
		672	1.4983977783	1
		673	2.8055360576	1
		674	0.7021393475	1
		675	2.8753929258	1
		676	0.3155919065	1
		677	1.9676198614	1
		678	2.0369273965	1
		679	0.4217963195	1
		680	2.9826960051	1
		681	2.1695913572	1
		682	0.452558977	1
		683	0.2169866024	1
		684	0.1483199561	1
		685	0.9856868191	1
		686	0.1637928404	1
		687	0.3057954649	1
		688	0.1105075228	1
		689	0.7234717856	1
		690	1.1457258827	1
		691	2.5693227943	1
		692	2.3082064272	1
		693	1.3214209418	1
		694	1.3168431654	1
		695	0.5497909482	1
		696	2.7183751946	1
		697	2.5331583605	1
		698	0.8608966338	1
		699	2.8621173742	1
		700	0.5011749626	1
		701	2.3680837428	1
		702	2.7809076205	1
		703	1.9049043245	1
		704	0.7365642262	1
		705	1.2557756279	1
		706	2.2790002136	1
		707	0.0961333048	1
		708	0.5963927122	1
		709	1.9050874355	1
		710	1.0572832423	1
		711	0.3469038972	1
		712	1.7960448012	0
		713	2.3234046449	1
		714	0.1311990722	1
		715	0.9951170385	1
		716	0.6689046907	1
		717
1.9690847499	1
		718	1.2510147404	1
		719	0.9166539506	1
		720	1.7079683828	0
		721	0.5012665181	1
		722	0.5239722892	1
		723	1.0330210273	1
		724	2.9176000244	1
		725	0.099978637	1
		726	1.3321329386	1
		727	1.9345683157	1
		728	1.819757683	1
		729	2.8219244972	1
		730	0.1377910703	1
		731	1.8367870113	1
		732	0.4582354198	1
		733	1.9624011963	1
		734	2.2724997711	1
		735	0.5905331584	1
		736	1.2450636311	1
		737	0.8928495132	1
		738	0.3012176885	1
		739	1.963042085	1
		740	1.9916074099	1
		741	1.3407391583	1
		742	2.0573442793	1
		743	1.9089327677	1
		744	2.9698782311	1
		745	0.581469161	1
		746	1.9406109806	1
		747	0.0510879849	1
		748	1.3460493789	1
		749	2.5117343669	1
		750	0.5724967193	1
		751	1.0882290109	1
		752	0.8319650868	1
		753	1.0722983489	1
		754	2.4038819544	1
		755	1.3498947111	1
		756	2.8958098086	1
		757	0.9891659291	1
		758	0.365581225	1
		759	2.2159184545	1
		760	1.3776360363	1
		761	1.3016449477	1
		762	0.1599475082	1
		763	0.6203802606	1
		764	0.8536637471	1
		765	0.6461073641	1
		766	0.2829065828	1
		767	1.3584093753	1
		768	2.5912045656	1
		769	0.7654042177	1
		770	1.3731498154	1
		771	1.4132511368	1
		772	2.439680166	1
		773	1.2101809748	1
		774	2.9813226722	1
		775	0.0257271035	1
		776	1.5008697775	1
		777	0.7032380139	1
		778	1.3520004883	1
		779	2.7206640828	1
		780	1.922849208	1
		781	1.1348307749	1
		782	0.3145847957	1
		783	1.0117801447	1
		784	0.6591082492	1
		785	2.656941435	1
		786	0.8736228523	1
		787	1.0038148137	1
		788	1.5403302103	1
		789	0.8460646382	1
		790	2.5956907865	1
		791	1.608539079	0
		792	1.4983062227	1
		793	1.4038209174	1
		794	0.383251442	1
		795	1.5956297494	1
		796	1.289742729	1
		797	0.3623767815	1
		798	0.7328104495	1
		799	2.196417127	1
		800	2.5608081301	1
		801	2.2656331065	1
		802	2.0677816095	1
		803	0.4778283029	1
		804	2.597338786	1
		805	0.2921536912	1
		806	2.2418286691	1
		807	0.2087466048	1
		808	2.6048463393	1
		809	2.7920773949	1
		810	1.8057496872	1
		811	2.4331797235	1
		812	1.8608661153	1
		813	0.2035279397	1
		814	0.1322061831	1
		815	2.4721823786	1
		816	2.5847956786	1
		817	1.8192999054	1
		818	0.9909970397	1
		819	0.5726798303	1
		820	0.8675801874	1
		821	0.3714407788	1
		822	0.6695455794	1
		823	1.9207434309	1
		824	0.5065767388	1
		825	2.9035920286	1
		826	2.2322153386	1
		827	1.2387462996	1
		828	1.0873134556	1
		829	0.8981597339	1
		830	2.0116580706	1
		831	2.6863307596	1
		832	0.1583910642	1
		833	0.1296426283	1
		834	0.9268166143	1
		835	1.2815027314	1
		836	2.8405102695	1
		837	1.2096316416	1
		838	1.7206030457	0
		839	0.5631580554	1
		840	0.7158726768	1
		841	0.2949003571	1
		842	2.7107760857	1
		843	1.711813715	0
		844	0.3404950102	1
		845	2.9264809107	1
		846	0.1492355113	1
		847	2.8481093783	1
		848	0.2226630451	1
		849	0.4673909726	1
		850	0.7819757683	1
		851	0.7282326731	1
		852	2.6127201147	1
		853	1.1101107822	1
		854	2.7033600879	1
		855	0.5546433912	1
		856	0.9462263863	1
		857	1.9197363201	1
		858	0.1001617481	1
		859	2.1197851497	1
		860	2.2864162114	1
		861	2.88390759	1
		862	2.9775688955	1
		863	1.0037232582	1
		864	1.6075319681	0
		865	0.4372692038	1
		866	1.4608600116	1
		867	0.0427564318	1
		868	0.2634968108	1
		869	1.4290902432	1
		870	0.7679677725	1
		871	0.7880184332	1
		872	0.4871669668	1
		873	1.0026245918	1
		874	2.4447157201	1
		875	0.1735892819	1
		876	2.2611468856	1
		877	1.3561204871	1
		878	0.9582201605	1
		879	1.1118503372	1
		880	0.405957213	1
		881	2.8530533769	1
		882	0.2413403729	1
		883	2.2358775597	1
		884	2.2295602283	1
		885	2.4504837184	1
		886	2.281655324	1
		887	2.5061494797	1
		888	0.5796380505	1
		889	2.9150364696	1
		890	2.3492233039	1
		891	0.9025543992	1
		892	0.6454664754	1
		893	1.7940305795	0
		894	2.9574266793	1
		895	2.9180578021	1
		896	2.3502304147	1
		897	2.6122623371	1
		898	0.1490524003	1
		899	2.07391583	1
		900	0.679708243	1
		901	2.260872219	1
		902	2.203009125	1
		903	2.1760917997	1
		904	1.790643025	0
		905	0.0495315409	1
		906	1.3540147099	1
		907	0.5291909543	1
		908	0.2404248177	1
		909	0.3886532182	1
		910	0.6203802606	1
		911	0.8297677541	1
		912	2.1858882412	1
		913	0.5714896084	1
		914	1.3328653829	1
		915	2.9545884579	1
		916	0.8906521805	1
		917	1.624652852	0
		918	2.4578997162	1
		919	2.3647877438	1
		920	1.388164922	1
		921	0.6957304605	1
		922	1.3100680563	1
		923	0.344615009	1
		924	0.6417126988	1
		925	2.9466231269	1
		926	1.7468794824	0
		927	0.7920468764	1
		928	2.0473647267	1
		929	2.4216437269	1
		930	1.4395275735	1
		931	0.780877102	1
		932	0.6211127049	1
		933	2.8590960417	1
		934	0.3135776849	1
		935	1.6136661885	0
		936	2.716727195	1
		937	0.9141819514	1
		938	1.7538377026	0
		939	2.5831476791	1
		940	1.6152226325	0
		941	2.7643360698	1
		942	0.6657918027	1
		943	1.1617481002	1
		944	2.8328196051	1
		945	2.5621814631	1
		946	1.988860744	1
		947	0.8372753075	1
		948	2.4874721519	1
		949	2.7087618641	1
		950	0.7544175542	1
		951	2.31388287	1
		952	0.571581164	1
		953	1.4121524705	1
		954	0.2823572497	1
		955	0.2973723563	1
		956	0.4713278603	1
		957	0.5035554064	1
		958	2.6104312265	1
		959	0.5827509384	1
		960	1.5786919767	1
		961	0.9767143773	1
		962	2.7488631855	1
		963	1.6635639515	0
		964	2.3384197516	1
		965	0.2212897122	1
		966	1.8562883389	1
		967	0.5811029389	1
		968	2.5747245705	1
		969	0.4184087649	1
		970	1.9282509842	1
		971	0.2334665975	1
		972	1.4409009064	1
		973	0.0665608692	1
		974	0.0931119724	1
		975	2.86138493	1
		976	0.835627308	1
		977	2.1079744865	1
		978	2.1104464858	1
		979	2.930692465	1
		980	1.6300546281	0
		981	1.6221808527	0
		982	1.1621143223	1
		983	0.1305581835	1
		984	2.5487228004	1
		985	1.5580919828	1
		986	1.5344706565	1
		987	0.7058931242	1
		988	1.0491348003	1
		989	1.4705648976	1
		990	0.2809839167	1
		991	0.840662862	1
		992	0.0425733207	1
		993	1.7323221534	0
		994	0.4625385296	1
		995	1.3152867214	1
		996	1.8009887997	1
		997	1.1893978698	1
		998	2.056428724	1
		999	2.1523789178	1
		1000	1.8928189947	1
comandos variados
	
AA
Format. cond.
	
	
	Produto	Viscosidade	Resíduo	Acidez	Quantidade	Classe
	P1	19	124	31	102	C
	P1	14	151	34	116	A
	P1	19	125	35	111	B
	P1	12	156	34	153	B
	P1	14	151	35	78	C			FORMATAÇÃO CONDICIONAL
	P1	18	170	35	81	B
	P1	20	166	34	106	C			Realçar produtos com Viscosidade > 13
	P1	15	196	33	118	C
	P1	20	140	35	76	A			Realçar produtos com Resíduo > 180
	P1	20	196	31	82	B
	P1	18	138	31	110	C			Realçar produtos cuja acidez > média da acidez dos produtos
	P1	15	189	30	110	C
	P1	16	197	32	86	C
	P1	13	138	35	95	C
	P1	12	133	35	120	C
	P1	14	154	32	71	B
	P1	16	158	30	119	B
	P1	15	133	33	86	B
	P1	20	186	33	114	C
	P1	13	131	32	123	C
	P1	14	134	34	113	C
	P2	20	164	30	106	A
	P2	12	200	30	117	C
	P2	16	128	32	107	C
	P2	15	164	34	96	A
	P2	19	149	30	92	A
	P2	17	192	32	104	A
	P2	18	160	32	98	B
	P2	12	184	32	90	B
	P2	15	120	34	118	C
	P2	18	122	35	116	B
	P2	16	124	32	114	C
	P2	18	189	33	94	A
	P2	17	165	31	122	A
	P2	20	181	35	98	C
	P2	13	131	35	110	A
	P3	13	167	34	120	A
	P3	12	170	33	101	A
	P3	17	191	31	98	C
	P3	14	132	31	122	B
	P3	13	172	34	108	C
	P3	15	153	34	126	A
	P3	12	133	30	114	B
	P3	17	137	32	112	B
	P3	17	126	32	130	A
	P3	13	158	32	66	B
	P3	14	132	34	111	B
	P3	12	192	35	106	B
	P3	20	176	32	69	A
	P3	15	178	30	101	C
	P3	13	191	32	118	A
	P3	15	140	31	124	B
	P3	19	135	30	86	C
	P3	19	191	30	134	A
	P3	12	142	31	91	C
	P3	17	138	31	100	C
	P3	14	159	31	90	A
	P3	19	184	33	124	A
	P3	18	141	31	72	A
	P3	20	146	33	96	A
	P3	14	169	31	116	B
	P3	18	131	33	102	A
	P3	19	159	35	131	B
	P4	14	147	31	105	C
	P4	12	158	33	99	C
	P4	19	164	31	128	B
	P4	12	171	30	87	B
	P4	19	137	31	102	A
	P4	16	141	35	93	A
	P4	12	149	35	96	B
	P4	19	194	34	126	B
	P4	16	147	32	108	C
	P4	15	169	32	104	C
	P4	16	139	32	75	C
	P4	16	157	33	78	B
	P4	20	149	30	113	C
P5	17	184	32	84	A
	P5	17	148	32	83	A
	P5	20	165	34	92	A
	P5	18	121	31	125	B
	P5	12	127	30	122	A
	P5	16	171	32	81	B
	P5	18	139	34	108	C
	P5	15	133	33	107	C
	P5	12	141	30	103	A
	P5	17	145	32	95	A
	P5	20	132	33	86	A
	P5	12	140	33	121	B
	P5	16	179	35	98	C
	P5	12	144	34	98	C
	P5	14	154	30	93	B
	P5	17	156	35	101	C
	P5	15	173	32	102	C
	P5	17	136	32	90	C
	P5	13	171	32	98	A
	P5	20	190	30	116	B
	P5	12	192	35	110	A
	P5	17	154	32	111	C
	P5	13	173	31	88	C
	P5	14	160	34	89	C
	P5	19	155	35	153	A
	P5	13	186	33	104	C
	P5	14	152	34	78	C
	P5	20	181	33	94	A
	P6	19	196	33	81	B
	P6	18	155	32	106	C
	P6	16	190	35	118	A
	P6	14	144	34	76	A
	P6	12	152	35	82	C
	P6	17	137	31	110	A
	P6	16	170	34	110	A
	P6	19	123	32	86	C
	P6	16	127	34	95	C
	P6	13	192	35	120	B
	P6	18	146	32	71	A
	P6	15	193	32	119	C
	P6	18	184	33	86	B
	P6	15	145	31	114	B
	P6	20	124	33	123	C
Filtros
	FILTROS
						Filtrar produtos do tipo P1 com Viscosidade > 15 e Acidez <33
	Filtrar Viscosidade > 15
	
	Filtrar Acidez > 30
						Filtrar produtos classe A cujo Resíduo > 135 OU Acidez < 32
	Filtrar produtos classe A
	
	Filtrar, em outro local, produtos classe A com Resíduo > 150
	
	Produto	Viscosidade	Resíduo	Acidez	Quantidade	Classe
			>135			A
				<32		A
	
	
								Filtrar Viscosidade > 15							Filtrar Acidez > 30							Filtrar produtos classe A							Filtrar, em outro local, produtos classe A com Resíduo > 150
	Produto	Viscosidade	Resíduo	Acidez	Quantidade	Classe		Produto	Viscosidade	Resíduo	Acidez	Quantidade	Classe		Produto	Viscosidade	Resíduo	Acidez	Quantidade	Classe		Produto	Viscosidade	Resíduo	Acidez	Quantidade	Classe		Produto	Viscosidade	Resíduo	Acidez	Quantidade	Classe		Produto	Viscosidade	Resíduo	Acidez	Quantidade	Classe		Produto	Viscosidade	Resíduo	Acidez	Quantidade	Classe
	P1	19	124	31	102	C		P1	19	124	31	102	C		P1	19	124	31	102	C		P1	14	151	34	116	A		P1	14	151	34	116	A		P1	19	124	31	102	C		P1	14	151	34	116	A
	P1	14	151	34	116	A		P1	19	125	35	111	B		P1	14	151	34	116	A		P1	20	140	35	76	A		P2	20	164	30	106	A		P1	20	196	31	82	B		P1	20	140	35	76	A
	P1	19	125	35	111	B		P1	18	170	35	81	B		P1	19	125	35	111	B		P2	20	164	30	106	A		P2	15	164	34	96	A		P1	18	138	31	110	C		P2	20	164	30	106	A
	P1	12	156	34	153	B		P1	20	166	34	106	C		P1	12	156	34	153	B		P2	15	164	34	96	A		P2	17	192	32	104	A		P1	16	197	32	86	C		P2	15	164	34	96	A
	P1	14	151	35	78	C		P1	20	140	35	76	A		P1	14	151	35	78	C		P2	19	149	30	92	A		P2	18	189	33	94	A		P1	16	158	30	119	B		P2	19	149	30	92	A
	P1	18	170	35	81	B		P1	20	196	31	82	B		P1	18	170	35	81	B		P2	17	192	32	104	A		P2	17	165	31	122	A									P2	17	192	32	104	A
	P1	20	166	34	106	C		P1	18	138	31	110	C		P1	20	166	34	106	C		P2	18	189	33	94	A		P3	13	167	34	120	A									P2	18	189	33	94	A
	P1	15	196	33	118	C		P1	16	197	32	86	C		P1	15	196	33	118	C		P2	17	165	31	122	A		P3	12	170	33	101	A									P2	17	165	31	122	A
	P1	20	140	35	76	A		P1	16	158	30	119	B		P1	20	140	35	76	A		P2	13	131	35	110	A		P3	15	153	34	126	A									P3	13	167	34	120	A
	P1	20	196	31	82	B		P1	20	186	33	114	C		P1	20	196	31	82	B		P3	13	167	34	120	A		P3	20	176	32	69	A									P3	12	170	33	101	A
	P1	18	138	31	110	C		P2	20	164	30	106	A		P1	18	138	31	110	C		P3	12	170	33	101	A		P3	13	191	32	118	A									P3	15	153	34	126	A
	P1	15	189	30	110	C		P2	16	128	32	107	C		P1	16	197	32	86	C		P3	15	153	34	126	A		P3	19	191	30	134	A									P3	20	176	32	69	A
	P1	16	197	32	86	C		P2	19	149	30	92	A		P1	13	138	35	95	C		P3	17	126	32	130	A		P3	14	159	31	90	A									P3	13	191	32	118	A
	P1	13	138	35	95	C		P2	17	192	32	104	A		P1	12	133	35	120	C		P3	20	176	32	69	A		P3	19	184	33	124	A									P3	19	191	30	134	A
	P1	12	133	35	120	C		P2	18	160	32	98	B		P1	14	154	32	71	B		P3	13	191	32	118	A		P5	17	184	32	84	A									P3	14	159	31	90	A
	P1	14	154	32	71	B		P2	18	122	35	116	B		P1	15	133	33	86	B		P3	19	191	30	134	A		P5	20	165	34	92	A									P3	19	184	33	124	A
	P1	16	158	30	119	B		P2	16	124	32	114	C		P1	20	186	33	114	C		P3	14	159	31	90	A		P5	13	171	32	98	A									P3	18	141	31	72	A
	P1	15	133	33	86	B		P2	18	189	33	94	A		P1	13	131	32	123	C		P3	19	184	33	124	A		P5	12	192	35	110	A									P3	20	146	33	96	A
	P1	20	186	33	114	C		P2	17	165	31	122	A		P1	14	134	34	113	C		P3	18	141	31	72	A		P5	19	155	35	153	A									P4	19	137	31	102	A
	P1	13	131	32	123	C		P2	20	181	35	98	C		P2	16	128	32	107	C		P3	20	146	33	96	A		P5	20	181	33	94	A									P4	16	141	35	93	A
	P1	14	134	34	113	C		P3	17	191	31	98	C		P2	15	164	34	96	A		P3	18	131	33	102	A		P6	16	190	35	118	A									P5	17	184	32	84	A
	P2	20	164	30	106	A		P3	17	137	32	112	B		P2	17	192	32	104	A		P4	19	137	31	102	A		P6	16	170	34	110	A									P5	17	148	32	83	A
	P2	12	200	30	117	C		P3	17	126	32	130	A		P2	18	160	32	98	B		P4	16	141	35	93	A																P5	20	165	34	92	A
	P2	16	128	32	107	C		P3	20	176	32	69	A		P2	12	184	32	90	B		P5	17	184	32	84	A																P5	12	127	30	122	A
	P2	15	164	34	96	A		P3	19	135	30	86	C		P2	15	120	34	118	C		P5	17	148	32	83	A																P5	12	141	30	103	A
	P2	19	149	30	92	A		P3	19	191	30	134	A		P2	18	122	35	116	B		P5	20	165	34	92	A																P5	17	145	32	95	A
	P2	17	192	32	104	A		P3	17	138	31	100	C		P2	16	124	32	114	C		P5	12	127	30	122	A																P5	13	171	32	98	A
	P2	18	160	32	98	B		P3	19	184	33	124	A		P2	18	189	33	94	A		P5	12	141	30	103	A																P5	12	192	35	110	A
	P2	12	184	32	90	B		P3	18	141	31	72	A		P2	17	165	31	122	A		P5	17	145	32	95	A																P5	19	155	35	153	A
	P2	15	120	34	118	C		P3	20	146	33	96	A		P2	20	181	35	98	C		P5	20	132	33	86	A																P5	20	181	33	94	A
	P2	18	122	35	116	B		P3	18	131	33	102	A		P2	13	131	35	110	A		P5	13	171	32	98	A																P6	16	190	35	118	A
	P2	16	124	32	114	C		P3	19	159	35	131	B		P3	13	167	34	120	A		P5	12	192	35	110	A																P6	14	144	34	76	A
	P2	18	189	33	94	A		P4	19	164	31	128	B		P3	12	170	33	101	A		P5	19	155	35	153	A																P6	17	137	31	110	A
	P2	17	165	31	122	A		P4	19	137	31	102	A		P3	17	191	31	98	C		P5	20	181	33	94	A																P6	16	170	34	110	A
	P2	20	181	35	98	C		P4	16	141	35	93	A		P3	14	132	31	122	B		P6	16	190	35	118	A																P6	18	146	32	71	A
	P2	13	131	35	110	A		P4	19	194	34	126	B		P3	13	172	34	108	C		P6	14	144	34	76	A
	P3	13	167	34	120	A		P4	16	147	32	108	C		P3	15	153	34	126	A		P6	17	137	31	110	A
	P3	12	170	33	101	A		P4	16	139	32	75	C		P3	17	137	32	112	B		P6	16	170	34	110	A
	P3	17	191	31	98	C		P4	16	157	33	78	B		P3	17	126	32	130	A		P6	18	146	32	71	A
	P3	14	132	31	122	B		P4	20	149	30	113	C		P3	13	158	32	66	B
	P3	13	172	34	108	C		P5	17	184	32	84	A		P3	14	132	34	111	B
	P3	15	153	34	126	A		P5	17	148	32	83	A		P3	12	192	35	106	B
	P3	12	133	30	114	B		P5	20	165	34	92	A		P3	20	176	32	69	A
	P3	17	137	32	112	B		P5	18	121	31	125	B		P3	13	191	32	118	A
	P3	17	126	32	130	A		P5	16	171	32	81	B		P3	15	140	31	124	B
	P3	13	158	32	66	B		P5	18	139	34	108	C		P3	12	142	31	91	C
	P3	14	132	34	111	B		P5	17	145	32	95	A		P3	17	138	31	100	C
	P3	12	192	35	106	B		P5	20	132	33	86	A		P3	14	159	31	90	A
	P3	20	176	32	69	A		P5	16	179	35	98	C		P3	19	184	33	124	A
	P3	15	178	30	101	C		P5	17	156	35	101	C		P3	18	141	31	72	A
	P3	13	191	32	118	A		P5	17	136	32	90	C		P3	20	146	33	96	A
	P3	15	140	31	124	B		P5	20	190	30	116	B		P3	14	169	31	116	B
	P3	19	135	30	86	C		P5	17	154	32	111	C		P3	18	131	33	102	A
	P3	19	191	30	134	A		P5	19	155	35	153	A		P3	19	159	35	131	B
	P3	12	142	31	91	C		P5	20	181	33	94	A		P4	14	147	31	105	C
	P3	17	138	31	100	C		P6	19	196	33	81	B		P4	12	158	33	99	C
	P3	14	159	31	90	A		P6	18	155	32	106	C		P4	19	164	31	128	B
	P3	19	184	33	124	A		P6	16	190	35	118	A		P4	19	137	31	102	A
	P3	18	141	31	72	A		P6	17	137	31	110	A		P4	16	141	35	93	A
	P3	20	146	33	96	A		P6	16	170	34	110	A		P4	12	149	35	96	B
	P3	14	169	31	116	B		P6	19	123	32	86	C		P4	19	194	34	126	B
	P3	18	131	33	102	A		P6	16	127	34	95	C		P4	16	147	32	108	C
	P3	19	159	35	131	B		P6	18	146	32	71	A		P4	15	169	32	104	C
	P4	14	147	31	105	C		P6	18	184	33	86	B		P4	16	139	32	75	C
	P4	12	158	33	99	C		P6	20	124	33	123	C		P4	16	157	33	78	B
	P4	19	164	31	128	B									P5	17	184	32	84	A
	P4	12	171	30	87	B
P5	17	148	32	83	A
	P4	19	137	31	102	A									P5	20	165	34	92	A
	P4	16	141	35	93	A									P5	18	121	31	125	B
	P4	12	149	35	96	B									P5	16	171	32	81	B
	P4	19	194	34	126	B									P5	18	139	34	108	C
	P4	16	147	32	108	C									P5	15	133	33	107	C
	P4	15	169	32	104	C									P5	17	145	32	95	A
	P4	16	139	32	75	C									P5	20	132	33	86	A
	P4	16	157	33	78	B									P5	12	140	33	121	B
	P4	20	149	30	113	C									P5	16	179	35	98	C
	P5	17	184	32	84	A									P5	12	144	34	98	C
	P5	17	148	32	83	A									P5	17	156	35	101	C
	P5	20	165	34	92	A									P5	15	173	32	102	C
	P5	18	121	31	125	B									P5	17	136	32	90	C
	P5	12	127	30	122	A									P5	13	171	32	98	A
	P5	16	171	32	81	B									P5	12	192	35	110	A
	P5	18	139	34	108	C									P5	17	154	32	111	C
	P5	15	133	33	107	C									P5	13	173	31	88	C
	P5	12	141	30	103	A									P5	14	160	34	89	C
	P5	17	145	32	95	A									P5	19	155	35	153	A
	P5	20	132	33	86	A									P5	13	186	33	104	C
	P5	12	140	33	121	B									P5	14	152	34	78	C
	P5	16	179	35	98	C									P5	20	181	33	94	A
	P5	12	144	34	98	C									P6	19	196	33	81	B
	P5	14	154	30	93	B									P6	18	155	32	106	C
	P5	17	156	35	101	C									P6	16	190	35	118	A
	P5	15	173	32	102	C									P6	14	144	34	76	A
	P5	17	136	32	90	C									P6	12	152	35	82	C
	P5	13	171	32	98	A									P6	17	137	31	110	A
	P5	20	190	30	116	B									P6	16	170	34	110	A
	P5	12	192	35	110	A									P6	19	123	32	86	C
	P5	17	154	32	111	C									P6	16	127	34	95	C
	P5	13	173	31	88	C									P6	13	192	35	120	B
	P5	14	160	34	89	C									P6	18	146	32	71	A
	P5	19	155	35	153	A									P6	15	193	32	119	C
	P5	13	186	33	104	C									P6	18	184	33	86	B
	P5	14	152	34	78	C									P6	15	145	31	114	B
	P5	20	181	33	94	A									P6	20	124	33	123	C
	P6	19	196	33	81	B
	P6	18	155	32	106	C
	P6	16	190	35	118	A
	P6	14	144	34	76	A
	P6	12	152	35	82	C
	P6	17	137	31	110	A
	P6	16	170	34	110	A
	P6	19	123	32	86	C
	P6	16	127	34	95	C
	P6	13	192	35	120	B
	P6	18	146	32	71	A
	P6	15	193	32	119	C
	P6	18	184	33	86	B
	P6	15	145	31	114	B
	P6	20	124	33	123	C
Tabela dinâmica
	
								Gere uma tabela dinâmica com produtos nas linhas, classe nas colunas. A tabela deve apresentar a média da acidez.
	
	
	Produto	Viscosidade	Resíduo	Acidez	Quantidade	Classe
	P1	19	124	31	102	C
	P1	14	151	34	116	A
	P1	19	125	35	111	B
	P1	12	156	34	153	B
	P1	14	151	35	78	C		Média de Acidez	Rótulos de Coluna
	P1	18	170	35	81	B		Rótulos de Linha	A	B	C	Total Geral
	P1	20	166	34	106	C		P1	34.50	32.86	32.92	33.05
	P1	15	196	33	118	C		P2	32.14	33.00	32.60	32.47
	P1	20	140	35	76	A		P3	32.33	32.33	31.17	32.07
	P1	20	196	31	82	B		P4	33.00	32.60	31.67	32.23
	P1	18	138	31	110	C		P5	32.55	31.20	33.25	32.61
	P1	15	189	30	110	C		P6	33.20	33.00	33.00	33.07
	P1	16	197	32	86	C		Total Geral	32.62	32.45	32.60	32.56
	P1	13	138	35	95	C
	P1	12	133	35	120	C
	P1	14	154	32	71	B
	P1	16	158	30	119	B
	P1	15	133	33	86	B
	P1	20	186	33	114	C
	P1	13	131	32	123	C
	P1	14	134	34	113	C
	P2	20	164	30	106	A
	P2	12	200	30	117	C
	P2	16	128	32	107	C
	P2	15	164	34	96	A
	P2	19	149	30	92	A
	P2	17	192	32	104	A
	P2	18	160	32	98	B
	P2	12	184	32	90	B
	P2	15	120	34	118	C
	P2	18	122	35	116	B
	P2	16	124	32	114	C
	P2	18	189	33	94	A
	P2	17	165	31	122	A
	P2	20	181	35	98	C
	P2	13	131	35	110	A
	P3	13	167	34	120	A
	P3	12	170	33	101	A
	P3	17	191	31	98	C
	P3	14	132	31	122	B
	P3	13	172	34	108	C
	P3	15	153	34	126	A
	P3	12	133	30	114	B
	P3	17	137	32	112	B
	P3	17	126	32	130	A
	P3	13	158	32	66	B
	P3	14	132	34	111	B
	P3	12	192	35	106	B
	P3	20	176	32	69	A
	P3	15	178	30	101	C
	P3	13	191	32	118	A
	P3	15	140	31	124	B
	P3	19	135	30	86	C
	P3	19	191	30	134	A
	P3	12	142	31	91	C
	P3	17	138	31	100	C
	P3	14	159	31	90	A
	P3	19	184	33	124	A
	P3	18	141	31	72	A
	P3	20	146	33	96	A
	P3	14	169	31	116	B
	P3	18	131	33	102	A
	P3	19	159	35	131	B
	P4	14	147	31	105	C
	P4	12	158	33	99	C
	P4	19	164	31	128	B
	P4	12	171	30	87	B
	P4	19	137	31	102	A
	P4	16	141	35	93	A
	P4	12	149	35	96	B
	P4	19	194	34	126	B
	P4	16	147	32	108	C
	P4	15	169	32	104	C
	P4	16	139	32	75	C
	P4	16	157	33	78	B
	P4	20	149	30	113	C
	P5	17	184	32	84	A
	P5	17	148	32	83	A
	P5	20	165	34	92	A
	P5	18	121	31	125	B
	P5	12	127	30	122	A
	P5	16	171	32	81	B
	P5	18	139	34	108	C
	P5	15	133	33	107	C
	P5	12	141	30	103	A
	P5	17	145	32	95	A
	P5	20	132	33	86	A
	P5	12	140	33	121	B
	P5	16	179	35	98	C
	P5	12	144	34	98	C
	P5	14	154	30	93	B
	P5	17	156	35	101	C
	P5	15	173	32	102	C
	P5	17	136	32	90	C
	P5	13	171	32	98	A
	P5	20	190	30	116	B
	P5	12	192	35	110	A
	P5	17	154	32	111	C
	P5	13	173	31	88	C
	P5	14	160	34	89	C
	P5	19	155	35	153	A
	P5	13	186	33	104	C
	P5	14	152	34	78	C
	P5	20	181	33	94	A
	P6	19	196	33	81	B
	P6	18	155	32	106	C
	P6	16	190	35	118	A
	P6	14	144	34	76	A
	P6	12	152	35	82	C
	P6	17	137	31	110	A
	P6	16	170	34	110	A
	P6	19	123	32	86	C
	P6	16	127	34	95	C
	P6	13	192	35	120	B
	P6	18	146	32	71	A
	P6	15	193	32	119	C
	P6	18	184	33	86	B
	P6	15	145	31	114	B
	P6	20	124	33	123	C
Previsão
	
	
			Prediga os valores faltantes da tabela abaixo:
	
	
	
	
	
	
			Tempo	Valor
			1	21.2212828463
			2	22.8051488157
			3	23.9230275187
			4	24.2947773967
			5	25.548
			6	26.8707364253
			7	27.9612320226
			8	28.0083969396
			9	29.5367496538
			10	30.4266270129
			11	31.20502501
			12	32.611
			13	33.6248
			14	34.7918047587
			15	35.8986805968
			16	36.5477968866
			17	37.9804099536
			18	38.9570437409
			19	39.0410594657
			20	40.671
			21	41.6411269989
			22	42.3338608271
			23	43.5986680678
			24	44.605
			25	45.5631688941
			26	46.681295589
			27	47.3452425864
			28	48.0843085695
			29	49.356
			30	50.1452664315
	
			Tempo	Valor
			1	21.2212828463
			2	22.8051488157
			3	23.9230275187
			4	24.2947773967
	
			6	26.8707364253
			7	27.9612320226
			8	28.0083969396
			9	29.5367496538
			10	30.4266270129
			11	31.20502501
	
	
			14	34.7918047587
			15	35.8986805968
			16	36.5477968866
			17	37.9804099536
			18	38.9570437409
			19	39.0410594657
	
			21	41.6411269989
			22	42.3338608271
			23	43.5986680678
	
			25	45.5631688941
			26	46.681295589
			27	47.3452425864
			28	48.0843085695
	
			30	50.1452664315
Previsão
	
	
Valor