Difference between revisions of "Manuals/calci/LUDECOMPOSITION"
Jump to navigation
Jump to search
Line 65: | Line 65: | ||
1 0 | 1 0 | ||
|} | |} | ||
− | 2 | + | |
+ | {| class="wikitable" | ||
+ | |+Spreadsheet | ||
+ | |- | ||
+ | ! !! A !! B !! C | ||
+ | |- | ||
+ | ! 1 | ||
+ | | 1 || 2 || 3 | ||
+ | |- | ||
+ | ! 2 | ||
+ | | 4 || 5 || 6 | ||
+ | |- | ||
+ | ! 3 | ||
+ | | 7 || 8 | 9 | ||
+ | |} | ||
+ | =LUDECOMPOSITION(A1:C3) | ||
{| border="1" cellpadding="5" cellspacing="0" | {| border="1" cellpadding="5" cellspacing="0" | ||
|- | |- |
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 | 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 |