I am using Excel and need help solving and answering the questions below to complete the chart. Please go step by step and include formulas when needed. The yellow boxes require answers as well.
B D E F H 1 CONTEXT - You are a teacher and have administered a reading test to 3rd graders. You want to analyze the test scores 2 in the experiment. There are 3 groups: 3 1-the control group (using current teaching method) 4 2-the CBT group (using a computer based training method) 5 3-the hybrid group (using a combination of the current and CBT methods) 6 Answer the questions below the data. 7 8 Control CBT Only Hybrid General Stats Control CBT Only Hybrid 9 15 14 16 Average 10 11 12 14 Median 11 12 13 13 Mode 12 14 11 17 High 13 15 15 15 Low 14 14 16 16 Variance 15 12 11 11 Standard Deviation 16 10 10 17 17 12 9 14 18 9 14 15 Total number of students passing with 15 or higher 19 14 13 12 Total number of students failing with 14 or lower 20 13 13 15 Average passing grade for Hybrid Group 21 13 11 11 Average failing grade for the CBT group 22 10 13 14 23 12 13 14 24 13 12 13 25 10 16 11 26 11 15 12 27 9 12 18 28 11 10 13 29 8 12 11 30 15 11 11 31 13 10 12 32 12 10 14 33 Questions 34 1-Calculate the items in the general stats column (use .S descriptor for Variance and St Dev) 35 2-Based on the data provided, which method do you feel is the most effective? 36 3-Why do you think this method is most effective? 37 4-Which of the options provides results closest to the mean? B D E F H 1 CONTEXT - You are a teacher and have administered a reading test to 3rd graders. You want to analyze the test scores 2 in the experiment. There are 3 groups: 3 1-the control group (using current teaching method) 4 2-the CBT group (using a computer based training method) 5 3-the hybrid group (using a combination of the current and CBT methods) 6 Answer the questions below the data. 7 8 Control CBT Only Hybrid General Stats Control CBT Only Hybrid 9 15 14 16 Average 10 11 12 14 Median 11 12 13 13 Mode 12 14 11 17 High 13 15 15 15 Low 14 14 16 16 Variance 15 12 11 11 Standard Deviation 16 10 10 17 17 12 9 14 18 9 14 15 Total number of students passing with 15 or higher 19 14 13 12 Total number of students failing with 14 or lower 20 13 13 15 Average passing grade for Hybrid Group 21 13 11 11 Average failing grade for the CBT group 22 10 13 14 23 12 13 14 24 13 12 13 25 10 16 11 26 11 15 12 27 9 12 18 28 11 10 13 29 8 12 11 30 15 11 11 31 13 10 12 32 12 10 14 33 Questions 34 1-Calculate the items in the general stats column (use .S descriptor for Variance and St Dev) 35 2-Based on the data provided, which method do you feel is the most effective? 36 3-Why do you think this method is most effective? 37 4-Which of the options provides results closest to the mean
