Statistical Functions Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering Create Model Calculations with DAX

Statistical Functions Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    Which DAX function would you use to calculate the arithmetic mean of a column of numbers?

  2. 2

    If you need to find the value that appears most frequently in a dataset, which function should you use?

  3. 3

    What is the primary difference between STDEV.S and STDEV.P in DAX?

  4. 4

    You want to find the median value of sales, but you only want to include rows where the 'Region' is 'West'. Which DAX pattern is most efficient?

  5. 5

    When calculating the correlation coefficient between two columns using CORREL, what happens if the two columns have a different number of rows or contain non-numeric data?