JJ,,

As far as I know there is no function beyond CORREL that will allow you to
regress more than two arrays. However, it can be done with VBA.

I have a template the currently regresses up to 8 columns of data. It could
be modified to include ten. If you would like it, please go to my site's
"Contact" page and send me an email. I'll send the template to you.

----------------------------
Regards,
John Mansfield
http://www.pdbook.com


"juanes" wrote:

I wuold like to returns the correlation coefficient using ten different
arrays but the "CORREL" statistical funcion just let me use 2 at the time.
Some body know how to run a correlation funcion over 10 different colums at
the time ?

I really appreciate your help ,

Thank You very much.

JJ