View Single Post
  #5   Report Post  
Mike Middleton
 
Posts: n/a
Default

MrShorty -

How many rows/columns will the built in matrix functions (mmult, minverse,
etc.) handle? Least squares regression "reduces" to some fairly simple
matrix algebra which can be performed using the built in matrix functions.
Most of the LSQ regression I do, I prefer to use the matrix notation
rather than LINEST or LOGEST, but I've never had to regress on more than 5
or 6 parameters. I haven't heard of any limit to the size of matrix these
equations can handle, so, in theory anyway, you should be able to perform
the regression this way. <


Some of the limitations, e.g., maximum 52 columns by 52 rows for MINVERSE,
are described at the end of the following Knowledge Base article:

http://support.microsoft.com/default...b;en-us;166342

- Mike
www.mikemiddleton.com