Discuss the below:
Century National Bank
Assume that you work in the Planning D partment of the Century National Bank and report to Ms. Lamberg. You will need to do some data analysis and prepare a short written report. Remember, Mr. Selig 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 Table 1.
The Century National Bank has offices in several cities in the Midwest and the southeastern part of the United States. Mr. Dan Selig, 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. Selig asked Ms. Wendy Lamberg, 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 each account at the end of last month, you determine: (1) the number of ATM (automatic teller machine) transactions in the last month; (2) the number of other bank services (a savings account, a certificate of deposit, etc.) the customer uses; (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); and (4) whether or not interest is paid on the checking account. The sample includes customers from the branches in Cincinnati, Ohio; Atlanta, Georgia; Louisville, Kentucky; and Erie, Pennsylvania.
1. Develop a graph or table that portrays the checking balances. What is the balance of a typical customer? Do many customers have more than $2,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 range and the standard deviation of the checking account balances. What do the first and third quartiles show? Determine the coefficient of skewness and indicate what it shows. Because Mr. Selig does not deal with statistics daily, include a brief description and interpretation of the standard deviation and other measures.
X1= Account balance in $
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
X6 = City where banking is
|
x,
|
X2
|
X3
|
X4
|
X5
|
X6
|
|
1756
|
13
|
4
|
0
|
1
|
2
|
|
748
|
9
|
2
|
1
|
0
|
1
|
|
1501
|
10
|
1
|
0
|
0
|
1
|
|
1831
|
10
|
4
|
0
|
1
|
3
|
|
1622
|
14
|
6
|
0
|
1
|
4
|
|
1886
|
17
|
3
|
0
|
1
|
1
|
|
740
|
6
|
3
|
0
|
0
|
3
|
|
1593
|
10
|
8
|
1
|
0
|
1
|
|
1169
|
6
|
4
|
0
|
0
|
4
|
|
2125
|
18
|
6
|
0
|
0
|
2
|
|
1554
|
12
|
6
|
1
|
0
|
3
|
|
1474
|
12
|
7
|
1
|
0
|
1
|
|
1913
|
6
|
5
|
0
|
0
|
1
|
|
1218
|
10
|
3
|
1
|
0
|
1
|
|
1006
|
12
|
4
|
0
|
0
|
1
|
|
2215
|
20
|
3
|
1
|
0
|
4
|
|
137
|
7
|
2
|
0
|
0
|
3
|
|
167
|
5
|
4
|
0
|
0
|
4
|
|
343
|
7
|
2
|
0
|
0
|
1
|
|
2557
|
20
|
7
|
1
|
0
|
4
|
|
2276
|
15
|
4
|
1
|
0
|
3
|
|
1494
|
11
|
2
|
0
|
1
|
1
|
|
2144
|
17
|
3
|
0
|
0
|
3
|
|
1995
|
10
|
7
|
0
|
0
|
2
|
|
1053
|
8
|
4
|
1
|
0
|
3
|
|
1526
|
8
|
4
|
0
|
1
|
2
|
|
1120
|
8
|
6
|
1
|
0
|
3
|
|
1838
|
7
|
5
|
1
|
1
|
3
|
|
1746
|
11
|
2
|
0
|
0
|
2
|
|
1616
|
10
|
4.
|
1
|
1
|
2
|
|
1958
|
6
|
2
|
1
|
0
|
2
|
|
634
|
2
|
7
|
1
|
0
|
4
|
|
580
|
4
|
1
|
0
|
0
|
1
|
|
1320
|
4
|
5
|
1
|
0
|
1
|
|
1675
|
6
|
7
|
1
|
0
|
2
|
|
789
|
8
|
4
|
0
|
0
|
4
|
|
1735
|
12
|
7
|
0
|
1
|
3
|
|
1784
|
11
|
5
|
0
|
0
|
1
|
|
1326
|
16
|
8
|
0
|
0
|
3
|
|
2015
|
14
|
4
|
1
|
0
|
4
|
|
1044
|
7
|
5
|
1
|
0
|
1
|
|
1885
|
10
|
6
|
1
|
1
|
2
|
|
1790
|
11
|
4
|
0
|
1
|
3
|
|
765
|
4
|
3
|
0
|
0
|
4
|
|
1645
|
6
|
9
|
0
|
1
|
4
|
|
32
|
2
|
0
|
0
|
0
|
3
|
|
1266
|
11
|
7
|
0
|
0
|
4
|
|
890
|
7
|
1
|
0
|
1
|
1
|
|
2204
|
14
|
5
|
0
|
0
|
2
|
|
2409
|
16
|
8
|
0
|
0
|
2
|
|
1338
|
14
|
4
|
1
|
0
|
2
|
|
2076
|
12
|
5
|
1
|
0
|
2
|
|
1708
|
13
|
3
|
1
|
0
|
1
|
|
2138
|
18
|
5
|
0
|
1
|
4
|
|
2375
|
12
|
4
|
0
|
0
|
2
|
|
1455
|
9
|
5
|
1
|
1
|
3
|
|
1487
|
8
|
4
|
1
|
0
|
4
|
|
1125
|
6
|
4
|
1
|
0
|
2
|
|
1989
|
12
|
3
|
0
|
1
|
2
|
|
2156
|
14
|
5
|
1
|
0
|
2
|