Statistical Functions Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Create Model Calculations with DAX

What you'll be asked

  1. Which DAX function would you use to calculate the arithmetic mean of a column of numbers?
  2. If you need to find the value that appears most frequently in a dataset, which function should you use?
  3. What is the primary difference between STDEV.S and STDEV.P in DAX?
  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. 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?

Answers and explanations come after you submit.