mxqrdh
Syntax:
Return
Range
mxqrdh
(
Range
matrix1)
Description:
Computes the Householder vectors of matrix QR decomposition of
matrix1
and places it at the current cell.
Examples:
($a4) = mxqrdh($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
1.26726124191242
0
0
5
0.534522483824849
1.14995361172815
0
6
0.801783725737273
0.9886930334182
2
($a2) = mxqrdh($a1:$d4)