View Single Post
  #4   Report Post  
Michael R Middleton
 
Posts: n/a
Default

JJ -

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 ? <


Use the Correlation tool of the Analysis ToolPak. It will provide
correlations for each pair of the ten variables.

- Mike
www.mikemiddleton.com