Power BI: Quartiles and Percentiles Quiz

What is the primary purpose of merging data in Power BI?

• To create a new data source

• To combine data from multiple sources into a single table

• To delete unnecessary data

• To format data for visualisation

Which of the following is NOT a step in the data merging process in Power BI?

• Selecting the tables to merge

• Defining the join type

• Creating a new Power BI account

• Matching columns from different tables

In Power BI, what is a 'Left Outer Join'?

• A join that includes all rows from the left table and matching rows from the right table

• A join that includes only matching rows from both tables

• A join that includes all rows from the right table and matching rows from the left table

• A join that excludes all matching rows

What is the first quartile (Q1) in a dataset?

• The median of the dataset

• The value below which 25% of the data falls

• The value below which 75% of the data falls

• The highest value in the dataset

How is the third quartile (Q3) calculated in a dataset?

• By finding the median of the entire dataset

• By finding the median of the lower half of the dataset

• By finding the median of the upper half of the dataset

• By finding the average of the dataset

Which of the following best describes the interquartile range (IQR)?

• The difference between the maximum and minimum values

• The difference between the first quartile (Q1) and the third quartile (Q3)

• The sum of the first quartile (Q1) and the third quartile (Q3)

• The average of the first quartile (Q1) and the third quartile (Q3)

What is a percentile in a dataset?

• A value below which a given percentage of observations fall

• The average value of the dataset

• The sum of all values in the dataset

• The highest value in the dataset

How would you calculate the 90th percentile of a dataset?

• By finding the value below which 90% of the data falls

• By finding the value below which 10% of the data falls

• By finding the median of the dataset

• By finding the average of the dataset

In a dataset, if the 50th percentile is also known as:

• The first quartile (Q1)

• The median

• The third quartile (Q3)

• The mode

In Power BI, which feature allows you to append data from one table to another?

• Merge Queries

• Append Queries

• Split Columns

• Group By