: .
:
( p)
-
.
Excel
, , . , , , . , (. 5), . (R^2, .
, 5, , , , 8:
8
: y = 7,7145x + 240,14 R2 = 0,786,
: y = 334,76e0,0659x R2 = 0,789,
: y = 122,94Ln(x) + 457,51 R2 = 0,787.
, , .
, , , , ( ).
, , , , , . ( 2), , , x = 17 109,014. , , 109,1948, 109,1927. x = 17.
, , . -, , , , -, , . .
, . , , . , , . , , , , .
|
|
, , . , . , , , , , , 1, . . . . , x , y , Y D1:D16. , , (. 10):
10
x (.) | y (. .) | ln(y) | |
15,09. | 125,1779 | 4,829736 | |
15,21. | 123,8094 | 4,818744 | |
15,28. | 121,175 | 4,797236 | |
15,49. | 116,9143 | 4,761441 | |
15,54. | 119,8643 | 4,78636 | |
15,62. | 118,0681 | 4,771261 | |
15,70. | 123,5887 | 4,816959 | |
15,91. | 117,0877 | 4,762923 | |
15,92. | 116,1699 | 4,755054 | |
15,95. | 118,3436 | 4,773592 | |
16,31. | 116,2008 | 4,75532 | |
16,33. | 111,4565 | 4,713635 | |
16,60. | 115,1026 | 4,745824 | |
16,69. | 110,1056 | 4,70144 | |
16,76. | 110,0231 | 4,700691 |
(. 11).
11
R | 0,888266 | ||||||||
R- | 0,789016 | ||||||||
R- | 0,772787 | ||||||||
0,019221 | |||||||||
Df | SS | MS | F | F | |||||
0,01796 | 0,01796 | 48,61611 | 9,73E06 | ||||||
0,004803 | 0,000369 | ||||||||
0,022763 | |||||||||
- | t- | P- | 95 % | 95 % | |||||
Y- | 5,813415 | 0,1503 | 38,67869 | 8,27E15 | 5,488711 | 6,138119 | |||
x (.) | 0,06591 | 0,009452 | 6,97253 | 9,73E06 | 0,08633 | 0,04549 | |||
.
|
|
. .
. , .