Use the data in BUSI1013 Bank Dataset.xlsx(see below) to answer this question. (4 points)

a Perform a statistical test to see whether the average Increase in Loans in the population is higher than $7.5 (thousands). Use the p-value approach and a 0.05 level of significance.

b Perform a statistical test to see whether the average Increase in Deposits in the population is less than $4.1 (thousands). Use the critical value approach and a 0.05 level of significance?

BUS 1013 Bank Dataset Legend and Coding Customer ID Customer ID Number Branch Branch Name Gender : M = Male Female Age Age of customers Incom Personal income in thousands Deposit Before Amount of deposits before the change ; in thousands Deposit After : Amount of deposits after the change , in thousands Increase in Deposits Increase in deposits since the change ( in thousands ) ; it equals to Deposits After minus Deposits Before Loans Before Amount of loans before the change in thousands Loans After : Amount of loans after the change in thousands Increase in Loan Increase in Loans since the change ( in thousands ) it equals to Loans After minus Loans Before Rating Rating of the Bank's friendliness to its customers ( on a scale of 1 -10 ) Recommend Before : Before the change , whether customer would recommend the Bank to their friends and family : Yes = Recommend No = Not Recomme of Recommend Recommend After : After the change , whether customer would recommend the Bank to their friends and family : Yes - Recommend No = Not Recommend