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

    Which Excel function estimates the variance based on a sample?

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