Modelo para Construçao de Histograma

Prévia do material em texto

Histograma
			 Amostras	Altura 
(cm)			Altura 
(cm)		Altura 
(cm)							Altura 
(cm)
			1	151		MÉDIA	171		CLASSE		H	151	Xi	Fi		CORTE	FREQUÊNCIA
			2	161		DESVIO	8.11		1	151	I--------	155	153	3		155	3
			3	166					2	155	I--------	159	157	2		159	2
			4	168			Altura 
(cm)		3	159	I--------	163	161	7		163	7
			5	169		K	10.0		4	163	I--------	167	165	11		167	11
			6	170		A	39		5	167	I--------	171	169	29		171	29
			7	173		H	3.90		6	171	I--------	174	172	13		174	13
			8	176		H (2)	0.39		7	174	I--------	178	176	15		178	15
			9	179					8	178	I--------	182	180	12		182	12
			10	182			Altura 
(cm)		9	182	I--------	186	184	4		186	4
			11	152		MÁXIMO	190		10	186	I--------	190	188	4		190	4
			12	162		MÍNIMO	151
			13	166		n	100
			14	168
			15	169
			16	170
			17	173
			18	176
			19	179
			20	182
			21	154
			22	163					TOTAL					100
			23	166
			24	168
			25	169
			26	171		Altura 
(cm)						Altura 
(cm)		Pontos	Eixo X	Altura 
(cm)
			27	174		PONTOS	VALOR 1	VALOR 2	PDM		MÉDIA	171		1	151	0.0020832563
			28	176		1	151.000	151.390	0.0023482144		DESVIO	8.11		2	151	0.0023510282
			29	180		2	151.390	151.780	0.0026407615		MÉDIA+4	203.851362207		3	152	0.0026469696
			30	183		3	151.780	152.170	0.0029628999		MÉDIA-4	138.948637793		4	152	0.002973145
			31	155		4	152.170	152.560	0.0033166616		PONTOS	100		5	153	0.0033316489
			32	163		5	152.560	152.950	0.0037040918		INCREMENTO 1	202.4478406131		6	153	0.0037245892
			33	167		6	152.950	153.340	0.0041272302		INICIO DO EIXO	151		7	153	0.0041540673
			34	168		7	153.340	153.730	0.0045880911		FINAL DO EIXO	190		8	154	0.0046221569
			35	169		8	153.730	154.120	0.0050886404		PONTOS	100		9	154	0.0051308799
			36	171		9	154.120	154.510	0.005630771		INCREMENTO 2	0.3939393939		10	155	0.0056821804
			37	174		10	154.510	154.900	0.006216277					11	155	0.0062778971
			38	177		11	154.900	155.290	0.0068468251					12	155	0.0069197337
			39	180		12	155.290	155.680	0.0075239256					13	156	0.0076092275
			40	184		13	155.680	156.070	0.0082489018					14	156	0.0083477179
			41	158		14	156.070	156.460	0.0090228588					15	157	0.0091363129
			42	163		15	156.460	156.850	0.0098466516					16	157	0.0099758561
			43	167		16	156.850	157.240	0.0107208537					17	157	0.010866893
			44	168		17	157.240	157.630	0.0116457254					18	158	0.0118096387
			45	169		18	157.630	158.020	0.0126211843					19	158	0.0128039462
			46	171		19	158.020	158.410	0.0136467758					20	158	0.0138492761
			47	174		20	158.410	158.800	0.0147216465					21	159	0.0149446695
			48	177		21	158.800	159.190	0.0158445204					22	159	0.0160887225
			49	180		22	159.190	159.580	0.0170136775					23	160	0.0172795654
			50	185		23	159.580	159.970	0.0182269364					24	160	0.0185148447
			51	159		24	159.970	160.360	0.0194816414					25	160	0.019791711
			52	164		25	160.360	160.750	0.0207746537					26	161	0.0211068106
			53	167		26	160.750	161.140	0.0221023487					27	161	0.0224562839
			54	168		27	161.140	161.530	0.0234606178					28	162	0.0238357694
			55	170		28	161.530	161.920	0.0248448766					29	162	0.0252404136
			56	171		29	161.920	162.310	0.0262500799					30	162	0.0266648881
			57	175		30	162.310	162.700	0.0276707415					31	163	0.0281034132
			58	177		31	162.700	163.090	0.0291009623					32	163	0.0295497887
			59	180		32	163.090	163.480	0.030534463					33	164	0.0309974306
			60	186		33	163.480	163.870	0.0319646244					34	164	0.0324394155
			61	159		34	163.870	164.260	0.0333845333					35	164	0.0338685302
			62	165		35	164.260	164.650	0.0347870337					36	165	0.0352773282
			63	167		36	164.650	165.040	0.0361647835					37	165	0.0366581909
			64	168		37	165.040	165.430	0.0375103162					38	166	0.0380033934
			65	170		38	165.430	165.820	0.0388161059					39	166	0.0393051748
			66	172		39	165.820	166.210	0.0400746361					40	166	0.0405558113
			67	175		40	166.210	166.600	0.0412784702					41	167	0.0417476911
			68	177		41	166.600	166.990	0.0424203243					42	167	0.0428733911
			69	181		42	166.990	167.380	0.0434931396					43	168	0.0439257532
			70	187		43	167.380	167.770	0.0444901549					44	168	0.0448979595
			71	160		44	167.770	168.160	0.045404977					45	168	0.0457836062
			72	165		45	168.160	168.550	0.0462316492					46	169	0.0465767731
			73	167		46	168.550	168.940	0.0469647155					47	169	0.0472720899
			74	168		47	168.940	169.330	0.0475992807					48	170	0.0478647964
			75	170		48	169.330	169.720	0.0481310646					49	170	0.0483507967
			76	172		49	169.720	170.110	0.0485564502					50	170	0.0487267067
			77	175		50	170.110	170.500	0.0488725247					51	171	0.048989893
			78	178		51	170.500	170.890	0.0490771126					52	171	0.0491385039
			79	181		52	170.890	171.280	0.0491688009					53	171	0.0491714906
			80	188		53	171.280	171.670	0.0491469548					54	172	0.0490886201
			81	161		54	171.670	172.060	0.0490117257					55	172	0.0488904778
			82	165		55	172.060	172.450	0.048764049					56	173	0.0485784602
			83	168		56	172.450	172.840	0.0484056334					57	173	0.0481547591
			84	169		57	172.840	173.230	0.0479389414					58	173	0.0476223355
			85	170		58	173.230	173.620	0.047367161					59	174	0.0469848856
			86	172		59	173.620	174.010	0.0466941695					60	174	0.0462467973
			87	175		60	174.010	174.400	0.0459244897					61	175	0.0454131009
			88	178		61	174.400	174.790	0.0450632393					62	175	0.0444894113
			89	181		62	174.790	175.180	0.0441160742					63	175	0.0434818654
			90	190		63	175.180	175.570	0.0430891269					64	176	0.0423970541
			91	161		64	175.570	175.960	0.0419889402					65	176	0.041241951
			92	166		65	175.960	176.350	0.0408223983					66	177	0.0400238378
			93	168		66	176.350	176.740	0.0395966553					67	177	0.0387502281
			94	169		67	176.740	177.130	0.0383190624					68	177	0.0374287913
			95	170		68	177.130	177.520	0.0369970953					69	178	0.0360672765
			96	173		69	177.520	177.910	0.0356382825					70	178	0.0346734377
			97	176		70	177.910	178.300	0.0342501351					71	179	0.0332549624
			98	178		71	178.300	178.690	0.0328400791					72	179	0.0318194029
			99	182		72	178.690	179.080	0.0314153921					73	179	0.0303741126
			100	190		73	179.080	179.470	0.0299831432					74	180	0.0289261861
						74	179.470	179.860	0.0285501383					75	180	0.0274824066
						75	179.860	180.250	0.027122871					76	181	0.0260491977
						76	180.250	180.640	0.0257074786					77	181	0.0246325826
						77	180.640	181.030	0.0243097052					78	181	0.0232381501
						78	181.030	181.420	0.0229348701					79	182	0.0218710263
						79	181.420	181.810	0.0215878435					80	182	0.0205358545
						80	181.810	182.200	0.0202730281					81	183	0.019236781
						81	182.200	182.590	0.018994347					82	183	0.0179774475
						82	182.590	182.980	0.0177552379					83	183	0.0167609899
						83	182.980	183.370	0.0165586531					84	184	0.0155900428
						84	183.370	183.760	0.0154070646					85	184	0.0144667493
						85	183.760	184.150	0.0143024745					86	184	0.0133927762
						86	184.150	184.540	0.0132464299					87	185	0.0123693327
						87	184.540	184.930	0.0122400416					88	185	0.0113971939
						88	184.930	185.320	0.0112840065					89	186	0.0104767266
						89	185.320	185.710	0.0103786327					90	186	0.0096079181
						90	185.710	186.100	0.0095238674					91	186	0.0087904069
						91	186.100	186.490	0.0087193262					92	187	0.008023515
						92	186.490	186.880	0.0079643235					93	187	0.007306281
						93	186.880	187.270	0.0072579044					94	188	0.006637493
						94	187.270	187.660	0.0065988761					95	188	0.0060157224
						95	187.660	188.050	0.0059858399					96	188	0.0054393563
						96	188.050	188.440	0.0054172215					97	189	0.0049066291
						97	188.440	188.830	0.004891302					98	189	0.0044156532
						98	188.830	189.220	0.0044062461					99	190	0.0039644478
						99	189.220	189.610	0.0039601297					100	190	0.0035509654
						100	189.610	190.000	0.0035509654
Altura
(cm)
FREQUÊNCIA	154.9	158.80000000000001162.70000000000002	166.60000000000002	170.50000000000003	174.40000000000003	178.30000000000004	182.20000000000005	186.10000000000005	190.00000000000006	3	2	7	11	29	13	15	12	4	4	PDM	151.38999999999999	151.77999999999997	152.16999999999996	152.55999999999995	152.94999999999993	153.33999999999992	153.7299999999999	154.11999999999989	154.50999999999988	154.89999999999986	155.28999999999985	155.67	999999999984	156.06999999999982	156.45999999999981	156.8499999999998	157.23999999999978	157.62999999999977	158.01999999999975	158.40999999999974	158.	79999999999973	159.18999999999971	159.5799999999997	159.96999999999969	160.35999999999967	160.74999999999966	161.13999999999965	161.52999999999963	161.91999999999962	162.3099999999996	162.69999999999959	163.08999999999958	163.47999999999956	163.86999999999955	164.25999999999954	164.64999999999952	165.03999999999951	165.4299999999995	165.81999999999948	166.20999999999947	166.59999999999945	166.98999999999944	167.37999999999943	167.76999999999941	168.1599999999994	168.54999999999939	168.93999999999937	169.32999999999936	169.71999999999935	170.10999999999933	170.49999999999932	170.8899999999993	171.27999999999929	171.66999999999928	172.05999999999926	172.44999999999925	172.83999999999924	173.22999999999922	173.61999999999921	174.0099999999992	174.39999999999918	174.78999999999917	175.17999999999915	175.56999999999914	175.95999999999913	176.34999999999911	176.7399999999991	177.12999999999909	177.51999999999907	177.90999999999906	178.29999999999905	178.68999999999903	179.07999999999902	17	9.469999999999	179.85999999999899	180.24999999999898	180.63999999999896	181.02999999999895	181.41999999999894	181.80999999999892	182.19999999999891	182.58999999999889	182.97999999999888	183.36999999999887	183.75999999999885	184.14999999999884	184.53999999999883	184.92999999999881	185.3199999999988	185.70999999999879	186.09999999999877	186.48999999999876	186.87999999999874	187.26999999999873	187.65999999999872	188.0499999999987	188.43999999999869	188.82999999999868	189.21999999999866	189.60999999999865	189.99999999999864	2.348214422498445E-3	2.6407614530821696E-3	2.9628998825437991E-3	3.316661621125008E-3	3.7040917687634891E-3	4.1272302126150722E-3	4.5880911169551902E-3	5.0886403594773708E-3	5.6307710092378081E-3	6.2162769855755471E-3	6.8468250836243088E-3	7.5239255997568855E-3	8.2489018385793443E-3	9.0228588	30926345E-3	9.8466516386138837E-3	1.0720853665321948E-2	1.1645725432698149E-2	1.262118431536257E-2	1.3646775756730362E-2	1.4721646508270594E-2	1.5844520446881141E-2	1.7013677527486774E-2	1.8226936419915102E-2	1.9481641359909006E-2	2.0774653713345737E-2	2.210234871014476E-2	2.3460617750018856E-2	2.4844876616499152E-2	2.6250079859183206E-2	2.7670741517852107E-2	2.9100962267207448E-2	3.0534462958999888E-2	3.1964624431023679E-2	3.3384533341825041E-2	3.4787033678195536E-2	3.6164783471908282E-2	3.7510316155109434E-2	3.8816105882729761E-2	4.0074636057629003E-2	4.1278470212230176E-2	4.2420324331282247E-2	4.3493139646027475E-2	4.4490154892084514E-2	4.540497700309995E-2	4.6231649210605616E-2	4.6	964715538072785E-2	4.7599280713970869E-2	4.8131064584364468E-2	4.8556450179417669E-2	4.8872524678884616E-2	4.9077112627603343E-2	4.9168800871154862E-2	4.9146954811852328E-2	4.9011725723464412E-2	4.8764049006724833E-2	4.8405633413770549E-2	4.7938941415159517E-2	4.7367161025030899E-2	4.6694169535367251E-2	4.5924489736441518E-2	4.506323931485854E-2	4.411607422090106E-2	4.3089126881283468E-2	4.1988940200409067E-2	4.0822398341750499E-2	3.9596655310397959E-2	3.8319062367965631E-2	3.6997095302175952E-2	3.5638282546240338E-2	3.4250135098709111E-2	3.2840079134215265E-2	3.1415392121239956E-2	2.998314317669469E-2	2.8550138290954957E-2	2.712287095333878E-2	2.5707478599318188E-2	2.430970518941062E-2	2.2934870118094551E-2	2.1587843	541499934E-2	2.027302810714764E-2	1.8994346969562311E-2	1.7755237883828878E-2	1.6558653086507558E-2	1.5407064600883813E-2	1.4302474542129594E-2	1.3246429948115111E-2	1.2240041623568551E-2	1.1284006458989485E-2	1.0378632670877387E-2	9.5238674059039095E-3	8.7193261578994621E-3	7.9643234620335561E-3	7.2579043543041259E-3	6.5988761152735572E-3	5.9858398536971709E-3	5.4172215270526331E-3	4.8913020407701313E-3	4.4062461149900044E-3	3.9601296558024711E-3	3.550965416100569E-3	
Frequência
CURVA GAUSS ALTURA (cm)
Altura 	
(cm)	151	151.39393939393941	151.78787878787881	152.18181818181822	152.57575757575762	152.96969696969703	153.36363636363643	153.75757575757584	154.15151515151524	154.54545454545465	154.93939393939405	155.33333333333346	155.72727272727286	156.12121212121227	156.51515151515167	156.90909090909108	157.30303030303048	157.69696969696989	158.09090909090929	158.4848484848487	158.8787878787881	159.27272727272751	159.66666666666691	160.06060606060632	160.45454545454572	160.84848484848513	161.24242424242453	161.63636363636394	162.03030303030334	162.42424242424275	162.81818181818215	163.21212121212156	163.60606060606096	164.00000000000037	164.39393939393977	164.78787878787918	165.18181818181858	165.57575757575799	165.9696969696974	166.3636363636368	166.75757575757621	167.15151515151561	167.54545454545502	167.93939393939442	168.33333333333383	168.72727272727323	169.12121212121264	169.51515151515204	169.90909090909145	170.30303030303085	170.69696969697026	171.09090909090966	171.48484848484907	171.87878787878847	172.27272727272788	172.66666666666728	173.06060606060669	173.45454545454609	173.8484848484855	174.2424242424249	174.63636363636431	175.03030303030371	175.42424242424312	175.81818181818252	176.21212121212193	176.60606060606133	177.00000000000074	177.39393939394014	177.78787878787955	178.18181818181895	178.57575757575836	178.96969696969776	179.36363636363717	179	.75757575757657	180.15151515151598	180.54545454545539	180.93939393939479	181.3333333333342	181.7272727272736	182.12121212121301	182.51515151515241	182.90909090909182	183.30303030303122	183.69696969697063	184.09090909091003	184.48484848484944	184.87878787878884	185.27272727272825	185.66666666666765	186.06060606060706	186.45454545454646	186.84848484848587	187.24242424242527	187.63636363636468	188.03030303030408	188.42424242424349	188.81818181818289	189.2121212121223	189.6060606060617	190.00000000000111	2.0832563489540661E-3	2.3510281736526346E-3	2.6469696357526418E-3	2.97314500957006E-3	3.3316489186582796E-3	3.7245891617838974E-3	4.154067283275149E-3	4.6221569064637206E-3	5.1308798901322982E-3	5.6821804127301237E-3	6.2778971370513114E-3	6.9197336583658045E-3	7.6092274907925131E-3	8.3477178990175177E-3	9.1363129341787332E-3	9.9758560826510474E-3	1.0866892983283631E-2	1.1809638711022257E-2	1.2803946161431748E-2	1.3849276100069176E-2	1.4944669461650503E-2	1.6088722495297272E-2	1.7279565352772294E-2	1.8514844705613549E-2	1.9791710953762344E-2	2.1106810552211495E-2	2.2456283933202887E-2	2.3835769439716915E-2	2.5240413611872681E-2	2.6664888082184392E-2	2.8103413239512931E-2	2.9549788716455219E-2	3.0997430642574791E-2	3.2439415488321292E-2	3.3868530203979758E-2	3.5277328236991756E-2	3.6658190892096508E-2	3.8003393384624509E-2	3.9305174830621577E-2	4.0555811320909477E-2	4.1747691142188584E-2	4.2873391139144484E-2	4.3925753159246857E-2	4.4897959488205005E-2	4.5783606170161327E-2	4.6576773113516226E-2	4.7272089911172738E-2	4.7864796352860409E-2	4.8350796676440308E-2	4.8726706693605459E-2	4.8989893031597738E-2	4.9138503854444925E-2	4.9171490562366429E-2	4.9088620113651789E-2	4.889047776646242	3E-2	4.8578460195430807E-2	4.8154759096308924E-2	4.7622335547902184E-2	4.6984885550828852E-2	4.6246797304129207E-2	4.541310091049975E-2	4.4489411316331356E-2	4.3481865391537838E-2	4.2397054134538578E-2	4.1241951048332365E-2	4.0023837773479794E-2	3.8750228082608522E-2	3.7428791338877478E-2	3.6067276498274903E-2	3.4673437693728423E-2	3.325496237923823E-2	3.181940293643587E-2	3.0374112556262416E-2	2.8926186107229569E-2	2.748240659153204E-2	2.6049197673775993E-2	2.4632582646962529E-2	2.3238150079266783E-2	2.1871026265626332E-2	2.053585449257915E-2	1.9236781015339356E-2	1.7977447544678189E-2	1.6760989949407348E-2	1.55900427994459E-2	1.4466749305565775E-21.3392776155597131E-2	1.2369332703448239E-2	1.1397193936757085E-2	1.0476726631052645E-2	9.6079180924082755E-3	8.7904068959320132E-3	8.0235150430787716E-3	7.3062809855527289E-3	6.637492996245103E-3	6.0157224068998127E-3	5.4393562766582183E-3	4.9066291039472909E-3	4.4156532450199083E-3	3.9644477545739609E-3	3.5509654160980888E-3	
Frequência