exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 3 question 11 discussion

Actual exam question from Microsoft's DA-100
Question #: 11
Topic #: 3
[All DA-100 Questions]

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.
Reference:
https://dash-intel.com/powerbi/statistical_functions_percentile.php

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
stinosanti
Highly Voted 4 years, 5 months ago
Correction. Answer is Yes. The median is a term that is used to describe a number that lies exactly in the middle of a class or a range. The term 50th percentile means that exactly 50 people out of 100 are above him and 50 are below him. Thus, the 50th percentile is the median for that group or class of people.
upvoted 100 times
...
Robc79
Highly Voted 3 years, 11 months ago
Answer is no The average is the arithmetic mean of a set of numbers. The median is a numeric value that separates the higher half of a set from the lower half. Example. 2, 2, 3, 3, 5, 7, 8, 130 (2+2+3+3+5+7+8+130)/8= 20 AVG = 20 2, 2, 3, 3, 5, 7, 8, 130 (3+5)/2=4 MED = 4
upvoted 14 times
kelvintoys93
3 years, 7 months ago
You sir, have answered wrongly but gave the correct explanation. The answer is Yes.
upvoted 9 times
...
SirChris
3 years, 11 months ago
This is the best explanation of the differences between mean (what is commonly known as the average) and median.
upvoted 5 times
Canary_2021
3 years, 10 months ago
Good explanation! The answer is no.
upvoted 2 times
Canary_2021
3 years, 10 months ago
Correct my comment. The correct answer is Yes. 1. term 50th percentile = median 2. mean = average
upvoted 9 times
...
...
...
Meyti
3 years, 3 months ago
your explanation is not related to this question. median : the value that 50% of the data are greater/lower than that. Thereby the answer is Yes.
upvoted 3 times
...
ismailqtr
2 years, 8 months ago
50th percentile is the median... Stat101 bro get it done before PBI
upvoted 1 times
...
...
svw2020
Most Recent 2 years, 8 months ago
Selected Answer: A
50th Percentile - Also known as the Median. The median cuts the data set in half. Half of the answers lie below the median and half lie above the median.
upvoted 1 times
...
QWERTYman
2 years, 8 months ago
Selected Answer: A
Right answer is A
upvoted 1 times
...
edriska1
2 years, 9 months ago
on exam 07/11/2022 answer Yes i passed
upvoted 1 times
...
mlfattori
2 years, 9 months ago
Selected Answer: B
El enunciado pide crear una línea de referencia para mostrar que empleados están por encima del salario medio, es decir, por encima del AVG de salario. El percentil 50 es la MEDIANA, por lo tanto no resuelve el requerimiento. Llego a la conclusión que la Rta B es la correcta
upvoted 2 times
...
TechDiva
3 years, 1 month ago
I got it on my exam 03/17/2022. 90-95% questions were from here. 61 questions in 100 min. All 3 case studies that appeared in exam, where from here.
upvoted 1 times
TechDiva
3 years, 1 month ago
Answered: Yes
upvoted 1 times
...
...
Ashley090521
3 years, 2 months ago
on exam 3/1/2022
upvoted 1 times
...
Marski
3 years, 3 months ago
Reference to MS Docs here. Thanks.
upvoted 2 times
REINORK
2 years, 9 months ago
Hello, did you take the examn? can you answer me?
upvoted 1 times
...
...
ssicefox
3 years, 3 months ago
The answer is No. The 50th percentile is also known as the median or middle value where 50 percent of observations fall below. Reference: https://dash-intel.com/powerbi/statistical_functions_percentile.php
upvoted 1 times
...
ssicefox
3 years, 3 months ago
The 50th percentile is also known as the median or middle value where 50 percent of observations fall below. Reference: https://dash-intel.com/powerbi/statistical_functions_percentile.php
upvoted 1 times
...
PatrickStr
3 years, 4 months ago
on exam 12/10/2021
upvoted 1 times
...
tramynt
3 years, 9 months ago
Yes. 50th percentile is the median.
upvoted 3 times
tramynt
3 years, 9 months ago
I can confirm both theoretically and practically. Tested both lines works the same
upvoted 1 times
...
...
daviddbeloved
3 years, 10 months ago
you are talking about percentile. The Median is correct.
upvoted 1 times
...
SuzyQt
3 years, 11 months ago
The median is the value where fifty percent or the data values fall at or below it. Therefore, the median is the 50th percentile. So the correct answer is Yes
upvoted 4 times
...
EmperorWenchang
4 years, 1 month ago
B. No is correct answer. Median != Average
upvoted 1 times
...
EmperorWenchang
4 years, 1 month ago
stinosanti, why do you say the answer is No and the answer is Yes at the same time? You make me confused.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago