Quiz 2 Makeup

What is the definition of IQR in statistics?

• The mean of a dataset

• The difference between the maximum and minimum values in a dataset

• The range of values that fall within the middle 50% of a dataset

• The measure of central tendency in a dataset

What is the primary use of the dollar sign ($) in Excel?

• Representing currency values

• Anchoring or fixing cell references in formulas

• Applying conditional formatting

• Indicating absolute cell values

What is the difference between COUNTBLANK and COUNTIF functions when checking for missing values in Excel?

• COUNTBLANK counts the number of empty cells, while COUNTIF counts the number of cells that meet a specific condition.

• COUNTBLANK counts the number of cells that contain any value, while COUNTIF counts the number of cells that are completely empty.

• COUNTBLANK counts the number of cells with missing values, while COUNTIF counts the number of cells with non-missing values.

• None of the above.

What type of missing values can we encounter in data analysis?

• Missing values where the reason is unknown, but there is a relationship with another variable

• Missing values that occur randomly and have no identifiable relationship to another variable

• Missing values that are "not at random" and the missing category itself may have a relationship to the target variable

• None of the above

• All of the above

What percentage of the data is typically above the median?

• 25%

• 50%

• 75%

• It depends on the distribution of the data

The reference error (#REF!) occurs because the formula is unable to locate the data reference.

• True

• False

Histograms are generally used to show the results of a continuous data set such as height or weight. They are the same as bar charts.

• True

• False

When the "Sort A to Z" function is applied to a dataset with numerical values, it arranges the data in ascending order based on the numerical values.

• True

• False

Unimodal refers to a distribution or dataset that has a single peak or mode.

• True

• False

We use COUNTIF for missing values when they are reported as any other character than a blank or coded value.

• True

• False