Re: Multiple regression in Oracle

Andreas Sheriff wrote:
> I know Oracle 10gR2 can do linear regression. It does it quite well. But
> has anyone ever accomplished multiple regression? I found some definitions
> for multiple regression on the web and it looks like greek. Serious! There
> were so many alpha's and betas that I thought I was watching some random
> version of Stargate SG1.
>
> Any help would be appreciated.
>
> Thanks,
>
> --
>
> Andreas Sheriff
> Oracle 9i Certified Professional
> Oracle 10g Certified Professional
> Oracle 9i Certified PL/SQL Developer
> ----
> "If you don't eat your meat, you cannot have any pudding.
> "How can you have any pudding, if you don't eat your meat?"
>
> DO NOT REPLY TO THIS EMAIL
> Reply only to the group.

I was browisng the Oracle Database Data Warehousing Guide available at :
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14223/analysis.htm#sthref1803

It has a section on Linear Algebra and gives a good example of multiple linear regression using the UTL_NLA package. I am not a math person either but found it fairly easy to understand. Received on Wed Dec 20 2006 - 12:29:27 CST