Calculate Class Average for Test 1 in Cell G13
5 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What function should be typed in the blank to calculate the class average for Test 1 and have it in cell G13?

  • =SUM(B2:B30)/COUNT(B2:B30)
  • =MEDIAN(B2:B30)
  • =MAX(B2:B30)-MIN(B2:B30)
  • =AVERAGE(B2:B30) (correct)

    • Which function sums the values in the range B2 to B30 and then divides by the count of values to calculate an average?

  • =SUM(B2:B30)/COUNT(B2:B30) (correct)
  • =MAX(B2:B30)-MIN(B2:B30)
  • =MEDIAN(B2:B30)
  • =AVERAGE(B2:B30)

    • Which function would give the middle value in the range B2 to B30 when arranged in ascending order?

  • =SUM(B2:B30)/COUNT(B2:B30)
  • =MAX(B2:B30)-MIN(B2:B30)
  • =MEDIAN(B2:B30) (correct)
  • =AVERAGE(B2:B30)

    • What function calculates the difference between the maximum and minimum values in the range B2 to B30?

    <p>=MAX(B2:B30)-MIN(B2:B30)</p> Signup and view all the answers

    If you want to quickly find the arithmetic mean of values in cells B2 to B30, which function should you use?

    <p>=AVERAGE(B2:B30)</p> Signup and view all the answers

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser