Having trouble using LINEST in Excel 2007 VBA
I'm trying to run regressions in VBA using the code
ols = Application.WorksheetFunction.LinEst(Y, x, True, True)
As I understand it the second TRUE generates the stats for the regression,
but I only get the coefficients. (It shows NA for the stats).
Help?!
|