5
MS Excel
: Excel , . . .
1.
A 3 x 4, B 4 x 2. , ( Open Office Calc: MMULT).
. 1.1
1. ,
.
2. ,
.
3. .
4. , , -
Ctrl+Shift+Enter.
, -
.
2.
A 3 x 3. A -1,
, ( Open Office Calc: MINVERSE).
1. , .
2. , .
3. Ctrl+Shift+Enter,
, .
4. :
.
3.
A 3 x 3. AT, , ( Open Office Calc: TRANSPOSE).
1. , .
2. , .
3. Ctrl+Shift+Enter,
, -
.
4.
A 3 x 3. A, ( Open Office Calc: MDETERM).
1. , .
2. , , .
5.
F 3 x 4, K 4 x 3. :
(F× K) T = KT× FT
1. F× K.
2. (F×K) T F× K.
3. KT K.
4. FT F.
5. KT× FT.
6. :
. , ;
; ;
; ;
|
|
Ctrl+Shift+Enter.
. 1.5