QUESTION: 21 Exam Topic: 1, Exam Pool A

Connect to the "Covid data" source. Create a line chart using continuous months and new deaths.
Find the Excess Kurtosis for the sum of new deaths.

-0.56
-0.67
-0.69
-0.58

Answer(s): B

Explanation:

Drop the Date to the columns and select the continuous month. Drop New Deaths to rows. Click on the Show/Hide card and enable the Summary Card.

You will see the Summary Card on the right, if Excess Kurtosis is not enabled, click on the drop-down and select the Excess Kurtosis.

Reveal Solution Next Question

QUESTION: 22 Exam Topic: 1, Exam Pool A

View Related Case Study

Connect to the "Global Superstore" data source and use the Orders table. Create a hierarchy of Segment, Category, Region. Create a crosstab using this hierarchy and add profit, profit ratio fields.
Which of the following are true from the below options?

The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment (among all the segments)
The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765
The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment
The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment (among all the segments)

Answer(s): A,B

Explanation:

Create a hierarchy of Segment, Category, Region and drop it into the rows.

Create profit ratio calculated field:

Drop the profit and profit ratio fields to the view, your view will look like this:

Now let's go through each answer option.
1) The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment - The profit ratio is -142.26% which is lowest overall so it is true.
2) The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765 - It is true, the profit ratio is 2.06%, which is third- lowest.
3) The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment - False, it is having a $2,245 profit.
4) The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment - False

Note: This is an easy question but time consuming, so attempt these types of questions in the end.

Reveal Solution Next Question

QUESTION: 23 Exam Topic: 1, Exam Pool A

View Related Case Study

Connect to the "Significant Volcano Eruption" data source. How many volcano eruptions took place within 30 miles of the Black Peak volcano in the Alaska Peninsula?

Answer(s): A

Explanation:

Add the Latitude to Rows and Longitude to columns. Or double click on these fields. Don't use Latitude (generated)/Longitude (generated) fields. Drop Location to filter and select 'Alaska Peninsula' Drop Name to the Label Marks card.
Your view will look like this:

Use the radial selection tool to find the number of volcano eruptions that took place within 30 miles of the Black Peak volcano. You need to zoom-in first, only then you would be able to find the distance using a radial selection tool.

There were no eruptions that took place with 30 miles of Black Peak.