. , ( .1).
1
| |||||
D | |||||
1 | 7 | 2 | 2 | 6 | 80 |
2 | 5 | 8 | 4 | 3 | 480 |
3 | 2 | 4 | 1 | 8 | 130 |
(..) | 3 | 4 | 3 | 1 |
, .
1. - .
1, 2, 3, 4 .
(, ) - ,
f(x) = 31 +42 +33 +4
71 +22 +23 +64 80
51 +82 +43 +34 480
21 +42 +3 +84 130
1, 2, 3, 4 0
1. (.1).
, ( ).
=(1, 2, , 4) :, F4.
.
.
1.
F4.
.
1 2.
.
.2.
.
1 [1] $3:E$3.
2 4:E4.
. : F4 , 2.
4. :
F4.
.
F7.
.
F8.
.
F9.
.
.
.
6) ( ).
¨ .
¨ $F$4.
¨ : .
:
¨ .
¨ $3:E$3.
.
. (. 3.).
.3. .
$F$7.
£..
.
$H$7.
. . .
.
|
|
(.4).
.4. .
8) ( 5).
.
, -.
.
( ).
( 6. ).
. 5.
.6.
, 150 . . 30 10 . , 480 ( ) 280 .
Excel . :
(Answer). ,
(Sensitivity). , .
(Limits). , .
1. .
| ||||
() | ||||
$F$4 | . | 0 | 150 | |
| ||||
$B$3 | 1 | 0 | 0 | |
$C$3 | 2 | 0 | 30 | |
$D$3 | 3 | 0 | 10 | |
$E$3 | 4 | 0 | 0 | |
$F$7 | 80 | $F$7<=$H$7 | ||
$F$8 | 280 | $F$8<=$H$8 | ||
$F$9 | 130 | $F$9<=$H$9 |
1, 2, 3, 4, 0,10, 30,0; 150, .
4