Determine correlation for the shifted cycle?

E

Eric

There are two sets of daily data for business activities. I would like to
determine correlation for the shifted cycle? If two similar cycles are
shifted backward or forward within a period, the function of correlation
cannot be determined, due to delayed periods.
Does Excel have any tools to measure the correlation between two shifted
cycles? which may be shifted backward or forward.
Thanks in advance for any suggestions
Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Any tools on Excel to determine the delayed periods? 1
How to determine the optimized correlation between 2 sets of data? 1
How to determine the correlation between two lists of numbers? 4
Macro deletes row in range, macro then skips the row moved up 8
Outlook 2003 HTML signatures 2
Help to create biweekly dates excluding nonworking days 2
Cycle Times 4
How can count the number of cells that fulfill certain criteria in other cells 2

Top