Question

What criteria do you apply to judge the merits of an average?

Answer 1

Answer:

Answer:To calculate an average with criteria, use AVERAGEIF or AVERAGEIFS. In the example below, AVERAGEIFS is used to calculate the average score for Red and Blue groups: = AVERAGEIFS(C5:C14, D5:D14,"red") // red average = AVERAGEIFS(C5:C14, D5:D14,"blue") // blue average The AVERAGEIFS function can also apply multiple criteria.

Answer 2

Concept

In everyday terms, an average is a single number that represents a group of numbers, usually the sum of the numbers divided by the number of numbers in the group.

Given

Merits of an average

Find

We are asked to explain what criteria do you apply to judge the merits of an average

Solution

1) It is simple to calculate and comprehend.

2) An optimal average should be well defined.

3) In the case of a frequency distribution with open ended classes, it can also be computed.

4) It is unaffected by extreme values and is dependent on the data's range or dispersion.