7 .
: .
:
.
, ;
( );
.
.
.
;
.
,
, , j- i- .
;
;
, ;
;
,
rij , a ri0 y;
() .
H0:b i = 0.
H1: bI ¹ 0.
t- :
,
.
, , x i . , .
F- ( ) .
H0 :R2 = 0.
H1:R2 ¹ 0.
,
.
, , . , .
MathCad
, , . ( 1). .
MathCad , , , . . , .
, , , . (. 12).
12
, . , . , , , .
|
|
1, (y) (x 1), (x 2, x 3) (x 4). 12.
12
x 1(.) | x 2 (.) | x 3 (.) | x 4 (. .) | y (. .) | |
15,09. | 24,30. | 12,85. | 5,09 | 125,1779 | |
15,21. | 26,65. | 12,26. | 5,03 | 123,8094 | |
15,28. | 25,22. | 13,42. | 4,80 | 121,175 | |
15,49. | 26,59. | 12,05. | 4,95 | 116,9143 | |
15,54. | 26,88. | 12,70. | 4,88 | 119,8643 | |
15,62. | 24,74. | 12,41. | 4,96 | 118,0681 | |
15,70. | 24,42. | 13,83. | 5,10 | 123,5887 | |
15,91. | 25,79. | 13,10. | 4,90 | 117,0877 | |
15,92. | 24,14. | 13,07. | 4,72 | 116,1699 | |
15,95. | 26,70. | 12,40. | 4,81 | 118,3436 | |
16,31. | 24,66. | 12,82. | 4,95 | 116,2008 | |
16,33. | 24,04. | 12,48. | 4,88 | 111,4565 | |
16,60. | 25,15. | 13,20. | 5,02 | 115,1026 | |
16,69. | 24,10. | 12,40. | 4,80 | 110,1056 | |
16,76. | 24,49. | 12,01. | 4,85 | 110,0231 |
, X , , , - Y , MathCad :
: y = 113,938 6,095 x 1 + 0,534 x 2 + 2,588 x 3 + 10,995 x 4.
(y = 240,14 7,7145x), :
1. . 7,714 . ., 6,095 . . ( , 8.)
2. . 239,96, 113,93. , , . , .
3. . , , 0,534, 2,588. , .
4. . 10,995 . .
|
|
, , , . MathCad , , , . . MathCad Excel. , .
Excel
Excel , : (), , (), , (), . , , . , , , . Excel.
, , X Y.
10 Excel, Y G1:G16, X B1:F16 , 13.
13
R- | 0,928412953 | ||||||
R- | 0,899778134 | ||||||
1,496311516 | |||||||
df | SS | MS | F | F | |||
290,3694 | 72,59234 | 32,42252 | 1,06E05 | ||||
22,38948 | 2,238948 | ||||||
312,7588 | |||||||
- | t- | P- | 95 % | 95 % | |||
Y- | 113,1921888 | 36,06499 | 3,138562 | 0,010536 | 32,83438 | 193,55 | |
x1(.) | 6,080773549 | 0,900492 | 6,75273 | 5,03E05 | 8,08719 | 4,07435 | |
x2 (.) | 0,55174938 | 0,452263 | 1,219975 | 0,250464 | 0,45596 | 1,559454 | |
x3 (.) | 2,620192945 | 0,85151 | 3,077112 | 0,011698 | 0,722909 | 4,517476 | |
x4 (. .) | 10,92686031 | 3,846179 | 2,840965 | 0,017519 | 2,357038 | 19,49668 | |
, , . , R-, . .
, , MathCad, , , .
:
1. , F 1,06E-05, , 0,01. , F-, , , F. 4, 10.
|
|
2. b 1 , 5,03E-0 , , x 1, .
3. b 3, b 4, , 0,01169 0,01752, 0,01, , 0,0 , .
4. b 2 , 0,25, , x 2 .
, , . Excel , x 3, .
1.14
R | 0,9579 | ||||
R- | 0,9177 | ||||
R- | 0,8953 | ||||
1,5291 | |||||
df | SS | MS | F | F | |
287,037 | 95,67901 | 40,91741 | 2,94E06 | ||
25,72179 | 2,338345 | ||||
312,7588 | |||||
- | t- | P- | 95 % | 95 % | ||
Y- | 142,2167 | 27,6999 | 5,134194 | 0,000326 | 81,24956 | 203,1838 |
x1(.) | 6,61474 | 0,804244 | 8,2248 | 5,01E06 | 8,38487 | 4,84461 |
x3 (.) | 2,240018 | 0,809838 | 2,766008 | 0,018358 | 0,457576 | 4,02246 |
x4 (. .) | 10,56105 | 3,918663 | 2,695063 | 0,02084 | 1,936122 | 19,18597 |
, () , , , x 2, , . , :
y = 142,21 6,61 x 1 + 2,24 x 3 + 10,56 x 4.
, .
, (, , . .). ( 6).