R*R - Excel like regression with SSAS?

Question

Hi!

I try to make linear regression in multiple dimensions

with SSAS (y = a + a1*x1+ ... a2*xn)

 

I got the equation, but I also want to see R squared and R adjusted in same manner as in Excel.

How to achieve that?

Greetings

 

 

Answer 1

You can use a stored procedure. An example (including the code for the stored procedure) is available here:

http://www.sqlserverdatamining.com/ssdm/Default.aspx?tabid=102&Id=8

 

On the same site, you can find other analysis stored procedures, e.g. for covariance/correlation matrix

Answer 2

Hello, Bjorn D. Jensen,

Please could you send-me an example of your equation? Thanks

my email: [e-mail]