none
Linest function: retrieving Standard error of the slope in vba RRS feed

  • Question

  • Hello,

    I found documentation how to use the linest function in excel ( http://web.centre.edu/james.kelly/p210l_fa10/LINEST.pdf ). Linest is an array-function, so it returns multiple calculations, of which the Standard error of the slope.

    When using Application.WorksheetFunction.LinEst(), I only get the slope. Is there a way to tell VBA to return the Standard error of the slope directly in my varaible (not on a worksheet)?

    Thanks for the advice.

    Tuesday, September 9, 2014 9:59 AM

Answers

  • Found it. I think I'll manage.

    For those who're intrested:

     Dim MyArray() As Variant
        
        MyArray = Application.WorksheetFunction.LinEst(ThisWorkbook.Worksheets("bei-ep").Range("test"), , , True)

    MyArray(2,1) will return the SE of a slope

    Tuesday, September 9, 2014 12:13 PM

All replies

  • Found it. I think I'll manage.

    For those who're intrested:

     Dim MyArray() As Variant
        
        MyArray = Application.WorksheetFunction.LinEst(ThisWorkbook.Worksheets("bei-ep").Range("test"), , , True)

    MyArray(2,1) will return the SE of a slope

    Tuesday, September 9, 2014 12:13 PM
  • Hi Wouter,

    Thanks for your sharing.

    It would be helpful for other community members.

    Regards,

    George.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, September 10, 2014 3:34 AM
    Moderator