Thread
:
LinEst embedded in VBA Function
View Single Post
#
2
Posted to microsoft.public.excel.programming
Tushar Mehta
external usenet poster
Posts: 1,071
LinEst embedded in VBA Function
See
http://www.google.com/groups?selm=MP...06d3ff898ad47%
40msnews.microsoft.com
or
http://www.google.com/groups?selm=MP...3f4cef498acb6%
40msnews.microsoft.com
Basically, the x values have to be a single 2D array.
--
Regards,
Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
I am performing an iterative regression and am wrapping
the worksheet function LinEst in my own VBA function. I
want to pass LinEst a single column array of doubles for
the Yvalues and a two column Array of doubles for the
Xvalues. It works fine for a single column of Xvalues but
returns VALUE error when passed the two column array.
What are my work arounds? I would pass it range arguments
but I need to perform arithmatic on the Xvalues before the
regression.
Reply With Quote
Tushar Mehta
View Public Profile
Find all posts by Tushar Mehta