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:

Standard Error

A statistic that measures the dispersion or variability of a sampling distribution, often used in estimating parameters.

Confidence Interval

A range of values that is used to estimate the true value of a population parameter with a certain level of confidence.

Population Standard Deviation

A measure of the dispersion of a set of data from its mean, calculated for the entire population.

Confidence Interval

A statistical range, with a given probability, that contains the true parameter of the population.