Assume that you work in the Planning Department of XYZ National Bank and report to Miss X. 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. Y 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 XYZ National Bank has offices in several areas of Metro Manila. Mr. Y, 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. Y asked Miss X, 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? 2. 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. 3. Determine the standard deviation of the checking account balances. Because Mr. Y 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. Y 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?