"", , .
, .. "" "", .. "". , , , .
(. 4). : R , A , E . R A. . R A, A R. . ( ) R, .
. 4.
S, . Sijkm , i- j- , k- m- . Sijkm , , .
E. . 4 , . G. Gijkm , , . . .
S G, .
Excel
2
. .
.
MS Excel.
11
: (), . . , .
|
|
. Excel : . . . "".
R | 0,999969671 | |||
R- | 0,999939343 | |||
R- | 0,999931761 | |||
0,495429413 | ||||
df | SS | MS | F | |
32370,43169 | 32370,43169 | 131881,8159 | ||
1,963602424 | 0,245450303 | |||
32372,39529 | ||||
t- | P- | |||
Y- | -89,09666667 | 0,33844272 | -263,2547885 | 4,85319E-17 |
X 1 | 1,980830303 | 0,005454498 | 363,1553606 | 3,70155E-18 |
F | |||
3,70155E-18 | |||
95% | 95% | 95,0% | 95,0% |
-89,87711698 | -88,31621636 | -89,87711698 | -88,31621636 |
1,968252207 | 1,993408399 | 1,968252207 | 1,993408399 |
y=1,98x-89,10 . 1, . ta=0,34<F=131882 t=0,005<F=131882, , , 95%.
12
Excel , , , , .
S , , S , . . Excel , ..
, , .