. , ( .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
