Question

The following are considered statistical functions:

a. AVERAGE, COUNT, MIN, MAX, MEDIAN
b. AVERAGE, COUNT, MIN, VLOOKUP, IF
c. AVERAGE, VLOOKUP, MIN, MAX, MEDIAN
d. AVERAGE, MEDIAN, VLOOKUP, IF, PMT

Answer 1

The correct answer is option A): AVERAGE, COUNT, MIN, MAX, MEDIAN.

Step-by-step explanation:

AVERAGE, COUNT, MIN, MAX, MEDIAN" functions are commonly used in statistics to calculate various measures of central tendency and dispersion.

• the AVERAGE function calculates the mean of a set of values,
• the COUNT function determines the number of values in a data set,
• the MIN function finds the smallest value,
• the MAX function identifies the largest value,
• the MEDIAN function calculates the middle value.

Statistical functions are primarily used to mathematically process a specified set of cells in a worksheet.