Difference between revisions of "Manuals/calci/LUDECOMPOSITION"

From ZCubes Wiki
Jump to navigation Jump to search
Line 65: Line 65:
 
  1 0
 
  1 0
 
|}
 
|}
2. LUDECOMPOSITION([[10,12,16],[-8,-4,15],[20,24,28]])
+
 
 +
{| 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 08: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 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