Duplicate Question
The question on this page has been marked as a duplicate question.
Original Question
By examining the screenshot below, select the option that best indicates how to work out the average. Once you have worked out...Question
By examining the screenshot below, select the option that best indicates how to work out the average. Once you have worked out the average, also indicate whether the student achieved a distinction (>75%) or not.
=MEAN(B2:B6); the student did not get a distinction.
=AVERAGE(B2:B6); the student did not get a distinction.
=SUM(B2:B6/5); the student did get a distinction.
=AVERAGE(B2-B6); the student did pass and get a distinction.
=MEAN(B2:B6); the student did not get a distinction.
=AVERAGE(B2:B6); the student did not get a distinction.
=SUM(B2:B6/5); the student did get a distinction.
=AVERAGE(B2-B6); the student did pass and get a distinction.
Answers
There are no human answers yet.
Answered by
GPT 3.5
The correct option is: =AVERAGE(B2:B6); the student did not get a distinction.
To work out the average, you would add up all the scores in cells B2 to B6 and then divide by the total number of scores, in this case, 5. The student did not achieve a distinction (>75%) as the average score is below 75.
To work out the average, you would add up all the scores in cells B2 to B6 and then divide by the total number of scores, in this case, 5. The student did not achieve a distinction (>75%) as the average score is below 75.
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.