Question

Use the data in and description of BUSI1013 Bank Dataset.xlsx to complete and answer the following: (4 points each for Part a and b, 2 points for part c, 10 points in total

1. Summarize the variable Increase in Deposits using the two measures of location (Mean and Median) and the two measures of variability (range and standard deviation).
2. Summarize the variable Increase in Loans using the two measures of location (Mean and Median) and the two measures of variability (range and standard deviation).
3. Based on the above, would you consider if the recent change in the customer account management process is effective?

Here is the link address for the data set. please provide screen shot of how to enter the data to arrive at the solutions https://courses.yorkvilleu.ca/iSpring/BBA/BUSI_1013/Resources/Exercises/BUSI1013-Bank_Dataset.xlsx

Answer 1

a)Measures of location for increase in deposits are

Mean of Increase in Deposits = 3.92237

Median of Increase in Deposits = 4.35

Measures of variability increase in deposits are

Maximum of Increase in Deposits = 16.6

Minimum of Increase in Deposits= -7.9

Range of Increase in Deposits =maximum - minimum = 24.5

Standard deviation of Increase in Deposits = 5.85150

b)Measures of location for increase in loans are

Mean of Increase in Loans = 8.63224

Median of Increase in Loans = 8.4

Measures of variability for increase in loans are

Minimum of Increase in Loans = -9.7

Maximum of Increase in Loans = 28

Range of Increase in Loans =maximum - minimum= 37.7

Standard deviation of Increase in Loans = 7.79427

c) from the above results for both increase in deposits as well increase in loans  , we can say that yes,the recent change in the customer account management process is effective.