Statistics Set 1

STATISTICS FOR MANAGEMENT ASSIGNMENT SET - 1 Case 1 ABC Branch of XYZ Bank has decided to give 10 Lakh of loan each on long term basis to only two of their customers (accountholders), who are businessmen of the locality. About 20 businessmen had applied for loan in order to develop their business further. In order to reject some of the applications (as the fund was limited), the Bank decided that accountholder who had maintained a minimum balance of 50000 INR would only be considered for the loan. As a result, 10 applications were automatically rejected as they were not satisfying the requirement of minimum balance. Now, the 10 applications remained and it was found that monthly minimum balance in all the cases were more than 50000 INR for the last 12 months. Their account details of monthly minimum balance are given below. Mont

Monthly Minimum Balance in INR

hs A/C

A/C

A/C

A/C

A/C

A/C

A/C

Holder

Hold

Holder

Holde

Hold

Hold

Holde

Holde

Holde

Holder

Jan,

1 60000

er 2 5600

3 66000

r4 86000

er 5 5600

er 6 r7 59000 59000

r8 52000

r9 53000

10 56000

2008 Feb,

70000

0 7600

74000

96000

0 7600

96000 78000

73000

98000

76000

55000

0 1100

112000

19000

0 1100

12000 11500

11200

11300

120000

2008 Apr,

90000

00 8900

90000

0 98000

00 8900

0 0 97000 87000

0 93000

0 66000

89000

2008 May,

56000

0 8800

84000

84000

0 8800

98000 90000

89000

87000

86000

2008 Jun,

80000

0 5200

57000

57000

0 5200

57000 55000

54000

59000

72000

82000

0 5800

66000

0 5800

56000 86000

55000

98000

98000

79000

0 9500

93000

0 9500

98000 99000

96000

59000

95000

2008 Mar,

2008 Jul, 2008 Aug,

A/C

96000 55000

A/C A/C

2008 Sept,

51000

0 8600

95000

0 9000

2008 Nov,

82000

0 8200

87000

84000

0 8200

2008 Dec,

83000

0 5500

56000

57000

0 5500

2008 Oct,

2008

76000 95000

74000

0 8600

88000 89000

97000

87000

84000

99000

0 9000

99000 95000

99000

95000

90000

88000 87000

88000

86000

82000

59000 59000

59000

52000

53000

0

0

You as an Assistant Branch Manager of the Bank are entrusted the task of selecting two account holders for sanctioning the loans. How you will select the two individuals among the 10 applicants to give the loan using appropriate statistical techniques? Give proper justification for your selection. Answer:Mont Monthly Minimum Balance in INR hs A/C

A/C

A/C

A/C

A/C

Holde

Holde Holder

Holder Holde Holde Holde

Holde

Holde

Holder

r1 60000

r2 5600

4 86000

r5 5600

r6 r7 59000 59000

r8 52000

r9 53000

10 56000

70000

0 7600

96000

0 7600

96000 78000

73000

98000

76000

2008 Mar,

55000

0 1100

112000

19000

0 1100

12000 11500

11200

11300

12000

2008 Apr,

90000

00 8900

90000

0 98000

00 8900

0 0 97000 87000

0 93000

0 66000

0 89000

2008 May,

56000

0 8800

84000

84000

0 8800

98000 90000

89000

87000

86000

80000

0 5200

57000

0 5200

57000 55000

54000

59000

72000

2008 Jul,

82000

0 5800

96000

66000

0 5800

56000 86000

55000

98000

98000

2008 Aug,

79000

0 9500

55000

93000

0 9500

98000 99000

96000

59000

95000

2008 Sept,

51000

0 8600

76000

74000

0 8600

88000 89000

97000

87000

84000

Jan, 2008 Feb,

2008 Jun,

A/C 3 66000 74000

57000

A/C A/C

A/C

A/C

2008 Oct, 2008 Nov, 2008 Dec, 2008

95000

0 9000

82000

0 8200

83000

0 5500

95000 87000 56000

0

Average 73.56 78.06 79

99000

0 9000

99000 95000

99000

95000

90000

84000

0 8200

88000 87000

88000

86000

82000

57000

0 5500

59000 59000

59000

52000

53000

0 90.33 78.06 84.56 83.25 80.56 79.97 83.47

As an Assistant Branch Manager of the Bank , I will give 10 lakh loan to each. Give the minimum before of 50,000 would only be consider for one and all the A/C holders have more than 50,000 as minimum balance. While looking at the statement, it has been observed that only two A/C holders A/C holder no. 4 and A/C holder no. 6 have maximum average balance in their A./C, that should eligible for the loan for Rs. 10 lakh