Question 1 A school has implemented a new teaching method to…

/in /by

QuestionAnswered step-by-stepQuestion 1 A school has implemented a new teaching method to…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 Data3Student (2020) SAT SCORE (2020)1 6562 6413 6434 6165 6626 6457 5938 6349 65910 59511 64712 62713 65114 56915 68716 61817 58918 65319 67020 59221 60222 64923 61424 59625 57026 63927 64028 60929 61830 63831 65932 59133 73734 61835 64036 64037 65438 63839 65940 57041 65542 63143 66344 65745 61646 64747 67348 63449 66650 61251 63252 62653 62454 64255 61856 63757 61858 57759 68960 62561 60862 60663 65164 68265 57466 64267 63368 62169 64170 63371 71872 66073 63074 63875 61576 59577 59278 61879 61080 65181 70682 64683 60884 61085 63786 66587 62288 60089 63390 60891 64292 63393 62294 62895 63596 59497 60898 65099 699100 634101 632102 719103 621104 638105 546106 638107 650108 600109 634110 651111 617112 622113 623114 689115 641116 685117 600118 634119 652120 653121 654122 701123 701124 618125 629  Student (2019) SAT   SCORE (2019)1 5802 5753 6044 6445 6626 6367 6398 6449 55310 64311 60912 61613 68414 57015 60116 57817 57218 70319 67620 63821 64222 64523 64624 58925 66726 62627 68528 62629 60830 57831 63532 59933 59734 67035 61036 63637 57638 69239 60940 60441 59842 64543 64444 60345 60346 68347 67848 65649 63150 63751 59252 64553 63254 61355 63756 66257 56558 56859 61560 64761 62862 68263 66964 61165 61766 60967 57268 63869 62270 63671 64472 67773 67474 66375 63376 62477 59178 60979 63380 60581 60082 72083 61284 65285 64986 68687 56588 64889 61790 62491 59392 62193 64794 59695 67996 60997 59798 57299 686100 569101 645102 582103 563104 675105 644106 671107 564108 655109 683110 595111 616112 655113 605114 603115 594116 612117 643118 660119 605120 589121 676122 706123 653124 638125 604MathStatistics and ProbabilityMGT 782Share Question