mxqrdr
Syntax:
Return
Range
mxqrdr
(
Range
matrix1)
Description:
Computes the upper triangular factor of matrix QR decomposition of
matrix1
and places it at the current cell.
Examples:
($a4) = mxqrdr($a1:$c3)
Before:
A
B
C
D
1
1
4
7
2
2
5
8
3
3
6
20
4
5
6
After:
A
B
C
D
1
1
4
7
2
2
5
8
3
3
6
20
4
-3.74165738677394
-8.55235974119758
-22.1826830787312
5
0
1.96396101212393
-0.872871560943962
6
0
0
-4.49073119510249
($a2) = mxqrdr($a1:$d4)