STATS250 Individual PROJECT #1(Descriptive Statistics) Spring, 2018
General Instructions/Information:
Individual Project #1 is due on Wednesday, February 14.
Individual Project #1 will be scored on a 50-point scale.
SPSS INDIVIDUAL PROJECT 1
CASE: 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.
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 a 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. Classify each variable in the data set by the scale of measurement (nominal, ordinal, interval,
and ratio) and by the type of variable (Categorical or Quantitative: discrete or continuous).
Variable Scale of Measurement Categorical vs Quantitative Discrete vs Continuous
Balance
ATM
Services
Debit
Interest
City
2. Develop a histogram (interval width = 500) that shows the checking balances. How many
customers have more than $2,000 in their accounts?
2
3. Referring to the data calculate the quartiles of checking account balances for the whole bank
and for each of the four branches. What do the first and third quartiles show? Because Mr.
Selig does not deal with statistics daily, include a brief description and interpretation of the
numerical measures.
4. What is the shape of the distribution of the checking account balances? Justify your answer
statistically.
5. Determine the mean and median of the checking account balances. Compare the mean and the
median balances for each of 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.
6. Obtain a single exhibit showing 4 individual boxplots (one for each of the four cities) of the
checking account balances. Does it appear that there is a difference in the distribution of the
accounts among the four branches?
Data:
I have posted the data in Blackboard Assignments SPSS Individual Project 1. You will find an
Excel file that contains the data. The structure of the data follows:
Balance = Account balance in $
ATM = Number of ATM transactions in the month
Services = Number of other bank services used
Debit = Has a debit card (1 = yes, 0 = no)
Interest = Receives interest on the account (1 = yes, 0 = no)
City = City where banking is done (1 = Cincinnati, 2 = Atlanta, 3 = Louisville, 4 = Erie)
Approximate scoring:
1. Each variable @ 2 point 12
2. Histogram 3
Numerical value 3
3. Each quartiles @ 0.5 point 6
Description and Interpretation 4
4. The shape of the distribution 2
Arguments 4
5. Each mean and median @ 0.5 point 5
Comparison 4
6. 4 individual boxplots 3
Notable differences 4_____
50 points
Type your project with all results and draw conclusions.