Hello, using this link's data would someone help me answer these questions

https://docs.google.com/spreadsheets/d/1JiD_eIrXnaiq3kdbVHp9k9ZhfG4PW_u38hiuqx1PQBc/edit?usp=sharing (copy and paste into URL)

Use the data inBUSI1013 Bank Dataset.xlsx(Unit 1 Question 2) to answer this question.

1. Perform a statistical test to see whether the average loans of customers before the change at the Brock and Chase branch are different.
2. Construct a 95% confidence interval for the difference of average loans of customers before the change at the Brock and Chase branch.
3. Use the data, test whether the average deposits of customers have increased since the change. Use 0.05 as the level of significance. Note that the difference in Deposits is already calculated as Increase in Deposits.