Excel Statistical Functions
5 Questions
1 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

Which function calculates the average of the absolute deviations of data points from their mean?

  • AVERAGEIF
  • AVERAGEA
  • AVEDEV (correct)
  • AVERAGE

    • What does the COUNTIFS function do?

  • Counts the number of cells within a range that meet multiple criteria (correct)
  • Counts the number of blank cells within a range
  • Counts how many values are in the list of arguments, including numbers and text
  • Counts how many numbers are in the list of arguments

    • Which function returns the correlation coefficient between two data sets?

  • CORREL (correct)
  • COUNT
  • COUNTA
  • COVARIANCE.P

    • What does the GROWTH function do?

    <p>Returns values along an exponential trend</p> Signup and view all the answers

    Which function returns the intercept of the linear regression line?

    <p>INTERCEPT</p> Signup and view all the answers

    More Like This

    Excel Statistical Functions Quiz
    5 questions

    Excel Statistical Functions Quiz

    NiftyAlien avatar
    NiftyAlien
    Funciones Estadísticas en Excel
    10 questions

    Funciones Estadísticas en Excel

    UserReplaceableNickel avatar
    UserReplaceableNickel
    Microsoft Excel: Análisis De Datos
    10 questions

    Microsoft Excel: Análisis De Datos

    TenderRainbow9364 avatar
    TenderRainbow9364
    Встроенные функции MS Excel
    15 questions

    Встроенные функции MS Excel

    SmilingSweetPea avatar
    SmilingSweetPea
    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser