- . ..
(1,2 ):
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20 (OLAP)
21 Data mining
22
23.
24.
25
26 .
27 .
28
29
30 .
31 ()
32
33 , ,
34
35
36
37
38 .
39
40
41
42 .
44 .
45
46
(3- ):
1. ( , ) .
2. MS Excel y = 0,5tg(x) + 3 x[-2;2] 0,5. ,
3. MS Excel y = 0,5 cos(x + 2) x[-2;2] 0,5. ,
4. Excel 45, 3- .
5. Excel 45, 2- 4- .
6. Access 5 , 8 , , \, , , , . .
7. Access 4 , 5 , . , .
|
|
8. Excel 45, - .
9. 10 : 25, 38, 63, 45, 98, 86, 75, 91, Excel .
10. , (.):
25, 38, 63, 45, 98, 86, 75, 91, 36, 53 = 1200 . Excel, , 10%.
11. Excel :
Z=3*x1+6*x2+8*x3=max
2*x1+3*x2+7*x3<=100 0<=x1<=30
x1+8*x2+ 23*x3<=120 0>=x2<=50
14*x1+5*x2+22*x3<=135 0>=x3<=70
12. Excel :
Z=3*x1+6*x2+8*x3=min
2*x1+3*x2+7*x3<=100 0<=x1<=30
x1+8*x2+ 23*x3<=120 0>=x2<=50
14*x1+5*x2+22*x3<=135 0>=x3<=70
13. Access 5 , 8 , , \, , , , . .
14. MS Access , .
15. MS Access , .
16. MS Access - .
17. MS Access .
18. MS Access .
19. MS Access .
20. MS Access .
21. MS Access - .