Scatter chart/ correlation between 2 dates

Hi There,

Im trying to find if the is a positive correlation between 2 different dates, I tried datedif formulas but nothing seems be working. I like to know if a renewal date might cause client to cancel. So I have attach spread sheet with a renewal and cancel date. Is this possible, I tried making is continues date but dont seem to know how?

I think the difficult thing about your question is that it is more about statistics than about spreadsheets. One reason I didn't respond to your previous post was that I'm not enough of a statistician to know how best to test for this correlation.

The first step in a problem like this is to figure out exactly what you want to measure. In this case would days between cancellation and renewal seem like a reasonable statistic? This is easy in Excel, simply =A2-B2
Using that as our measure, you could then count how many cancel within different days from renewal using the FREQUENCY() function. That might show you some patterns.

Maybe that helps, maybe it doesn't. As I said, at this point in the problem statement, we have to decide how to best answer the question from a statistical standpoint before we can really answer how to put that solution into a spreadsheet.