84 79 90 90 19 2 The Following Table Displays Student Averages From 3 Semesters Of Mat 150 I Used Excel To Calculate S 1 (193.77 KiB) Viewed 19 times
84 79 90 90 19 2. The following table displays student averages from 3 semesters of MAT 150. I used Excel to calculate some statistics. We want to know if students did better with the traditional in-person model from Fall 2019 vs. the hybrid model (NAUFlex) from Fall 2020 or with the in-person model from Fall 2021. Fall 2019 (In class lecture, paper-and pencil homework + proctored in class quizzes/tests/final) Overall Grade Att./Notes Homework Quizzes Test 1 Test 2 Test 3 Final Mean 80 94 89 77 72 75 Mode #N/A 100 100 100 85 89 90 86 Median 84 97 84 78 75 80 Standard Deviation 15 11 11 19 18 21 20 Fall 2020 (Synchronous online lectures, online homework and videos + unproctored online quizzes, tests and final, including take-home tests and final) Overall Grade Att./Notes Homework Quizzes Test 1 Test 2 Test 3 Final Mean 83 89 89 76 80 79 84 83 Mode #N/A N 100 100 87 81 87 101 Median 99 82 83 82 87 Standard Deviation 15 22 22 20 15 16 11 26 Fall 2021 (In-class lectures, online homework and videos + unproctored online quizzes, tests and final, including take- home tests and final) Overall Grade Att./Notes Homework Quizzes Test 1 Test 2 Test 3 Final Mean 82 88 89 82 82 77 78 76 Mode #N/A 104 100 100 86 60 84 77 Median 88 95 97 90 86 83 84 84 Standard Deviation 17 18 21 15 21 23 88 88 97 92 16 19 Fall 2019 Number Percent А A 7 7 21% | В B 12 35% с 11 32% D 0 0% F F 4 12% Total 34 100% Fall 2020 Number Percent A 16 40% B B 11 28% с 8 D 3 8% F 2. 5% Total 100% 20% Fall 2021 Number Percent A 27 38% B 22 31% с с 10 14% D 4 6% F 8 8 11% Total 71 100% ot 40 Overall Grade 30 Fall 2019 Minimum Value 1st Quartile 3rd Quartile Maximum Value Overall Grade 24 72 89 Fall 2020 Minimum Value 1st Quartile 3rd Quartile Maximum Value 76 93 99 Fall 2021 Minimum Value 1st Quartile 3rd Quartile Maximum Value Overall Grade 15 78 88 99 99 a) Create a triple bar graph for the letter grades of each semester. Make sure to label each axis! (2 pts)
b) Based on the triple bar graph, in which semester did students do better and why? (1 pt) c) Are there any outliers in the overall grades? Show work for all semesters! (3 pts) d) Use the 5-number summary of the overall class grade to create a triple box-and-whisker plot. Label your axis. (3 pts) e) Based on the box and whisker plot, in which semester did students do better and why? (1 pt) f) One of the "major" department concerns with the NAUFlex and fall 2021 models is the lack of proctored exams. Which average (mean, mode, or median) for the tests and the final exam can you use to show if this concern is founded or unfounded? Explain. (1 pt)
g) People (ab)use statistics all the time to make their point. Pick a statistic from the tables to convince someone that one model is better for students. Then pick another statistic from the tables to convince someone that another model is better for students. (2 pts)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!