please answer this question at Excel

NPar Tests (Q2) Kruskal-Wallis Test Ranks METHOD RESULT 1 2 3 Total N 6 5 9 20 Moan Rank 10.17 8.40 11.89 8 Test Statistics RESULT Chi-Square 1.145 df 2 Asymp Sig .564 a Kruskal Wallis Test b. Grouping Variable: METHOD NPar Tests (Q1) Mann-Whitney Test Ranks BRANCH SCORE 1 2 Total N 15 15 30 Mean Rank 16.47 14.53 Sum of Ranks 247.00 218.00 Test Statistics Mann-Whitney Wilcoxon W Z Asymp. Sig. (2-tailed) Exact Sig. 12"(1-tailed SCORF 98.000 218.000 -601 518 567 Sig. a. Not corrected for ties. b Grouping Variable: BRANCH 2. The FAA wishes to determine whether there is a difference in the effectiveness among three training methods : video, audio, classroom. Exam results of 20 students pilots who were trained in the three methods are shown below: (File name : Data //) 74 70 Video Audio 78 Classroom 68 88 80 83 82 65 50 93 57 91 55 89 84 77 94 81 92 Command : Menu Analyze Nonparametric Tests K Independent samples Test Variable List: Grouping Variable: Define Groups: Group 1 Group 2 Test Type.. 1. The board of Regents of a large state university wants to determine whether the SAT scores of students at two branches of the state university are equal. A random sample of 15 students from each branch is taken. The results are shown below:- (File name: Data/0) Branch A 1000 1100 800 750 1300 950 1050 1250 1400 850 1150 1200 1500 600 775 Branch B 920 1120 830 1360 650 725 890 1600 900 1140 1550 550 1240 925 500 Command : Menu Analyze Nonparametric Tests 2 Independent samples Test Variable List: Grouping Variable: Define Groups: Group 1 Group 2 Test Type