View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chef Scottie Chef Scottie is offline
external usenet poster
 
Posts: 1
Default 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?!