This exercise requires you to use an electronic spreadsheet, such as Microsoft's Excel, to compute information about a data set ...

       This exercise requires you to use an electronic   spreadsheet, such as Microsoft's Excel, to compute information about a data   set. The data set is shown in Table 1 below. There are three groups in the   complete data set:   Group   1—Learning via the Lecture method of instruction    Group   2—Learning via the Cooperative method of instruction    Group   3—Learning via Computer-based instruction    The   scores in each group are the final examination scores of students in the   three groups. The scores represent overall knowledge learned under each   method of instruction. The higher the score, the more knowledge learned. The   Independent and Dependent variables are:   Independent   variable - the method of instruction at three   levels: Lecture, Cooperative, and Computer.   Dependent   variable - the final examination score.     A B C   1 Group 1 Group 2 Group 3   2 78 45 77   3 88 54 75   4 96 65 34   5 77 47 88   6 83 77 97   7 85 61 69   8 90 53 45   9 85 69 90   10 95 70 85   11 68 45 66   a.   Compute the descriptive statistics for Group 1.         b.   Calculate the correlation coefficient between Groups 1 and 2.   c.   Perform a t-Test between Groups 1 and 2.