() Microsoft Excel.
1. .
2. , , , Microsoft Excel.
3. ( ), , .
Microsoft Excel .
Excel .
, . F(x1,x2)= 3x1-2x2 : 2x1+2x2£10
-x1+3x2£5
2x1+x2³1
x1³0; x2³0
:
1. Microsoft Excel, .
2. , , (.1).
3. 1 0 , , 10 0,5. , (), .
X1. , A11. (A12) , . A13 =A12+0,5. A13 . A14-A32 . , , ( ), , Z+0,5, Z (.2).
4. , 2 1 2, 1. , .
. . : x2=(10-2x1)/2; x2 = (5+x1)/3;
x2 = 1 2x1; x2=3x1/2. , .. , x2 x1. , B12 =(10-2*A12)/2. B12 , B13-B32, . x2 x1 . , 3.
|
|
5. .
, , , . B11-E32. . . 1,2,3,, , 1. ջ , . Excel, , (.4.).
|
, , . , 1 ( A12-A32), . . , , , . - , 1, Y 2. . , .
(.5).
|
|
|
6. , (). , , , , , . , . , . , , , .
, , , . (0,0). , , (0,0), , (0,0).
|
|
, -.
7. , , .
: .
( ). , . .
-5, 5, 1, 0,5.
, . ( ) , ( ) . , , ( , , ).
(5,0), , . , (6,0). 1, 6. A24 (. .1), 24- . $B$32, $C$32, $D$32, $E$32 $B$24, $C$24, $D$24, $E$24. ջ $A$32 $A$24 (. . 6)
. 6.
. 7.
: , , , .
|
|
. 7.
8. , Excel .
|
|
. 8.
9. . .8 AB. (0,0) . {(0,0), (3,-2)}. , ( ), , , , (5,0) ( ), 15 ( ).
10. , , , 2- , .
Excel. , X2=3X1/2 X2=1-2X1. 3X1/2 = 1-2X1 , , , : 3X1/2 + 2X1 1=0. ( B50) : =3*A50/2 + 2*A50 1. 50 X1. , 0 0 50.
|
|
, , Excel . . , , . ʻ.
, ( $B$50), $A$50 . ($ ) , ʻ . Excel 50. 1 0,285714285714227. X2 B50, . , (0,285714285714227; 0,428571429)
11. , , .
12. :
- ;
- ;
- (. 3);
- , ;
- .