WorkbookView::show_horizontal_scrollbar
TRUE
WorkbookView::show_vertical_scrollbar
TRUE
WorkbookView::show_notebook_tabs
TRUE
WorkbookView::do_auto_completion
TRUE
WorkbookView::is_protected
FALSE
2019-11-25T15:07:38Z
Sheet1
Sheet2
Sheet3
msr
Sheet1!$D$32
A1
N
Sheet1!$B$31
A1
Sm
Sheet1!$D$33
A1
Sheet1
8
32
1
Print_Area
#REF!
A1
Sheet_Title
"Sheet1"
A1
d_then_r
portrait
na_letter
Arial CE
Arial CE
Sans
Sans
Sans
Sans
Sans
Sans
Arial CE
Sans
Sans
Sans
Sans
Sans
Arial CE
Arial CE
Sans
Sans
Sans
Arial CE
Sans
Sans
275.999250
494.226000
Default
7.086614
top-left
fill
0
7.086614
1
7.086614
1
"Tablica Galtona"
1
Linear
1
7.086614
1
"numer przegródki"
Linear
1
7.086614
1
"liczba kulek"
FALSE
FALSE
1
1
FALSE
1
y-origin
linear
1
"dane doświadczalne"
Sheet1!$A$2:$A$29
Sheet1!$B$2:$B$29
Sheet1!$C$2:$C$29
Sheet1!$C$2:$C$29
y-origin
linear
2
"Gauss teoretyczny"
Sheet1!$A$2:$A$29
Sheet1!$F$2:$F$29
5.669291
7.086614
7.086614
1
m
Nm
u_Nm
m*Nm
(msr-m)^2*Nm
Gauss teor.
chi^2
1
2
=sqrt(B2)
=A2*B2
=(msr-A2)^2*B2
=normdist(A2,msr,Sm,0)*N*1
=(B2-F2)^2/F2
2
2
3
4
4
8
5
11
6
10
7
18
8
14
9
30
10
43
11
46
12
53
13
65
14
74
15
90
16
92
17
84
18
82
19
76
20
54
21
60
22
46
23
42
24
30
25
14
26
10
27
4
28
6
=sum(B2:B29)
chi^2=
poziom ufnosci:
msr=
=D31/N
chi^2/ndf=
=G31/25
=chidist(G31,25)
Sm=
=sqrt(E31/(N-1))
Sheet2
0
0
1
Print_Area
#REF!
A1
Sheet_Title
"Sheet2"
A1
d_then_r
portrait
na_letter
Sans
Sheet3
0
0
1
Print_Area
#REF!
A1
Sheet_Title
"Sheet3"
A1
d_then_r
portrait
na_letter
Sans