Regression

[Guest]

I am running a regression using visual basic,

Application.Run "ATPVBAEN.XLA!Regress", Range(Range("poolTbl").Cells(i, 8)), _
Range(Range("poolTbl").Cells(i, 9)), False, False, ,
Worksheets("Result").Cells(myRow, 1), False, False, _
False, False, , False

Things were working fine. But at some point, I started receiving the error:

The macro '' cannot be found

Any idea why this is happening?
Thanks

 

[Guest]

Do you have the "Analysis ToolPak - VBA" add-in checked (worksheet Tools
menu) and the ATPVBAEN reference checked (VBA Tools menu).

More to the point, why are you using a canon to kill a fly? With only two
y-values and no x-values,
slope = Range("poolTbl").Cells(i, 9) - Range("poolTbl").Cells(i, 8)
intercept = 2* Range("poolTbl").Cells(i, 8) - Range("poolTbl").Cells(i, 1)
Rsq = 1
Ssreg = slope^2/2
and all other quantities returned by LINEST are zero, except for F which
involves division by zero.

Jerry

 

[Guest]

Yes, I do have the analysis tool pack checked.
I guess I will go with your suggestion.
Thanks!