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 (1 = yes, 0 = no)

x6 = City/branches (1 = Cincinnati, 2 = Atlanta, 3 = Louisville, 4 = Erie)

x1 x2 x3 x4 x5 x6 1756 13 4 no yes Atlanta 748 9 2 yes no Cincinnati 1501 10 1 no no Cincinnati 1831 10 4 no yes Louisville 1622 14 6 no yes Erie 1886 17 3 no yes Cincinnati 740 6 3 no no Louisville 1593 10 8 yes no Cincinnati 1169 6 4 no no Erie 2125 18 6 no no Atlanta 1554 12 6 yes no Louisville 1474 12 7 yes no Cincinnati 1913 6 5 no no Cincinnati 1218 10 3 yes no Cincinnati 1006 12 4 no no Cincinnati 2215 20 3 yes no Erie 137 7 2 no no Louisville 167 5 4 no no Erie 343 7 2 no no Cincinnati 2557 20 7 yes no Erie 2276 15 4 yes no Louisville 1494 11 2 no yes Cincinnati 2144 17 3 no no Louisville 1995 10 7 no no Atlanta 1053 8 4 yes no Louisville 1526 8 4 no yes Atlanta 1120 8 6 yes no Louisville 1838 7 5 yes yes Louisville 1746 11 2 no no Atlanta 1616 10 4 yes yes Atlanta 1958 6 2 yes no Atlanta 634 2 7 yes no Erie 580 4 1 no no Cincinnati 1320 4 5 yes no Cincinnati 1675 6 7 yes no Atlanta 789 8 4 no no Erie 1735 12 7 no yes Louisville 1784 11 5 no no Cincinnati 1326 16 8 no no Louisville 2051 14 4 yes no Erie 1044 7 5 yes no Cincinnati 1885 10 6 yes yes Atlanta 1790 11 4 no yes Louisville 765 4 3 no no Erie 1645 6 9 no yes Erie 32 2 0 no no Louisville 1266 11 7 no no Erie 890 7 1 no yes Cincinnati 2204 14 5 no no Atlanta 2409 16 8 no no Atlanta 1338 14 4 yes no Atlanta 2076 12 5 yes no Atlanta 1708 13 3 yes no Cincinnati 2138 18 5 no yes Erie 2375 12 4 no no Atlanta 1455 9 5 yes yes Louisville 1487 8 4 yes no Erie 1125 6 4 yes no Atlanta 1989 12 3 no yes Atlanta 2156 14 5 yes no Atlanta

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 Lambert, 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 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 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 60 customers from the branches in the cities of Cincinnati, Atlanta, Louisvile, and Erie.

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 $2000 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 using ANOVA. Is there a statistical difference among the branches? Be sure to explain the difference between the mean and the median in your report

.*Note: ANOVA is based on analyzing the mean of the dependent variable, so running ANOVA on checking account balance as the dependent variable with branch as the factor will automatically analyze the mean balances across the branches. To analyze the median balances across the branches you will need to use a nonparametric test: Stat > Nonparametrics > Moods Media Test > Response = Balance, Factor = Branches

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.

4. Finally, develop a 95 percent confidence interval for the proportion of customers using debit cards. On the basis of the confidence interval, is it reasonable to conclude that more than half of the customers use a debit card?

5. Because Mr. Selig does not deal with statistics daily, include a brief description and interpretation of the descriptive and inferential statistics that you are running for questions 1-4.