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)
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)
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F945d05fc-761f-497e-bd03-ee18a70483a0%2F3d462d2a-c5d2-4777-8481-8642db81cfdc%2F7hpt2wp_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Mathematics For Machine Technology](https://www.bartleby.com/isbn_cover_images/9781337798310/9781337798310_smallCoverImage.jpg)
![Algebra: Structure And Method, Book 1](https://www.bartleby.com/isbn_cover_images/9780395977224/9780395977224_smallCoverImage.gif)
![Mathematics For Machine Technology](https://www.bartleby.com/isbn_cover_images/9781337798310/9781337798310_smallCoverImage.jpg)
![Algebra: Structure And Method, Book 1](https://www.bartleby.com/isbn_cover_images/9780395977224/9780395977224_smallCoverImage.gif)