0 Replies Latest reply: Jun 10, 2015 7:41 AM by Zsolt Feleki RSS

    Error LINEST_M with zero intercept?

      Given the following set of numbers


      load * inline


      returns QlikView  the following values for the slope of the linear regression


      linest_m(b,a) = 2          - Korrekt


      For the slope given the intercept 0 it rerturns:


      linest_m(b,a,0)  = 2.8   - which is inkorrekt.


      Is this an Error? I couldn't figure out what QlikView computes in this case.


      Also on non trivial examples (many data points, "well distributed") QlikView gives different results than Excel for the slope when the intercept is zero.


      Any help is welcome.