use the data below from this link: https://docs.google.com/spreadsheets/d/1QorJa5qWY1dyH7TzTvXhbHpolBNq4w_TwMJin91nCeA/edit?

use the data below from this link: https://docs.google.com/spreadsheets/d/1QorJa5qWY1dyH7TzTvXhbHpolBNq4w_TwMJin91nCeA/edit?usp=sharing

for question 1,2,3

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 below to 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.