If A7=21, Which of the Following =IF Statements Would Produce

question 11

Multiple Choice

If A7=21, which of the following =IF statements would produce the result of "Much Greater"?

• A)=IF(A7>14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20"))
• B)=IF(A7<50,"Greater",IF(A7>20,"Much Greater","Not Greater than 20"))
• C)=IF(A7<14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20"))
• D)=IF(A7<14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20")

---

Definitions:

Normally Distributed

Describes data that follows a normal distribution characterized by a symmetric bell-shaped curve.

Pooled Variance

A method used in statistical analysis to estimate the variance of two or more different populations by pooling their variances, assuming they have the same variance.

Sample Sizes

The number of observations or units chosen from a larger population for the purpose of statistical analysis.

Weighted Average

An average resulting from the multiplication of each component by a factor reflecting its importance.