topic Re: How to forecast with multiple linear regression? in QlikView

How to forecast with multiple linear regression?

Sat, 21 Jan 2012 00:34:19 GMT

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

Re: How to forecast with multiple linear regression?

gussfish — Sun, 22 Jan 2012 22:30:57 GMT

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.

Re: How to forecast with multiple linear regression?

Sun, 29 Jan 2012 03:21:32 GMT

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

Re: How to forecast with multiple linear regression?

gussfish — Sun, 29 Jan 2012 21:41:22 GMT

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.