Just use the CORREL() function.

CORREL(array1,array2)

Just grab the necessary arrays to accomplish your goal and you are solid!

"todd012976459210" wrote:

HELP!

I need to do a correlation analysis of mutiple variables against an
observable daily event. Can someone profiicient in Excel and statistics guide
me? Specifically, I have 10 variables whose correlation I want to measure
against a daily observation, both individually and collectively. I also want
to mearsure the correlation for all available samples, but also for just the
most recent 20.

Please, can anyone help me accomplish this?