Match the LIST-I with LIST-II LIST-I (Statistical functions in MS-Excel)…
2024
Match the LIST-I with LIST-II
LIST-I (Statistical functions in MS-Excel) | LIST-II (Return value) | ||
|---|---|---|---|
A. | Average | I. | Returns the number of cells containing numeric values in a selected range |
B. | Count | II. | Returns the middle value after ordering, or the average of the two middle values when the range contains an even number of values |
C. | Median | III. | Returns the value that occurs most frequently |
D. | Mode | IV. | Returns the total of all the values in range divided by number of values in the range |
Choose the correct answer from the options given below:
Answer: B. A B C D IV I II III — ConceptSpreadsheet statistical functions summarize a set of numeric observations in different ways. Average is the arithmetic mean, Count gives the number of…
- A.
A
B
C
D
II
III
I
IV
- B.
A
B
C
D
IV
I
II
III
- C.
A
B
C
D
I
IV
II
III
- D.
A
B
C
D
II
III
IV
I
Attempted by 3 students.
Show answer & explanation
Correct answer: B
Concept
Spreadsheet statistical functions summarize a set of numeric observations in different ways.
Average is the arithmetic mean, Count gives the number of cells containing numeric values, Median is the middle value after ordering (or the average of the two middle values for an even-sized set), and Mode is the most frequently occurring value.
Application
Average corresponds to IV because it divides the total of the values by the number of values.
Count corresponds to I because it returns the number of cells containing numeric values in the selected range.
Median corresponds to II because it returns the middle value of the ordered range, or the average of the two middle values when the range has an even number of values.
Mode corresponds to III because it returns the value occurring most frequently.
Contrast with the other sequences
The sequence A-II, B-III, C-I, D-IV assigns the middle-value definition to Average, the most-frequent-value definition to Count, the entry-count definition to Median, and the arithmetic-mean definition to Mode.
The sequence A-I, B-IV, C-II, D-III interchanges the entry-count and arithmetic-mean definitions between Average and Count.
The sequence A-II, B-III, C-IV, D-I assigns the middle-value definition to Average, the most-frequent-value definition to Count, the arithmetic-mean definition to Median, and the entry-count definition to Mode.
Cross-check
The four definitions use four distinct return values, so the one-to-one matching is complete without duplication.
Result: A-IV, B-I, C-II, D-III.