3. ) .
2.
. 2 , , 2, . (, , .) Excel =b*rnx c , b m.
F8:G12, =(2:7;D2:D7;1;1), trl+Shift+Enter, :
1,56628015 | 1,196513 |
0,02038299 | 0,07938 |
0,99181334 | 0,085268 |
484,599687 | |
3,52335921 | 0,029083 |
, m=1,556, b=1,197, .. :
=1,197*(1,556) (13)
m, b 0,02, 0,07 0,08 . r2 =0,992, .. 99,2%.
. 2 (99,2%) m, b , (13).
=8 =1,197*34,363=41,131 .
) , :
(_;__;__;).
F14: F17,
=(2:7;D2:D7;G2:G5;), {27,6696434;43,3384133;67,8800967;106,319248}, .. =8 =43,34 . . ), .
. , , ( ), .. , (, , , . 2 . .) . . 2 2 . . .
.
4. , . :
;
1 ;
2 ;
3 ;
4 .
11 1500 :
D | |||||
1-, 2 | 2- | 3- | 4-, | , .. | |
1,5 | |||||
1,5 | |||||
- .
|
|
, (1,2,3,4) (), .. .
- 14:18 ( . 1),
- =(2:12;2:D12;;), -
- Ctrl+Shift+Enter,
- :
D | E | ||||
-234,237 | 2553,210 | 12529,7682 | 27,6413 | 52317,83 | |
13,2680 | 530,6691 | 400,066838 | 5,42937 | 12237,36 | |
0,99674 | 970,5784 | #/ | #/ | #/ | |
459,753 | #/ | #/ | #/ | ||
#/ | #/ | #/ |
=m1*x2+m2*x2+m3*x3+m4*x4+b 14:
=27,64*1+12,530*2+2553*3-234,24*4+52318 (14)
, 2500 . , , , 25 , :
=27,64*2500+12530*3+2553*2-234,24*25+52318=158261 ..
: