Question

2. Use the data in BUSI1013 Bank Dataset.xlsx (Unit 1 Question 2) to answer this question. (4 points for each part; 8 points total)
   
   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.

Loans After	Increase in Loans
48.1	12.9
62.4	8.1
51.1	12.6
63.3	12.7
45.5	6.3
60.6	17.1
55.1	4.4
48.8	-1.5
55.9	13.4
58.7	8.5
53.0	7.0
54.3	5.6
62.0	13.2
50.1	9.3
51.3	-3.3
48.7	6.8
43.2	3.3
47.0	1.1
61.4	11.2
50.1	1.0
61.6	15.0
58.1	6.6
55.7	8.2
56.0	6.6
62.3	24.3
49.9	3.2
53.5	10.4
61.4	15.8
55.7	15.6
49.5	3.2
47.1	11.3
49.6	0.1
54.7	6.2
60.5	7.3
49.2	3.0
57.1	12.6
50.7	12.6
56.0	5.9
50.2	3.4
46.2	-0.6
62.7	16.1
61.3	13.8
56.6	17.1
45.1	9.5
55.9	6.2
43.4	-0.6
57.9	17.6
47.6	9.9
63.4	10.4
56.7	5.4
47.5	2.3
50.5	13.7
56.1	20.7
57.8	11.1
61.2	11.1
58.7	18.6
45.3	-2.9
51.5	2.0
62.9	23.5
46.2	0.7
50.1	10.8
47.0	2.5
48.3	8.4
54.3	10.1
46.4	7.4
63.4	12.2
54.5	8.4
44.7	1.3
57.3	13.2
55.7	5.5
46.5	7.4
49.6	14.0
44.2	-5.1
60.6	23.2
56.5	7.2
49.0	-3.9
62.8	12.8
61.4	23.7
50.6	-2.4
44.7	-1.0
44.7	7.8
50.1	6.7
59.2	18.0
54.8	-0.1
55.4	0.4
45.7	8.9
59.1	20.5
55.2	18.1
59.5	9.6
45.9	-1.3
47.2	1.2
58.4	18.5
58.1	4.2
63.5	28.0
63.0	8.7
61.0	24.2
47.4	5.4
44.4	-6.1
63.7	13.4
49.7	5.0
58.0	20.4
48.8	13.5
57.2	17.4
63.5	14.8
43.6	-7.9
54.9	4.5
59.0	16.1
57.2	5.0
52.2	7.5
59.9	19.3
48.2	10.0
59.5	12.9
58.3	11.3
58.6	5.1
56.6	20.1
62.1	14.4
58.9	13.1
57.8	13.3
48.6	10.3
49.2	-5.1
52.4	-2.1
62.9	18.4
56.3	13.9
62.6	10.3
45.9	-4.8
61.0	17.3
52.6	-1.9
45.6	6.9
56.8	12.3
53.3	0.8
47.3	-5.7
58.7	10.1
52.5	8.2
62.7	8.2
49.9	1.8
45.2	-9.7
48.2	6.5
53.7	2.0
62.7	25.6
46.2	6.5
58.1	15.8
60.1	20.5
48.3	-5.1
56.2	10.3
48.4	5.6
51.1	5.0
57.5	16.5
49.8	6.0
51.7	15.4
56.1	20.5
44.8	-6.8
44.3	-5.6

Answer 1

a)

b)