using linest excel function from msaccess with multidimensional ar
 

Hi

I am trying to call the excel function linest from VB from an MS Access
application .

the call
Slope1 =
Excel.WorksheetFunction.Index(Excel.WorksheetFunct ion.LinEst(y, x),1)

works fine as long as x is a one dimensional array.

But I need to do regression analysis for a multidimensional array (e.g.
I have x1,x2,x3,...,xn independent variables in the regression.)

so when I define x as say
dim x (10,2) as double

I get an error messages
"unable to get the linest property of the worksheet function class"

anyone know how to use linest for a multidimensioanl array ?

Thanks

using linest excel function from msaccess with multidimensional ar
 

You do not specify how you declared Y. It too must be a 2D array even
if it has just 1 column. So, declare it as Y(10,1). I just verified
that that works.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
Hi

I am trying to call the excel function linest from VB from an MS Access
application .

the call
Slope1 =
Excel.WorksheetFunction.Index(Excel.WorksheetFunct ion.LinEst(y, x),1)

works fine as long as x is a one dimensional array.

But I need to do regression analysis for a multidimensional array (e.g.
I have x1,x2,x3,...,xn independent variables in the regression.)

so when I define x as say
dim x (10,2) as double

I get an error messages
"unable to get the linest property of the worksheet function class"

anyone know how to use linest for a multidimensioanl array ?

Thanks