. . 1.1, Excel.
Excel. Excel, .
.
(__ ; __ ).
.
(__ ; __ ).
. ( )
(; __ ;__ ).
YX. (YX ):
YX(__ ; __ ).
. Excel, . 1.4. .
. 1.4. Excel
. , 1.1 1.3.
1.5
. g = 0.95, , 1.1.
. ( ) ( ) ( ) g
. (1.12)
, (1.13)
- . , (1.12) ( ) , Excel:
=().
. (1.12) . , , . 1.5.
.1.5.
, , ( 16:18) (1:2) .
= () = 2.31.
1.6
. 1.1 a = 0.05 , 1.1.
. a, :
(1.14)
F g; 1; n -2 g F - k 1 = 1 k 2 = n 2.
= F(). (1.15)
, (1.14) :
, . (1.16)
(1.14) F-.
|
|
. . 1.6 Excel, Qe, F. D . 1.1.
, , . (1.15) F 0.95; 1; 8 = 5.32. (1.14) , . . 24.04 > 5.32 a = 0.05.
. 1.6. F