View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default Calculating a generalized inverse matrix

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.