Difference between revisions of "Manuals/calci/LUDECOMPOSITION"
Jump to navigation
Jump to search
Line 78: | Line 78: | ||
|- | |- | ||
! 3 | ! 3 | ||
− | | 7 || 8 | 9 | + | | 7 || 8 || 9 |
|} | |} | ||
=LUDECOMPOSITION(A1:C3) | =LUDECOMPOSITION(A1:C3) |
Revision as of 07:37, 4 September 2017
LUDECOMPOSITION (Matrix)
- is the set of values.
Description
- This function gives the value of LU Decomposition of a given matrix.
- In , is any square matrix.
- LU Decomposition is the procedure for decomposing any square matrix in to a product of Lower Triangular matrix and Upper Triangular matrix.
- In LU Decomposition, L stands for Lower Triangular matrix and U stands for Upper Triangular matrix.
- So A=LU.But sometimes the product includes Permutation Matrix also.
- LU Decomposition is also called LU Factorization.Here given matrix is split in to lower triangular and Upper triangular matrix.
- For 2x2 matrix,
- For 3x3 matrix,
Examples
A | B | |
---|---|---|
1 | 4 | 3 |
2 | 6 | 3 |
=LUDECOMPOSITION(A1:B2)
1 0 |
0.6666666666666666 1 |
6 3 |
0 1 |
0 1 |
1 0 |
A | B | C | |
---|---|---|---|
1 | 1 | 2 | 3 |
2 | 4 | 5 | 6 |
3 | 7 | 8 | 9 |
=LUDECOMPOSITION(A1:C3)
1 0 0 |
-0.4 1 0 | 0.5 0 1 |
20 24 28 |
0 5.600000000000001 26.200000000000003 |
0 0 2 |
0 0 1 |
0 1 0 |
1 0 0 |