I wish I had taken a stats class, but I didn't so I'm hoping someone out there can help me out.
We sell a product with a recurring monthly fee. I'd like to be able to figure out how long the average customer keeps their account open before cancelling.
The problem is that at any point in time, most customer accounts are still open and I don't know when in the future they will quit. So I don't know how to write the query if I use existing and cancelled customers. On the flip side, if I only queried customers who already closed their accounts, it seems like my stats would be skewed in a bad direction since it wouldn't take into account any customers who have had their accounts open for a long time (and are still open).
Any easy solutions or formulas for this? If not I can just work off of cancelled accounts.