How to find coefficiences of Multiple regression model

[alessandravo]

Hi,

I want to find coefficiences in Multiple regression model with dependent variable Y and 4 independent variable X1, X2, X3, X4 by VBA.

I am a newbie to VBA, so any assistance would be appreciated.

Thank you

 

[shg]

How about just a formula?

=LINEST(E1:E100, A1:D100)