1. (9+1 for Excel work) The instructor in the previous example teaches the same sections of the course four times a year and wanted to investigate if there was not only a difference in the way assignments were treated but also in the time of year the course was given. The following data was collected. Assume all populations are normally distributed, observations are independent, and population variances are equal. Using EXCEL perform all remaining tests necessary to determine whether the grades were influenced by assignment method and/or semester. Use alpha = 0.05 in all tests. No post tests are required. TERM FALL WINTER EARLY SUMMER LATE SUMMER No Assignments 69 69 92 84 79 84 76 63 76 82 89 72 72 65 73 47 92 71 83 81 92 80 64 72 84 79 74 81 Assignments, Not Collected 73 63 68 79 57 68 72 74 49 84 79 71 80 74 71 63 88 83 89 82 69 92 79 81 76 81 81 75 Assignments, Collected 83 97 72 79 84 76 91 76 83 88 91 96 68 99 89 80 79 91 83 83 76 90 79 67 86 86 82 84