: , .
:
0 1.
;
;
.
, , .
, .
.
Excel
, . , . , , , . , , , . , . , , , . , . 0 1, . . .
. x y , , 17.
17
x 1(.) | y (. .) | ||
15,09. | 125,1779 | ||
15,21. | 123,8094 | ||
15,28. | 121,175 | ||
15,49. | 116,9143 | ||
15,54. | 119,8643 | ||
15,62. | 118,0681 | ||
15,70. | 123,5887 | ||
15,91. | 117,0877 | ||
15,92. | 116,1699 | ||
15,95. | 118,3436 | ||
16,31. | 116,2008 | ||
16,33. | 111,4565 | ||
16,60. | 115,1026 | ||
16,69. | 110,1056 | ||
16,76. | 110,0231 |
Excel . . , . . , . , , , .
|
|
, 18.
18
x 1 (.) | y (. .) | |||
=(B2="";1;0) | 15,09. | 125,1779 |
1, , 0 . , C, , , . , :
(B2 = "";0;1).
. , ( , - ) ( -), .
, , . , , Y E1:E16, X 1:D16, , 19.
19
R | 0,963696 | ||||||
R- | 0,928711 | ||||||
R- | 0,916830 | ||||||
1,363084 | |||||||
df | SS | MS | F | F | |||
290,4628387 | 145,231419 | 78,16547142 | 1,31E07 | ||||
22,29599593 | 1,85799966 | ||||||
312,7588347 | |||||||
- | t- | P- | 95 % | 95 % | |||
Y- | 232,0028 | 10,78827 | 21,5051052 | 5,9691E-11 | 208,49 | 255,508 | |
3,474500 | 0,7109700 | 4,8869856 | 0,00037407 | 1,9254 | 5,02357 | ||
x(.) | -7,30442 | 0,675558 | 10,8124125 | 1,5303E07 | 8,77634 | 5,83251 | |
: y = 232 + 3,47 D 7,304 x
D 1 0 , .
y = 232 7,304 x ,
y = 235,47 7,304 x .
, 3,47 . . . 0,928, , .
, x Dx. , x, .
|
|
, . , , : y = 233,52 + 0,21 Dx 7,403 x.
, :
y = 233,52 7,4 x ;
y = 233,52 7,19 x .
, . 0,929, , , . . 3,47 . . , , .
, , .
, , . , . , . , , , .
.
1. , . , , , D1, D2, D3.
2. . . , .
3. , 1, 0.
, . , . , 18.
18
D1 | D2 | D3 | x 1 (.) | y (..) | ||
=(B2= ;1;0) | =(B2= ;1;0) | =(B2= ;1;0) | 15,09. | 125,1779 |
, 1 . .
, X, D X, X 1:F16.
. , D 1, , , . , .