Create a Pivot table from Week $1$ worksheet: $$IBM$\_$New$\_$Churn$\_$Desktop $...$

For Columns: use Geography

For Rows use : Tenure and Gender $($drag these to move other to the top$)$

For values: Use average of Exited

Task; Descriptive Analysis

Examine the pivot table results and make a list of your observations

E$.$g$.($ but not limited to$).$ Explain your conclusions with examples

$1.$ How do the countries compare with regard to total churn?

$2.$ Is gender a factor in the churn rate? $($explain with examples?$)$

$3.$ What impact does tenure $($length of customer history$)$ have on the likelihood to churn?

$4.$ If you were to define a plan to minimize churn what actions might you take and why?

Week$2$Week$2$

Charts:IBM$\_$New$\_$ChurnCharts:IBM$\_$New$\_$Churn