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 (B)</p> Signup and view all the answers

Which function returns the intercept of the linear regression line?

<p>INTERCEPT (A)</p> Signup and view all the answers

More Like This

Funciones Estadísticas en Excel
10 questions
Microsoft Excel: Análisis De Datos
10 questions
Use Quizgecko on...
Browser
Browser