You create a table calculation named Rank_Score that has a formula of RANK(AVG([Score]), and you drag Rank_Score to Text on the Marks cards. What is the Rank Score value for Student ID 4220?
80 is ranked 1.
75.5 is ranked 2.
71 is ranked 3 (both instances, it's a tie, so they share the rank).
67 is ranked 5.
66 is ranked 6.
64 is ranked 7.
39 is ranked 8.
The answer should be D. As we are using rank function, which does not differentiate between same values. Before student 4220 we have 2 values that are above, and then 2 values that match theirs. Therefore two students would be sharing rank 3.
upvoted 4 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
thahb
1 month agoPdel
11 months, 3 weeks agoMonBouj
1 year agoCollectiveConsciousness
1 year, 3 months ago