A Mixed Cell Reference

question 80

Multiple Choice

A mixed cell reference

• A) occurs when a formula directly or indirectly refers to the cell containing the formula.
• B) causes a potential error.
• C) contains absolute or relative cell references, but not both.
• D) contains both an absolute and a relative cell reference.

---

Definitions:

Prediction Interval

A range of values that is likely to contain the value of an unknown parameter for a future observation, with a specified level of confidence.

Expected Value

In probability and statistics, it is the average value obtained from numerous trials of an experiment over an extended period.

Confidence Interval

A compilation of values, resulting from the statistical study of samples, aimed to likely capture the value of an unknown population parameter.

Long-Run Average

Refers to the average of a set of values or outcomes over a long period of time, often used in economics to predict long-term equilibrium or trends.