Assume that you work in the Planning Department of LTG National Bank and report to Miss G. You will need to do some data analysis and prepare a short-written report. The written part of the report should not exceed a page in length. Remember, Mr. K is the President of the bank, so you will want to ensure that your report is complete and accurate. A copy of the data appears in page 3. The LTG National Bank has offices in several areas of Metro Manila. Mr. K, President and CEO, would like to know the characteristics of his checking account customers. What is the balance of a typical customer? How many other bank services do the checking account customers use? Do the customers use the ATM service and if so how often? What about debit cards? Who uses them, and how often are they used?   To better understand the customers, Mr. K asked Miss G, Director of Planning to select a sample of customers and prepare a report. To begin, she has appointed a team from her staff. You are the head of the team and responsible for preparing the report. You select a random sample of 60 customers. In addition to the balance in the account at the end of last month, you determine: (1) the number of ATM transactions in the last month; (2) the number of other bank services (a savings account, a certificate of deposit, etc.); (3) whether the customer has a debit card (this is a relatively new bank service in which charges are made directly to the customer’s account); (4) whether or not interest is paid on the checking account. The sample included customers from the branches in Makati, Quezon City, Pasig City, and San Juan.   What is the balance of a typical customer? Do many customers have more than Php 200,000 in their accounts? Does it appear that there is a difference in the distribution of the accounts among the four branches? Around what value do the account balances tend to cluster? Determine the mean and median of the checking account balances. Compare the mean and the median balances for the four branches? Is there a difference among the branches? Be sure to explain the difference between the mean and the median in your report. Determine the standard deviation of the checking account balances. Because Mr. K does not deal with statistics daily, include a brief description of the standard deviation and other measures. The bank has branch offices in four different places in Metro Manila: Makati, Manila, Quezon City and Pasig City. Mr. K would like to know if there are differences in the mean checking account balance among the branches. If there are any differences, where do these differences occur? Mr. Selig is also interested in the ATMs. Do customers who have debit cards tend to use the ATMs differently than those who do not have debit cards? Also, is there a difference in ATM use by those with checking accounts that pay interest versus those that do not?   THE DATA SET X1 – account balances in peso X2 – number of ATM transactions in the month X3 – number of other bank services used X4 – has a debit card (1=yes, 0=no) X5 – receives interest on the account (1=yes; 0=no) X6 – branches where banking is done (1=Makati; 2=Manila; 3=Quezon City; 4=Pasig City)

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Question
100%

Assume that you work in the Planning Department of LTG National Bank and report to Miss G.

You will need to do some data analysis and prepare a short-written report. The written part of the

report should not exceed a page in length. Remember, Mr. K is the President of the bank, so you will

want to ensure that your report is complete and accurate. A copy of the data appears in page 3.

The LTG National Bank has offices in several areas of Metro Manila. Mr. K, President and CEO,

would like to know the characteristics of his checking account customers. What is the balance of a

typical customer? How many other bank services do the checking account customers use? Do the

customers use the ATM service and if so how often? What about debit cards? Who uses them, and how

often are they used?

 

To better understand the customers, Mr. K asked Miss G, Director of Planning to select a sample

of customers and prepare a report. To begin, she has appointed a team from her staff. You are the

head of the team and responsible for preparing the report. You select a random sample of 60

customers. In addition to the balance in the account at the end of last month, you determine: (1) the

number of ATM transactions in the last month; (2) the number of other bank services (a savings account,

a certificate of deposit, etc.); (3) whether the customer has a debit card (this is a relatively new bank

service in which charges are made directly to the customer’s account); (4) whether or not interest is paid

on the checking account. The sample included customers from the branches in Makati, Quezon City,

Pasig City, and San Juan.

 

  1. What is the balance of a typical customer? Do many customers have more than Php 200,000 in

their accounts? Does it appear that there is a difference in the distribution of the accounts

among the four branches? Around what value do the account balances tend to cluster?

  1. Determine the mean and median of the checking account balances. Compare the mean and the

median balances for the four branches? Is there a difference among the branches? Be sure to

explain the difference between the mean and the median in your report.

  1. Determine the standard deviation of the checking account balances. Because Mr. K does not

deal with statistics daily, include a brief description of the standard deviation and other

measures.

The bank has branch offices in four different places in Metro Manila: Makati, Manila, Quezon

City and Pasig City. Mr. K would like to know if there are differences in the mean checking account

balance among the branches. If there are any differences, where do these differences occur?

Mr. Selig is also interested in the ATMs. Do customers who have debit cards tend to use the

ATMs differently than those who do not have debit cards? Also, is there a difference in ATM use by

those with checking accounts that pay interest versus those that do not?

 

THE DATA SET

X1 – account balances in peso

X2 – number of ATM transactions in the month

X3 – number of other bank services used

X4 – has a debit card (1=yes, 0=no)

X5 – receives interest on the account (1=yes; 0=no)

X6 – branches where banking is done (1=Makati; 2=Manila; 3=Quezon City; 4=Pasig City)

Client
X1
X2
X3
Х4
X5
X6
Client
X1
X2
X3
X4
X5
X6
1.
175600
13
2.
31
195800
6.
2.
1.
74800
2
1
1.
32
63400
2
7
1
4
3
150100
10
1
1.
33
58000
4
1.
4
183100
10
1.
3
34
132000
1
162200
14
1
4
35
167500
6
7
1
188600
17
1
1.
36
78900
8
4
7
74000
6
3
3
37
173500
12
7
8
159300
10
8
1.
1
38
178400
11
1
116900
6
4
4
39
132600
16
3
10
212500
18
6.
2
40
205100
14
4
1
4
11
155400
12
1
41
104400
7
1
1.
12
147400
12
7
1
42
188500
10
1
1
13
191300
6
43
179000
11
3
14
121800
10
1.
1.
44
76500
4
4
15
100600
12
4
1
45
164500
9
1
4
16
221500
20
3
1.
4
46
3200
2
3
17
13700
7
3
47
126600
11
7
4
18
16700
5
4
4
48
89000
7
1
1.
19
34300
7
2
1
49
220400
14
20
255700
20
7
1
4
50
240900
16
8
21
227600
15
4
1.
51
133800
14
4
22
149400
11
2
1
52
207600
12
1.
23
214400
17
3
53
170800
13
1.
1.
24
199500
10
7
54
213800
18
25
105300
4
3
55
237500
12
4
26
152600
8
4
56
145500
1
3
27
112000
8
6
1.
3
57
148700
4
1
4
28
183800
7
1.
58
112500
4
29
174600
11
2.
59
198900
12
2.
30
161600
10
4
1
1.
2.
60
215600
14
1
2.
Ololo
al 0o | 6
Hoo -HOlooo oloo olooc olooloHO oo
+NH 4
Transcribed Image Text:Client X1 X2 X3 Х4 X5 X6 Client X1 X2 X3 X4 X5 X6 1. 175600 13 2. 31 195800 6. 2. 1. 74800 2 1 1. 32 63400 2 7 1 4 3 150100 10 1 1. 33 58000 4 1. 4 183100 10 1. 3 34 132000 1 162200 14 1 4 35 167500 6 7 1 188600 17 1 1. 36 78900 8 4 7 74000 6 3 3 37 173500 12 7 8 159300 10 8 1. 1 38 178400 11 1 116900 6 4 4 39 132600 16 3 10 212500 18 6. 2 40 205100 14 4 1 4 11 155400 12 1 41 104400 7 1 1. 12 147400 12 7 1 42 188500 10 1 1 13 191300 6 43 179000 11 3 14 121800 10 1. 1. 44 76500 4 4 15 100600 12 4 1 45 164500 9 1 4 16 221500 20 3 1. 4 46 3200 2 3 17 13700 7 3 47 126600 11 7 4 18 16700 5 4 4 48 89000 7 1 1. 19 34300 7 2 1 49 220400 14 20 255700 20 7 1 4 50 240900 16 8 21 227600 15 4 1. 51 133800 14 4 22 149400 11 2 1 52 207600 12 1. 23 214400 17 3 53 170800 13 1. 1. 24 199500 10 7 54 213800 18 25 105300 4 3 55 237500 12 4 26 152600 8 4 56 145500 1 3 27 112000 8 6 1. 3 57 148700 4 1 4 28 183800 7 1. 58 112500 4 29 174600 11 2. 59 198900 12 2. 30 161600 10 4 1 1. 2. 60 215600 14 1 2. Ololo al 0o | 6 Hoo -HOlooo oloo olooc olooloHO oo +NH 4
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON