Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Course In Derivative Securities

Authors: Kerry Back

2005th Edition

3540253734, 978-3540253730

More Books

Students also viewed these Finance questions

Question

design a simple disciplinary and grievance procedure.

Answered: 1 week ago