8.1. 1,, 10 - ( ), 10 . .
8.2. 1, 2,..., 7 - . , 0o.
8.3. , , . , , (, , 0 ).
8.4. n m . . .
8.5. 10 . ³: ( ), , (/) . .
8.6. n (1, 1), (2, 2),...,(xn, yn). , R .
8.7. (1, 2,..., 8). , b i c (b c ).
8.8. n . i - , 1 i- ; i - ( ) i- (i =1,2,..., n). .
8.9. ³ ( ) . .
8.10. bi (i =1,2,...,12) - 㳿 i- . , 㳿. , 㳿.
8.11. 100 n . , , , 0,02 .
8.12. 1- (200 ), 30 . , 25 . .
8.13. 10 . 20 1 . ( ), , , ( ).
8.14. R. n (1, 1), (2, 3),...,(n, yn), R. , .
8.15. 4 - = 0 i (i =1,2,...,6). , . : 1 (2,5;1), 2 (3;-2), 3 (1;-1), a4 (0;2), 5 (4;3), 6 (5;2).
|
|
8.16. "" "ͳ" , n .
8.17. . ϳ, .
8.18. =(i), i =1,2,..., n. .
8.19. =(i), i =1,2,..., n. , , .
8.20. =(i), i =1,2,..., n. , 7 1 2.
8.21. . .
8.22. ³ N . , .
8.23. N . , .
8.24. ϳ N . i- i . , bi - , , i- .
8.25. 2 , N . ' 1- 2- .
8.26. N . , .
8.27. 2 , N . 1- 2- .
8.28. ϳ N . ³ : i - i- , bi - i- . (= - ).
8.29. N , i - i- . , , , .
8.30. N . , 4, , 5.
. =(xi), i=1,2,...,12. - VBA , a<xi<b, ,b - .
: s - .
-
0
Public Sub pr3()
1 Dim x(1 to 12) As Single
a,b Dim s,a,b As Single, i As Integer
a=Val(InputBox(" "))
2 xi, b=Val(InputBox(" b"))
i=1,2...,12 for i=1 to 12
3 x(i)=Val(InputBox(" "))
s=0 next i
4 s=0
i=1,12 for i=1 to 12
5 if x(i)>a and x(i)<b then s=s+x(i)^2
a<xi<b next i
6 MsgBox "s= " & s
s=s+xi2 EndSub
7
s
7
9.1. n, 9, , , 2, 1 0 ( , : 2 - , 1 - , 0 - ). .
|
|
9.2. 7.1. , .
9.3. 7.1. , .
9.4. 7.1. , , .
9.5. 7.1. , .
9.6. m ´ n. .
9.7. m ´ n. .
9.8. ' m ´ n.
9.9. D m ´ n. .
9.10. 20 . ( 10 ) , ( 2, 5 10 ). , 10 , . , .
9.11. 7.10. .
9.12. 7.10. , 5 10 .
9.13. 7.10. , 10 .
9.14. 7.10. , 5 10 .
9.15. C m ´ n , .
9.16. m ´ n , .
9.17. m ´ n .
9.18. N ´ N , ji = ij.
9.19. m ´ n , .
9.20. F m ´ n .
9.21. V m ´ n , .
9.22. N . , .
9.23. 4´3. max min (, max min - ).
9.24. 4´3 .
9.25. , M ´ N.
9.26. 2´6. .
9.27. m ´ n .
9.28. ´ N .
9.29. 4´5. , .
9.30. ´ N. ' .
. - ' . =(aij), i=1,2,...,7; j=1,2,...,8. .
: b
|
|
-
0
Public Sub pr4()
1 Dim a(1 to7, 1 to 8) As Single
aij, Dim i,j As Integer, b As Single
i=1,2,...,7; for i=1 to 7
j=1,2,...,8 for j=1 to 8
2 a(i,j)=Val(InputBox(" "))
j=1,8 next j: next i
3 for j=1 to 8
b=a2j b=a(2,j)
4 for i=1 to 7
i=1,7 a(i,j)=a(i,j)/b
5 next i: next j
aij=aij/b for i=1 to 7
for j=1 to 8
Debug.Print a(i,j)
6 next j
aij Debug.Print
i=1,2,...,7; next i
j=1,2,...,8 EndSub
1. . .., .. - , , 2009.
2. : . .., .. - , , 2007.
3. . . 㳿. .., .., .. . - , , 2003.
4. 6.051701 . .. , .. , : , 2009.
1. .. . Visual Basic 6.0. : ² ², 2002.
2. .., .. . 3- . .: , 1999.
3. , , 㳿. .. . , "", 2001.
4. ij .. . . : "", 2002.
5. . Excel , . . . .: , 1999.
6. . MS Excel VBA . - .: - -, 1999.