A professor of business at a local college wanted to determinewhich of his two methods of teaching statistics resulted in bettergrades. He randomly selected 30 students from his current classesand set up two special sub-sections of the course, one for each ofhis two methods, with 15 students in each sub-section. After thesemester was over, he placed the final averages for each of thestudents in a spreadsheet and wanted to determine if the differencein the average scores of the samples indicated that there would bea difference in the scores of the population of students.
Use the correct Excel function found in DataAnalysis to determine if the population average scores ofthe two methods are the same. At the bottom of the Excel worksheet,write a Decision Rule and ConclusionStatement
Method 1: 86, 69, 85, 68, 68, 68, 87, 85, 85, 72, 67, 73, 84,66, 76
Method 2: 91, 94, 55, 96, 70, 91, 58, 87, 64, 87, 95, 65, 86,75, 88
