using linest excel function from msaccess with multidimensional ar

[Guest]

Hi

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

the call
Slope1 =
Excel.WorksheetFunction.Index(Excel.WorksheetFunction.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

 

[Tushar Mehta]

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