this is problem on chapter 4 case A century national bank. need to make a report. not sure how to put everything together. i have attached all parts of the question and have also attached the data set

149 of 890 1 2. Deter count balan amon betwc 3. Dete! the cl third skew Mr. S brief devia A. Century National Bank The following case will appear in subsequent review sec- tions. Assume that you work in the Planning Department of the Century National Bank and report to Ms. Lamberg. You will need to do some data analysis and prepare a short writ- ten report. Remember, Mr. Sellg 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 Appendix A.6. 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 custom- ers. What is the balance of a typical customer? How many other bank services do the checking ac- count customers use? Do the customers use the ATM ser vice 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 sam- ple 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) transac- tions in the last month; (2) the number of other bank ser- vices (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 accounts, and (4) whether or not interest is paid on the checking account. The sample Includes cus- tomers 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? Doimanv.customers have more than $2.000 then B. Wild Do Wildcat F needs of The come and is ru grown frc today. Co the comp sentially gate, hec are a stuc have bee the situati o andom sample of 60 customers. In addition to the n each account at the end of last month, you determine 1) the number of ATM (automatic teller machine) transac- tions in the last month; (2) the number of other bank ser- vices (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 pald on the checking account. The sample includes cus- tomers 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 bal. ances tend to cluster? S 120 160 200 ed? and first and third quartile values? itively skewed? Tell how you know. ? If yes, estimate these values. he number of observations in the study? u k, 2. Determine the mean and median of the checking ac- count 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 M Selig does not deal with statistics daily. Include a brief description and interpretation of the standard deviation and other measures B. Wildcat Plumbing Supply Inc.. Do We Have Gender Differences? Wildcat Plumbing Supply has served the plumbing needs of Southwest Arizona for more than 40 years. The company was founded by Mr. Terrence St. Julian and is run today by his son Cory The company has to - ser- Who sked sam- Clipboard A 2 --- X F2 G B D Debit E Interest F City Services 1 21 13 0 1 6 2 0 U 1 0 1 4 0 1 6 0 3 4 1 3 1 0 0 0 3 1 0 0 1 4 2 3 1 1 Balance ATM 2 1756 348 4 1501 5 1831 6 1622 2 1886 740 1593 10 1169 2125 12 1554 13 7474 1913 15 1218 16 1006 2215 18 137 19 167 20 343 21 2557 22 2276 1494 24 2144 25 1995 26 1053 27 1526 28 1120 29 1838 1746 31 1616 3 8 4 6 6 7 5 3 4 3 2 0 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 10 10 14 17 6 10 6 18 12 12 6 10 12 20 7 5 7 20 15 11 17 10 8 8 8 7 11 10 6 2 4 4 17 1 0 4 3 4 0 2 2 1 4 1 1 0 0 2 1 1 0 0 3 2 0 1 0 0 7 4 4 6 5 2 3 1 2 1 0 0 1 1958 2 7 634 580 1320 1 -OOO 5 Sheet e Type here o BE Clipboard F2 RAM x A fia 2 B C D E F G 8 Sm 6 5 1 1 7 2. 0 0 11 10 3 2 2 2 4 1 1 NON 6 1 2 7 1 O 2 4 4 1 0 0 1 4 5 0 1 1 1 2 6 8 12 0 0 0 0 2 4 3 1 4 7 5 8 4 1 0 16 0 0 31 4 0 A 28 1120 29 1838 30 1746 31 1616 32 1958 634 580 1320 1675 37 789 38 1735 1784 1326 2051 1044 1885 1790 765 1645 32 1266 890 2204 2409 1338 2076 1708 2138 56 2375 57 1455 50 1487 59 1125 1989 61 2156 1 7 10 11 1 1 1 2 0 6 4 3 9 0 7 1 0 D 0 0 1 4 4 3 0 0 0 1 5 0 0 0 8 51 52 53 54 1 6 2 11 7 14 16 14 12 13 18 12 9 8 6 12 14 4 5 3 5 0 0 0 0 NOWN-ON - 5 4 0 4 3 5 0 1 0 Sheet Type here to search la