---

Overview

Dane
Analiza
Test Bartlett'a
Dane po transformacji
Analiza po transformacji
Test Bartletta po transformacji

---

Sheet 1: Dane

		Stan	Liczba firm w stanie	Region
1	Northeast	Pennsylvania	2067,000	1
2	Northcentral	Vermont	16172,000	1
3	South	Rhode Island	22178,000	1			Northeast	Northcentral	South	West
4	West	New Hampshire	25725,000	1			2067,000	14706,000	10947,000	2565,000
		Maine	27305,000	1			16172,000	16536,000	13793,000	4013,000
		CONNECTICUT	70772,000	1			22178,000	34061,000	15258,000	11933,000
		Massachusetts	118833,000	1			25725,000	50099,000	28679,000	12255,000
		New Jersey	169962,000	1			27305,000	55643,000	59504,000	21023,000
		New York	371479,000	1			70772,000	87835,000	60429,000	22537,000
		North Dakota	14706,000	2			118833,000	96113,000	65056,000	22551,000
		South Dakota	16536,000	2			169962,000	96618,000	84235,000	28979,000
		Nebraska	34061,000	2			371479,000	99417,000	87823,000	30897,000
		Kansas	50099,000	2				160736,000	118695,000	42261,000
		Iowa	55643,000	2				181045,000	122003,000	58191,000
		Minnesota	87835,000	2				212755,000	284249,000	65492,000
		Indiana	96113,000	2						67744,000
		Wisconsin	96618,000	2						67958,000
		Missouri	99417,000	2						80702,000
		Michigan	160736,000	2						108405,000
		Ohio	181045,000	2						295485,000
		Illinois	212755,000	2						568686,000
		Virginia	10947,000	3
		District of Columbia	13793,000	3
		Delaware	15258,000	3
		West Virginia	28679,000	3
		South Carolina	59504,000	3
		Kentucky	60429,000	3
		ALABAMA	65056,000	3
		Tennessee	84235,000	3
		Maryland	87823,000	3
		Georgia	118695,000	3
		North Carolina	122003,000	3
		Florida	284249,000	3
		Nevada	2565,000	4
		Mississippi	4013,000	4
		Alaska	11933,000	4
		Wyoming	12255,000	4
		Montana	21023,000	4
		Hawaii	22537,000	4
		Idaho	22551,000	4
		New Mexico	28979,000	4
		Utah	30897,000	4
		Arkansas	42261,000	4
		Oklahoma	58191,000	4
		Oregon	65492,000	4
		Louisiana	67744,000	4
		Arizona	67958,000	4
		Colorado	80702,000	4
		Washington	108405,000	4
		Texas	295485,000	4
		California	568686,000	4

---

Sheet 2: Analiza

Analiza wariancji: jednoczynnikowa
PODSUMOWANIE
Grupy	Licznik	Suma	Średnia	Wariancja
Northeast	9	824493	91610,3333333333	14080827075,5
Northcentral	12	1105564	92130,3333333333	4131768037,69697		4,61649535584753
South	12	950671	79222,5833333333	5641325411,35606
West	18	1511677	83982,0555555556	19074287957,4673
ANALIZA WARIANCJI
Źródło wariancji	SS	df	MS	F	Wartość-p	Test F
Pomiędzy grupami	1357948325,82513	3	452649441,941711	0,039077874107014	0,989551504961461	2,8023521281284
W obrębie grup	544413539820,53	47	11583266804,6921
Razem	545771488146,35	50

---

Sheet 3: Test Bartlett'a

Licznik	Wariancja
9	14080827075,5	81,1890253201399			0,125
12	4131768037,69697	105,777495249035			0,090909090909091
12	5641325411,35606	107,265192672778			0,090909090909091
18	19074287957,4673	174,767621690427			0,058823529411765
		468,99933493238			0,365641711229946	0,021276595744681	0,111111111111111
473,000059812915
					0,344365115485266
	M=	4,00072488053507
					1,03826279060947
			7,81472790325118
					2,30258509299405
					8,87697784200385

---

Sheet 4: Dane po transformacji

Stan	Liczba firm w stanie	Log	Region
Pennsylvania	2067,000	3,315	1
Vermont	16172,000	4,209	1
Rhode Island	22178,000	4,346	1
New Hampshire	25725,000	4,410	1			Northeast	Northcentral	South	West
Maine	27305,000	4,436	1			3,31534047662729	4,16749456163572	4,03929511808431	3,40908736944783
CONNECTICUT	70772,000	4,850	1			4,20876373266164	4,21843046361923	4,13965873620818	3,60346915973384
Massachusetts	118833,000	5,075	1			4,34592237913834	4,53225739430499	4,18349761055935	4,076749640624
New Jersey	169962,000	5,230	1			4,41035538343447	4,6998290572282	4,4575640039674	4,0883133155881
New York	371479,000	5,570	1			4,43624218087156	4,74541053699798	4,7745461610149	4,32269469030688
North Dakota	14706,000	4,167	2			4,84986146883813	4,94366760563273	4,78124540745257	4,35289610469331
South Dakota	16536,000	4,218	2			5,07493706124917	4,98278213320889	4,81328735695795	4,35316580496576
Nebraska	34061,000	4,532	2			5,23035183293674	4,98505804331451	4,92549258019957	4,46208339486963
Kansas	50099,000	4,700	2			5,56993426778192	4,99746065376271	4,94360826835471	4,48991631286508
Iowa	55643,000	4,745	2				5,20611315647946	5,07443242478319	4,62593976932168
Minnesota	87835,000	4,944	2				5,25778653521548	5,08637050991595	4,76485582051615
Indiana	96113,000	4,983	2				5,32787977532252	5,45369894549611	4,81618825315137
Wisconsin	96618,000	4,985	2						4,83087083633932
Missouri	99417,000	4,997	2						4,83224058912366
Michigan	160736,000	5,206	2						4,90688429777289
Ohio	181045,000	5,258	2						5,03504931377369
Illinois	212755,000	5,328	2						5,47053543925255
Virginia	10947,000	4,039	3						5,75487253685497
DISTRICT OF COLUMBIA	13793,000	4,140	3
DELAWARE	15258,000	4,183	3
West Virginia	28679,000	4,458	3
South Carolina	59504,000	4,775	3
Kentucky	60429,000	4,781	3
ALABAMA	65056,000	4,813	3
Tennessee	84235,000	4,925	3
Maryland	87823,000	4,944	3
Georgia	118695,000	5,074	3
North Carolina	122003,000	5,086	3
Florida	284249,000	5,454	3
Nevada	2565,000	3,409	4
Mississippi	4013,000	3,603	4
Alaska	11933,000	4,077	4
Wyoming	12255,000	4,088	4
Montana	21023,000	4,323	4
Hawaii	22537,000	4,353	4
Idaho	22551,000	4,353	4
New Mexico	28979,000	4,462	4
Utah	30897,000	4,490	4
Arkansas	42261,000	4,626	4
Oklahoma	58191,000	4,765	4
Oregon	65492,000	4,816	4
Louisiana	67744,000	4,831	4
Arizona	67958,000	4,832	4
Colorado	80702,000	4,907	4
Washington	108405,000	5,035	4
Texas	295485,000	5,471	4
California	568686,000	5,755	4

---

Sheet 5: Analiza po transformacji

Analiza wariancji: jednoczynnikowa
PODSUMOWANIE
Grupy	Licznik	Suma	Średnia	Wariancja
Northeast	9	41,4417087835393	4,60463430928214	0,444583955084166
Northcentral	12	58,0641699167224	4,83868082639353	0,1441338593259
South	12	56,6726971229942	4,72272476024952	0,187508545678621		3,08452127184718
West	18	82,1958126492007	4,56643403606671	0,336090523007549
ANALIZA WARIANCJI
Źródło wariancji	SS	df	MS	F	Wartość-p	Test F
Pomiędzy grupami	0,605498769340329	3	0,201832923113443	0,734319862934282	0,536789227901146	2,8023521281284
W obrębie grup	12,9182769868514	47	0,274856957167052
Razem	13,5237757561918	50

---

Sheet 6: Test Bartletta po transformacji

Licznik	Wariancja
9	0,444583955084166	-2,81636971940569			0,125
12	0,1441338593259	-9,25357383004957			0,090909090909091
12	0,187508545678621	-7,99676828025111			0,090909090909091
18	0,336090523007549	-8,0502434691567			0,058823529411765
		-28,1169552988631			0,365641711229946	0,021276595744681	0,111111111111111
-26,3619835010837
					0,344365115485266
	M=	1,75497179777937
					1,03826279060947
			7,81472790325118
					2,30258509299405
					3,89380057803468