Is there a function in Excel that automatically queries just the most recent
20 occurances or do I have to manually adjust the parameters each day? Thanks!
Todd

"Sean Timmons" wrote:

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?