Cross Correlation

[Mik]

EXCEL 2002 patch SP2

I need function Cross correlation This macros is present
in Version 97 but missing in version Excel 2002.
I added all Macros but this function is missing.

Do you know this problem ?

 

[Rafael Ortiz]

There is a Correlation function in the Analysis Toolpak. Is that what you
are talking about? If so, just do Tools, Add-ins, and select Analysis
Toolpak.

MRO

 

[Jimmy L. Day]

The CORREL function returns the correlation coefficient between two data
sets. It is part of the ATP.