12
: Microsoft Excel. ()
:
() .. 1
. 1
. 1
. 2
.. 2
. 3
. 3
. 3
1. . 3
.. 5
()
Excel, . . :
þ , ;
þ ;
þ Ctrl+Shift+Enter!!!
. , , , . . , , , Ctrl+/. . , .
:
þ ,
þ ,
þ ,
þ ,
þ .
() , () Excel : ( , ), , .
, 3 ´ 3.
(9 ) A1:C3, E1:G3. A5:C7. , , =A1:C3+E1:G3, Ctrl+Shift+Enter. A5:C7 , {=A1:C3+E1:G3}.
2. A5:C7, , Ctrl+/, =A1:C3*2 Ctrl+Shift+Enter. A5:C7 , {=A1:C3*2}.
Excel :
|
|
() | |
() | |
(1;2) | |
() |
( ), (Enter). , (Ctrl+Shift+Enter).
C :
n () n . aij (i = 1, 2,, n; j = 1, 2,, n) ( ), bi (i = 1, 2,, n) . . xi (i = 1, 2,, n), .
AX=B, A ( ):
X - , B - , n . , , . , , , .
( ).
det A = |A| ( ), det Ai = | Ai | (i = 1, 2, , n) Ai ( ), A i - B. ( ), det A =0.
. AX=B -1. A -1 ´A´X = A -1 ´B. .. A -1 ´A = E, E ( , ). X = A -1 ´B .. A A -1 - B .
Excel (1;2) ().