View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Calculating a generalized inverse matrix

You are in luck. If the matrix is singular, it has no inverse because its
determinant is zero.
--
Gary''s Student - gsnu2007a


"Ying-Foon Chow" wrote:

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.