Calculating churn

It will be extremely useful to have a measure that calculates churn before deep-diving into the analysis. There is a column called Churn Label that indicates "Yes" or "No", but this column isn't the easiest to work with.

You'll convert this column to a binomial column indicating if the customer churned or not. You need to use that to calculate the churn rate.

If you've lost progress, open up 1_2_calculating_churn.xlsx from the Workbooks folder.