Question

In: Statistics and Probability

The attached Excel workbook, BUSI1013 Bank Dataset.xlsx, contains the data collected from research study. Answer the...

The attached Excel workbook, BUSI1013 Bank Dataset.xlsx, contains the data collected from research study.

Answer the following questions using this data set. (18 points)

  1. What would the population of interest be for this study?
  2. Which method of sampling was used in this study?
  3. How big is the sample size?
  4. How many variables are in the data set?
  5. Which of the variables are in nominal scale?
  6. Name the variable(s) measured in ratio scale.
  7. Name the variable(s) measured in interval scale.
  8. Which of the variables are categorical?
  9. Which of the variables are numerical?

Solutions

Expert Solution

ANSWER:

a)

Population of interest for this study is all customers of four branches of YU Bank where research study was conducted.

b)Simple random sampling method was used in this study as every customer of the particular branch had equal chance of selection as no specific criteria was specified for selection.

c)

Since, the mentioned excel workbook "BUSI1013 Bank Dataset.xlsx" is not attached, it is not possible to answer sample size. Though, the total number of customers selected for the research study in all four branches is a sample size. Like if S1, S2, S3 and S4 are number of customers selected from Branch 1, 2, 3 and 4 respectively then S1+ S2 + S3 + S4 is a sample size.

d)

Again this question cannot be answered without looking in excel file. But still count the number of colums above to get answer. The variables mentioned in the write up are :  Personal deposit (Before changes), loan balances (Before changes), Personal deposit (After changes), loan balances (After changes). Then the total number questions asked in survey to customer are also variable. Other than could be serial number, Customer name, Branche of customer, Account number could be other. Kindly count total headings in data set to get total number of variables.

e)

Nominal scale variables are not quantitative or number oiented. These are variable which are used to identify observation or categorize them. They could be answered by two or more categories: Like gender is nominal scale variable whose answer will be male or female. In this particular case Branch name could be one such variable whose answer can Branch 1, 2, 3 or 4 only. Similarly survey questions will nominal scale variable whose answer could be yes,no or agree/disagree or similar. Kindly review such options in the data set.

f)

Ratio scale variables are variables which could be quantified but they are shown in ratio form. Like total number of banks transaction in one month, total number of transactions in monh. Kindly check such variables.

g)

Interval scales are quantitive measurement where the distance between two points is an actual and equal distance which starts from beginning or Zero.Like total transactions, number or visits , temperature and others Identify such variables.

h)

Categorical variables are the variables which could be divided in groups: Like branch names, gender, account class (saving or current.}Kindly identify such variables.

i)

numerical variable is a variable where the measurement or number has a numerical meaning: Like total number of transactions, total money deposited or deited. These are numerical variables.

If possible kindly add headings of all variables in comments. It wil help in giving exact answer.

NOTE:: I HOPE THIS ANSWER IS HELPFULL TO YOU......**PLEASE SUPPORT ME WITH YOUR RATING......

**PLEASE GIVE ME "LIKE".....ITS VERY IMPORTANT  FOR,ME......PLEASE SUPPORT ME .......THANK YOU


Related Solutions

The data in the attached excel file comes from Consumer Reports and was collected over a...
The data in the attached excel file comes from Consumer Reports and was collected over a two-year period. It gives the average mpg over a 195-mile trip, the weight of the vehicle (pounds), engine displacement (liters), number of cylinders, horsepower, type of transmission (0 = manual, 1 = automatic), the number of gears and whether the car was foreign (1) or domestic (0). Part a: Build a model for predicting the average mpg based on the data in the attached...
Use the data in BUSI1013 Bank Dataset.xlsx (Unit 1 Question 2) to answer this question. (4...
Use the data in BUSI1013 Bank Dataset.xlsx (Unit 1 Question 2) to answer this question. (4 points for each part; 8 points total) Perform a statistical test to see whether the average loans of customers before the change at the Brock and Chase branch are different. Construct a 95% confidence interval for the difference of average loans of customers before the change at the Brock and Chase branch. Loans After Increase in Loans 48.1 12.9 62.4 8.1 51.1 12.6 63.3...
The data in BUSI1013 Credit Card Balance.xlsx is collected for building a regression model to predict...
The data in BUSI1013 Credit Card Balance.xlsx is collected for building a regression model to predict credit card balance of retail banking customers in a Canadian bank. Use this data to perform a simple regression analysis between Account balance and Income (in thousands). (12 points) Develop a scatter diagram using Account Balance as the dependent variable y and Income as the independent variable x. Develop the estimated regression equation. Use the estimated regression equation to predict the Account Balance of...
The data in BUSI1013 Credit Card Balance.xlsx is collected for building a regression model to predict...
The data in BUSI1013 Credit Card Balance.xlsx is collected for building a regression model to predict credit card balance of retail banking customers in a Canadian bank. Use this data to perform a simple regression analysis between Account balance and Income (in thousands). (12 points) Develop a scatter diagram using Account Balance as the dependent variable y and Income as the independent variable x. Develop the estimated regression equation. Use the estimated regression equation to predict the Account Balance of...
The attached Excel sheet contains data on annual returns on IBM and 3M stocks over the...
The attached Excel sheet contains data on annual returns on IBM and 3M stocks over the period 1990-2002, as well as annual returns on S&P 500 Index and one-year U.S. Treasury bills for this period. You are asked to evaluate performance of IBM and 3M stocks using the CAPM’s Security Market Line with S&P 500 Index as proxy for the market return. (i) Compute the annual excess returns of IBM, 3M, and the S&P 500. (ii) Use Excel to compute...
Look at the attached Excel file which contains two column charts identifying data for a company:...
Look at the attached Excel file which contains two column charts identifying data for a company: Week 1 Discussion Topic 2 Ethics.xls. Notice that the data is depicted differently, however, the data presented is really the same. Is it ethical to present data in a different way in order to make the data appear more favorable? Explain your reasoning.
Please answer the following questions using the data in the attached Excel file. You are thinking...
Please answer the following questions using the data in the attached Excel file. You are thinking of investing in Abercrombie and Fitch Co. (ANF). The returns for ANF are embedded in an Excel document below (Source: yahoo.com). 1.      For the investment in ANF that you are considering, for all of 2012 determine the following items: a) the mean return b) the median return c) the standard deviation d) the variance e) the coefficient of variation The weekly rates of return...
Create a new workbook in Excel. Please include an input area and an answer area for...
Create a new workbook in Excel. Please include an input area and an answer area for each problem. You will have an answer for each bullet point. Formatting is up to you. Just make sure it is easy to tell where your answers are, and what equation you used in excel to get the answer. 5. Assume you have won the lottery and have the choice of (1) receiving $1,000,000 now or (2) receiving $120,000 each year for 20 years....
Create a new workbook in Excel. Please include an input area and an answer area for...
Create a new workbook in Excel. Please include an input area and an answer area for each problem. You will have an answer for each bullet point. Formatting is up to you. Just make sure it is easy to tell where your answers are, and what equation you used in excel to get the answer. 2. If a 6.5 percent annual return can be expected: • How much would a 20-year old person have to put into a retirement fund...
Create a new workbook in Excel. Please include an input area and an answer area for...
Create a new workbook in Excel. Please include an input area and an answer area for each problem. You will have an answer for each bullet point. Formatting is up to you. Just make sure it is easy to tell where your answers are, and what equation you used in excel to get the answer. Assume a farmer has a choice of purchasing either a subsurface drip irrigation (SDI) system or a low energy precision application (LEPA) center pivot. The...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT