QUESTION: 25 Exam Topic: 1, Exam Pool A

Connect to the Olympic Athletes data source, find out how many countries participated in 5 different sports from 2000 to 2012?

7
8
9
10

Answer(s): B

Explanation:

First, find the distinct sports for each country:

It will be created as a Measure, move this to Dimension Get the distinct countries:

drop these columns to the view, final view will look like this:
The X-axis represents a number of distinct sports. As the data set contains data from 2000 to 2012, so even if you don't include the filter, your answer would remain the same.

Reveal Solution Next Question

QUESTION: 26 Exam Topic: 1, Exam Pool A

View Related Case Study

Connect to the Olympic Athletes data source, find out the average age of players who won at least one gold medal for the country?

26.33
(Correct)
26.41
26.72
26.02

Answer(s): A

Explanation:

Drop the Age to the columns and change the aggregation to AVG. Drop Gold Medals field to filter and select All values ->

Change 1 from 0.

Reveal Solution Next Question

QUESTION: 27 Exam Topic: 1, Exam Pool A

View Related Case Study

Connect to the "Significant Volcano Eruption" data source.
What is the interquartile range of the distribution of Total Injuries data of the 21st century (show null values at default location)?

32
48
30
42

Answer(s): C

Explanation:

Drop year to filter shelf and select from 2000.

Drop Total injuries field to rows, go to Analysis -> Aggregated Measures (Untick this, it will disaggregate the total injuries field.
Click on Show Me, and select Box and whisker Plot.
IQR = Upper hinge - Lower hinge

Here IQR = 32 -2 = 30