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 andmedian 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)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps