Difference between revisions of "Manuals/calci/LUDECOMPOSITION"

From ZCubes Wiki
Jump to navigation Jump to search
Line 36: Line 36:
  
 
==Examples==
 
==Examples==
1. LUDECOMPOSITION([4,3;6,3])
+
{| class="wikitable"
 +
|+Spreadsheet
 +
|-
 +
! !! A !! B     
 +
|-
 +
! 1
 +
| 4 || 3
 +
|-
 +
!2
 +
|6 || 3
 +
|}
 +
=LUDECOMPOSITION(A1:B2)
 
{| border="1" cellpadding="5" cellspacing="0"
 
{| border="1" cellpadding="5" cellspacing="0"
 
|-
 
|-

Revision as of 08:18, 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

2. LUDECOMPOSITION([[10,12,16],[-8,-4,15],[20,24,28]])

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