Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A Sort the data by score in descending order and assign each student an overall rank so that the student with the highest score in
A Sort the data by score in descending order and assign each student an overall rank so that the student with the highest score in the class is ranked 1 and the student with the second highest score is ranked 2, etc. Students with the same score should get the same rank and students with a score below should be ranked 1 below. For instance, if you had the scores 90, 87, 87, 85, the ranks should be 1, 2, 2, 3, not 1, 2, 2, 4. (Hint: With the data sorted, you can do this using an IF function) Section Student Score Overall Rank Grade from Grade from Score Rank Grade Rules Counts Count O to 59.99 F. 60 to 69.99 D 70 to 79.99 C 80 to 89.99 B 90 to 100 A 3 Deborah Moore 3 Patrick Reed 3 Carolyn Mitchell 1 Dawn Hardy 1 Guillermo Horton 3 Eugenio Frame 2 Michael Morgan 3 Thomas Young 1 Marty Wong 3 Tammy Walker 2 Jason Parker 1 Jennifer Shelton 2 Kimberly Anderson 1 Alice Washington 3 Angela Brown 2 Irene Clark 2 Ruby Russell 2 Alexander Lowe 3 Merrill Mcswain 3 Sharon Cook 1 Juan Perry 2 Bryan Jacobs 1 Sara Obrien 2 Horace Floyd 1 Marie Bell 3 Billy Martinez 1 Benny Wade 1 Aaron Spencer
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