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.

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)