Multiple Regression model Coefficients and Intercept

[kabiri]

Hi,

I am new to Qlik and trying to learn about it. I want to estimate the coefficients and intercept of a multiple regression model. 

I can use LinEst_M and LinEst_b for a single regression model, but I have problem to extend these formulas for the multiple regression model. 

Single Regression:  Y = A + B*X

Multiple Regression: Y = A + B1 * X1 + B2 * X2

I also tried to calculate them manually by using the covariance and variance formulas, still no luck. 

B1 = Covariance(X1Y)/Variance(X1)

B2 = Covariance(X2,Y)/Variance(X2)

Any help or comment will be appreciated.

Thanks,

Maryam