Excel Statistical Functions Quiz
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

Which Excel function returns the slope of the linear regression line?

  • GROWTH
  • TREND
  • INTERCEPT
  • SLOPE (correct)

Which Excel chart type displays the magnitude of change over time or between categories, while also showing the sum of group values?

  • Column
  • Stock
  • Area (correct)
  • Pie

Which Excel function estimates the standard deviation based on a sample, including numbers, text, and logical values?

  • PERCENTILE.EXC
  • MODE.SNGL
  • STDEVA (correct)
  • MEDIAN

Which Excel function returns the $k$-th percentile of values in a range, where $k$ is in the range 0..1, exclusive?

<p>PERCENTILE.EXC (D)</p> Signup and view all the answers

Which Excel function estimates the variance based on a sample?

<p>VAR.S (C)</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