of 6
7/23/2019 Practical Zan2 Intr Geostat 2013
1/6
2.
: 1. EXCEL
( 2).
2. 1 ,1- , 2- ,
Z .
. / / .
EXCEL 2 1- RES1.
RES2...( , 4).
. ,
, 1- , 5 :
1-
2-
/ / / ,
. Practical_zan2_VVGeostat.pdf
2. Variants_lecture_2_geostat.xls
. 2 .
. 2
. 200, 1 .
Z.
1.
2. 2
. , .
:
[ ] +=)(
1
2)()(
)(2
1)(
hN
hxzxzhN
h
7/23/2019 Practical Zan2 Intr Geostat 2013
2/6
Excel . __2.xls . ,
- .
-
1
(h=1)
2
(h=2)
3
(h=3)
4
(h=4)
1
(h=1)
2
(h=2)
3
(h=3)
4
(h=4)
1 2 3 4 Z(xi)
Z(xj+1)
Z(xi)
Z(xj+2)
Z(xi)
Z(xj+3)
Z(xi)
Z(xj+4)
Z[(xi)
Z(xj+1
Z[(xi)
Z(xj+2)
]2
Z[(xi)
Z(xj+3)
]2
Z[(xi)
Z(xj+4
1 p1 p2 p3 1-2
2 p2 p3 p4
3 p3 p4 p5
4 p4 p5 p6
5 p5 p6 p7
6 p6 p7 p8
7 p7 p8 p9
8 p8 p9
9 p9
-
( h)
.
. 1
1 . , ,
.
( ). ().
7/23/2019 Practical Zan2 Intr Geostat 2013
3/6
h. .
, 2. , 2. -.
2. 5
semivariograms_100.xls,
c .
?
0
5
10
15
20
25
30
1 2 3 4
h )
g
m
m
a
h
7/23/2019 Practical Zan2 Intr Geostat 2013
4/6
, .
, , 2. ,
.
.
2 :
1) Word.
;
2) Excel.
, Excel ,
. , ,
-.
1.
B,
0 1. B ,
.
, . , : z(x) 4 9.
. , . , .
,
. :
. 1 2 .
, ().
7/23/2019 Practical Zan2 Intr Geostat 2013
5/6
.
semivariograms_100.xls.
, 2.
, . ( )
.
. .
, 8.
. . (
) . .
:
7/23/2019 Practical Zan2 Intr Geostat 2013
6/6
2. ,
. (
) :
1-
2-
.
.
