---

Overview

Arkusz1
Arkusz2
Arkusz3
Arkusz4

---

Sheet 1: Arkusz1

X	n	30	xi - xśr	xi - xśr^2		Var	2,72863788888889
1,24	x śr	3,44	-2,20	4,85		S	1,65185891918435
4,69	alfa=	0,1	1,25	1,56
1,51	1 chi^2	42,5569678042927	-1,93	3,73
3,7	2 chi^2	17,7083661828246	0,26	0,07
4,79			1,35	1,82
3,84			0,40	0,16
0,66			-2,78	7,74
1,72			-1,72	2,97
7,28			3,84	14,73			Var	(	1,924	;	4,623	)
2,91			-0,53	0,28			S	(	1,387	;	2,150	)
4,1			0,66	0,43
2,06			-1,38	1,91
2,58			-0,86	0,74
3,18			-0,26	0,07
3,61			0,17	0,03
1,8			-1,64	2,70
4,22			0,78	0,60
5,36			1,92	3,68
7,27			3,83	14,65
2,4			-1,04	1,09
5,6			2,16	4,66
3,19			-0,25	0,06
3,49			0,05	0,00
3,72			0,28	0,08
5,32			1,88	3,53
3,45			0,01	0,00
0,91			-2,53	6,41
2,15			-1,29	1,67
2,37			-1,07	1,15
4,15			0,71	0,50
			Suma	81,86

---

Sheet 2: Arkusz2

X	alfa=	0,1	xi - xśr	xi - xśr^2
48,96	x śr=	42,5163	6,44369999999999	41,5212696899999
41,59	n=	100	-0,926300000000005	0,858031690000009
41,64	S^2 (Var)=	25,57791131	-0,876300000000008	0,767901690000013	S	(	4,561	;	5,772	)
50,24	S=	5,05746095486658	7,72369999999999	59,6555416899999	Var	(	20,805	;	33,319	)
40,32	U*=	1,64485362695147	-2,19630000000001	4,82373369000004
44,13			1,61369999999999	2,60402768999998
42,22			-0,296300000000009	0,087793690000006
56,41			13,8937	193,03489969
39,74			-2,77630000000001	7,70784169000003
47,16			4,64369999999999	21,5639496899999
43,33			0,81369999999999	0,662107689999984
49,71			7,19369999999999	51,7493196899999
48,37			5,85369999999999	34,2658036899999
42,12			-0,396300000000011	0,157053690000009
48,92			6,40369999999999	41,0073736899999
44,71			2,19369999999999	4,81231968999997
53,56			11,0437	121,96330969
45,94			3,42369999999999	11,7217216899999
41,89			-0,626300000000008	0,39225169000001
39,56			-2,95630000000001	8,73970969000004
47,53			5,01369999999999	25,1371876899999
52,42			9,90369999999999	98,0832736899999
38,39			-4,12630000000001	17,0263516900001
45,21			2,69369999999999	7,25601968999996
39,19			-3,32630000000001	11,0642716900001
47,5			4,98369999999999	24,8372656899999
35,39			-7,12630000000001	50,7841516900001
37,73			-4,78630000000001	22,9086676900001
40,69			-1,82630000000001	3,33537169000004
37,22			-5,29630000000001	28,0507936900001
50,7			8,18369999999999	66,9729456899999
33,15			-9,36630000000001	87,7275756900002
41,74			-0,776300000000006	0,60264169000001
45,8			3,28369999999999	10,7826856899999
43,83			1,31369999999999	1,72580768999997
42,02			-0,496300000000005	0,246313690000005
38,74			-3,77630000000001	14,26044169
44,54			2,02369999999999	4,09536168999996
39,11			-3,40630000000001	11,6028796900001
34,18			-8,33630000000001	69,4938976900001
46,74			4,22369999999999	17,8396416899999
37,2			-5,31630000000001	28,2630456900001
45,77			3,25369999999999	10,58656369
42,69			0,17369999999999	0,030171689999996
45,45			2,93369999999999	8,60659568999997
40,89			-1,62630000000001	2,64485169000002
44,43			1,91369999999999	3,66224768999997
36,8			-5,71630000000001	32,6760856900001
38,09			-4,42630000000001	19,59213169
44,02			1,5037	2,26111368999998
46,33			3,81369999999999	14,5443076899999
40,12			-2,39630000000001	5,74225369000005
43,03			0,513699999999993	0,263887689999993
46,86			4,34369999999999	18,8677296899999
38,68			-3,83630000000001	14,7171976900001
40,39			-2,12630000000001	4,52115169000003
45,35			2,83369999999999	8,02985568999996
40,01			-2,50630000000001	6,28153969000005
40,15			-2,36630000000001	5,59937569000005
45,52			3,00369999999999	9,02221368999997
39,04			-3,47630000000001	12,0846616900001
48,09			5,5737	31,0661316899999
43,46			0,943699999999993	0,890569689999986
33,27			-9,24630000000001	85,4940636900001
38,18			-4,33630000000001	18,8034976900001
37,63			-4,88630000000001	23,8759276900001
38,41			-4,10630000000001	16,8616996900001
40,94			-1,57630000000001	2,48472169000003
33,83			-8,68630000000001	75,4518076900002
43,54			1,02369999999999	1,04796168999998
54,07			11,5537	133,48798369
45,03			2,51369999999999	6,31868768999996
42,75			0,233699999999992	0,054615689999996
44,27			1,7537	3,07546368999998
41,13			-1,38630000000001	1,92182769000002
39,09			-3,4263	11,73953169
42,45			-0,066300000000005	0,004395690000001
36,44			-6,07630000000001	36,9214216900001
38,34			-4,17630000000001	17,44148169
38,25			-4,26630000000001	18,2013156900001
38,26			-4,25630000000001	18,1160896900001
41,2			-1,31630000000001	1,73264569000001
26,43			-16,0863	258,76904769
45,86			3,34369999999999	11,1803296899999
48,6			6,08369999999999	37,0114056899999
45,03			2,51369999999999	6,31868768999996
43,4			0,88369999999999	0,780925689999983
35,69			-6,82630000000001	46,5983716900001
47,36			4,84369999999999	23,4614296899999
43,49			0,973699999999994	0,948091689999988
52,85			10,3337	106,78535569
34,79			-7,72630000000001	59,6957116900001
37,55			-4,96630000000001	24,6641356900001
41,58			-0,93630000000001	0,876657690000019
45,06			2,54369999999999	6,47040968999997
47,41			4,89369999999999	23,9482996899999
45,43			2,91369999999999	8,48964768999995
41,72			-0,796300000000009	0,634093690000015
41,84			-0,676300000000005	0,457381690000006
35,75			-6,76630000000001	45,7828156900001
				2557,791131

---

Sheet 3: Arkusz3

X	alfa=	0,1	xi - x śr	xi - x śr^2
19,763	x śr	19,90635	-0,143350000000002	0,020549222500001
20,274	n=	40	0,367649999999998	0,135166522499998
22,625	S^2=	3,0948125275	2,71865	7,39105782249998	T-student	(	19,432	;	20,381	)
18,971	S=	1,75920792617018	-0,935350000000003	0,874879622500006	Chi kwadrat	(	1,506	;	2,195	)
20,789			0,882649999999998	0,779071022499997
19,705	T=	1,68487512171122	-0,201350000000005	0,040541822500002
17,76			-2,14635	4,60681832250001
18,351			-1,55535	2,41911362250001
20,069	1Chi^2	25,6953903995748	0,162649999999996	0,026455022499999
22,06	2Chi^2	54,5722277589418	2,15365	4,63820832249998
21,957			2,05065	4,20516542249999
21,365			1,45865	2,12765982249999
19,07			-0,836350000000003	0,699481322500005
21,125			1,21865	1,48510782249999
19,435			-0,471350000000005	0,222170822500004
21,863			1,95665	3,82847922249999
18,294			-1,61235	2,59967252250001
21,299			1,39265	1,93947402249999
18,325			-1,58135	2,50066782250001
20,903			0,996649999999995	0,993311222499991
20,449			0,542649999999998	0,294469022499998
16,938			-2,96835	8,81110172250003
19,379			-0,527350000000002	0,278098022500002
18,467			-1,43935	2,07172842250001
16,162			-3,74435	14,0201569225
20,016			0,109649999999995	0,012023122499999
20,283			0,376649999999998	0,141865222499998
19,432			-0,474350000000005	0,225007922500004
22,637			2,73065	7,45644942249998
21,157			1,25065	1,56412542249999
19,115			-0,791350000000005	0,626234822500008
18,146			-1,76035	3,09883212250001
19,831			-0,075350000000004	0,005677622500001
17,716			-2,19035	4,79763312250001
24,595			4,68865	21,9834388225
16,572			-3,33435	11,1178899225
20,815			0,908649999999998	0,825644822499996
19,945			0,038649999999997	0,0014938225
18,778			-1,12835	1,27317372250001
21,818			1,91165	3,65440572249999
			Suma	123,7925011

---

Sheet 4: Arkusz4

X	alfa=	0,1	xi - xśr	xi - xśr^2
11,6	n=	200	-0,359499999999993	0,129240249999995
10,5	x śr=	11,9595	-1,45949999999999	2,13014024999998
11,3	S^2=	0,87820975	-0,659499999999992	0,43494024999999	S1	(	11,850	;	12,069	)
11,9	S=	0,937128459710834	-0,059499999999993	0,003540249999999
11,8	S1=	0,939480103206879	-0,159499999999992	0,025440249999998	Sigma	(	0,869	;	1,025	)
11,8			-0,159499999999992	0,025440249999998
11,1	U*=	1,64485362695147	-0,859499999999994	0,738740249999989
11,8			-0,159499999999992	0,025440249999998
12			0,040500000000007	0,001640250000001
11,8			-0,159499999999992	0,025440249999998
12,7			0,740500000000006	0,548340250000009
10,6			-1,35949999999999	1,84824024999998
13,1			1,14050000000001	1,30074025000002
12,8			0,840500000000008	0,706440250000013
12,9			0,940500000000007	0,884540250000014
12,3			0,340500000000008	0,115940250000005
12,3			0,340500000000008	0,115940250000005
12,7			0,740500000000006	0,548340250000009
11,6			-0,359499999999993	0,129240249999995
11,5			-0,459499999999993	0,211140249999994
11,2			-0,759499999999994	0,576840249999991
11,1			-0,859499999999994	0,738740249999989
12,4			0,440500000000007	0,194040250000006
13,1			1,14050000000001	1,30074025000002
12,9			0,940500000000007	0,884540250000014
12,2			0,240500000000006	0,057840250000003
12,6			0,640500000000007	0,410240250000008
11,8			-0,159499999999992	0,025440249999998
11,6			-0,359499999999993	0,129240249999995
11,7			-0,259499999999994	0,067340249999997
12,3			0,340500000000008	0,115940250000005
13			1,04050000000001	1,08264025000001
13,6			1,64050000000001	2,69124025000002
13,9			1,94050000000001	3,76554025000003
13,2			1,24050000000001	1,53884025000002
13,3			1,34050000000001	1,79694025000002
12,4			0,440500000000007	0,194040250000006
11			-0,959499999999993	0,920640249999987
10,6			-1,35949999999999	1,84824024999998
12			0,040500000000007	0,001640250000001
10,7			-1,25949999999999	1,58634024999998
11,4			-0,559499999999993	0,313040249999992
10,9			-1,05949999999999	1,12254024999998
12,4			0,440500000000007	0,194040250000006
13,9			1,94050000000001	3,76554025000003
13			1,04050000000001	1,08264025000001
12,7			0,740500000000006	0,548340250000009
10,5			-1,45949999999999	2,13014024999998
13			1,04050000000001	1,08264025000001
13,1			1,14050000000001	1,30074025000002
10,1			-1,85949999999999	3,45774024999998
11,4			-0,559499999999993	0,313040249999992
12,3			0,340500000000008	0,115940250000005
12			0,040500000000007	0,001640250000001
13,3			1,34050000000001	1,79694025000002
12,6			0,640500000000007	0,410240250000008
12,9			0,940500000000007	0,884540250000014
12,5			0,540500000000007	0,292140250000007
12,5			0,540500000000007	0,292140250000007
11,9			-0,059499999999993	0,003540249999999
11,3			-0,659499999999992	0,43494024999999
11,1			-0,859499999999994	0,738740249999989
9,5			-2,45949999999999	6,04914024999997
12,3			0,340500000000008	0,115940250000005
10,2			-1,75949999999999	3,09584024999998
12			0,040500000000007	0,001640250000001
12,8			0,840500000000008	0,706440250000013
12,4			0,440500000000007	0,194040250000006
13,8			1,84050000000001	3,38744025000003
12,1			0,140500000000007	0,019740250000002
12,1			0,140500000000007	0,019740250000002
10,7			-1,25949999999999	1,58634024999998
13,5			1,54050000000001	2,37314025000002
13			1,04050000000001	1,08264025000001
12,5			0,540500000000007	0,292140250000007
12,7			0,740500000000006	0,548340250000009
11,7			-0,259499999999994	0,067340249999997
11,5			-0,459499999999993	0,211140249999994
11,5			-0,459499999999993	0,211140249999994
12,3			0,340500000000008	0,115940250000005
11,3			-0,659499999999992	0,43494024999999
10,4			-1,55949999999999	2,43204024999998
9,5			-2,45949999999999	6,04914024999997
10,9			-1,05949999999999	1,12254024999998
12			0,040500000000007	0,001640250000001
14,4			2,44050000000001	5,95604025000004
12,9			0,940500000000007	0,884540250000014
12,7			0,740500000000006	0,548340250000009
11,6			-0,359499999999993	0,129240249999995
12,3			0,340500000000008	0,115940250000005
12			0,040500000000007	0,001640250000001
11,4			-0,559499999999993	0,313040249999992
11,9			-0,059499999999993	0,003540249999999
11,7			-0,259499999999994	0,067340249999997
13,5			1,54050000000001	2,37314025000002
13			1,04050000000001	1,08264025000001
11,4			-0,559499999999993	0,313040249999992
11,7			-0,259499999999994	0,067340249999997
12,5			0,540500000000007	0,292140250000007
10,2			-1,75949999999999	3,09584024999998
11,8			-0,159499999999992	0,025440249999998
12,5			0,540500000000007	0,292140250000007
13,3			1,34050000000001	1,79694025000002
12,1			0,140500000000007	0,019740250000002
11,5			-0,459499999999993	0,211140249999994
10,6			-1,35949999999999	1,84824024999998
11,2			-0,759499999999994	0,576840249999991
12,2			0,240500000000006	0,057840250000003
11			-0,959499999999993	0,920640249999987
10,4			-1,55949999999999	2,43204024999998
13			1,04050000000001	1,08264025000001
11,9			-0,059499999999993	0,003540249999999
11,8			-0,159499999999992	0,025440249999998
11,2			-0,759499999999994	0,576840249999991
12,1			0,140500000000007	0,019740250000002
10,8			-1,15949999999999	1,34444024999998
12,6			0,640500000000007	0,410240250000008
12,2			0,240500000000006	0,057840250000003
12,3			0,340500000000008	0,115940250000005
11,5			-0,459499999999993	0,211140249999994
10,1			-1,85949999999999	3,45774024999998
12,3			0,340500000000008	0,115940250000005
12,2			0,240500000000006	0,057840250000003
13			1,04050000000001	1,08264025000001
13,4			1,44050000000001	2,07504025000002
12,1			0,140500000000007	0,019740250000002
14,1			2,14050000000001	4,58174025000003
11,3			-0,659499999999992	0,43494024999999
12,4			0,440500000000007	0,194040250000006
12,2			0,240500000000006	0,057840250000003
13			1,04050000000001	1,08264025000001
11,2			-0,759499999999994	0,576840249999991
14,1			2,14050000000001	4,58174025000003
12,1			0,140500000000007	0,019740250000002
11,1			-0,859499999999994	0,738740249999989
9,8			-2,15949999999999	4,66344024999997
12,6			0,640500000000007	0,410240250000008
12,5			0,540500000000007	0,292140250000007
13,6			1,64050000000001	2,69124025000002
11,1			-0,859499999999994	0,738740249999989
13			1,04050000000001	1,08264025000001
12,1			0,140500000000007	0,019740250000002
12,2			0,240500000000006	0,057840250000003
10,8			-1,15949999999999	1,34444024999998
11,1			-0,859499999999994	0,738740249999989
12,4			0,440500000000007	0,194040250000006
12			0,040500000000007	0,001640250000001
11,7			-0,259499999999994	0,067340249999997
10,9			-1,05949999999999	1,12254024999998
11,1			-0,859499999999994	0,738740249999989
12,3			0,340500000000008	0,115940250000005
11,7			-0,259499999999994	0,067340249999997
10,4			-1,55949999999999	2,43204024999998
12,6			0,640500000000007	0,410240250000008
11,3			-0,659499999999992	0,43494024999999
11,1			-0,859499999999994	0,738740249999989
12,5			0,540500000000007	0,292140250000007
12,9			0,940500000000007	0,884540250000014
12,2			0,240500000000006	0,057840250000003
11,8			-0,159499999999992	0,025440249999998
12,1			0,140500000000007	0,019740250000002
12,9			0,940500000000007	0,884540250000014
11,8			-0,159499999999992	0,025440249999998
11,3			-0,659499999999992	0,43494024999999
11,3			-0,659499999999992	0,43494024999999
12,5			0,540500000000007	0,292140250000007
13,1			1,14050000000001	1,30074025000002
13			1,04050000000001	1,08264025000001
11,2			-0,759499999999994	0,576840249999991
12,6			0,640500000000007	0,410240250000008
11,3			-0,659499999999992	0,43494024999999
12,3			0,340500000000008	0,115940250000005
11,9			-0,059499999999993	0,003540249999999
11			-0,959499999999993	0,920640249999987
10,7			-1,25949999999999	1,58634024999998
11,9			-0,059499999999993	0,003540249999999
10,7			-1,25949999999999	1,58634024999998
11,7			-0,259499999999994	0,067340249999997
10,4			-1,55949999999999	2,43204024999998
13			1,04050000000001	1,08264025000001
12			0,040500000000007	0,001640250000001
11,4			-0,559499999999993	0,313040249999992
12			0,040500000000007	0,001640250000001
11,8			-0,159499999999992	0,025440249999998
12,9			0,940500000000007	0,884540250000014
10			-1,95949999999999	3,83964024999997
12,7			0,740500000000006	0,548340250000009
10,8			-1,15949999999999	1,34444024999998
12,6			0,640500000000007	0,410240250000008
12			0,040500000000007	0,001640250000001
13,1			1,14050000000001	1,30074025000002
11,2			-0,759499999999994	0,576840249999991
12,9			0,940500000000007	0,884540250000014
10,7			-1,25949999999999	1,58634024999998
11,1			-0,859499999999994	0,738740249999989
10,7			-1,25949999999999	1,58634024999998
12			0,040500000000007	0,001640250000001
11,8			-0,159499999999992	0,025440249999998
12,8			0,840500000000008	0,706440250000013
11			-0,959499999999993	0,920640249999987
				175,64195