IMPORTING DATA

[READING AND PREPARING DATA]

Number of Rows and Columns

[1] 6347   13

Data Structure

'data.frame':   6347 obs. of  13 variables:
 $ ID                   : int  1 1112 2223 3334 4445 5556 6015 6126 6237 1002 ...
 $ Age                  : int  58 58 52 57 54 55 54 42 53 53 ...
 $ Churn                : Factor w/ 2 levels "No","Yes": 1 1 1 1 1 1 1 1 1 1 ...
 $ CHIDec               : int  1 223 1 149 202 45 92 21 240 240 ...
 $ CHIChange            : int  1 179 1 95 2 3 53 8 75 39 ...
 $ SupportCasesDec      : int  1 1 1 2 1 1 2 1 2 1 ...
 $ SupportCasesChange   : int  1 1 1 2 1 1 20 1 11 1 ...
 $ SupportPriorityDec   : int  1 1 1 11 1 1 11 1 11 1 ...
 $ SupportPriorityChange: int  1 1 1 1 1 1 42 1 1 1 ...
 $ LoginsChange         : int  1 1 1 152 1 228 120 1 84 72 ...
 $ BlogPostsChange      : int  1 1 1 23 1 1 2 1 25 1 ...
 $ ViewsChange          : int  1 145 1 887 1331 319 1334 1044 1 989 ...
 $ DaysSinceLoginChange : int  134 134 134 1 134 1 1 139 141 115 ...

Descriptive Statistics

                      vars    n    mean      sd median
ID                       1 6347 3174.00 1832.37   3174
Age                      2 6347   24.50   19.65     18
Churn*                   3 6347    1.05    0.22      1
CHIDec                   4 6347  103.14   92.67     73
CHIChange                5 6347   80.39   77.91     49
SupportCasesDec          6 6347    3.03    4.66      1
SupportCasesChange       7 6347    6.42    9.51      1
SupportPriorityDec       8 6347    3.60    4.36      1
SupportPriorityChange    9 6347    8.79   14.09      1
LoginsChange            10 6347  115.91   98.90     98
BlogPostsChange         11 6347    9.94   14.70      1
ViewsChange             12 6347  471.71  450.25    372
DaysSinceLoginChange    13 6347   52.80   58.47     11

Percentage of Customers Churn

Churn
  No  Yes 
94.9  5.1 

Percentage of Customers Churn by Age

             Churn
Age_cat           No    Yes    Sum
  <6 months    92.85   7.15 100.00
  6-14 months  94.46   5.54 100.00
  >14 months   95.87   4.13 100.00

Percentage of Churn by CHI Value

           Churn
CHIDec_cat      No    Yes    Sum
  (0,20]     93.99   6.01 100.00
  (20,40]    95.23   4.77 100.00
  (40,60]    95.85   4.15 100.00
  (60,80]    96.43   3.57 100.00
  (80,100]   97.61   2.39 100.00
  (100,120]  96.76   3.24 100.00
  (120,140]  98.84   1.16 100.00
  (140,160]  95.95   4.05 100.00
  (160,180]  92.22   7.78 100.00
  (180,200]  93.28   6.72 100.00
  (200,220]  94.54   5.46 100.00
  (220,240]  93.17   6.83 100.00
  (240,263]  94.65   5.35 100.00

Percentage of Churn by CHI Change

                  Churn
CHIChange_Category     No    Yes    Sum
         (0,20]     94.59   5.41 100.00
         (20,40]    93.51   6.49 100.00
         (40,60]    93.30   6.70 100.00
         (60,80]    92.65   7.35 100.00
         (80,100]   93.45   6.55 100.00
         (100,120]  97.60   2.40 100.00
         (120,140]  98.00   2.00 100.00
         (140,160]  94.09   5.91 100.00
         (160,180]  96.02   3.98 100.00
         (180,200]  95.34   4.66 100.00
         (200,220]  96.99   3.01 100.00
         (220,242]  99.57   0.43 100.00

Percentage of Churn by suppoprt Cases

               Churn
SupportCasesDec     No    Yes
             1   94.16   5.84
             2   96.54   3.46
             3   88.89  11.11
             4  100.00   0.00
             5  100.00   0.00
             6  100.00   0.00
             7  100.00   0.00
             8  100.00   0.00
             9  100.00   0.00
             10 100.00   0.00
             11  96.63   3.37
             12 100.00   0.00
             13 100.00   0.00
             14  96.48   3.52
             15 100.00   0.00
             16  96.99   3.01
             17  98.78   1.22
             18  97.73   2.27
             19  96.77   3.23
             20 100.00   0.00
             21 100.00   0.00

Average Age of Customers (Churned / Not Churned)

  Status AverageAge
1     No      24.68
2    Yes      21.20

Average CHI of Customers (Churned / Not Churned)

  Status AvereageCHI
1     No      102.92
2    Yes      107.16

Average No. of Support Cases (Churned / Not Churned)

  Status AverageAge Average No. of Cases
1     No     102.92                 3.08
2    Yes     107.16                 2.12