Solving m*n matrix

**kakoc** · 06-14-2010, 11:16 PM

Hy everyone,

I need to solve 200 x 8 matrix in excel. I was thinking about Gauss elimination method
however I have no Idea how to implement it.

I have never had any exposure to matrixes in excel, so I completely lost.

**shg** · 06-15-2010, 12:34 AM

Solve? What does that mean?

**kakoc** · 06-15-2010, 05:41 AM

To solve the the matrix is to solve the system of linear equation i.e. all unknown variables such is x,y,z etc

One of the ways to do that is trough Gaussian elimination
http://en.wikipedia.org/wiki/Gaussian_elimination

**jawad1_ali** · 06-15-2010, 06:21 AM

kakoc,

I haven't well undestood the alogorithem.

But I would suggest to try it in MATLAB. matrix related operations are much easy to handle there..

**shg** · 06-15-2010, 09:30 AM

To solve the the matrix is to solve the system of linear equation

You can only invert square, non-singular matrices. If your matrix represents 200 equations in 8 unknowns, the system is overdefined, and you need to premultiply both sides by the transpose to get a square system, which you can then solve to get a least-squares best fit.

Excel's MINVERSE function is limited to 52x52. I've heard that MoreFunc's MINVERSE.EXT will do up to 256x256.