Regression


G

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
 
Ad

Advertisements

G

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
 
Ad

Advertisements

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top