Atividade estruturada Etapa 2 Excel

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

Plan1
	 supermercado extra
	Alimentos	arroz R$	feijão R$	açucar R$	óleo R$	sal R$	vinagre R$	azeite R$	carne R$
	1°semana	12.99	3.89	2.79	4.99	1.85	3.19	17.399999999999999	18.989999999999998
	2°semana	11.59	3.59	2.58	5.25	2.15	3.15	17.989999999999998	18.7
	3°semana	11.99	3.47	2.2799999999999998	5.49	2.09	3.29	17.25	18.600000000000001
	4°semana	12.19	3.67	2.39	5.79	1.89	3.35	16.989999999999998	18.5
	5°semana	11.87	3.89	2.39	5.69	1.99	3.48	17.8	18.399999999999999
	6°semana	11.87	3.29	2.59	5.89	2.29	2.99	17.3	18.350000000000001
	7°semana	10.99	3.49	2.99	5.38	2.19	3.29	17.2	18.45
	8°semana	12.25	3.89	2.89	5.49	2.09	3.29	17.25	18.399999999999999
	Limite Inferior	10.99	3.29	2.2799999999999998	5.25	1.85	2.99	17.2	18.350000000000001
	Limite Superior	12.99	3.89	2.99	5.89	2.29	3.48	17.989999999999998	18.899999999999999
	Média	11.97	3.65	2.61	5.50	2.07	3.25	17.40	18.55
	Moda	11.87	3.89	2.39	5.49	2.09	3.29	17.25	18.399999999999999
	Mediana	11.93	3.63	2.585	5.49	2.09	3.29	17.274999999999999	18.475000000000001
	Amplitude	2	0.60000000000000009	0.71000000000000041	0.63999999999999968	0.43999999999999995	0.48999999999999977	0.78999999999999915	0.54999999999999716
	Variância	0.3275	0.0521	0.0660	0.0871	0.0224	0.0213	0.1102	0.0452
	Desvio Padrão	0.5723	0.2281	0.2569	0.2951	0.1498	0.1458	0.3319	0.2125
	Coef. De Variação %	4.78%	6.25%	9.84%	5.37%	7.25%	4.48%	1.91%	1.15%
	 Carrefur
	Alimentos	arroz R$	feijão R$	açucar R$	óleo R$	sal R$	vinagre R$	azeite R$	carne R$
	1°semana	12.98	3.45	3.15	4.8	2.99	2.99	14.98	19.98
	2°semana	12.99	3.99	3.2	4.85	2.95	2.98	14.99	19.9
	3°semana	12.89	3.98	3.25	4.79	2.9	2.95	14.9	19.89
	4°semana	12.79	3.54	3.15	4.75	2.85	2.8	14.89	19.86
	5°semana	12.98	3.67	3.35	4.8	2.89	2.99	14.85	19.8
	6°semana	12.68	3.25	3.29	4.55	2.75	2.86	14.8	19.7
	7°semana	12.35	3.65	3.3	4.59	2.8	2.7	14.98	19.98
	8°semana	12.59	3.45	3.4	4.5	2.99	2.75	14.87	19.95
	Limite Inferior	12.35	3.25	3.15	4.5	2.75	2.7	14.8	19.7
	Limite Superior	12.99	3.99	3.4	4.85	2.99	2.99	14.99	19.98
	Média	12.80	3.62	3.26	4.70	2.89	2.88	14.91	19.88
	Moda	12.98	3.45	3.15	4.8	2.99	2.99	14.98	19.98
	Mediana	12.935	3.595	3.27	4.77	2.895	2.905	14.895	19.895
	Amplitude	0.64	0.74	0.25	0.35	0.24	0.29	0.19	0.28
	Variância	0.0711	0.0673	0.0083	0.0182	0.0076	0.0136	0.0049	0.0092
	Desvio Padrão	0.2667	0.2594	0.0911	0.1350	0.0870	0.1166	0.0696	0.0960
	Coef. De Variação %	2.08%	7.16%	2.79%	2.87%	3.01%	4.05%	0.47%	0.48%
	 Makro
	Alimentos	arroz R$	feijão R$	açucar R$	óleo R$	sal R$	vinagre R$	azeite R$	carne R$
	1°semana	10.49	2.49	2.29	3.79	0.99	3.19	7.99	15.59
	2°semana	10.48	2.5	2.29	3.79	0.99	3.15	7.99	15.6
	3°semana	10.45	2.55	2.35	3.78	0.99	3.29	7.95	15.65
	4°semana	10.4	2.49	2.38	3.79	0.99	2.99	7.8	15.7
	5°semana	10.99	2.85	2.4	3.7	1.05	3.48	7.79	15.69
	6°semana	10.49	2.8	2.39	3.8	1.09	2.99	7.75	15.6
	7°semana	10.49	2.79	2.45	3.79	1.1	3.29	7.85	15.6
	8°semana	10.8	2.49	2.29	3.85	1.1	3.29	7.99	15.55
	Limite Inferior	10.4	2.49	2.29	3.7	0.99	2.99	7.8	15.55
	Limite Superior	10.99	2.85	2.45	385	1.1	3.48	7.99	15.69
	Média	10.57	2.62	2.36	3.79	1.04	3.24	7.89	15.62
	Moda	10.49	2.49	2.29	3.79	0.99	3.29	7.99	15.6
	Mediana	10.49	2.525	2.365	3.79	1.02	3.29	7.95	15.6
	Amplitude	0.59	0.36	0.16	381.3	0.11	0.49	0.19	0.14
	Variância	0.0428	0.0263	0.0037	0.0017	0.0028	0.0230	0.0119	0.0027
	Desvio Padrão	0.2069	0.1622	0.0605	0.0410	0.0531	0.1518	0.1089	0.0523
	Coef. De Variação %	1.96%	6.19%	2.57%	1.08%	5.12%	4.68%	1.38%	0.33%
	 Prezunic 
	Alimentos	arroz R$	feijão R$	açucar R$	óleo R$	sal R$	vinagre R$	azeite R$	carne R$
	1°semana	13.89	3.19	3.89	2.99	1.85	12.98	17.84	19.95
	2°semana	13.89	3.2	3.89	2.99	1.85	12.95	17.989999999999998	19.95
	3°semana	13.89	3.19	3.9	2.95	2.09	12.9	17.25	19.99
	4°semana	13.99	3.25	3.95	2.9	1.85	12.89	16.989999999999998	20.19
	5°semana	13.8	3.29	3.99	2.89	1.99	12.89	17.8	20.05
	6°semana	13.79	3.3	3.97	2.85	2.29	12.97	17.3	19.98
	7°semana	13.75	3.28	3.93	2.88	2.19	12.94	17.25	19.95
	8°semana	13.7	3.35	3.89	2.99	2.09	12.89	17.25	19.9
	Limite Inferior	13.7	3.19	3.89	2.85	1.85	12.89	17.25	19.95
	Limite Superior	13.99	3.35	3.99	2.99	2.29	12.95	17.99	20.19
	Média	13.89	3.265	3.915	2.925	2.04	12.94	17.275	19.965
	Moda	13.89	3.19	3.89	2.99	1.85	12.89	17.25	19.95
	Mediana	13.89	3.265	3.915	2.925	2.04	12.94	17.275	19.965
	Amplitude	0.29	0.16	0.1	0.14	0.44	0.06	0.74	0.24
	Variância	0.0067	0.0035	0.0016	0.0032	0.0284	0.0014	0.1314	0.0081
	Desvio Padrão	0.0818	0.0590	0.0400	0.0568	0.1686	0.0380	0.3625	0.0898
	Coef. De Variação %	0.59%	1.81%	1.02%	1.94%	8.27%	0.29%	2.10%	0.45%
	 Guanabara
	Alimentos	arroz R$	feijão R$	açucar R$	óleo R$	sal R$	vinagre R$	azeite R$	carne R$
	1°semana	11.95	3.98	3.95	3.15	1	2.89	8.98	21.8
	2°semana	11.95	3.99	3.95	3.15	1.5	2.89	8.99	21.8
	3°semana	11.9	3.98	3.95	3.19	1.1	2.9	8.98	21.7
	4°semana	11.89	3.95	3.9	3.2	1.15	2.95	8.98	21.6
	5°semana	11.85	3.98	3.89	3.15	1.2	2.99	8.95	21.65
	6°semana	11.8	3.9	3.85	3.1	1.2	2.89	8.96	21.7
	7°semana	11.95	3.89	3.8	3.15	1.19	2.85	8.98	21.8
	8°semana	11.99	3.85	3.85	3.2	1.2	2.9	8.98	21.85
	Limite Inferior	11.8	3.85	3.85	3.1	1	2.85	8.95	21.6
	Limite Superior	11.99	3.99	3.95	3.19	1.2	2.99	8.99	21.85
	Média	11.925	3.965	3.895	3.15	1.195	2.895	8.98	21.75
	Moda	11.95	3.98	3.95	3.15	1.2	2.89	8.98	21.8
	Mediana	11.925	3.965	3.895	3.15	1.195	2.895	8.98	21.75
	Amplitude	0.19	0.14	0.1	0.09	0.2	0.14	0.04	0.25
	Variância	0.0039	0.0028	0.0032	0.0012	0.0203	0.0019	0.0002	0.0077
	Desvio Padrão	0.0626	0.0529	0.0563	0.0340	0.1425	0.0430	0.0131	0.0876
	Coef. De Variação %	0.52%	1.33%	1.44%	1.08%	11.92%	1.49%	0.15%	0.40%
	 Auto Posto Bangu	 Posto Olinda Ellis	 Auto Posto Guerrera	 Auto Posto 3Pontos	 Auto Posto Inajá
	Energia	Etanol	Gasolina	Etanol	Gasolina	Etanol	Gasolina	Etanol	Gasolina	Etanol	Gasolina
	1°semana	2.5489999999999999	3.1589999999999998	2.4590000000000001	3.2989999999999999	2.4990000000000001	3.4990000000000001	2.5990000000000002	3.4590000000000001	2.569	3.4590000000000001
	2°semana	2.5489999999999999	3.1589999999999998	2.4590000000000001	3.2989999999999999	2.4990000000000001	3.4990000000000001	2.5990000000000002	3.4590000000000001	2.569	3.4590000000000001
	3°semana	2.5489999999999999	3.1589999999999998	2.4590000000000001	3.2989999999999999	2.589	3.5790000000000002	2.7989999999999999	3.5990000000000002	2.79	3.5990000000000002
	4°semana	2.6890000000000001	3.4590000000000001	2.589	3.399	2.589	3.5790000000000002	2.7989999999999999	3.5990000000000002	2.79	3.5990000000000002
	5°semana	2.6890000000000001	3.4590000000000001	2.589	3.399	2.6789999999999998	3.6989999999999998	2.899	3.7890000000000001	2.899	3.6989999999999998
	6°semana	2.8889999999999998	3.569	2.7989999999999999	3.5990000000000002	2.7890000000000001	3.6989999999999998	2.6989999999999998	3.7890000000000001	2.899	3.6989999999999998
	7°semana	2.899	3.569	2.6789999999999998	3.6989999999999998	2.7890000000000001	3.6989999999999998	2.7989999999999999	3.7890000000000001	2.899	3.6989999999999998
	8°semana	2.899	3.5990000000000002	2.6789999999999998	3.6989999999999998	2.7890000000000001	3.899	2.899	3.859	2.9489999999999998	3.7890000000000001
	Limite Inferior	2.5489999999999999	3.1589999999999998	2.4590000000000001	3.2989999999999999	2.4990000000000001	3.4990000000000001	2.5990000000000002	3.4590000000000001	2.569	3.4590000000000001
	Limite Superior	2.899	3.5990000000000002	2.6789999999999998	3.6989999999999998	2.7890000000000001	3.899	2.899	3.859	2.9489999999999998	3.7890000000000001
	Média	2.714	3.3914999999999997	2.589	3.4615	2.6527500000000002	3.6440000000000001
2.7614999999999998	3.6677500000000007	2.7955000000000005	3.6252499999999994
	Moda	2.5489999999999999	3.1589999999999998	2.4590000000000001	3.2989999999999999	2.7890000000000001	3.6989999999999998	2.7989999999999999	3.7890000000000001	2.899	3.6989999999999998
	Mediana	2.6890000000000001	3.4590000000000001	2.589	3.399	2.6339999999999999	3.6390000000000002	2.7989999999999999	3.694	2.8445	3.649
	Amplitude	0.35000000000000009	0.44000000000000039	0.21999999999999975	0.39999999999999991	0.29000000000000004	0.39999999999999991	0.29999999999999982	0.39999999999999991	0.37999999999999989	0.33000000000000007
	Variância	0.0260	0.0396	0.0159	0.0312	0.0160	0.0178	0.0141	0.0253	0.0226	0.0143
	Desvio Padrão	0.16	0.20	0.13	0.18	0.13	0.13	0.12	0.16	0.15	0.12
	Coef. De Variação %	5.94%	5.87%	4.86%	5.11%	4.76%	3.66%	4.30%	4.34%	5.38%	3.29%
	Ponto Frio	Walmart	Casas Bahia	Shoptime	Casa e Video
	Lazer	Bola Futebol	Bola Futebol	Bola Futebol	Bola Futebol	Bola Futebol
	1°semana	45.57	39.99	54.99	49.9	65
	2°semana	45.57	39.99	54.99	49.9	65
	3°semana	45.57	39.99	54.99	49.9	65
	4°semana	45.57	39.99	56.89	49.9	65
	5°semana	45.57	39.99	56.89	49.9	65
	6°semana	47.78	39.99	58	51.87	64.99
	7°semana	47.78	43.56	58	51.87	66.5
	8°semana	47.78	43.56	58.99	54.5	66.6
	Limite Inferior	45.57	39.99	54.99	49.9	64.99
	Limite Superior	47.78	43.56	58.99	54.5	66.5
	Média	46.40	40.88	56.72	50.97	65.39
	Moda	45.57	39.99	54.99	49.9	65
	Mediana	45.57	39.99	56.89	49.9	65
	Amplitude	2.21	3.57	4	4.6	1.51
	Variância	1.308	2.731	2.495	2.829	0.517
	Desvio Padrão	1.144	1.653	1.580	1.682	0.719
	Coef. De Variação %	81.70%	118.04%	112.83%	120.15%	51.34%
	Lazer	Bicicleta	Bicicleta	Bicicleta	Bicicleta	Bicicleta
	1°semana	429.9	499	568	503.4	279.9
	2°semana	429.9	499	568	503.4	279.9
	3°semana	429.9	499	568	503.4	288
	4°semana	429.9	499	568	500	288
	5°semana	429.9	499	568	500	299.9
	6°semana	429.9	480.99	575	499.9	299.9
	7°semana	450.99	480.99	575	499.9	280.99
	8°semana	450.99	480.99	579	503.4	280.99
	Limite Inferior	429.9	480.99	568	499.9	279.9
	Limite Superior	450.99	499	579	503.4	299.9
	Média	435.17	492.25	571.13	501.68	287.20
	Moda	429.9	499	568	503.4	279.9
	Mediana	429.9	499	568	501.7	284.495
	Amplitude	21.09	18.01	11	3.5	20
	Variância	95.31	86.88	20.13	3.40	72.51
	Desvio Padrão	9.76	9.32	4.49	1.84	8.52
	Coef. De Variação %	103.14%	103.14%	103.14%	103.14%	103.14%
	Lazer	Skate 	Skate 	Skate 	Skate 	Skate 
	1°semana	161	152.92	170.91	169	175.91
	2°semana	161	152.92	170.91	170.91	175.91
	3°semana	175	153	162.45	170.91	175.91
	4°semana	175	153	162.45	162.45	162.45
	5°semana	175	173	162.45	162.45	162.45
	6°semana	175	173	162.45	195.8	145.26
	7°semana	193	173	160	195.8	145.26
	8°semana	193	173	160	195.8	150
	Limite Inferior	161	152.92	160	162.45	145.26
	Limite Superior	193	173	170.91	195.8	175.91
	Média	176	162.98	163.9525	177.89	161.64375
	Moda	175	173	162.45	195.8	175.91
	Mediana	175	163	162.45	170.91	162.45
	Amplitude	32	20.08	10.91	33.35	30.65
	Variância	147.43	114.74	19.58	230.79	183.47
	Desvio Padrão	12.14	10.71	4.43	15.19	13.55
	Coef. De Variação %	6.82%	6.02%	2.49%	8.53%	7.61%
	Lazer	Prancha Surf	Prancha Surf	Prancha Surf	Prancha Surf	Prancha Surf
	1°semana	259.9	359.9	429.9	269.9	310.9
	2°semana	259.9	359.9	429.9	269.9	310.9
	3°semana	259.9	359.9	460	288.9	310.9
	4°semana	259.9	298.9	460	288.9	329.99
	5°semana	298.9	298.9	460	288.9	329.99
	6°semana	298.9	329.9	449.9	290	355.8
	7°semana	298.9	329.9	449.9	290	355.8
	8°semana	349.9	359.9	455	295.9	359.9
	Limite Inferior	259.9	298.9	429.9	269.9	310.9
	Limite Superior	349.9	359.9	460	295.9	359.9
	Média	285.775	337.15	449.325	285.3	333.0225
	Moda	259.9	359.9	460	288.9	310.9
	Mediana	279.4	344.9	452.45	288.9	329.99
	Amplitude	90	61	30.1	26	49
	Variância	1043.84	728.79	161.34	95.68	463.81
	Desvio Padrão	32.31	27.00	12.70	9.78	21.54
	Coef. De Variação %	11.31%	8.01%	2.83%	3.43%	6.47%
	Lazer	bote inflável	bote inflável	bote inflável	bote inflável	bote inflável
	1°semana	501.59	284.91	676.9	314.1	420.9
	2°semana	501.59	284.91	676.9	314.1	420.9
	3°semana	501.59	284.91	676.9	314.1	420.9
	4°semana	501.59	284.91	676.9	314.1	435.9
	5°semana	501.59	284.91	650.9	314.1	435.9
	6°semana	499.9	284.91	650.9	314.1	440
	7°semana	499.9	299.9	650.9	340.9	440
	8°semana	499.9	299.9	660	345	445.9
	Limite Inferior	499.9	284.91	650.9	314.1	420.9
	Limite Superior	501.59	299.9	676.9	345	445.9
	Média	500.96	288.66	665.04	321.31	432.55
	Moda	501.59	284.91	676.9	314.1	420.9
	Mediana	501.59	284.91	668.45	314.1	435.9
	Amplitude	1.69	14.99	26	30.9	25
	Variância	0.77	48.15	169.69	179.56	102.69
	Desvio Padrão	0.90	7.31	13.08	14.13	9.69
	Coef. De Variação %	0.18%	2.53%	1.97%	4.40%	2.24%
Plan2
Plan3