=AVERAGEIFS(C2:C64,A2:A64,"Blue",B2:B64,"Black") Returns an Average of Column C of the Items Which

question 35

True/False

=AVERAGEIFS(C2:C64,A2:A64,"Blue",B2:B64,"Black")
Returns an average of Column C of the items which are either Blue or Black.

---

Definitions:

Hypotheses

Formally proposed explanations for a phenomenon, which are typically tested through research and experiments to be supported or refuted.

Z Statistic

The Z statistic, or Z-score, is used in hypothesis testing, measuring the number of standard deviations a datapoint is from the population mean.

P-value

A measure in statistical hypothesis testing representing the probability of obtaining a result at least as extreme as the one observed, under the assumption that the null hypothesis is true.

Confidence Interval

A set of numbers obtained from statistical data from a sample, which is expected to encompass the value of a parameter from the overall population that is not known.