Hi. I've tried writing code for "PseudoInverse" in the past, but had no
luck. Have you made any progress?
If you have a particular problem, feel free to send me your workbook. I can
run "PseudoInverse" via a math program for you. Its based on
"SingularValueDecomposition."
I did find this code once, but didn't do much with it. (beginning on line
#38)
http://www.koders.com/cpp/fidB528B6A...936C05A4A.aspx
--
Dana DeLouis
"Ying-Foon Chow" wrote in message
oups.com...
I'd appreciate if someone can tell me if I could find a (generalized)
inverse matrix of a singular matrix using Excel. Specifically, I have
a square matrix, say 10 by 10, but I know the rank of the matrix is 8.
Still, I need to find its inverse and I think that can be done in
other programming languages, but I am not sure how to do that in Excel
(or if that can be done at all). Thanks in advance.
Regards,
Y. F.