Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Scores of students are given in the accompanying file scores.pdf. Grade curve is also shown. Use Excel functions to return each student's letter grade on
Scores of students are given in the accompanying file scores.pdf. Grade curve is also shown. Use Excel functions to return each student's letter grade on the exam and answer how many scores are in 40-59 60-69 70-79 80-89 and 90-100? Return Student's Grade:
SCORE | GRADE |
90 | A |
80 | B |
60 | D |
70 | C |
0 | F |
STUDENT. SCORES
Stu 14 | 44 |
Stu 15 | 47 |
Stu 16 | 81 |
Stu 17 | 41 |
Stu 18 | 93 |
Stu 19 | 94 |
Stu 20 | 67 |
Stu 21 | 43 |
Stu 22 | 66 |
Stu 23 | 63 |
Stu 24 | 96 |
Stu 25 | 46 |
Stu 26 | 65 |
Stu 27 | 49 |
Stu 28 | 77 |
Stu 29 | 85 |
Stu 30 | 56 |
Stu 31 | 95 |
Stu 32 | 82 |
Stu 33 | 96 |
Stu 34 | 71 |
Stu 35 | 49 |
Stu 36 | 40 |
Stu 37 | 95 |
Stu 38 | 49 |
Stu 39 | 74 |
Stu 40 | 56 |
Stu 41 | 62 |
Stu 42 | 98 |
Stu 43 | 80 |
Stu 44 | 60 |
Stu 45 | 91 |
Stu 46 | 52 |
Stu 47 | 42 |
Stu 48 | 51 |
Stu 49 | 92 |
Stu 50 | 66 |
Stu 51 | 82 |
Stu 52 | 50 |
Stu 53 | 76 |
Stu 54 | 74 |
Stu 55 | 92 |
Stu 56 | 43 |
Stu 57 | 91 |
Stu 58 | 74 |
Stu 59 | 46 |
Stu 60 | 66 |
Stu 61 | 96 |
Stu 62 | 78 |
Stu 63 | 66 |
Stu 64 | 42 |
Stu 65 | 96 |
Stu 66 | 40 |
Stu 67 | 100 |
Stu 68 | 82 |
Stu 69 | 40 |
Stu 70 | 66 |
Stu 71 | 43 |
Stu 72 | 41 |
Stu 73 | 56 |
Stu 74 | 84 |
Stu 75 | 48 |
Stu 76 | 89 |
Stu 77 | 55 |
Stu 78 | 87 |
Stu 79 | 41 |
Stu 80 | 90 |
Stu 81 | 60 |
Stu 82 | 66 |
Stu 83 | 85 |
Stu 84 | 49 |
Stu 85 | 70 |
Stu 86 | 77 |
Stu 87 | 100 |
Stu 88 | 70 |
Stu 89 | 62 |
Stu 90 | 58 |
Stu 91 | 59 |
Stu 92 | 81 |
Stu 93 | 81 |
Stu 94 | 99 |
Stu 95 | 60 |
Stu 96 | 63 |
Stu 97 | 53 |
Stu 98 | 99 |
Stu 99 | 54 |
Stu 100 | 69 |
Stu 101 | 75 |
Stu 102 | 41 |
Stu 103 | 41 |
Stu 104 | 92 |
Stu 105 | 68 |
Stu 106 | 95 |
Stu 107 | 81 |
Stu 108 | 90 |
Stu 109 | 41 |
Stu 110 | 42 |
Stu 111 | 74 |
Stu 112 | 99 |
Stu 113 | 63 |
Stu 114 | 82 |
Stu 115 | 61 |
Stu 116 | 68 |
Stu 117 | 62 |
Stu 118 | 50 |
Stu 119 | 84 |
Stu 120 | 61 |
Stu 121 | 93 |
Stu 122 | 72 |
Stu 123 | 74 |
Stu 124 | 76 |
Stu 125 | 46 |
Stu 126 | 92 |
Stu 127 | 59 |
Stu 128 | 89 |
Stu 129 | 73 |
Stu 130 | 45 |
Stu 131 | 87 |
Stu 132 | 83 |
Stu 133 | 86 |
Stu 134 | 50 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started