R*R - Excel like regression with SSAS?

Thu, 13 Dec 2007 14:29:45 Z

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

Thu, 13 Dec 2007 19:17:45 Z

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

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

Fri, 26 Jun 2009 20:48:33 Z

Hello, Bjorn D. Jensen,

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