Excel Statistical Functions

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson
Download our mobile app to listen on the go
Get App

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

Flashcards are hidden until you start studying

More Like This

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