BUSINESS REPORT - Case Analysis - 6 different versions, homework help

Anonymous
timer Asked: Jun 18th, 2017
account_balance_wallet $40

Question description

I NEED 6 different versions of this assignment for me and 5 of my friend and we are at the same class so make sure can make it look different so my teacher will not notice.

I need 2-3 pages business report that answer the questions below based on the data attached in excel file.

MAKE SUER IT IS BUSINESS REPORT NOT QUESTION ADN ANSWER

Century National Bank

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 written report. Remember, Mr. Selig is the president of the bank, so you will want to ensure that your report is complete and accurate.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 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


Refer to the Century National Bank data.

1) Is it reasonable that the distribution of checking account balances approximates a normal probability distribution?

2) Determine the mean and the standard deviation for the sample of 60 customers.

3) Compare the actual distribution with the theoretical distribution.

4) Cite some specific examples and comment on your findings.

5) Divide the account balances into three groups, of about 20 each, with the smallest third of the balances in the first group, the middle third in the second group, and those with the largest balances in the third group.

6) Develop a table that shows the number in each of the categories of the account balances by branch.

7) Does it appear that account balances are related to the branch?

8) Cite some examples and comment on your findings?

Balance 1756 748 1501 1831 1622 1886 740 1593 1169 2125 1554 1474 1913 1218 1006 2215 137 167 343 2557 2276 1494 2144 1995 1053 1526 1120 1838 1746 1616 1958 634 580 1320 1675 789 1735 1784 1326 2051 1044 1885 1790 765 1645 32 1266 890 2204 2409 1338 ATM Services 13 9 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 6 8 12 11 16 14 7 10 11 4 6 2 11 7 14 16 14 4 2 1 4 6 3 3 8 4 6 6 7 5 3 4 3 2 4 2 7 4 2 3 7 4 4 6 5 2 4 2 7 1 5 7 4 7 5 8 4 5 6 4 3 9 0 7 1 5 8 4 Debit Interest 0 1 0 0 0 0 0 1 0 0 1 1 0 1 0 1 0 0 0 1 1 0 0 0 1 0 1 1 0 1 1 1 0 1 1 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 1 0 1 0 0 0 0 0 0 1 0 0 0 0 1 1 0 1 0 0 1 0 0 0 City 2 1 1 3 4 1 3 1 4 2 3 1 1 1 1 4 3 4 1 4 3 1 3 2 3 2 3 3 2 2 2 4 1 1 2 4 3 1 3 4 1 2 3 4 4 3 4 1 2 2 2 2076 1708 2138 2375 1455 1487 1125 1989 2156 12 13 18 12 9 8 6 12 14 5 3 5 4 5 4 4 3 5 1 1 0 0 1 1 1 0 1 0 0 1 0 1 0 0 1 0 2 1 4 2 3 4 2 2 2
Century National Bank 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 written report. Remember, Mr. Selig is the president of the bank, so you will want to ensure that your report is complete and accurate.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 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 Refer to the Century National Bank data. 1) Is it reasonable that the distribution of checking account balances approximates a normal probability distribution? 2) Determine the mean and the standard deviation for the sample of 60 customers. 3) Compare the actual distribution with the theoretical distribution. 4) Cite some specific examples and comment on your findings. 5) Divide the account balances into three groups, of about 20 each, with the smallest third of the balances in the first group, the middle third in the second group, and those with the largest balances in the third group. 6) Develop a table that shows the number in each of the categories of the account balances by branch. 7) Does it appear that account balances are related to the branch? 8) Cite some examples and comment on your findings?

Tutor Answer

generalgenius2
School: University of Virginia

Phew, there you go.

Type
Topic

Report
The Characteristics of the Century
National bank checking account customers

Prepared for
Prepared by
Date of preparation

Dan Selig

Introduction
Dan Selig requested the preparation of a report to present findings about the checking account
clients in four branches of the Century National Bank. Ms. Lamberg was the supervisor. This
report presents these findings in the ensuing paragraphs.
The underlying assumption of normal probability distribution
The research was based on an underlying assumption of a normal probability distribution among
the checking account balances...

flag Report DMCA
Review

Anonymous
Awesome! Exactly what I wanted.

Similar Questions
Hot Questions

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors