ID Gender 1M 2F 3M 4F 5M 6M 7F 8F 9F 10 M 11 M 12 M 13 F 14 F 15 M 16 F 17 F 18 M 19 F 20 F 21 M 22 F 23 M 24 F 25 M 26 F 27 M 28 M 29 F 30 F 31 F 32 M 33 M 34 F 35 F 36 F 37 M 38 M 39 M 40 F 41 M 42 M 43 F 44 F 45 M 46 M 47 F 48 M 49 F 50 M 51 M 52 F 53 M 54 M 55 F 56 M 57 M 58 M 59 M 60 F 61 F 62 M 63 F 64 F 65 M 66 M 67 F 68 F 69 M 70 M 71 F 72 F 73 M 74 F 75 F 76 M 77 F 78 M 79 M 80 M 81 M 82 F 83 F 84 F 85 M 86 M Class Level Lectures WAttendanceQuiz 1 Quiz 2 Quiz 3 Quiz 4 Jr 82 78 50 71 89 So 73 97 64 60 52 Sr 76 64 87 99 65 So 96 97 65 62 87 Sr 69 50 82 84 50 F 0 60 54 79 53 So 78 90 91 69 64 Sr 99 87 62 87 50 Sr 100 90 91 83 72 Sr 67 91 95 62 55 So 77 57 61 98 74 Jr 51 79 89 64 97 Jr 73 65 61 64 97 Jr 63 82 61 100 90 F 72 70 54 81 71 Jr 100 100 100 93 56 F 53 63 90 74 73 F 98 92 83 51 77 So 90 79 76 84 83 F 97 92 97 64 81 F 97 82 60 53 82 Jr 91 50 73 89 52 Jr 99 50 89 95 64 So 82 76 94 51 72 So 93 83 83 56 59 So 93 64 95 64 85 Sr 82 61 59 56 98 F 60 53 75 62 67 F 55 100 54 88 78 So 89 73 58 53 70 Jr 82 87 67 92 84 Jr 99 58 50 89 88 Jr 56 96 60 68 59 So 68 62 56 67 59 Sr 53 92 63 60 100 F 59 79 83 63 60 F 91 66 100 83 65 F 84 53 84 56 92 Jr 53 74 69 55 70 Jr 81 68 55 93 75 F 94 93 68 99 86 F 57 94 60 96 61 So 97 76 92 54 72 So 92 78 88 96 91 Sr 89 94 51 85 60 Jr 74 52 86 89 60 Jr 79 84 95 87 84 So 92 50 89 94 98 So 52 60 54 74 68 F 100 69 79 57 75 F 95 77 83 66 72 So 94 78 56 94 73 Jr 73 63 64 66 83 F 96 64 98 91 100 Jr 96 76 55 63 67 Jr 79 90 58 83 72 So 74 96 81 90 93 So 91 58 57 78 54 So 97 50 80 61 78 Sr 82 77 60 100 79 F 71 86 74 85 62 So 74 88 100 62 67 Sr 58 57 75 72 60 Sr 76 89 96 96 68 Sr 88 73 61 51 73 So 64 83 86 60 58 Jr 94 89 50 79 67 Jr 83 76 75 64 69 Jr 54 97 86 72 76 F 86 57 51 53 91 Jr 78 81 78 89 84 F 66 74 79 93 57 F 94 83 63 57 71 So 76 53 95 52 78 F 92 83 74 51 87 F 78 70 92 97 96 Jr 72 85 68 72 65 Jr 80 92 88 95 99 So 79 96 83 89 99 So 95 70 98 100 98 So 10 63 76 86 59 Sr 30 79 53 95 26 F 72 63 95 95 95 F 91 87 71 91 92 So 46 67 68 71 79 Jr 35 85 65 51 67 Quiz 5 87 81 56 65 51 72 71 51 90 91 62 53 92 56 98 62 65 82 55 66 88 66 79 91 93 85 50 83 96 96 96 77 67 60 68 58 84 64 81 52 64 64 81 63 50 66 78 50 75 82 64 59 94 54 99 56 71 56 54 54 55 90 91 62 68 88 68 94 97 62 51 50 91 95 96 86 73 90 80 99 84 92 84 71 70 88 Midterm Final 53 78 56 95 51 89 79 99 59 67 54 55 75 53 77 61 80 80 50 54 76 79 100 84 71 99 64 69 53 88 73 86 50 84 55 93 93 51 55 79 69 82 53 51 89 97 95 53 59 98 91 57 74 55 75 86 54 78 58 86 66 63 97 53 55 79 69 60 82 93 78 72 96 71 73 86 81 99 79 67 68 72 56 54 78 98 75 65 85 56 72 88 62 88 59 79 50 97 95 78 82 51 94 95 72 100 65 95 54 62 94 98 58 95 97 98 75 85 78 88 100 51 95 58 63 76 63 89 53 89 82 91 97 50 54 65 91 76 83 60 92 97 69 85 83 64 58 75 64 58 97 87 65 65 82 88 90 68 100 98 60 97 15 54 91 88 76 85 94 82 42 94 Final avera Final Grade 93 80.9 B70 81.42 B97 82.92 B100 93.42 A89 69.84 D+ 73 62.88 F 65 68.2 D+ 58 66.18 D 54 74.84 C 85 74.02 C 61 68.24 D+ 53 73.02 C86 83.9 B91 79.24 C+ 76 77.48 C+ 80 85.16 B 57 68.98 D+ 88 86.62 B 98 76.14 C 60 74.62 C 67 75.18 C 60 56.62 F 61 74.04 C 50 62.22 F 81 84.3 B 76 69.5 D+ 74 64.38 F 86 76.68 C 58 75.6 C 73 75.7 C 85 78 C+ 77 66.64 D 92 82.86 B60 60.84 F 100 91.22 A60 69.08 D+ 80 75.62 C 74 73.36 C77 81.84 B59 65.56 D 54 71.8 C55 64.98 F 83 87 B+ 76 74.42 C 59 66.54 D 87 77.82 C+ 66 79.24 C+ 83 88 B+ 58 71.34 C85 78.22 C+ 69 66.08 D 82 83.74 B60 75.76 C 94 85.82 B 93 75.22 C 93 89.82 B+ 61 81.72 B89 81.38 B81 73.72 C74 78.84 C+ 76 70.34 C76 74.36 C 61 66.94 D 89 86.6 B 89 88 B+ 97 87.96 B+ 73 94 A 63 67.84 D 98 88.48 B+ 71 64.3 F 55 77.56 C+ 51 69.52 D+ 80 74.4 C 52 63.82 F 77 71.98 C81 83.12 B66 70.02 C100 92.96 A82 81.84 B100 93.2 A59 74 C 74 65.44 D 92 85 B 99 88.64 B+ 90 80.28 B29 66.42 D 87 M 88 F 89 F 90 M 91 F 92 F 93 M 94 F 95 F 96 M 97 F 98 M 99 F 100 M 101 F 102 M 103 M 104 F 105 F 106 F 107 M 108 M 109 F 110 M 111 F 112 M 113 M 114 M 115 F 116 M 117 M 118 F 119 F 120 M 121 M 122 F 123 M 124 F 125 M 126 M 127 F 128 M 129 M 130 F 131 M 132 M 133 M 134 M 135 F 136 F 137 M 138 F 139 F 140 M 141 M 142 F 143 F 144 M 145 M 146 F 147 F 148 M 149 F 150 F Jr Jr So Sr F F F Jr Jr F F So So Sr Jr Jr So So F F F So Jr Jr So Sr So F F Jr So So Sr F F Sr So F Jr So So F F Sr Sr Jr F F So Sr So Jr F F F Jr Jr Sr So So F Jr F So 45 83 37 34 80 55 5 99 74 88 20 17 72 91 25 12 61 51 71 39 29 59 35 55 83 48 37 100 100 95 39 100 22 90 65 29 37 64 21 98 75 34 20 43 37 84 70 18 3 53 22 58 97 29 62 25 100 82 7 87 74 24 69 3 58 76 52 70 82 65 70 73 78 71 85 61 65 82 79 90 89 59 76 55 52 54 74 57 79 55 96 54 79 55 63 91 76 53 82 100 55 72 83 98 87 54 95 92 71 67 83 65 78 60 83 93 77 57 76 75 59 70 78 71 71 79 91 51 89 97 86 75 99 88 73 96 100 76 85 0 67 85 73 81 73 77 68 99 72 71 96 89 95 69 54 100 93 74 69 91 89 98 94 69 61 70 69 100 93 64 93 76 95 100 69 62 51 61 74 82 80 79 79 53 100 99 89 62 73 97 84 74 87 99 82 60 89 100 75 93 99 91 80 69 35 99 85 98 69 81 63 87 51 67 75 34 93 68 67 98 95 73 76 89 74 99 78 53 87 59 77 100 92 76 64 87 95 87 73 58 63 71 76 77 68 92 87 54 99 100 68 100 69 73 100 72 79 93 92 71 95 96 75 85 100 76 66 67 26 79 77 48 72 68 74 95 29 66 97 83 78 55 74 99 95 95 89 90 60 99 91 57 52 67 71 100 95 100 79 85 79 85 0 56 70 79 68 75 54 76 81 66 99 100 82 63 69 86 54 72 79 91 95 67 95 88 74 97 99 72 84 71 78 92 82 85 73 70 73 96 65 74 99 42 85 70 55 99 90 89 65 93 86 91 97 61 84 63 96 100 83 78 84 69 93 93 75 58 60 69 71 91 52 50 75 74 98 99 71 70 62 74 94 73 86 92 93 66 94 98 73 93 99 89 72 72 98 91 47 98 70 94 70 91 82 69 86 70 59 68 68 98 98 91 55 99 55 91 70 62 89 75 94 100 83 99 64 76 90 83 75 68 68 61 88 58 54 58 92 73 100 100 70 66 66 58 88 71 84 100 94 71 88 86 73 90 100 81 83 70 97 93 80 62 70 70 61 92 85 74 79 54 83 56 92 100 98 99 84 86 77 93 82 80 87 72 61 100 74 87 89 84 77 94 74 52 68 72 91 73 68 84 71 54 98 99 68 67 68 92 95 73 86 95 85 58 96 86 74 82 99 85 72 71 80 98 96 74 71 94 72 76 81 68 99 83 86 67 94 100 100 89 89 98 95 96 67 90 89 62 100 100 67 70 28 89 97 93 73 62 57 91 83 83 57 89 88 58 99 100 56 67 68 54 66 73 79.4 C+ 92.58 A82.02 B66.26 D 90.48 A83.4 B72.9 C84.76 B 95.18 A 80.16 B78.98 C+ 65.66 D 78.26 C+ 91.54 A83.16 B75.2 C 74.38 C 76.6 C 69.02 D+ 80.12 B72.16 C67.28 D 86.32 B 65.22 D 82.9 B61.1 F 87.72 B+ 90.56 A94.04 A 84.28 B 78.66 C+ 91.88 A81.36 B86.42 B 78.3 C+ 83.08 B78.72 C+ 67.96 D 81.18 B99.6 A 77.54 C+ 74.58 C 69.46 D+ 86.02 B 84.48 B 87.42 B+ 72.38 C59.28 F 65.58 D 74.54 C 83.88 B80.72 B65.22 D 77.5 C+ 79.46 C+ 61.4 F 90.74 A93.62 A68 D+ 68.84 D+ 68.56 D+ 75.12 C 83.3 B68.48 D+ Objectives 1 Create a graph to summarize information on student class level. 2 Create a graph to summarize information on final grade 3 Create a frequency distribution of the final grades (a) by percentage and (b) by letter grade. 4 Provide descriptive statistics (mean, range, standard deviation) on all of the variables in the data set. 5 Create a contingency table to evaluate the relationship between gender and final letter grade 6 Calculate and report the correlation between midterm grade and grade on the final exam. Provide an interpretation of the effect size. 7 Determine the probability of receiving an A or A8 Determine the probability of receiving at least 90% on the final exam (assume a normal distribution). 9 Test the hypothesis that students watching more than 74% of lectures have a significantly higher final exam grade with 95% confidence. Record all steps of the hypothesis test. 10 Summarize all of the information above, and make three recommendations to students taking MGQ201 1. Create a graph to summarize information on student class level. Place in the space outlined below. 4. Provide descriptive statistics (mean, range, standard deviation) on all of the variables in the data set. 9. Test the hypothesis that students watching more than 74% of lectures have a significantly higher final exam grade with 95% confidence. Record all steps of the hypothesis test. 2. Create a graph to summarize information on final grade. Place in the space outlined below. 5. Create a contingency table to evaluate the relationship between gender and final letter grade. Place the formatted table in the space below. 10. Summarize all of the information above, and make three recommendations to students taking MGQ201. 3. Create a frequency distribution of the final grades (a) by percentage and (b) by letter grade. Place the tables in the space below. 6. Calculate and report the correlation between midterm grade and grade on the final exam. Provide an interpretation of the effect size. 7. Determine the probability of receiving an A or A-. Report the probability below. 8. Determine the probability of receiving at least 90% on the final exam (assume a normal distribution). final exam GQ201. (empty) Final Grade A AB BB+ C CC+ D D+ F (empty) Total Result Count - Final Grade 4 11 12 24 9 22 11 17 16 13 11 A; 1% 4% A-; B; 4% B-; 8% B+; 3% 150 C; 7% Total Result; 50% C-; 4% C+; 6% D; 5% D+; 4% F; 4% A AB BB+ C CC+ D D+ F (empty) Total Result ID Gender 1M 2F 3M 4F 5M 6M 7F 8F 9F 10 M 11 M 12 M 13 F 14 F 15 M 16 F 17 F 18 M 19 F 20 F 21 M 22 F 23 M 24 F 25 M 26 F 27 M 28 M 29 F 30 F 31 F 32 M 33 M 34 F 35 F 36 F 37 M 38 M 39 M 40 F 41 M 42 M 43 F 44 F 45 M 46 M 47 F 48 M 49 F 50 M 51 M 52 F 53 M 54 M 55 F 56 M 57 M 58 M 59 M 60 F 61 F 62 M 63 F 64 F 65 M 66 M 67 F 68 F 69 M 70 M 71 F 72 F 73 M 74 F 75 F 76 M 77 F 78 M 79 M 80 M Class Level Lectures Watched (%) Attendance (%) Quiz 1 Quiz 2 Quiz 3 Quiz 4 Jr 82 78 50 71 89 So 73 97 64 60 52 Sr 76 64 87 99 65 So 96 97 65 62 87 Sr 69 50 82 84 50 F 0 60 54 79 53 So 78 90 91 69 64 Sr 99 87 62 87 50 Sr 100 90 91 83 72 Sr 67 91 95 62 55 So 77 57 61 98 74 Jr 51 79 89 64 97 Jr 73 65 61 64 97 Jr 63 82 61 100 90 F 72 70 54 81 71 Jr 100 100 100 93 56 F 53 63 90 74 73 F 98 92 83 51 77 So 90 79 76 84 83 F 97 92 97 64 81 F 97 82 60 53 82 Jr 91 50 73 89 52 Jr 99 50 89 95 64 So 82 76 94 51 72 So 93 83 83 56 59 So 93 64 95 64 85 Sr 82 61 59 56 98 F 60 53 75 62 67 F 55 100 54 88 78 So 89 73 58 53 70 Jr 82 87 67 92 84 Jr 99 58 50 89 88 Jr 56 96 60 68 59 So 68 62 56 67 59 Sr 53 92 63 60 100 F 59 79 83 63 60 F 91 66 100 83 65 F 84 53 84 56 92 Jr 53 74 69 55 70 Jr 81 68 55 93 75 F 94 93 68 99 86 F 57 94 60 96 61 So 97 76 92 54 72 So 92 78 88 96 91 Sr 89 94 51 85 60 Jr 74 52 86 89 60 Jr 79 84 95 87 84 So 92 50 89 94 98 So 52 60 54 74 68 F 100 69 79 57 75 F 95 77 83 66 72 So 94 78 56 94 73 Jr 73 63 64 66 83 F 96 64 98 91 100 Jr 96 76 55 63 67 Jr 79 90 58 83 72 So 74 96 81 90 93 So 91 58 57 78 54 So 97 50 80 61 78 Sr 82 77 60 100 79 F 71 86 74 85 62 So 74 88 100 62 67 Sr 58 57 75 72 60 Sr 76 89 96 96 68 Sr 88 73 61 51 73 So 64 83 86 60 58 Jr 94 89 50 79 67 Jr 83 76 75 64 69 Jr 54 97 86 72 76 F 86 57 51 53 91 Jr 78 81 78 89 84 F 66 74 79 93 57 F 94 83 63 57 71 So 76 53 95 52 78 F 92 83 74 51 87 F 78 70 92 97 96 Jr 72 85 68 72 65 Jr 80 92 88 95 99 So 79 96 83 89 99 So 95 70 98 100 98 Quiz 5 87 81 56 65 51 72 71 51 90 91 62 53 92 56 98 62 65 82 55 66 88 66 79 91 93 85 50 83 96 96 96 77 67 60 68 58 84 64 81 52 64 64 81 63 50 66 78 50 75 82 64 59 94 54 99 56 71 56 54 54 55 90 91 62 68 88 68 94 97 62 51 50 91 95 96 86 73 90 80 99 Midterm Final 53 78 56 95 51 89 79 99 59 67 54 55 75 53 77 61 80 80 50 54 76 79 100 84 71 99 64 69 53 88 73 86 50 84 55 93 93 51 55 79 69 82 53 51 89 97 95 53 59 98 91 57 74 55 75 86 54 78 58 86 66 63 97 53 55 79 69 60 82 93 78 72 96 71 73 86 81 99 79 67 68 72 56 54 78 98 75 65 85 56 72 88 62 88 59 79 50 97 95 78 82 51 94 95 72 100 65 95 54 62 94 98 58 95 97 98 75 85 78 88 100 51 95 58 63 76 63 89 53 89 82 91 97 50 54 65 91 76 83 60 92 97 69 85 83 64 58 75 64 58 97 87 65 65 82 88 90 68 100 98 Final average Final Grade 93 80.9 B70 81.42 B97 82.92 B100 93.42 A89 69.84 D+ 73 62.88 F 65 68.2 D+ 58 66.18 D 54 74.84 C 85 74.02 C 61 68.24 D+ 53 73.02 C86 83.9 B91 79.24 C+ 76 77.48 C+ 80 85.16 B 57 68.98 D+ 88 86.62 B 98 76.14 C 60 74.62 C 67 75.18 C 60 56.62 F 61 74.04 C 50 62.22 F 81 84.3 B 76 69.5 D+ 74 64.38 F 86 76.68 C 58 75.6 C 73 75.7 C 85 78 C+ 77 66.64 D 92 82.86 B60 60.84 F 100 91.22 A60 69.08 D+ 80 75.62 C 74 73.36 C77 81.84 B59 65.56 D 54 71.8 C55 64.98 F 83 87 B+ 76 74.42 C 59 66.54 D 87 77.82 C+ 66 79.24 C+ 83 88 B+ 58 71.34 C85 78.22 C+ 69 66.08 D 82 83.74 B60 75.76 C 94 85.82 B 93 75.22 C 93 89.82 B+ 61 81.72 B89 81.38 B81 73.72 C74 78.84 C+ 76 70.34 C76 74.36 C 61 66.94 D 89 86.6 B 89 88 B+ 97 87.96 B+ 73 94 A 63 67.84 D 98 88.48 B+ 71 64.3 F 55 77.56 C+ 51 69.52 D+ 80 74.4 C 52 63.82 F 77 71.98 C81 83.12 B66 70.02 C100 92.96 A82 81.84 B100 93.2 A- Lectures Watched (%) 1 0 1 1 0 0 1 1 1 0 1 0 0 0 0 1 0 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 0 0 0 0 1 1 0 1 1 0 1 1 1 0 1 1 0 1 1 1 0 1 1 1 0 1 1 1 0 0 0 1 1 0 1 1 0 1 1 0 1 1 1 1 0 1 1 1 81 M 82 F 83 F 84 F 85 M 86 M 87 M 88 F 89 F 90 M 91 F 92 F 93 M 94 F 95 F 96 M 97 F 98 M 99 F 100 M 101 F 102 M 103 M 104 F 105 F 106 F 107 M 108 M 109 F 110 M 111 F 112 M 113 M 114 M 115 F 116 M 117 M 118 F 119 F 120 M 121 M 122 F 123 M 124 F 125 M 126 M 127 F 128 M 129 M 130 F 131 M 132 M 133 M 134 M 135 F 136 F 137 M 138 F 139 F 140 M 141 M 142 F 143 F 144 M 145 M 146 F 147 F 148 M 149 F 150 F So Sr F F So Jr Jr Jr So Sr F F F Jr Jr F F So So Sr Jr Jr So So F F F So Jr Jr So Sr So F F Jr So So Sr F F Sr So F Jr So So F F Sr Sr Jr F F So Sr So Jr F F F Jr Jr Sr So So F Jr F So 10 30 72 91 46 35 45 83 37 34 80 55 5 99 74 88 20 17 72 91 25 12 61 51 71 39 29 59 35 55 83 48 37 100 100 95 39 100 22 90 65 29 37 64 21 98 75 34 20 43 37 84 70 18 3 53 22 58 97 29 62 25 100 82 7 87 74 24 69 3 63 79 63 87 67 85 58 76 52 70 82 65 70 73 78 71 85 61 65 82 79 90 89 59 76 55 52 54 74 57 79 55 96 54 79 55 63 91 76 53 82 100 55 72 83 98 87 54 95 92 71 67 83 65 78 60 83 93 77 57 76 75 59 70 78 71 71 79 91 51 76 53 95 71 68 65 89 97 86 75 99 88 73 96 100 76 85 0 67 85 73 81 73 77 68 99 72 71 96 89 95 69 54 100 93 74 69 91 89 98 94 69 61 70 69 100 93 64 93 76 95 100 69 62 51 61 74 82 80 79 79 53 100 99 89 62 73 97 84 74 86 95 95 91 71 51 87 99 82 60 89 100 75 93 99 91 80 69 35 99 85 98 69 81 63 87 51 67 75 34 93 68 67 98 95 73 76 89 74 99 78 53 87 59 77 100 92 76 64 87 95 87 73 58 63 71 76 77 68 92 87 54 99 100 68 100 69 73 100 72 59 26 95 92 79 67 79 93 92 71 95 96 75 85 100 76 66 67 26 79 77 48 72 68 74 95 29 66 97 83 78 55 74 99 95 95 89 90 60 99 91 57 52 67 71 100 95 100 79 85 79 85 0 56 70 79 68 75 54 76 81 66 99 100 82 63 69 86 54 72 84 92 84 71 70 88 79 91 95 67 95 88 74 97 99 72 84 71 78 92 82 85 73 70 73 96 65 74 99 42 85 70 55 99 90 89 65 93 86 91 97 61 84 63 96 100 83 78 84 69 93 93 75 58 60 69 71 91 52 50 75 74 98 99 71 70 62 74 94 73 60 15 91 76 94 42 86 92 93 66 94 98 73 93 99 89 72 72 98 91 47 98 70 94 70 91 82 69 86 70 59 68 68 98 98 91 55 99 55 91 70 62 89 75 94 100 83 99 64 76 90 83 75 68 68 61 88 58 54 58 92 73 100 100 70 66 66 58 88 71 97 54 88 85 82 94 84 100 94 71 88 86 73 90 100 81 83 70 97 93 80 62 70 70 61 92 85 74 79 54 83 56 92 100 98 99 84 86 77 93 82 80 87 72 61 100 74 87 89 84 77 94 74 52 68 72 91 73 68 84 71 54 98 99 68 67 68 92 95 73 59 74 92 99 90 29 86 95 85 58 96 86 74 82 99 85 72 71 80 98 96 74 71 94 72 76 81 68 99 83 86 67 94 100 100 89 89 98 95 96 67 90 89 62 100 100 67 70 28 89 97 93 73 62 57 91 83 83 57 89 88 58 99 100 56 67 68 54 66 73 77.58 15.58 74 C 65.44 D 85 B 88.64 B+ 80.28 B66.42 D 79.4 C+ 92.58 A82.02 B66.26 D 90.48 A83.4 B72.9 C84.76 B 95.18 A 80.16 B78.98 C+ 65.66 D 78.26 C+ 91.54 A83.16 B75.2 C 74.38 C 76.6 C 69.02 D+ 80.12 B72.16 C67.28 D 86.32 B 65.22 D 82.9 B61.1 F 87.72 B+ 90.56 A94.04 A 84.28 B 78.66 C+ 91.88 A81.36 B86.42 B 78.3 C+ 83.08 B78.72 C+ 67.96 D 81.18 B99.6 A 77.54 C+ 74.58 C 69.46 D+ 86.02 B 84.48 B 87.42 B+ 72.38 C59.28 F 65.58 D 74.54 C 83.88 B80.72 B65.22 D 77.5 C+ 79.46 C+ 61.4 F 90.74 A93.62 A68 D+ 68.84 D+ 68.56 D+ 75.12 C 83.3 B68.48 D+ 0 0 0 1 0 0 0 1 0 0 1 0 0 1 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 1 1 1 0 1 0 1 0 0 0 0 0 1 1 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 1 1 0 1 0 0 0 0 Objectives 1 Create a graph to summarize information on student class level. 2 Create a graph to summarize information on final grade 3 Create a frequency distribution of the final grades (a) by percentage and (b) by letter grade. 4 Provide descriptive statistics (mean, range, standard deviation) on all of the variables in the data set. 5 Create a contingency table to evaluate the relationship between gender and final letter grade 6 Calculate and report the correlation between midterm grade and grade on the final exam. Provide an interpretation of the effect size. 7 Determine the probability of receiving an A or A8 Determine the probability of receiving at least 90% on the final exam (assume a normal distribution). 9 Test the hypothesis that students watching more than 74% of lectures have a significantly higher final exam grade with 95% confidence. Record all steps of the hypothesis test. 10 Summarize all of the information above, and make three recommendations to students taking MGQ201 1. Create a graph to summarize information on student class level. Place in the space outlined below. 4. Provide descriptive statistics (mean, range, standard deviation) on all of the variables in the data set. 9. Test the hypothesis that students watching more than 74% of lectures have a significantly higher fi exam grade with 95% confidence. Record all steps of the hypothesis test. Null hypothesis: P>=0.5 Alternative : p<0.5 From the data, 71 studets watched more than 74% of the lectures. then, the sample proportion = (71/150) = 0.4733 Test statistic, Z = (p^-p)/(Sqrt(pq/n)) = (0.4733-0.5)/ sqrt(0.5*0.5/150) = -0.6540 P-value = P(Z< - 0.6540) = 0.2566 Since the P-value is higher than the significance level, do not reject the null hypothesis and conclude 2. Create a graph to summarize information on final grade. Place in the space outlined below. 5. Create a contingency table to evaluate the relationship between gender and final letter grade. Place the formatted table in the space below. 10. Summarize all of the information above, and make three recommendations to students taking M As there is positive correlation betwee midterm exam and final exam, getting good grade in Midter can improve the grade in final exam Only 10% of persons receive high grades Almost 21.27% chance exists to get at least 90% in the exam 3. Create a frequency distribution of the final grades (a) by percentage and (b) by letter grade. Place the tables in the space below. Final Grade Frquency Final Grade % of frequency A AB BB+ C CC+ D D+ F Total 4 11 12 24 9 22 11 17 16 13 11 150 A AB BB+ C CC+ D D+ F Total 2.67% 7.33% 8.00% 16.00% 6.00% 14.67% 7.33% 11.33% 10.67% 8.67% 7.33% 100% 6. Calculate and report the correlation between midterm grade and grade on the final exam. Provide an interpretation of the effect size. Correlation(Midterm, Final) = 0.289793 The correlation between Midterm and Final scores is 0.28979 indicating that there is weak positive correlation between midterm and final scores. The change in midterm will change the final score in the same direction. 7. Determine the probability of receiving an A or A-. Report the probability below. The probability of receiving A grade = 4/150 = 0.02667 The probability of receiving A- grade = 11/150 = 0.0733 Then, the probability of receiving A or A- = 0.02667+0.0733 = 0.1 8. Determine the probability of receiving at least 90% on the final exam (assume a normal distribution). From the above table, the mean score in final exam = 77.58 The standard deviation of the scores, = 15.57802 Z-value corresponding to 90 = (90-77.58)/15.58 = 0.7972 Then, P(X>90) = P(Z>0.7972) = 1 - P(Z<=0.7972) = 1 - 0.7873 = 0.2127 Final grade (Pie chart) final de that there is no sufficient evidence to support the claim that more than 74% of lectures have a significantly higher final exam grade MGQ201. erm exam (empty) Final Grade A AB BB+ C CC+ D D+ F (empty) Total Result Count - Final Grade 4 11 12 24 9 22 11 17 16 13 11 A; 1% 4% A-; B; 4% B-; 8% B+; 3% 150 C; 7% Total Result; 50% C-; 4% C+; 6% D; 5% D+; 4% F; 4% A AB BB+ C CC+ D D+ F (empty) Total Result ID Gender 1M 2F 3M 4F 5M 6M 7F 8F 9F 10 M 11 M 12 M 13 F 14 F 15 M 16 F 17 F 18 M 19 F 20 F 21 M 22 F 23 M 24 F 25 M 26 F 27 M 28 M 29 F 30 F 31 F 32 M 33 M 34 F 35 F 36 F 37 M 38 M 39 M 40 F 41 M 42 M 43 F 44 F 45 M 46 M 47 F 48 M 49 F 50 M 51 M 52 F 53 M 54 M 55 F 56 M 57 M 58 M 59 M 60 F 61 F 62 M 63 F 64 F 65 M 66 M 67 F 68 F 69 M 70 M 71 F 72 F 73 M 74 F 75 F 76 M 77 F 78 M 79 M 80 M Class Level Lectures Watched (%) Attendance (%) Quiz 1 Quiz 2 Quiz 3 Quiz 4 Jr 82 78 50 71 89 So 73 97 64 60 52 Sr 76 64 87 99 65 So 96 97 65 62 87 Sr 69 50 82 84 50 F 0 60 54 79 53 So 78 90 91 69 64 Sr 99 87 62 87 50 Sr 100 90 91 83 72 Sr 67 91 95 62 55 So 77 57 61 98 74 Jr 51 79 89 64 97 Jr 73 65 61 64 97 Jr 63 82 61 100 90 F 72 70 54 81 71 Jr 100 100 100 93 56 F 53 63 90 74 73 F 98 92 83 51 77 So 90 79 76 84 83 F 97 92 97 64 81 F 97 82 60 53 82 Jr 91 50 73 89 52 Jr 99 50 89 95 64 So 82 76 94 51 72 So 93 83 83 56 59 So 93 64 95 64 85 Sr 82 61 59 56 98 F 60 53 75 62 67 F 55 100 54 88 78 So 89 73 58 53 70 Jr 82 87 67 92 84 Jr 99 58 50 89 88 Jr 56 96 60 68 59 So 68 62 56 67 59 Sr 53 92 63 60 100 F 59 79 83 63 60 F 91 66 100 83 65 F 84 53 84 56 92 Jr 53 74 69 55 70 Jr 81 68 55 93 75 F 94 93 68 99 86 F 57 94 60 96 61 So 97 76 92 54 72 So 92 78 88 96 91 Sr 89 94 51 85 60 Jr 74 52 86 89 60 Jr 79 84 95 87 84 So 92 50 89 94 98 So 52 60 54 74 68 F 100 69 79 57 75 F 95 77 83 66 72 So 94 78 56 94 73 Jr 73 63 64 66 83 F 96 64 98 91 100 Jr 96 76 55 63 67 Jr 79 90 58 83 72 So 74 96 81 90 93 So 91 58 57 78 54 So 97 50 80 61 78 Sr 82 77 60 100 79 F 71 86 74 85 62 So 74 88 100 62 67 Sr 58 57 75 72 60 Sr 76 89 96 96 68 Sr 88 73 61 51 73 So 64 83 86 60 58 Jr 94 89 50 79 67 Jr 83 76 75 64 69 Jr 54 97 86 72 76 F 86 57 51 53 91 Jr 78 81 78 89 84 F 66 74 79 93 57 F 94 83 63 57 71 So 76 53 95 52 78 F 92 83 74 51 87 F 78 70 92 97 96 Jr 72 85 68 72 65 Jr 80 92 88 95 99 So 79 96 83 89 99 So 95 70 98 100 98 Quiz 5 87 81 56 65 51 72 71 51 90 91 62 53 92 56 98 62 65 82 55 66 88 66 79 91 93 85 50 83 96 96 96 77 67 60 68 58 84 64 81 52 64 64 81 63 50 66 78 50 75 82 64 59 94 54 99 56 71 56 54 54 55 90 91 62 68 88 68 94 97 62 51 50 91 95 96 86 73 90 80 99 Midterm Final 53 78 56 95 51 89 79 99 59 67 54 55 75 53 77 61 80 80 50 54 76 79 100 84 71 99 64 69 53 88 73 86 50 84 55 93 93 51 55 79 69 82 53 51 89 97 95 53 59 98 91 57 74 55 75 86 54 78 58 86 66 63 97 53 55 79 69 60 82 93 78 72 96 71 73 86 81 99 79 67 68 72 56 54 78 98 75 65 85 56 72 88 62 88 59 79 50 97 95 78 82 51 94 95 72 100 65 95 54 62 94 98 58 95 97 98 75 85 78 88 100 51 95 58 63 76 63 89 53 89 82 91 97 50 54 65 91 76 83 60 92 97 69 85 83 64 58 75 64 58 97 87 65 65 82 88 90 68 100 98 Final average Final Grade 93 80.9 B70 81.42 B97 82.92 B100 93.42 A89 69.84 D+ 73 62.88 F 65 68.2 D+ 58 66.18 D 54 74.84 C 85 74.02 C 61 68.24 D+ 53 73.02 C86 83.9 B91 79.24 C+ 76 77.48 C+ 80 85.16 B 57 68.98 D+ 88 86.62 B 98 76.14 C 60 74.62 C 67 75.18 C 60 56.62 F 61 74.04 C 50 62.22 F 81 84.3 B 76 69.5 D+ 74 64.38 F 86 76.68 C 58 75.6 C 73 75.7 C 85 78 C+ 77 66.64 D 92 82.86 B60 60.84 F 100 91.22 A60 69.08 D+ 80 75.62 C 74 73.36 C77 81.84 B59 65.56 D 54 71.8 C55 64.98 F 83 87 B+ 76 74.42 C 59 66.54 D 87 77.82 C+ 66 79.24 C+ 83 88 B+ 58 71.34 C85 78.22 C+ 69 66.08 D 82 83.74 B60 75.76 C 94 85.82 B 93 75.22 C 93 89.82 B+ 61 81.72 B89 81.38 B81 73.72 C74 78.84 C+ 76 70.34 C76 74.36 C 61 66.94 D 89 86.6 B 89 88 B+ 97 87.96 B+ 73 94 A 63 67.84 D 98 88.48 B+ 71 64.3 F 55 77.56 C+ 51 69.52 D+ 80 74.4 C 52 63.82 F 77 71.98 C81 83.12 B66 70.02 C100 92.96 A82 81.84 B100 93.2 A- Lectures Watched (%) 1 0 1 1 0 0 1 1 1 0 1 0 0 0 0 1 0 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 0 0 0 0 1 1 0 1 1 0 1 1 1 0 1 1 0 1 1 1 0 1 1 1 0 1 1 1 0 0 0 1 1 0 1 1 0 1 1 0 1 1 1 1 0 1 1 1 81 M 82 F 83 F 84 F 85 M 86 M 87 M 88 F 89 F 90 M 91 F 92 F 93 M 94 F 95 F 96 M 97 F 98 M 99 F 100 M 101 F 102 M 103 M 104 F 105 F 106 F 107 M 108 M 109 F 110 M 111 F 112 M 113 M 114 M 115 F 116 M 117 M 118 F 119 F 120 M 121 M 122 F 123 M 124 F 125 M 126 M 127 F 128 M 129 M 130 F 131 M 132 M 133 M 134 M 135 F 136 F 137 M 138 F 139 F 140 M 141 M 142 F 143 F 144 M 145 M 146 F 147 F 148 M 149 F 150 F So Sr F F So Jr Jr Jr So Sr F F F Jr Jr F F So So Sr Jr Jr So So F F F So Jr Jr So Sr So F F Jr So So Sr F F Sr So F Jr So So F F Sr Sr Jr F F So Sr So Jr F F F Jr Jr Sr So So F Jr F So 10 30 72 91 46 35 45 83 37 34 80 55 5 99 74 88 20 17 72 91 25 12 61 51 71 39 29 59 35 55 83 48 37 100 100 95 39 100 22 90 65 29 37 64 21 98 75 34 20 43 37 84 70 18 3 53 22 58 97 29 62 25 100 82 7 87 74 24 69 3 63 79 63 87 67 85 58 76 52 70 82 65 70 73 78 71 85 61 65 82 79 90 89 59 76 55 52 54 74 57 79 55 96 54 79 55 63 91 76 53 82 100 55 72 83 98 87 54 95 92 71 67 83 65 78 60 83 93 77 57 76 75 59 70 78 71 71 79 91 51 76 53 95 71 68 65 89 97 86 75 99 88 73 96 100 76 85 0 67 85 73 81 73 77 68 99 72 71 96 89 95 69 54 100 93 74 69 91 89 98 94 69 61 70 69 100 93 64 93 76 95 100 69 62 51 61 74 82 80 79 79 53 100 99 89 62 73 97 84 74 86 95 95 91 71 51 87 99 82 60 89 100 75 93 99 91 80 69 35 99 85 98 69 81 63 87 51 67 75 34 93 68 67 98 95 73 76 89 74 99 78 53 87 59 77 100 92 76 64 87 95 87 73 58 63 71 76 77 68 92 87 54 99 100 68 100 69 73 100 72 59 26 95 92 79 67 79 93 92 71 95 96 75 85 100 76 66 67 26 79 77 48 72 68 74 95 29 66 97 83 78 55 74 99 95 95 89 90 60 99 91 57 52 67 71 100 95 100 79 85 79 85 0 56 70 79 68 75 54 76 81 66 99 100 82 63 69 86 54 72 84 92 84 71 70 88 79 91 95 67 95 88 74 97 99 72 84 71 78 92 82 85 73 70 73 96 65 74 99 42 85 70 55 99 90 89 65 93 86 91 97 61 84 63 96 100 83 78 84 69 93 93 75 58 60 69 71 91 52 50 75 74 98 99 71 70 62 74 94 73 60 15 91 76 94 42 86 92 93 66 94 98 73 93 99 89 72 72 98 91 47 98 70 94 70 91 82 69 86 70 59 68 68 98 98 91 55 99 55 91 70 62 89 75 94 100 83 99 64 76 90 83 75 68 68 61 88 58 54 58 92 73 100 100 70 66 66 58 88 71 97 54 88 85 82 94 84 100 94 71 88 86 73 90 100 81 83 70 97 93 80 62 70 70 61 92 85 74 79 54 83 56 92 100 98 99 84 86 77 93 82 80 87 72 61 100 74 87 89 84 77 94 74 52 68 72 91 73 68 84 71 54 98 99 68 67 68 92 95 73 59 74 92 99 90 29 86 95 85 58 96 86 74 82 99 85 72 71 80 98 96 74 71 94 72 76 81 68 99 83 86 67 94 100 100 89 89 98 95 96 67 90 89 62 100 100 67 70 28 89 97 93 73 62 57 91 83 83 57 89 88 58 99 100 56 67 68 54 66 73 77.58 15.58 74 C 65.44 D 85 B 88.64 B+ 80.28 B66.42 D 79.4 C+ 92.58 A82.02 B66.26 D 90.48 A83.4 B72.9 C84.76 B 95.18 A 80.16 B78.98 C+ 65.66 D 78.26 C+ 91.54 A83.16 B75.2 C 74.38 C 76.6 C 69.02 D+ 80.12 B72.16 C67.28 D 86.32 B 65.22 D 82.9 B61.1 F 87.72 B+ 90.56 A94.04 A 84.28 B 78.66 C+ 91.88 A81.36 B86.42 B 78.3 C+ 83.08 B78.72 C+ 67.96 D 81.18 B99.6 A 77.54 C+ 74.58 C 69.46 D+ 86.02 B 84.48 B 87.42 B+ 72.38 C59.28 F 65.58 D 74.54 C 83.88 B80.72 B65.22 D 77.5 C+ 79.46 C+ 61.4 F 90.74 A93.62 A68 D+ 68.84 D+ 68.56 D+ 75.12 C 83.3 B68.48 D+ 0 0 0 1 0 0 0 1 0 0 1 0 0 1 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 1 1 1 0 1 0 1 0 0 0 0 0 1 1 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 1 1 0 1 0 0 0 0 Objectives 1 Create a graph to summarize information on student class level. 2 Create a graph to summarize information on final grade 3 Create a frequency distribution of the final grades (a) by percentage and (b) by letter grade. 4 Provide descriptive statistics (mean, range, standard deviation) on all of the variables in the data set. 5 Create a contingency table to evaluate the relationship between gender and final letter grade 6 Calculate and report the correlation between midterm grade and grade on the final exam. Provide an interpretation of the effect size. 7 Determine the probability of receiving an A or A8 Determine the probability of receiving at least 90% on the final exam (assume a normal distribution). 9 Test the hypothesis that students watching more than 74% of lectures have a significantly higher final exam grade with 95% confidence. Record all steps of the hypothesis test. 10 Summarize all of the information above, and make three recommendations to students taking MGQ201 1. Create a graph to summarize information on student class level. Place in the space outlined below. 4. Provide descriptive statistics (mean, range, standard deviation) on all of the variables in the data set. 9. Test the hypothesis that students watching more than 74% of lectures have a significantly higher fi exam grade with 95% confidence. Record all steps of the hypothesis test. Null hypothesis: P>=0.5 Alternative : p<0.5 From the data, 71 studets watched more than 74% of the lectures. then, the sample proportion = (71/150) = 0.4733 Test statistic, Z = (p^-p)/(Sqrt(pq/n)) = (0.4733-0.5)/ sqrt(0.5*0.5/150) = -0.6540 P-value = P(Z< - 0.6540) = 0.2566 Since the P-value is higher than the significance level, do not reject the null hypothesis and conclude 2. Create a graph to summarize information on final grade. Place in the space outlined below. 5. Create a contingency table to evaluate the relationship between gender and final letter grade. Place the formatted table in the space below. 10. Summarize all of the information above, and make three recommendations to students taking M As there is positive correlation betwee midterm exam and final exam, getting good grade in Midter can improve the grade in final exam Only 10% of persons receive high grades Almost 21.27% chance exists to get at least 90% in the exam 3. Create a frequency distribution of the final grades (a) by percentage and (b) by letter grade. Place the tables in the space below. Final Grade Frquency Final Grade % of frequency A AB BB+ C CC+ D D+ F Total 4 11 12 24 9 22 11 17 16 13 11 150 A AB BB+ C CC+ D D+ F Total 2.67% 7.33% 8.00% 16.00% 6.00% 14.67% 7.33% 11.33% 10.67% 8.67% 7.33% 100% 6. Calculate and report the correlation between midterm grade and grade on the final exam. Provide an interpretation of the effect size. Correlation(Midterm, Final) = 0.289793 The correlation between Midterm and Final scores is 0.28979 indicating that there is weak positive correlation between midterm and final scores. The change in midterm will change the final score in the same direction. 7. Determine the probability of receiving an A or A-. Report the probability below. The probability of receiving A grade = 4/150 = 0.02667 The probability of receiving A- grade = 11/150 = 0.0733 Then, the probability of receiving A or A- = 0.02667+0.0733 = 0.1 8. Determine the probability of receiving at least 90% on the final exam (assume a normal distribution). From the above table, the mean score in final exam = 77.58 The standard deviation of the scores, = 15.57802 Z-value corresponding to 90 = (90-77.58)/15.58 = 0.7972 Then, P(X>90) = P(Z>0.7972) = 1 - P(Z<=0.7972) = 1 - 0.7873 = 0.2127 Final grade (Pie chart) final de that there is no sufficient evidence to support the claim that more than 74% of lectures have a significantly higher final exam grade MGQ201. erm exam