Question 1

A school has implemented a new teaching method to increase the students' SAT examination score in 2020. The head of the program believes the students' score in 2020 is better than the previous year student who was taught using the old methods. The scores for both 2019 and 2020 are listed in file Data3. Test the head of the program's claim at the 5% significance level.

*please help to use excel to show the working.

File Data3

Student (2020)	SAT SCORE (2020)
1	656
2	641
3	643
4	616
5	662
6	645
7	593
8	634
9	659
10	595
11	647
12	627
13	651
14	569
15	687
16	618
17	589
18	653
19	670
20	592
21	602
22	649
23	614
24	596
25	570
26	639
27	640
28	609
29	618
30	638
31	659
32	591
33	737
34	618
35	640
36	640
37	654
38	638
39	659
40	570
41	655
42	631
43	663
44	657
45	616
46	647
47	673
48	634
49	666
50	612
51	632
52	626
53	624
54	642
55	618
56	637
57	618
58	577
59	689
60	625
61	608
62	606
63	651
64	682
65	574
66	642
67	633
68	621
69	641
70	633
71	718
72	660
73	630
74	638
75	615
76	595
77	592
78	618
79	610
80	651
81	706
82	646
83	608
84	610
85	637
86	665
87	622
88	600
89	633
90	608
91	642
92	633
93	622
94	628
95	635
96	594
97	608
98	650
99	699
100	634
101	632
102	719
103	621
104	638
105	546
106	638
107	650
108	600
109	634
110	651
111	617
112	622
113	623
114	689
115	641
116	685
117	600
118	634
119	652
120	653
121	654
122	701
123	701
124	618
125	629

Student (2019)	SAT SCORE (2019)
1	580
2	575
3	604
4	644
5	662
6	636
7	639
8	644
9	553
10	643
11	609
12	616
13	684
14	570
15	601
16	578
17	572
18	703
19	676
20	638
21	642
22	645
23	646
24	589
25	667
26	626
27	685
28	626
29	608
30	578
31	635
32	599
33	597
34	670
35	610
36	636
37	576
38	692
39	609
40	604
41	598
42	645
43	644
44	603
45	603
46	683
47	678
48	656
49	631
50	637
51	592
52	645
53	632
54	613
55	637
56	662
57	565
58	568
59	615
60	647
61	628
62	682
63	669
64	611
65	617
66	609
67	572
68	638
69	622
70	636
71	644
72	677
73	674
74	663
75	633
76	624
77	591
78	609
79	633
80	605
81	600
82	720
83	612
84	652
85	649
86	686
87	565
88	648
89	617
90	624
91	593
92	621
93	647
94	596
95	679
96	609
97	597
98	572
99	686
100	569
101	645
102	582
103	563
104	675
105	644
106	671
107	564
108	655
109	683
110	595
111	616
112	655
113	605
114	603
115	594
116	612
117	643
118	660
119	605
120	589
121	676
122	706
123	653
124	638
125	604