X1 1756 746 1501 1831 1622 1886 740 1593 1169 2125 1554 1474 1913 1218 1006 2215 137 167 343 2557 2276 1494 2144 1995 1053 1526 1120 1838 1746 1616 X2 X3 13 9 10 10 14 17 6 10 6 18 12 12 6 10 12 20 7 5 7 20 15 11 17 10 8 8 8 7 11 10 X4 4 2 1 4 6 3 3 8 4 6 6 7 5 3 4 3 2 4 2 7 4 2 3 7 4 4 6 5 2 4 X5 0 1 0 0 0 0 0 1 0 0 1 1 0 1 0 1 0 0 0 1 1 0 0 0 1 0 1 1 0 1 X6 1 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 1 0 1 2 1 1 3 4 1 3 1 4 2 3 1 1 1 1 4 3 4 1 4 3 1 3 2 3 2 3 3 2 2 X1 1958 634 580 1320 1675 789 1735 1784 1326 2051 1044 1885 1790 765 1645 32 1266 890 2204 2409 1338 2076 1708 2138 2375 1455 1487 1125 1989 2156 X2 X3 6 2 4 4 6 8 12 11 16 14 7 10 11 4 6 2 11 7 14 16 14 12 13 18 12 9 8 6 12 14 X4 2 7 1 5 7 4 7 5 8 4 5 6 4 3 9 0 7 1 5 8 4 5 3 5 4 5 4 4 3 5 X5 1 1 0 1 1 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 1 1 1 0 0 1 1 1 0 1 X6 0 0 0 0 0 0 1 0 0 0 0 1 1 0 1 0 0 1 0 0 0 0 0 1 0 1 0 0 1 0 2 4 1 1 2 4 3 1 3 4 1 2 3 4 4 3 4 1 2 2 2 2 1 4 2 3 4 2 2 2 x2 5 Number of ATM tra x3 5 Number of other b x4 5 Has a debit card (1 x5 5 Receives interest on x6 5 City where banking 60 Accounts transactions in the month r bank services used (1 5 yes, 0 5 no) t on the account (1 5 yes, 0 5 no) ing is done Balance 1756 748 1501 1831 1622 1886 740 1593 1169 2125 1554 1474 1913 1218 1006 2215 137 167 343 2557 2276 1494 2144 1995 1053 1526 1120 1838 1746 1616 1958 634 580 1320 1675 789 1735 1784 1326 2051 1044 1885 1790 765 1645 32 1266 890 2204 2409 1338 2076 1708 2138 2375 1455 1487 1125 1989 2156 ATM Services 13 9 10 10 14 17 6 10 6 18 12 12 6 10 12 20 7 5 7 20 15 11 17 10 8 8 8 7 11 10 6 2 4 4 6 8 12 11 16 14 7 10 11 4 6 2 11 7 14 16 14 12 13 18 12 9 8 6 12 14 Debit 4 2 1 4 6 3 3 8 4 6 6 7 5 3 4 3 2 4 2 7 4 2 3 7 4 4 6 5 2 4 2 7 1 5 7 4 7 5 8 4 5 6 4 3 9 0 7 1 5 8 4 5 3 5 4 5 4 4 3 5 Interest 0 1 0 0 0 0 0 1 0 0 1 1 0 1 0 1 0 0 0 1 1 0 0 0 1 0 1 1 0 1 1 1 0 1 1 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 1 1 1 0 0 1 1 1 0 1 City 1 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 1 0 1 0 0 0 0 0 0 1 0 0 0 0 1 1 0 1 0 0 1 0 0 0 0 0 1 0 1 0 0 1 0 Question - 1 2 1 1 3 4 1 3 1 4 2 3 1 1 1 1 4 3 4 1 4 3 1 3 2 3 2 3 3 2 2 2 4 1 1 2 4 3 1 3 4 1 2 3 4 4 3 4 1 2 2 2 2 1 4 2 3 4 2 2 2 Balance 3000 2500 2000 Mean Standard deviation Balance 1499.87 596.90 By looking into the histogram of the Balance variable, It seems that this variable may be follow a normal distribution. Generally normal distribution is symmetrical in nature but the histrogram of the balance have few drops between in 15-20 and 45-48 observations 1500 1000 500 0 Question - 2 Group 1 Group 2 Group 3 1 8 6 2 2 1 6 10 3 5 5 4 4 6 3 4 In the above table, we can see that Branch 3 and 4 have almost consistent accounts in each groups but the branc 1 and 2 are quite differ. So we can say that branch 3 and 4 accounts could be realted to them Balance 32 137 167 343 580 634 740 748 765 789 890 1006 1044 1053 1120 1125 1169 1218 1266 1320 ATM Services 2 7 5 7 4 2 6 9 4 8 7 12 7 8 8 6 6 10 11 4 Debit 0 2 4 2 1 7 3 2 3 4 1 4 5 4 6 4 4 3 7 5 Interest 0 0 0 0 0 1 0 1 0 0 0 0 1 1 1 1 0 1 0 1 City 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 3 3 4 1 1 4 3 1 4 4 1 1 1 3 3 2 4 1 4 1 Balance 1326 1338 1455 1474 1487 1494 1501 1526 1554 1593 1616 1622 1645 1675 1708 1735 1746 1756 1784 1790 ATM Services 16 14 9 12 8 11 10 8 12 10 10 14 6 6 13 12 11 13 11 11 Debit 8 4 5 7 4 2 1 4 6 8 4 6 9 7 3 7 2 4 5 4 Interest 0 1 1 1 1 0 0 0 1 1 1 0 0 1 1 0 0 0 0 0 City 0 0 1 0 0 1 0 1 0 0 1 1 1 0 0 1 0 1 0 1 3 2 3 1 4 1 1 2 3 1 2 4 4 2 1 3 2 2 1 3 Balance 1831 1838 1885 1886 1913 1958 1989 1995 2051 2076 2125 2138 2144 2156 2204 2215 2276 2375 2409 2557 ATM Services 10 7 10 17 6 6 12 10 14 12 18 18 17 14 14 20 15 12 16 20 Debit 4 5 6 3 5 2 3 7 4 5 6 5 3 5 5 3 4 4 8 7 Interest 0 1 1 0 0 1 0 0 1 1 0 0 0 1 0 1 1 0 0 1 City 1 1 1 1 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 3 3 2 1 1 2 2 2 4 2 2 4 3 2 2 4 3 2 2 4