Linest functions

[linoyel]

Hi, does anybody know how to retrieve an "a" value in formula y=bx+a from LINEST functions?

[linoyel]

Thank you for the clarification, Stefan! You've helped me a lot!

[swuehl]

You can see it also when you change the x-values:

LOAD * INLINE [

Name, ValueID

1, 2

6, 6

7, 8

];

--> automatic equation doesn't change! Only y-values have an impact on equation values

I assume Qlik is just using the dimensional values autonumber'ed 0...n and use this as x-axis values.

Advantage: you can calculate an regression line also on textual x-values

Disadvantage: it's not a correct regression calculation, IMO

edit: Forgot to say: the automatic equation is correct if you change axis to continouus axis on axis tab.

[linoyel]

Thanks again, Stefan. Now i understand better this issue
Great edit at least the equation is right now!

[yuankai0102]

Hi, i understand that linest function works well for univariate linear regression. what about mutlivariate regression?