Difference between revisions of "Manuals/calci/LUDECOMPOSITION"

From ZCubes Wiki
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

Spreadsheet
A B
1 4 3
2 6 3

=LUDECOMPOSITION(A1:B2)

1  0
0.6666666666666666	1
6  3
0 1
0 1
1 0
Spreadsheet
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

See Also

References