Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Refer to the Banking Data.xls, which provides data acquired from banking and census records for different zip codes in the bank's current market. The data
Refer to the Banking Data.xls, which provides data acquired from banking and census records for different zip codes in the bank's current market. The data show the median age of the population, median years of education, median income, median home value, median household wealth, and average bank balance of customers. 1. Explain what kind of business decisions that can be taken by the bank based on analyzing the provided data. Please provide detailed examples. 2. Using SPSS software, summarize the variables in the data set using descriptive statistics measures of choice. Include a couple of measures of correlations as well. Write up your findings to the document used in the previous questions. 3. Develop a model to predict the average bank balance as a function of the other variables. Make sure all assumptions of conducting such an analysis are met with. You might need to adopt an iterative approach to obtain the best fitting model. Report your statistical findings in the same response document and interpret the same.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started