When You Are Only Comparing Two Values with Only a TRUE

question 46

Multiple Choice

When you are only comparing two values with only a TRUE or FALSE result, an IF function ____.

• A) is not necessary
• B) will make your formula simpler
• C) will result in an incorrect answer
• D) must be used

---

Definitions:

Median

The middle value in a sorted list of numbers, dividing the dataset into two halves.

Third Quartile

A statistical term which represents the 75th percentile of a dataset, indicating that 75% of the data points fall below this value.

Box Plot

A graphical representation of data that shows the distribution's five-number summary: minimum, first quartile, median, third quartile, and maximum.

Interquartile Range

The measure of variability in a dataset, represented by the difference between the 75th (upper quartile) and 25th (lower quartile) percentiles.