How to forecast with multiple linear regression?

[#1]

hi

Can qv make forecast with multiple linear regression?

I search the community and find out the solution   linear regression like y=ax+b. But the user want multiple linear regression. I am not a statistician. I have find out sevaral functions in qv help as below :

linest_f	linest_r2	sterr
linest_df	linest_sem	steyx
linest_m	linest_seb	linest_ssreg
linest_b	linest_sey	linest_ssresid

What I want to know is : Could I use these functions to caculate the multiple linear regression for forecast purpose?  And can I get some help and example here?

Thanks.

Zhou

[gussfish]

Hi Zhou,

The good news is yes, you can use QlikView to do multiple linear

regression.

The bad news is that it doesn't have built-in functions for doing it.

So, I'm afraid you're going to need to do some web searching to read-up

on how multiple linear regression is done and then figure-out the

appropriate expressions to implement the mathematics.

Angus.

[#3]

hi  Angus,

Thank you for your reply. Because I'm not a statistician. And I have no way of handling about these. Could you give me more help and detailed information on

multiple linear regression  in  qlikview .

Thanks again.

Zhou

[gussfish]

Hi Zhou,

I'd suggest you find a colleague or friend who has a good mathematical background to help you work through how multiple linear regression works and the equations involved.  You won't be able to develop the appropriate QlikView script (let alone debug it) until you firstly understand the mathematics.

Angus.